SAP Table
TAI05 CI Program Types
SAP table TAI05 has 2 primary key fields being MANDT,PRART.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TAI05 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyPRART | 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 | |||||||||
/ Relationships
TAI05 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TAI05 | DIMEN | TF150 | Dimensions | DIMEN |
| TAI05 | IVPRO | TAPRF | Cap. inv. measure profile for AuC and dep. simulation | MANDT |
| TAI05 | IVPRO | TAPRF | Cap. inv. measure profile for AuC and dep. simulation | IVPRO |
| TAI05 | KURST | TCURV | Exchange rate types for currency translation | MANDT |
| TAI05 | KURST | TCURV | Exchange rate types for currency translation | KURST |
| TAI05 | PPROFIL | TBP1C | Budget/Plan Profile | MANDT |
| TAI05 | PPROFIL | TBP1C | Budget/Plan Profile | PROFIL |
| TAI05 | PPROFIL | TBP1C | Budget/Plan Profile | APPLIK |
| TAI05 | PPROFIL | TBP1C | Budget/Plan Profile | WRTTP |
| TAI05 | PROFIL | TBP1C | Budget/Plan Profile | MANDT |
| TAI05 | PROFIL | TBP1C | Budget/Plan Profile | PROFIL |
| TAI05 | PROFIL | TBP1C | Budget/Plan Profile | APPLIK |
| TAI05 | PROFIL | TBP1C | Budget/Plan Profile | WRTTP |
| TAI05 | STSMA | TJ20 | Status profiles | MANDT |
| TAI05 | STSMA | TJ20 | Status profiles | STSMA |