SAP table IMZO (Assignment Table: CO Object - Capital Investment Prog.Pos.)

SAP table IMZO has 5 primary key fields being MANDT,POSNR,OBJNR,IPPOS,GJAHR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
POSNR Position number NUMC 8 0 IMPR IM_POSNR
OBJNR CO object number for inv. prog. position CHAR 22 0 ONR00 IM_OBJNR
IPPOS Budget Category in Investment Program CHAR 10 0 TAI08 IM_IPPOS
GJAHR Approval year of the investment program NUMC 4 0 IM_GNJHR
BAPRZ Percentage Assignment of a Measure to a Budget Category DEC 5 2 IM_BAPRZ
PROZU Percentage assignment of a measure to a program position DEC 5 2 IM_PROZU
XGENJ Budget status for measures CHAR 1 0 IM_BUDSTAT
0 Original assignment. Existing budget or no budget.
1 Assignment taken over. Budget from original assgnmt. only
2 Assignment taken over. Budget not only from orig. assignmt.
LOGDL IM Logical deletion indicator CHAR 1 0 IM_LOGDEL
The deletion indicator is not set
A Measure/app.reqst "removed from service" by fiscal yr change
R Approp. request was replaced by measure

IMZO foreign key relationships

Table Field Check Table Check Field
0 IMZO IPPOS TAI08 Budget categories for capital investment programs MANDT
0 IMZO IPPOS TAI08 Budget categories for capital investment programs IPPOS
1 IMZO MANDT T000 Clients MANDT
0 IMZO OBJNR ONR00 General Object Number MANDT
1 IMZO POSNR IMPR Investment Program Positions MANDT
1 IMZO POSNR IMPR Investment Program Positions POSNR