SAP Table TAI05
CI Program Types
TAI05 (CI Program Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TAI05 to other SAP tables.
TAI05 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||
| PRART | Program type | IM_PRART | CHAR | 4 | 0 | |||||||||||
| PROFIL | Budget Profile | BP_BPROFIL | TBP1C | CHAR | 6 | 0 | ||||||||||
| XALLP | Ind. "Operative objects at all positions" | IM_XALLP | CHAR | 1 | 0 |
Possible values
|
||||||||||
| DARST | Represent. of cap. inv. prog. position in graphic hierarchy | IM_DARST | CHAR | 1 | 0 |
Possible values
|
||||||||||
| SCOPE | Object Class | SCOPE_CV | CHAR | 2 | 0 |
Possible values
|
||||||||||
| VJAWE | Handling of unused budgets at fiscal year change | IM_VJAWE | CHAR | 1 | 0 | |||||||||||
| XJBDG | Ind. "Annual budget" | IM_XJBDG | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRAUT | Ind. automatic assignment of program position | IM_PRAUT | CHAR | 1 | 0 |
Possible values
|
||||||||||
| STSMA | Status Profile | J_STSMA | TJ20 | CHAR | 8 | 0 | ||||||||||
| XAKTB | Budget distrib. of overall values only from prog.position | IM_XAKTB | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XORGV | Ind: Data transfer of org. units to lower hierarchy levels | IM_XORGV | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XORGC | Indicator: Check org. units of assigned measures | IM_XORGC | CHAR | 1 | 0 |
Possible values
|
||||||||||
| XAFAV | Indicator: Depreciation forecast incl. distributed values | IM_XAFAV | CHAR | 1 | 0 |
Possible values
|
||||||||||
| KURST | Exch. Rate Type for Currency Translation in IM InfoSystem | IM_KURST | TCURV | CHAR | 4 | 0 | ||||||||||
| CAFWD | Ind: Take over old assignements of measures | IM_CAFWD | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PPROFIL | Planning profile | BP_PPROFIL | TBP1C | CHAR | 6 | 0 | ||||||||||
| YDIST | Budget distribution of annual values from program position | IM_YDIST | CHAR | 1 | 0 |
Possible values
|
||||||||||
| DIMEN | Dimension in Consolidation | IM_DIMEN | TF150 | CHAR | 2 | 0 | ||||||||||
| X1ASS | Indicator: Only single assignment allowed | IM_SINGLE_ASSIGN | CHAR | 1 | 0 |
Possible values
|
||||||||||
| IVPRO | Investment measure profile | IM_PROFIL | TAPRF | CHAR | 6 | 0 | ||||||||||
TAI05 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TAI05 | DIMEN | TAI05 | MANDT | TF150 | Dimensions | MANDT |
| TAI05 | DIMEN | TAI05 | DIMEN | TF150 | Dimensions | DIMEN |
| TAI05 | IVPRO | TAI05 | MANDT | TAPRF | Cap. inv. measure profile for AuC and dep. simulation | MANDT |
| TAI05 | IVPRO | TAI05 | IVPRO | TAPRF | Cap. inv. measure profile for AuC and dep. simulation | IVPRO |
| TAI05 | KURST | TAI05 | MANDT | TCURV | Exchange rate types for currency translation | MANDT |
| TAI05 | KURST | TAI05 | KURST | TCURV | Exchange rate types for currency translation | KURST |
| TAI05 | MANDT | TAI05 | MANDT | T000 | Clients | MANDT |
| TAI05 | PPROFIL | TAI05 | PPROFIL | TBP1C | Budget/Plan Profile | PROFIL |
| TAI05 | PPROFIL | 'I' | TBP1C | Budget/Plan Profile | APPLIK | |
| TAI05 | PPROFIL | '48' | TBP1C | Budget/Plan Profile | WRTTP | |
| TAI05 | PPROFIL | TAI05 | MANDT | TBP1C | Budget/Plan Profile | MANDT |
| TAI05 | PROFIL | '47' | TBP1C | Budget/Plan Profile | WRTTP | |
| TAI05 | PROFIL | TAI05 | MANDT | TBP1C | Budget/Plan Profile | MANDT |
| TAI05 | PROFIL | TAI05 | PROFIL | TBP1C | Budget/Plan Profile | PROFIL |
| TAI05 | PROFIL | 'I' | TBP1C | Budget/Plan Profile | APPLIK | |
| TAI05 | STSMA | TAI05 | MANDT | TJ20 | Status profiles | MANDT |
| TAI05 | STSMA | TAI05 | STSMA | TJ20 | Status profiles | STSMA |
