SAP table TAI08 (Budget categories for capital investment programs)

SAP table TAI08 has 3 primary key fields being MANDT,PRART,IPPOS.

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
PRART Program type CHAR 4 0 TAI05 IM_PRART
IPPOS Budget Category in Investment Program CHAR 10 0 IM_IPPOS
BPPOSIT Internal commitment item (8 chars) CHAR 8 0 BP_POSIT

TAI08 foreign key relationships

Table Field Check Table Check Field
0 TAI08 PRART TAI05 CI Program Types MANDT
0 TAI08 PRART TAI05 CI Program Types PRART