SAP Table TAIF1
Appropriation request types
TAIF1 (Appropriation request 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 TAIF1 to other SAP tables.
TAIF1 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||||
| IVART | Appropriation request type | IMA_IVART | CHAR | 2 | 0 | |||||||||
| PPROFIL | Planning profile for cost planning on approp. request | IM_PPROFIL | TBP1C | CHAR | 6 | 0 | ||||||||
| CPROFIL | Planning profile for revenue planning for app.requests | IM_CPROFIL | TBP1C | CHAR | 6 | 0 | ||||||||
| STSAV | Status profile for appropriation request variants | IMA_STSAV | TJ20 | CHAR | 8 | 0 | ||||||||
| STSAK | Status profile for appropriation requests | IMA_STSAK | TJ20 | CHAR | 8 | 0 | ||||||||
| PRART | Program type | IM_PRART | TAI05 | CHAR | 4 | 0 | ||||||||
| NUMKR | Number range | NUMKR | CHAR | 2 | 0 | |||||||||
| NUMVG | Control of number assignment with measure | IMA_NUMVG | CHAR | 1 | 0 |
Possible values
|
||||||||
| PARGR | Partner Determination Procedure | PARGR | TVPG | CHAR | 4 | 0 | ||||||||
| VARNUM | Manual number assignment for variants | IMA_VARNUM | CHAR | 1 | 0 |
Possible values
|
||||||||
| VARSCH | Increment for numbering of variants | IMA_VARSCH | NUMC | 2 | 0 | |||||||||
| PARVW_VERA | 1st partner function in master data of approp. request | IMA_P_ROL1 | TPAR | CHAR | 2 | 0 | ||||||||
| PARVW_AUTO | 2nd partner function in master data of approp. request | IMA_P_ROL2 | TPAR | CHAR | 2 | 0 | ||||||||
| PARVW_INTE | Partner function for applicant / author of approp. request | IMA_P_AUTO | TPAR | CHAR | 2 | 0 | ||||||||
| PARVW_GENE | Partner function for person responsible | IMA_P_VERA | TPAR | CHAR | 2 | 0 | ||||||||
| IVPRO | Investment measure profile | IM_PROFIL | TAPRF | CHAR | 6 | 0 | ||||||||
| AUART | Order Type | AUFART | T003O | CHAR | 4 | 0 | ||||||||
| PROFIDPROJ | Project Profile | PROFIDPROJ | TCJ41 | CHAR | 7 | 0 | ||||||||
| R_PROJ | Flag for allowed WBS element (measure) for approp. request | IMA_R_PROJ | CHAR | 1 | 0 |
Possible values
|
||||||||
| R_AUFTRG | Flag for allowed order for an appropriation request | IMA_R_AUFTRG | CHAR | 1 | 0 |
Possible values
|
||||||||
| ERSETZ | Replace appropriation request with measure | IMA_ERSETZ | CHAR | 1 | 0 |
Possible values
|
||||||||
| WIDAT | Reference date for the preinvestment analysis | IMA_WIDAT | DATS | 8 | 0 | |||||||||
| SLWID | Field key ID for user fields from PS | IMA_SLWID | TCN00 | CHAR | 7 | 0 | ||||||||
| LAYOUT | Assign Tab Layout | IMA_LAYOUT_CONTROLLER | TAMLAY0 | CHAR | 4 | 0 | ||||||||
| LAYOUT_PLANER | Assign Tab Layout | IMA_LAYOUT_PLANER | TAMLAY0 | CHAR | 4 | 0 | ||||||||
| LAYOUT_WEB | Assign Tab Layout | IMA_LAYOUT_WEB | TAMLAY0 | CHAR | 4 | 0 | ||||||||
| COSTCOPY | Copy Cost Estimate for Measure | IMA_COSTCPY | CHAR | 1 | 0 |
Possible values
|
||||||||
TAIF1 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TAIF1 | AUART | TAIF1 | MANDT | T003O | Order Types | CLIENT |
| TAIF1 | AUART | TAIF1 | AUART | T003O | Order Types | AUART |
| TAIF1 | CPROFIL | TAIF1 | MANDT | TBP1C | Budget/Plan Profile | MANDT |
| TAIF1 | CPROFIL | TAIF1 | CPROFIL | TBP1C | Budget/Plan Profile | PROFIL |
| TAIF1 | CPROFIL | 'Q' | TBP1C | Budget/Plan Profile | APPLIK | |
| TAIF1 | CPROFIL | '52' | TBP1C | Budget/Plan Profile | WRTTP | |
| TAIF1 | IVPRO | TAIF1 | MANDT | TAPRF | Cap. inv. measure profile for AuC and dep. simulation | MANDT |
| TAIF1 | IVPRO | TAIF1 | IVPRO | TAPRF | Cap. inv. measure profile for AuC and dep. simulation | IVPRO |
| TAIF1 | LAYOUT | TAIF1 | MANDT | TAMLAY0 | Tab pages in master data: Tab layouts | MANDT |
| TAIF1 | LAYOUT | 'IM-FA' | TAMLAY0 | Tab pages in master data: Tab layouts | APPL | |
| TAIF1 | LAYOUT | TAIF1 | LAYOUT | TAMLAY0 | Tab pages in master data: Tab layouts | LAYOUT |
| TAIF1 | LAYOUT_PLANER | TAIF1 | MANDT | TAMLAY0 | Tab pages in master data: Tab layouts | MANDT |
| TAIF1 | LAYOUT_PLANER | 'IM-FA' | TAMLAY0 | Tab pages in master data: Tab layouts | APPL | |
| TAIF1 | LAYOUT_PLANER | TAIF1 | LAYOUT_PLANER | TAMLAY0 | Tab pages in master data: Tab layouts | LAYOUT |
| TAIF1 | LAYOUT_WEB | TAIF1 | MANDT | TAMLAY0 | Tab pages in master data: Tab layouts | MANDT |
| TAIF1 | LAYOUT_WEB | 'IM-FA' | TAMLAY0 | Tab pages in master data: Tab layouts | APPL | |
| TAIF1 | LAYOUT_WEB | TAIF1 | LAYOUT_WEB | TAMLAY0 | Tab pages in master data: Tab layouts | LAYOUT |
| TAIF1 | PARGR | TAIF1 | MANDT | TVPG | Partner Function Groups | MANDT |
| TAIF1 | PARGR | TAIF1 | PARGR | TVPG | Partner Function Groups | PARGR |
| TAIF1 | PARVW_AUTO | TAIF1 | MANDT | TPAR | Business Partner: Functions | MANDT |
| TAIF1 | PARVW_AUTO | TAIF1 | PARVW_AUTO | TPAR | Business Partner: Functions | PARVW |
| TAIF1 | PARVW_GENE | TAIF1 | MANDT | TPAR | Business Partner: Functions | MANDT |
| TAIF1 | PARVW_GENE | TAIF1 | PARVW_GENE | TPAR | Business Partner: Functions | PARVW |
| TAIF1 | PARVW_INTE | TAIF1 | PARVW_INTE | TPAR | Business Partner: Functions | PARVW |
| TAIF1 | PARVW_INTE | TAIF1 | MANDT | TPAR | Business Partner: Functions | MANDT |
| TAIF1 | PARVW_VERA | TAIF1 | MANDT | TPAR | Business Partner: Functions | MANDT |
| TAIF1 | PARVW_VERA | TAIF1 | PARVW_VERA | TPAR | Business Partner: Functions | PARVW |
| TAIF1 | PPROFIL | TAIF1 | PPROFIL | TBP1C | Budget/Plan Profile | PROFIL |
| TAIF1 | PPROFIL | 'Q' | TBP1C | Budget/Plan Profile | APPLIK | |
| TAIF1 | PPROFIL | '39' | TBP1C | Budget/Plan Profile | WRTTP | |
| TAIF1 | PPROFIL | TAIF1 | MANDT | TBP1C | Budget/Plan Profile | MANDT |
| TAIF1 | PRART | TAIF1 | MANDT | TAI05 | CI Program Types | MANDT |
| TAIF1 | PRART | TAIF1 | PRART | TAI05 | CI Program Types | PRART |
| TAIF1 | PROFIDPROJ | TAIF1 | MANDT | TCJ41 | Default Values for Work Breakdown Structure | MANDT |
| TAIF1 | PROFIDPROJ | TAIF1 | PROFIDPROJ | TCJ41 | Default Values for Work Breakdown Structure | PROFIDPROJ |
| TAIF1 | SLWID | TAIF1 | SLWID | TCN00 | Key Word ID for PS User Fields | SLWID |
| TAIF1 | SLWID | TAIF1 | MANDT | TCN00 | Key Word ID for PS User Fields | MANDT |
| TAIF1 | STSAK | TAIF1 | MANDT | TJ20 | Status profiles | MANDT |
| TAIF1 | STSAK | TAIF1 | STSAK | TJ20 | Status profiles | STSMA |
| TAIF1 | STSAV | TAIF1 | MANDT | TJ20 | Status profiles | MANDT |
| TAIF1 | STSAV | TAIF1 | STSAV | TJ20 | Status profiles | STSMA |
