SAP table reference
TAI05
CI Program TypesExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table TAI05.
SAP table TAI05 has 2 primary key fields: MANDT,PRART.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
TAI05 fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| Key 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 | |||||||||
/ Relationships
TAI05 relationships.
| 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 |