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 |
|
|||||||||
| SCOPE | Object Class | CHAR | 2 | 0 | SCOPE_CV |
|
|||||||||
| 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 |