SAP table TAI05 (CI Program Types)

SAP table TAI05 has 2 primary key fields being MANDT,PRART.

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 IM_PRART
PROFIL Budget Profile CHAR 6 0 TBP1C BP_BPROFIL
XALLP Ind. "Operative objects at all positions" CHAR 1 0 IM_XALLP
DARST Represent. of cap. inv. prog. position in graphic hierarchy CHAR 1 0 IM_DARST
1 ID Cap.inv.prog.position / ID Measure
2 Text Cap.inv.prog.position / Text Measure
3 ID Cap.inv.prog.posit. / Text Measure
4 Text Cap.inv.prog.posit. / ID Measure
SCOPE Object Class CHAR 2 0 SCOPE_CV
IV Investment
OC Overhead costs
PA Profit analysis
PR Production
VJAWE Handling of unused budgets at fiscal year change CHAR 1 0 IM_VJAWE
XJBDG Ind. "Annual budget" CHAR 1 0 IM_XJBDG
PRAUT Ind. automatic assignment of program position CHAR 1 0 IM_PRAUT
STSMA Status Profile CHAR 8 0 TJ20 J_STSMA
XAKTB Budget distrib. of overall values only from prog.position CHAR 1 0 IM_XAKTB
XORGV Ind: Data transfer of org. units to lower hierarchy levels CHAR 1 0 IM_XORGV
XORGC Indicator: Check org. units of assigned measures CHAR 1 0 IM_XORGC
XAFAV Indicator: Depreciation forecast incl. distributed values CHAR 1 0 IM_XAFAV
KURST Exch. Rate Type for Currency Translation in IM InfoSystem CHAR 4 0 TCURV IM_KURST
CAFWD Ind: Take over old assignements of measures CHAR 1 0 IM_CAFWD
PPROFIL Planning Profile CHAR 6 0 TBP1C BP_PPROFIL
YDIST Budget distribution of annual values from program position CHAR 1 0 IM_YDIST
DIMEN Dimension in Consolidation CHAR 2 0 TF150 IM_DIMEN
X1ASS Indicator: Only single assignment allowed CHAR 1 0 IM_SINGLE_ASSIGN
IVPRO Investment Measure Profile CHAR 6 0 TAPRF IM_PROFIL

TAI05 foreign key relationships

Table Field Check Table Check Field
0 TAI05 DIMEN TF150 Dimensions DIMEN
1 TAI05 IVPRO TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
1 TAI05 IVPRO TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
0 TAI05 KURST TCURV Exchange rate types for currency translation MANDT
0 TAI05 KURST TCURV Exchange rate types for currency translation KURST
1 TAI05 PPROFIL TBP1C Budget/Plan Profile MANDT
1 TAI05 PPROFIL TBP1C Budget/Plan Profile PROFIL
1 TAI05 PPROFIL TBP1C Budget/Plan Profile APPLIK
1 TAI05 PPROFIL TBP1C Budget/Plan Profile WRTTP
0 TAI05 PROFIL TBP1C Budget/Plan Profile MANDT
0 TAI05 PROFIL TBP1C Budget/Plan Profile PROFIL
0 TAI05 PROFIL TBP1C Budget/Plan Profile APPLIK
0 TAI05 PROFIL TBP1C Budget/Plan Profile WRTTP
1 TAI05 STSMA TJ20 Status profiles MANDT
1 TAI05 STSMA TJ20 Status profiles STSMA