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 | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||
|
||||||||||||||||
|
DARST
Represent. of cap. inv. prog. position in graphic hierarchy
|
IM_DARST |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
SCOPE
Object Class
|
SCOPE_CV |
CHAR
|
2 | 0 | ||||||||||||
|
||||||||||||||||
|
VJAWE
Handling of unused budgets at fiscal year change
|
IM_VJAWE |
CHAR
|
1 | 0 | ||||||||||||
|
XJBDG
Ind. "Annual budget"
|
IM_XJBDG |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
PRAUT
Ind. automatic assignment of program position
|
IM_PRAUT |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
STSMA
Status Profile
|
J_STSMA | TJ20 |
CHAR
|
8 | 0 | |||||||||||
|
XAKTB
Budget distrib. of overall values only from prog.position
|
IM_XAKTB |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
XORGV
Ind: Data transfer of org. units to lower hierarchy levels
|
IM_XORGV |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
XORGC
Indicator: Check org. units of assigned measures
|
IM_XORGC |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
XAFAV
Indicator: Depreciation forecast incl. distributed values
|
IM_XAFAV |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | ||||||||||||
|
||||||||||||||||
|
PPROFIL
Planning profile
|
BP_PPROFIL | TBP1C |
CHAR
|
6 | 0 | |||||||||||
|
YDIST
Budget distribution of annual values from program position
|
IM_YDIST |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
DIMEN
Dimension in Consolidation
|
IM_DIMEN | TF150 |
CHAR
|
2 | 0 | |||||||||||
|
X1ASS
Indicator: Only single assignment allowed
|
IM_SINGLE_ASSIGN |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
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 | '48' |
TBP1C
Budget/Plan Profile
|
WRTTP | |
| TAI05 | PPROFIL | TAI05 | MANDT |
TBP1C
Budget/Plan Profile
|
MANDT |
| TAI05 | PPROFIL | TAI05 | PPROFIL |
TBP1C
Budget/Plan Profile
|
PROFIL |
| TAI05 | PPROFIL | 'I' |
TBP1C
Budget/Plan Profile
|
APPLIK | |
| 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 | PROFIL | '47' |
TBP1C
Budget/Plan Profile
|
WRTTP | |
| TAI05 | STSMA | TAI05 | STSMA |
TJ20
Status profiles
|
STSMA |
| TAI05 | STSMA | TAI05 | MANDT |
TJ20
Status profiles
|
MANDT |