TAIF1
Appropriation request types
TAIF1 is an SAP database table in S/4HANA. Appropriation request types. It contains 28 fields.
Fields (28)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | ivart | IMA_IVART | App.reqst type | |||
| pprofil | IM_PPROFIL | Cost planning prof. | ||||
| cprofil | IM_CPROFIL | Rev.planning profile | ||||
| stsav | IMA_STSAV | Var.status prof | ||||
| stsak | IMA_STSAK | Status profile | ||||
| prart | IM_PRART | Program type | ||||
| numkr | NUMKR | Number Range | ||||
| numvg | IMA_NUMVG | Control | ||||
| pargr | PARGR | PartnDet.Proc. | ||||
| varnum | IMA_VARNUM | Manual no.assgn | ||||
| varsch | IMA_VARSCH | Increment | ||||
| parvw_vera | IMA_P_ROL1 | 1st function | ||||
| parvw_auto | IMA_P_ROL2 | 2nd function | ||||
| parvw_inte | IMA_P_AUTO | Applicant | ||||
| parvw_gene | IMA_P_VERA | Resp. person | ||||
| ivpro | IM_PROFIL | Invest. Profile | ||||
| auart | AUFART | Order Type | ||||
| profidproj | PROFIDPROJ | Project Profile | ||||
| r_proj | IMA_R_PROJ | WBS element | ||||
| r_auftrg | IMA_R_AUFTRG | Order | ||||
| ersetz | IMA_ERSETZ | Replace | ||||
| widat | IMA_WIDAT | Preinv.anl.date | ||||
| slwid | IMA_SLWID | Field key PS | ||||
| layout | IMA_LAYOUT_CONTROLLER | Tab layout | ||||
| layout_planer | IMA_LAYOUT_PLANER | Tab layout | ||||
| layout_web | IMA_LAYOUT_WEB | Tab layout | ||||
| costcopy | IMA_COSTCPY | Copy Cost Estimate |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- Appropriation request types
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TAIF1 (
MANDT, -- Client [MANDT]
IVART, -- App.reqst type [IMA_IVART]
PPROFIL, -- Cost planning prof. [IM_PPROFIL]
CPROFIL, -- Rev.planning profile [IM_CPROFIL]
STSAV, -- Var.status prof [IMA_STSAV]
STSAK, -- Status profile [IMA_STSAK]
PRART, -- Program type [IM_PRART]
NUMKR, -- Number Range [NUMKR]
NUMVG, -- Control [IMA_NUMVG]
PARGR, -- PartnDet.Proc. [PARGR]
VARNUM, -- Manual no.assgn [IMA_VARNUM]
VARSCH, -- Increment [IMA_VARSCH]
PARVW_VERA, -- 1st function [IMA_P_ROL1]
PARVW_AUTO, -- 2nd function [IMA_P_ROL2]
PARVW_INTE, -- Applicant [IMA_P_AUTO]
PARVW_GENE, -- Resp. person [IMA_P_VERA]
IVPRO, -- Invest. Profile [IM_PROFIL]
AUART, -- Order Type [AUFART]
PROFIDPROJ, -- Project Profile [PROFIDPROJ]
R_PROJ, -- WBS element [IMA_R_PROJ]
R_AUFTRG, -- Order [IMA_R_AUFTRG]
ERSETZ, -- Replace [IMA_ERSETZ]
WIDAT, -- Preinv.anl.date [IMA_WIDAT]
SLWID, -- Field key PS [IMA_SLWID]
LAYOUT, -- Tab layout [IMA_LAYOUT_CONTROLLER]
LAYOUT_PLANER, -- Tab layout [IMA_LAYOUT_PLANER]
LAYOUT_WEB, -- Tab layout [IMA_LAYOUT_WEB]
COSTCOPY, -- Copy Cost Estimate [IMA_COSTCPY]
PRIMARY KEY (MANDT, IVART)
);
Learn More
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA