SAP table TAIF1 (Appropriation request types)

SAP table TAIF1 has 2 primary key fields being MANDT,IVART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
IVART Appropriation request type CHAR 2 0 IMA_IVART
PPROFIL Planning profile for cost planning on approp. request CHAR 6 0 TBP1C IM_PPROFIL
CPROFIL Planning profile for revenue planning for app.requests CHAR 6 0 TBP1C IM_CPROFIL
STSAV Status profile for appropriation request variants CHAR 8 0 TJ20 IMA_STSAV
STSAK Status profile for appropriation requests CHAR 8 0 TJ20 IMA_STSAK
PRART Program type CHAR 4 0 TAI05 IM_PRART
NUMKR Number Range CHAR 2 0 NUMKR
NUMVG Control of number assignment with measure CHAR 1 0 IMA_NUMVG
1 Same external coding mask and number assgnmt as WBS elements
2 Same number assignment as investment orders
3 Independent number assignment using number ranges
PARGR Partner Determination Procedure CHAR 4 0 TVPG PARGR
VARNUM Manual number assignment for variants CHAR 1 0 IMA_VARNUM
VARSCH Increment for numbering of variants NUMC 2 0 IMA_VARSCH
PARVW_VERA 1st partner function in master data of approp. request CHAR 2 0 TPAR IMA_P_ROL1
PARVW_AUTO 2nd partner function in master data of approp. request CHAR 2 0 TPAR IMA_P_ROL2
PARVW_INTE Partner function for applicant / author of approp. request CHAR 2 0 TPAR IMA_P_AUTO
PARVW_GENE Partner function for person responsible CHAR 2 0 TPAR IMA_P_VERA
IVPRO Investment Measure Profile CHAR 6 0 TAPRF IM_PROFIL
AUART Order Type CHAR 4 0 T003O AUFART
PROFIDPROJ Project Profile CHAR 7 0 TCJ41 PROFIDPROJ
R_PROJ Flag for allowed WBS element (measure) for approp. request CHAR 1 0 IMA_R_PROJ
R_AUFTRG Flag for allowed order for an appropriation request CHAR 1 0 IMA_R_AUFTRG
ERSETZ Replace appropriation request with measure CHAR 1 0 IMA_ERSETZ
WIDAT Reference date for the preinvestment analysis DATS 8 0 IMA_WIDAT
SLWID Field key ID for user fields from PS CHAR 7 0 TCN00 IMA_SLWID
LAYOUT Assign Tab Layout CHAR 4 0 TAMLAY0 IMA_LAYOUT_CONTROLLER
LAYOUT_PLANER Assign Tab Layout CHAR 4 0 TAMLAY0 IMA_LAYOUT_PLANER
LAYOUT_WEB Assign Tab Layout CHAR 4 0 TAMLAY0 IMA_LAYOUT_WEB
COSTCOPY Copy Cost Estimate for Measure CHAR 1 0 IMA_COSTCPY

TAIF1 foreign key relationships

Table Field Check Table Check Field
0 TAIF1 AUART T003O Order Types AUART
1 TAIF1 CPROFIL TBP1C Budget/Plan Profile MANDT
1 TAIF1 CPROFIL TBP1C Budget/Plan Profile PROFIL
1 TAIF1 CPROFIL TBP1C Budget/Plan Profile APPLIK
1 TAIF1 CPROFIL TBP1C Budget/Plan Profile WRTTP
0 TAIF1 IVPRO TAPRF Cap. inv. measure profile for AuC and dep. simulation MANDT
0 TAIF1 IVPRO TAPRF Cap. inv. measure profile for AuC and dep. simulation IVPRO
1 TAIF1 LAYOUT TAMLAY0 Tab pages in master data: Tab layouts MANDT
1 TAIF1 LAYOUT TAMLAY0 Tab pages in master data: Tab layouts APPL
1 TAIF1 LAYOUT TAMLAY0 Tab pages in master data: Tab layouts LAYOUT
0 TAIF1 LAYOUT_PLANER TAMLAY0 Tab pages in master data: Tab layouts MANDT
0 TAIF1 LAYOUT_PLANER TAMLAY0 Tab pages in master data: Tab layouts APPL
0 TAIF1 LAYOUT_PLANER TAMLAY0 Tab pages in master data: Tab layouts LAYOUT
1 TAIF1 LAYOUT_WEB TAMLAY0 Tab pages in master data: Tab layouts MANDT
1 TAIF1 LAYOUT_WEB TAMLAY0 Tab pages in master data: Tab layouts APPL
1 TAIF1 LAYOUT_WEB TAMLAY0 Tab pages in master data: Tab layouts LAYOUT
0 TAIF1 PARGR TVPG Partner Function Groups PARGR
1 TAIF1 PARVW_AUTO TPAR Business Partner: Functions PARVW
0 TAIF1 PARVW_GENE TPAR Business Partner: Functions PARVW
1 TAIF1 PARVW_INTE TPAR Business Partner: Functions PARVW
0 TAIF1 PARVW_VERA TPAR Business Partner: Functions PARVW
1 TAIF1 PPROFIL TBP1C Budget/Plan Profile MANDT
1 TAIF1 PPROFIL TBP1C Budget/Plan Profile PROFIL
1 TAIF1 PPROFIL TBP1C Budget/Plan Profile APPLIK
1 TAIF1 PPROFIL TBP1C Budget/Plan Profile WRTTP
0 TAIF1 PRART TAI05 CI Program Types MANDT
0 TAIF1 PRART TAI05 CI Program Types PRART
1 TAIF1 PROFIDPROJ TCJ41 Default Values for Work Breakdown Structure MANDT
0 TAIF1 SLWID TCN00 Key Word ID for PS User Fields MANDT
1 TAIF1 STSAK TJ20 Status profiles MANDT
1 TAIF1 STSAK TJ20 Status profiles STSMA
0 TAIF1 STSAV TJ20 Status profiles MANDT
0 TAIF1 STSAV TJ20 Status profiles STSMA