SAP VBAP Sales Document: Item Data Table
Overview
VBAP is a standard SAP S/4HANA table that stores Sales Document: Item Data data. There are total 405 fields in the VBAP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBAP belongs to Sales (SD-SLS) module and is located in the package Application development R/3 Sales (VA).
In addition, following links provide an overview of foreign key relationships, if any, that link VBAP to other SAP tables and standard CDS views available based on VBAP table in S/4HANA 2020.
Techincal Settings of VBAP
Below are technical details of the table VBAP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBAP Fields
The following table gives you an overview of the fields available in VBAP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Sales Document | VBELN_VA | VBAK | CHAR | 10 |
| POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| MATWA | Material entered | MATWA | MARA | CHAR | 40 |
| PMATN | Pricing Reference Material | PMATN | MARA | CHAR | 40 |
| CHARG | Batch Number | CHARG_D | MCHA | CHAR | 10 |
| MATKL | Material Group | MATKL | T023 | CHAR | 9 |
| ARKTX | Short text for sales order item | ARKTX | CHAR | 40 | |
| PSTYV | Sales document item category | PSTYV | TVPT | CHAR | 4 |
| POSAR | Item Type | POSAR | CHAR | 1 | |
| PROCESS_CODE | Item Processing Code | TDD_ITEM_PROCESS_CODE | CHAR | 1 | |
| LFREL | Item Is Relevant for Delivery | LFREL_AP | CHAR | 1 | |
| FKREL | Relevant for Billing | FKREL | CHAR | 1 | |
| UEPOS | Higher-Level item in bill of material structures | UEPOS | NUMC | 6 | |
| GRPOS | Item for Which this Item is an Alternative | GRPOS | NUMC | 6 | |
| ABGRU | Reason for Rejection of Sales Documents | ABGRU_VA | TVAG | CHAR | 2 |
| PRODH | Product hierarchy | PRODH_D | T179 | CHAR | 18 |
| PRODH_UNIV_SALES_PARNT_NODID | Node ID | NODID | CHAR | 40 | |
| PRODH_UNIV_SALES_DET_ORIGIN | Date Relevant for Determination of Product Hierarchy | SD_PRODH_DET_ORIGIN | CHAR | 2 | |
| PRODH_UNIV_BATDET_PARNT_NODID | Node ID | NODID | CHAR | 40 | |
| PRODH_UNIV_BATDET_DET_ORIGIN | Date Relevant for Determination of Product Hierarchy | SD_PRODH_DET_ORIGIN | CHAR | 2 | |
| ZWERT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR | 13 | |
| ZMENG | Target Quantity in Sales Units | DZMENG | QUAN | 13 | |
| ZIEME | Target Quantity UoM | DZIEME | T006 | UNIT | 3 |
| UMZIZ | Factor for Converting Sales Units to Base Units (Target Qty) | UMZIZ | DEC | 5 | |
| UMZIN | Factor for Converting Sales Units to Base Units (Target Qty) | UMZIN | DEC | 5 | |
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| SMENG | Scale Quantity in base unit of measure | SMENG | QUAN | 13 | |
| ABLFZ | Rounding quantity for delivery | ABLFZ | QUAN | 13 | |
| ABDAT | Reconciliation date for agreed cumulative quantity | ABDAT | DATS | 8 | |
| ABSFZ | Allowed deviation in quantity (absolute) | ABSFZ | QUAN | 13 | |
| POSEX | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | |
| KDMAT | Material Number Used by Customer | MATNR_KU | CHAR | 35 | |
| KBVER | Allowed deviation in quantity (in percent) | KBVER | DEC | 3 | |
| KEVER | Days by which the quantity can be shifted | KEVER | DEC | 3 | |
| VKGRU | Repair Processing: Classification of Items | VKGRU | TVRMAVK | CHAR | 3 |
| VKAUS | Usage Indicator | ABRVW | TVLV | CHAR | 3 |
| GRKOR | Delivery Group (Items are delivered together) | GRKOR | NUMC | 3 | |
| FMENG | Quantity is fixed | FMENG | CHAR | 1 | |
| UEBTK | Unlimited Overdelivery Allowed | UEBTK_V | CHAR | 1 | |
| UEBTO | Overdelivery Tolerance | UEBTO | DEC | 3 | |
| UNTTO | Underdelivery Tolerance | UNTTO | DEC | 3 | |
| FAKSP | Billing Block for Item | FAKSP_AP | TVFS | CHAR | 2 |
| ATPKZ | Replacement part | ATPKZ | CHAR | 1 | |
| RKFKF | Method of billing for CO/PPC orders | RKFKF | CHAR | 1 | |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| NETWR | Net Value of the Order Item in Document Currency | NETWR_AP | CURR | 15 | |
| WAERK | SD document currency | WAERK | TCURC | CUKY | 5 |
| ANTLF | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | |
| KZTLF | Partial delivery at item level | KZTLF | CHAR | 1 | |
| CHSPL | Batch split allowed | CHSPL | CHAR | 1 | |
| KWMENG | Cumulative order quantity in sales units | KWMENG | QUAN | 15 | |
| LSMENG | Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines) | LSMENG | QUAN | 15 | |
| KBMENG | Cumulative Confirmed Quantity in Sales Unit | KBMENG | QUAN | 15 | |
| KLMENG | Cumulative Confirmed Quantity in Base Unit | KLMENG | QUAN | 15 | |
| VRKME | Sales unit | VRKME | T006 | UNIT | 3 |
| UMVKZ | Numerator (factor) for conversion of sales quantity into SKU | UMVKZ | DEC | 5 | |
| UMVKN | Denominator (Divisor) for Conversion of Sales Qty into SKU | UMVKN | DEC | 5 | |
| BRGEW | Gross Weight of the Item | BRGEW_AP | QUAN | 15 | |
| NTGEW | Net Weight of the Item | NTGEW_AP | QUAN | 15 | |
| GEWEI | Weight Unit | GEWEI | T006 | UNIT | 3 |
| VOLUM | Volume of the item | VOLUM_AP | QUAN | 15 | |
| VOLEH | Volume unit | VOLEH | T006 | UNIT | 3 |
| VBELV | Originating Document | VBELV | CHAR | 10 | |
| POSNV | Originating item | POSNV | NUMC | 6 | |
| VGBEL | Document number of the reference document | VGBEL | CHAR | 10 | |
| VGPOS | Item number of the reference item | VGPOS | NUMC | 6 | |
| VOREF | Complete Reference Indicator | VOREF | CHAR | 1 | |
| UPFLU | Update Indicator for Document Flow of Sales Document | UPFLV | CHAR | 1 | |
| ERLRE | Completion Rule for Quotation / Contract | ERLRE | CHAR | 1 | |
| LPRIO | Delivery Priority | LPRIO | TPRIO | NUMC | 2 |
| WERKS | Plant (Own or External) | WERKS_EXT | CHAR | 4 | |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| VSTEL | Shipping Point / Receiving Point | VSTEL | TVST | CHAR | 4 |
| ROUTE | Route | ROUTE | TVRO | CHAR | 6 |
| STKEY | Origin of the bill of material | STKEY | CHAR | 1 | |
| STDAT | Key date of the bill of material | STDAT | DATS | 8 | |
| STLNR | Bill of Material | STNUM | CHAR | 8 | |
| STPOS | Bill of material item number VBAP not used | STPOS_VBAP | DEC | 5 | |
| AWAHR | Order Probability of the Item | AWAHR | NUMC | 3 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| TAXM1 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM2 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM3 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM4 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM5 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM6 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM7 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM8 | Tax classification material | TAXMT | CHAR | 1 | |
| TAXM9 | Tax classification material | TAXMT | CHAR | 1 | |
| VBEAF | Fixed shipping processing time in days (= setup time) | VBEAF | DEC | 5 | |
| VBEAV | Variable shipping processing time in days | VBEAV | DEC | 5 | |
| VGREF | Preceding document has resulted from reference | VGREF | CHAR | 1 | |
| NETPR | Net Price | NETPR | CURR | 11 | |
| KPEIN | Condition Pricing Unit | KPEIN | DEC | 5 | |
| KMEIN | Condition Unit | KMEIN | T006 | UNIT | 3 |
| SHKZG | Returns Item | SHKZG_VA | CHAR | 1 | |
| SKTOF | Cash discount indicator | SKTOF | CHAR | 1 | |
| MTVFP | Checking Group for Availability Check | MTVFP | TMVF | CHAR | 2 |
| SUMBD | Summing up of requirements | SUMBD | CHAR | 1 | |
| KONDM | Material Price Group | KONDM | T178 | CHAR | 2 |
| KTGRM | Account Assignment Group for Material | KTGRM | TVKM | CHAR | 2 |
| BONUS | Volume rebate group | BONUS | TVBO | CHAR | 2 |
| PROVG | Commission group | PROVG | TVPR | CHAR | 2 |
| EANNR | European Article Number (EAN) - obsolete!!!!! | EANNR | CHAR | 13 | |
| PRSOK | Pricing is OK | PRSOK | CHAR | 1 | |
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 |
| BWTEX | Indicator: Separate valuation | BWTEX | CHAR | 1 | |
| XCHPF | Batch Management Requirement Indicator | XCHPF | CHAR | 1 | |
| XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | |
| LFMNG | Minimum Delivery Quantity in Delivery Note Processing | MINLF | QUAN | 13 | |
| STAFO | Update Group for statistics update | STAFO | CHAR | 6 | |
| WAVWR | Cost in document currency | WAVWR | CURR | 13 | |
| KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13 | |
| KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13 | |
| KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13 | |
| KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13 | |
| KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13 | |
| KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13 | |
| STCUR | Exchange rate for statistics (Exch.rate at time of creation) | STCUR_AP | DEC | 9 | |
| AEDAT | Date of Last Change | AEDAT | DATS | 8 | |
| EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | |
| FIXMG | Delivery Date and Quantity Fixed | FIXMG | CHAR | 1 | |
| PRCTR | Profit Center | PRCTR | CHAR | 10 | |
| MVGR1 | Material group 1 | MVGR1 | TVM1 | CHAR | 3 |
| MVGR2 | Material group 2 | MVGR2 | TVM2 | CHAR | 3 |
| MVGR3 | Material group 3 | MVGR3 | TVM3 | CHAR | 3 |
| MVGR4 | Material group 4 | MVGR4 | TVM4 | CHAR | 3 |
| MVGR5 | Material group 5 | MVGR5 | TVM5 | CHAR | 3 |
| KMPMG | Component Quantity | KMPMG | QUAN | 13 | |
| SUGRD | Reason for material substitution | SUGRD | TVSU | CHAR | 4 |
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 |
| VPZUO | Allocation Indicator | VPZUO | CHAR | 1 | |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | |
| FREEZE_PAOBJNR | Profitability Segment Is Dependent on Preceding Document | SD_FREEZE_PAOBJNR | CHAR | 1 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PRPS | NUMC | 8 |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| VPMAT | Planning material | VPMAT | MARA | CHAR | 40 |
| VPWRK | Planning plant | VPWRK | T001W | CHAR | 4 |
| PRBME | Base unit of measure for product group | PRBME | T006 | UNIT | 3 |
| UMREF | Conversion factor: quantities | UMREFF | FLTP | 16 | |
| KNTTP | Account Assignment Category | KNTTP | T163K | CHAR | 1 |
| KZVBR | Consumption posting | KZVBR | CHAR | 1 | |
| SERNR | BOM explosion number | SERNR | SNUM | CHAR | 8 |
| OBJNR | Object Number at Item Level | OBJPO | ONR00 | CHAR | 22 |
| ABGRS | Results Analysis Key | ABGR_SCHL | TKKAA | CHAR | 6 |
| BEDAE | Requirements type | BEDAE | T459A | CHAR | 4 |
| CMPRE | Item credit price | CMPRE | CURR | 11 | |
| CMTFG | ID for partial release of order item credit block | CMTFG | CHAR | 1 | |
| CMPNT | ID: Item with active credit function / relevant for credit | CMPNT | CHAR | 1 | |
| CMKUA | Credit data exchange rate for requested delivery date | CMKUA | DEC | 9 | |
| CUOBJ | Configuration | CUOBJ_VA | NUMC | 18 | |
| CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | NUMC | 18 | |
| CEPOK | Status expected price | CEPOK | CHAR | 1 | |
| KOUPD | Condition Update | KOUPD | CHAR | 1 | |
| SERAIL | Serial Number Profile | SERAIL | T377P | CHAR | 4 |
| ANZSN | Number of serial numbers | ANZSN | INT4 | 10 | |
| NACHL | Customer has not posted goods receipt | NACHL | CHAR | 1 | |
| MAGRV | Material Group: Packaging Materials | MAGRV | TVEGR | CHAR | 4 |
| MPROK | Status manual price change | MPROK | CHAR | 1 | |
| VGTYP | Document Category of Preceding SD Document | VBTYPL_V | CHAR | 4 | |
| PROSA | ID for material determination | PROSA | CHAR | 1 | |
| UEPVW | ID for higher-level item usage | UEPVW | CHAR | 1 | |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12 | |
| KLVAR | Costing Variant | CK_KLVAR | CHAR | 4 | |
| SPOSN | BOM Item Number | SPOSN | CHAR | 4 | |
| KOWRR | Statistical Values | KOWRR | CHAR | 1 | |
| STADAT | Statistics date | STADAT | DATS | 8 | |
| EXART | Business Transaction Type | EXART | CHAR | 2 | |
| PREFE | Customs Preference | PREFE | CHAR | 1 | |
| KNUMH | Number of condition record from batch determination | KNUMH_CH | CHAR | 10 | |
| CLINT | Internal Class Number | CLINT | KLAH | NUMC | 10 |
| CHMVS | Batches: Exit to quantity proposal | CHMVS | NUMC | 3 | |
| STLTY | BOM category | STLTY | CHAR | 1 | |
| STLKN | BOM item node number | STLKN | NUMC | 8 | |
| STPOZ | Internal counter | CIM_COUNT | NUMC | 8 | |
| STMAN | Inconsistent configuration | CUINK | CHAR | 1 | |
| ZSCHL_K | Overhead key | AUFZSCHL | CHAR | 6 | |
| KALSM_K | Costing Sheet | AUFKALSM | T683 | CHAR | 6 |
| KALVAR | Costing Variant | CK_KLVAR | TCK03 | CHAR | 4 |
| KOSCH | Product allocation determination procedure | KOSCH | T190S | CHAR | 18 |
| UPMAT | Pricing reference material of main item | UPMAT | MARA | CHAR | 40 |
| UKONM | Material pricing group of main item | UKONM | T178 | CHAR | 2 |
| MFRGR | Material freight group | MFRGR | TMFG | CHAR | 8 |
| PLAVO | Instruction for Planning Delivery Schedule | PLAVO | TVZP | CHAR | 4 |
| KANNR | KANBAN/Sequence Number | KANNR | CHAR | 35 | |
| CMPRE_FLT | Item Credit Price | CMPRE_FLT | FLTP | 16 | |
| ABFOR | Form of payment guarantee | ABSFORM_CM | T691K | CHAR | 2 |
| ABGES | Guaranteed (factor between 0 and 1) | ABGES_CM | FLTP | 16 | |
| J_1BCFOP | CFOP Code and Extension | J_1BCFOP | J_1BAG | CHAR | 10 |
| J_1BTAXLW1 | Tax law: ICMS | J_1BTAXLW1 | J_1BATL1 | CHAR | 3 |
| J_1BTAXLW2 | Tax law: IPI | J_1BTAXLW2 | J_1BATL2 | CHAR | 3 |
| J_1BTXSDC | SD tax code | J_1BTXSDC_ | J_1BTXSDC | CHAR | 2 |
| WKTNR | Value Contract No. | WKTNR | VBAK | CHAR | 10 |
| WKTPS | Value Contract Item | WKTPS | VBAP | NUMC | 6 |
| SKOPF | Assortment module | W_SORTK | WSOH | CHAR | 18 |
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | |
| WGRU1 | Material group hierarchy 1 | WGRU_HIE1 | CHAR | 18 | |
| WGRU2 | Material group hierarchy 2 | WGRU_HIE2 | CHAR | 18 | |
| KNUMA_PI | Sales Promotion | KNUMA_PI | KONA | CHAR | 10 |
| KNUMA_AG | Sales deal | KNUMA_AG | KONA | CHAR | 10 |
| KZFME | ID: Leading unit of measure for completing a transaction | KZFME | CHAR | 1 | |
| LSTANR | Free goods delivery control | LSTANR | CHAR | 1 | |
| TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | |
| MWSBP | Tax amount in document currency | MWSBP | CURR | 13 | |
| BERID | MRP Area | BERID | CHAR | 10 | |
| PCTRF | Profit Center for Billing | PCTRF | CHAR | 10 | |
| LOGSYS_EXT | Logical system | LOGSYS | CHAR | 10 | |
| J_1BTAXLW3 | ISS Tax Law | J_1BTAXLW3 | J_1BATL3 | CHAR | 3 |
| J_1BTAXLW4 | COFINS Tax Law | J_1BTAXLW4 | J_1BATL4A | CHAR | 3 |
| J_1BTAXLW5 | PIS Tax Law | J_1BTAXLW5 | J_1BATL5 | CHAR | 3 |
| STOCKLOC | First Inventory-Managing Location | STOCKLOC | CHAR | 20 | |
| SLOCTYPE | Type of First Inventory-Managing Location | SLOCTYPE | CHAR | 4 | |
| MSR_RET_REASON | Return Reason | MSR_RETURNS_REASON | MSR_C_RET_REASON | CHAR | 3 |
| MSR_REFUND_CODE | Returns Refund Code | MSR_RETURNS_REFUND_CODE | MSR_C_RET_REFUND | CHAR | 3 |
| MSR_APPROV_BLOCK | Approval Block | MSR_APPROVAL_BLOCK | CHAR | 1 | |
| NRAB_KNUMH | Number of the Condition Record | KNUMH | CHAR | 10 | |
| TRMRISK_RELEVANT | Risk Relevancy in Sales | SLS_TRM_RISK_RELEVANCY | CHAR | 2 | |
| SGT_RCAT | Requirement Segment | SGT_RCAT | CHAR | 40 | |
| VBKD_POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | |
| VEDA_POSNR | Sales Document Item | POSNR_VA | NUMC | 6 | |
| HANDOVERLOC | Location for a physical handover of goods | HANDOVER_LOC | CHAR | 10 | |
| EXT_REF_ITEM_ID | External Item ID | SD_EXT_REF_ITEM_ID | CHAR | 40 | |
| HANDOVERDATE | Handover Date at the Handover Location | HANDOVER_DATE | DATS | 8 | |
| HANDOVERTIME | Handover time at the handover location | HANDOVER_TIME | TIMS | 6 | |
| TC_AUT_DET | Tax Code Automatically Determined | J_1BTC_AUT_DET | * | CHAR | 2 |
| MANUAL_TC_REASON | Manual Tax Code Reason | J_1BMANUAL_TC_REASON | * | CHAR | 2 |
| FISCAL_INCENTIVE | Tax Incentive Type | J_1BFISCAL_INCENTIVE_CODE | * | CHAR | 4 |
| TAX_SUBJECT_ST | Tax Subject to Substituição Tributária | J_1BTC_TAX_SUBJECT_ST | CHAR | 1 | |
| FISCAL_INCENTIVE_ID | Incentive ID | J_1BFISCAL_INCENTIVE_ID_SD | * | CHAR | 4 |
| SPCSTO | Nota Fiscal Special Case for CFOP Determination | J_1BSPCSTO_SD | * | NUMC | 2 |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| ABSTA | Rejection Status (Item) | ABSTA_VB | CHAR | 1 | |
| BESTA | Delivery Confirmation Status (Item) | BESTA | CHAR | 1 | |
| CMPPI | Status of Credit Check Against Financial Document | CMPSI | CHAR | 1 | |
| CMPPJ | Status of Credit Check Against Export Credit Insurance | CMPSJ | CHAR | 1 | |
| COSTA | Confirmation Status for ALE | COSTA_D | CHAR | 1 | |
| DCSTA | Delay Status (Item) | DCSTA | CHAR | 1 | |
| FKSAA | Order-Related Billing Status (Item) | FKSAA | CHAR | 1 | |
| FSSTA | Billing Block Status (Item) | FSSTA | CHAR | 1 | |
| GBSTA | Overall Processing Status (Item) | GBSTA | CHAR | 1 | |
| LFGSA | Overall Delivery Status (Item) | LFGSA | CHAR | 1 | |
| LFSTA | Delivery Status (Item) | LFSTA | CHAR | 1 | |
| LSSTA | Overall Delivery Block Status (Item) | LSSTA | CHAR | 1 | |
| MANEK | Manual Completion of Contract | MANEK | CHAR | 1 | |
| RFGSA | Overall Reference Status (Item) | RFGSA | CHAR | 1 | |
| RFSTA | Reference Status (Item) | RFSTA | CHAR | 1 | |
| UVALL | Incompletion Status (Item) | UVALL_UP | CHAR | 1 | |
| UVFAK | Billing Incompletion Status (Item) | UVFAK_UP | CHAR | 1 | |
| UVPRS | Pricing Incompletion Status (Item) | UVPRS_UP | CHAR | 1 | |
| UVVLK | Delivery Incompletion Status (Item) | UVVLK_UP | CHAR | 1 | |
| UVP01 | Customer reserves 1: Item status | UVP01 | CHAR | 1 | |
| UVP02 | Customer reserves 2: Item status | UVP02 | CHAR | 1 | |
| UVP03 | Item reserves 3: Item status | UVP03 | CHAR | 1 | |
| UVP04 | Item reserves 4: Item status | UVP04 | CHAR | 1 | |
| UVP05 | Customer reserves 5: Item status | UVP05 | CHAR | 1 | |
| WBSTA | Goods Movement Status (Item) | WBSTA | CHAR | 1 | |
| EMCST | Embargo Status (Item) | /SAPSLL/EMCST | CHAR | 1 | |
| SLCST | Watch List Screening Status (Item) | /SAPSLL/SLCST | CHAR | 1 | |
| TOTAL_LCCST | Legal Control Status | TDD_TOTAL_LCCST | CHAR | 1 | |
| PCSTA | Product Marketability Status (Item) | TDD_PCSTA | CHAR | 1 | |
| DGSTA | Dangerous Goods Status (Item) | TDD_DGSTA | CHAR | 1 | |
| SDSSTA | Safety Data Sheet Status (Item) | TDD_SDSSTA | CHAR | 1 | |
| DP_CLEAR_STA_ITM | Down Payment Status | DP_CLEAR_STA | CHAR | 1 | |
| CMTD_DELIV_DATE | Delivery Date that the Supplier Has Committed To | TDD_CMTD_DELIV_DATE | DATS | 8 | |
| CMTD_DELIV_CREADATE | Deliv. Creation Date in Order to Meet Committed Deliv. Date | TDD_CMTD_DELIV_CREADATE | DATS | 8 | |
| CMTD_DELIV_QTY_SU | Committed Delivery Quantity in Sales Unit | TDD_CMTD_DELIV_QTY_SU | QUAN | 15 | |
| DELIVERY_DATE_TYPE_RULE | Delivery Date Rule | SD_DELIVERY_DATE_TYPE_RULE | CHAR | 1 | |
| REQQTY_BU | Requested Order Quantity in Base Unit | TDD_REQQTY_BU | QUAN | 15 | |
| HANDLE | GUID in 'CHAR' Format in Uppercase | GUID_32 | CHAR | 32 | |
| PBS_STATE | State of Project-Based Service | SD_PBS_STATE | CHAR | 1 | |
| IFRS15_RELEVANCE | Item is relevant for IFRS 15 | IFRS15_RELEVANCE | CHAR | 1 | |
| IFRS15_TOTAL_SSP | IFRS 15: Standalone Selling Price | IFRS15_TOTAL_SSP | CURR | 15 | |
| REVFP | Rule for transferring the results of the availability check | REVFP | CHAR | 1 | |
| CAPPED_NET_AMOUNT | Net Amount Cap | CAPPED_NET_AMOUNT | CURR | 15 | |
| CAPPED_NET_AMOUNT_ALERT_THLD | Notification Threshold (in Pct) for Exceeded Net Amount Cap | CAPPED_NET_AMOUNT_ALERT_THLD | NUMC | 3 | |
| CATS_OVERTIME_CATEGORY | Overtime Category | CATS_OVERTIME_CATEGORY | CHAR | 4 | |
| SESSION_CREATION_DATE | Date of the Session During Which the Record Was Created | SESSION_CREATION_DATE | DATS | 8 | |
| SESSION_CREATION_TIME | Time of the Session During Which the Record Was Created | SESSION_CREATION_TIME | TIMS | 6 | |
| ORIGINAL_PLANT | Original Plant in Plant Substitution | ORIGINAL_PLANT | CHAR | 4 | |
| ATP_ABC_SUBSTITUTION_STATUS | Substitution Status for Alternative-Based Confirmation (ABC) | ATP_ABC_SUBSTITUTION_STATUS | CHAR | 1 | |
| TRANSIT_PLANT | Transit Plant | TRANSIT_PLANT | CHAR | 4 | |
| REASON_CODE | Reason for Change in Expected Delivery Quantity | SD_ITEM_REASON_CODE | CHAR | 3 | |
| DUMMY_SLSDOCITEM_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| PO_QUAN | Purchase Order Quantity | BSTMG | QUAN | 13 | |
| PO_UNIT | Purchase Order Unit of Measure | BSTME | * | UNIT | 3 |
| MILL_SE_GPOSN | Global Item | MILL_SE_GPOSN | NUMC | 6 | |
| MILL_BATCH_SEL_F | Control of Batch Selection | MILL_BATCH_SEL_FLG | CHAR | 1 | |
| VBTYP_ANA | SD Document Category | VBTYPL | CHAR | 4 | |
| AUART_ANA | Sales Document Type | AUART | * | CHAR | 4 |
| VKORG_ANA | Sales Organization | VKORG | CHAR | 4 | |
| VTWEG_ANA | Distribution Channel | VTWEG | CHAR | 2 | |
| SPART_ANA | Division | SPART | CHAR | 2 | |
| VKBUR_ANA | Sales office | VKBUR | * | CHAR | 4 |
| VKGRP_ANA | Sales group | VKGRP | * | CHAR | 3 |
| AUGRU_ANA | Order Reason (Reason for the Business Transaction) | AUGRU | * | CHAR | 3 |
| AUDAT_ANA | Document Date (Date Received/Sent) | AUDAT | DATS | 8 | |
| KVGR1_ANA | Customer group 1 | KVGR1 | * | CHAR | 3 |
| KVGR2_ANA | Customer group 2 | KVGR2 | * | CHAR | 3 |
| KVGR3_ANA | Customer group 3 | KVGR3 | * | CHAR | 3 |
| KVGR4_ANA | Customer group 4 | KVGR4 | * | CHAR | 3 |
| KVGR5_ANA | Customer group 5 | KVGR5 | * | CHAR | 3 |
| VDATU_ANA | Requested Delivery Date | EDATU_VBAK | DATS | 8 | |
| VSBED_ANA | Shipping Conditions | VSBED | * | CHAR | 2 |
| KUNNR_ANA | Sold-To Party | KUNAG | * | CHAR | 10 |
| KNUMV_ANA | Number of the Document Condition | KNUMV | CHAR | 10 | |
| BZIRK_ANA | Sales District | BZIRK | * | CHAR | 6 |
| BSTKD_ANA | Customer Reference | BSTKD | CHAR | 35 | |
| KDGRP_ANA | Customer Group | KDGRP | * | CHAR | 2 |
| VSART_ANA | Shipping Type | VSARTTR | * | CHAR | 2 |
| FKDAT_ANA | Billing Date | FKDAT | DATS | 8 | |
| FPLNR_ANA | Billing plan number / invoicing plan number | FPLNR | * | CHAR | 10 |
| KUNWE_ANA | Ship-to party | KUNWE | * | CHAR | 10 |
| KUNRE_ANA | Bill-to party | KUNRE | * | CHAR | 10 |
| PERVE_ANA | Sales Employee | SALES_EMPL | NUMC | 8 | |
| PERZM_ANA | Employee Responsible | RESP_EMPL | NUMC | 8 | |
| KUNRG_ANA | Payer | KUNRG | * | CHAR | 10 |
| SERVICE_DOC_TYPE | Service Document Type | FCO_SRVDOC_TYPE | CRMC_PROC_TYPE | CHAR | 4 |
| SERVICE_DOC_ID | Service Document ID | FCO_SRVDOC_ID | CHAR | 10 | |
| SERVICE_DOC_ITEM_ID | Service Document Item ID | FCO_SRVDOC_ITEM_ID | NUMC | 6 | |
| SOLUTION_ORDER_ID | Solution Order | CRMS4_SOLO_OBJECT_ID | CHAR | 10 | |
| SOLUTION_ORDER_ITM_ID | Solution Order Item | CRMS4_SOLO_NUMBER_INT | NUMC | 6 | |
| GLO_LOG_REF1_IT | Country Specific Reference 1 in the Document | GLO_LOG_REF1_IT | CHAR | 25 | |
| TXS_BUSINESS_TRANSACTION | Tax Service Business Transaction | TXS_BUSINESS_TRANSACTION | CHAR | 4 | |
| TXS_USAGE_PURPOSE | Tax Service Usage Purpose | TXS_USAGE_PURPOSE | CHAR | 25 | |
| CPD_UPDAT | Time Stamp | /CPD/PFP_SC_TSTMP | DEC | 15 | |
| ZAPCGKI | Annexing package key | /ILE/TAPCGK | /ILE/TV01 | NUMC | 4 |
| APCGK_EXTENDI | Extended key for annexing package | /ILE/TAPCGK_EXT | NUMC | 10 | |
| ZABDATI | Annexing base date | /ILE/TABDAT | DATS | 8 | |
| AUFPL_OLC | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL_OLC | Internal counter | CIM_COUNT | NUMC | 8 | |
| AD01PROFNR | Dynamic Item Processor Profile | AD01PROFNR | AD01C_PROF | CHAR | 8 |
| ADMOI | Model ID Code | ADMOI | CSPCMOI | CHAR | 4 |
| ADICC | Interchangeability Code | ADICC | CSPCICC | NUMC | 2 |
| ADPRI | Order Priority | ADPRI | CSPCPRI | CHAR | 3 |
| ADDNS | Do Not Substitute | ADDNS | CHAR | 1 | |
| ADACN | Aircraft registration number | ADACN | CHAR | 10 | |
| ASSIGNMENT_PRIORITY | ARun Demand Priority | ARUN_DEMAND_PRIORITY | CHAR | 10 | |
| ARUN_GROUP_PRIO | ARun Demand Group Priority | ARUN_DEMAND_GROUP_PRIORITY | CHAR | 10 | |
| LABSG | Indicator for Inbound Forecast and JIT Delivery Schedules | LABSG | CHAR | 1 | |
| FABSG | Indicator for Inbound Forecast Delivery Schedule Headers | FABSG | CHAR | 1 | |
| PR_L_L | Profile for Comparison of Frcst.DelSched with Frcst.DelSched | DI_ESD_PROFIL_L | ESD_TOPR | CHAR | 10 |
| PR_F_F | Profile for Comparison of JIT Del.Sched. with JIT Del.Sched. | DI_ESD_PROFIL_F | ESD_TOPR | CHAR | 10 |
| PR_F_L | Profile for Comp. of JIT Del.Sched. with Forecast Del.Sched. | DI_ESD_PROFIL_G | ESD_TOPR | CHAR | 10 |
| FERC_IND | Regulatory indicator | FE_IND | FERC_C7 | CHAR | 4 |
| FSH_SEASON_YEAR | Season Year | FSH_SAISJ | FSH_SEASONS | CHAR | 4 |
| FSH_SEASON | Season | FSH_SAISO | FSH_SEASONS | CHAR | 10 |
| FSH_COLLECTION | Fashion Collection | FSH_COLLECTION | FSH_COLLECTIONS | CHAR | 10 |
| FSH_THEME | Fashion Theme | FSH_THEME | FSH_THEMES | CHAR | 10 |
| FSH_CRSD | Condition Record Number for Seasons | FSH_CRSD | CHAR | 10 | |
| FSH_SEAREF | Season Determined from Reference Document | FSH_SEAREF | CHAR | 1 | |
| FSH_CANDATE | Cancellation Date | FSH_CANDATE | DATS | 8 | |
| FSH_PSM_PFM_SPLIT | PSM and PFM Split ID | FSH_PSM_PFM_SPLIT | CHAR | 15 | |
| FSH_VAS_REL | VAS Relevant | FSH_VAS_REL | CHAR | 1 | |
| FSH_VAS_PRNT_ID | Item number of the SD document | POSNR | NUMC | 6 | |
| FSH_TRANSACTION | Transaction Number | FSH_TRANSACTION | CHAR | 10 | |
| FSH_ITEM_GROUP | Item Group | FSH_ITEM_GROUP | NUMC | 5 | |
| FSH_ITEM | Item Number | FSH_ITEM | NUMC | 5 | |
| FSH_VASREF | VAS Determined from Reference Document | FSH_VASREF | CHAR | 1 | |
| FSH_GRID_COND_REC | Grid Condition Record Number | FSH_GRID_COND_REC | CHAR | 32 | |
| FSH_PQR_UEPOS | Higher-level item in Partial Quantity Rejection | FSH_PQR_UEPOS | NUMC | 6 | |
| RFM_SCC_INDICATOR | Season Completeness Indicator | RFM_SCC_INDICATOR | CHAR | 1 | |
| KOSTL | Cost Center | KOSTL | * | CHAR | 10 |
| FONDS | Fund | BP_GEBER | * | CHAR | 10 |
| FISTL | Funds Center | FISTL | * | CHAR | 16 |
| FKBER | Functional Area | FKBER | * | CHAR | 16 |
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | * | CHAR | 10 |
| IUID_RELEVANT | IUID Relevant for Customer | IUID_RELEVANT_CUST | CHAR | 1 | |
| EQUNR | Equipment Number | EQUNR | EQUI | CHAR | 18 |
| EQART | Type of Technical Object | EQART | T370K | CHAR | 10 |
| J_3GLVART | Activity Type | J_3GLVART | J_3GLEIART | CHAR | 4 |
| J_3GDATVO | From Date | J_3GDATVO | DATS | 8 | |
| J_3GDATBI | To Date | J_3GDATBI | DATS | 8 | |
| J_3GBELNRI | Document Number | J_3GBELNRI | J_3GBELK | CHAR | 10 |
| J_3GPOSNRI | Document Item | J_3GBELPOS | J_3GBELP | NUMC | 5 |
| PRS_OBJNR | Engagement mgmt: Object number | PRS_OBJNR | CHAR | 22 | |
| PRS_SD_SPSNR | Standard WBS Element for Project Inception via SD | PRS_SD_SPSNR | * | NUMC | 8 |
| PRS_WORK_PERIOD | Work Period (Internal Representation) | PRS_WORK_PERIOD | NUMC | 7 | |
| TAS | Treasury Account Symbol | FMFG_TAS | CHAR | 30 | |
| BETC | Business Event Type Code | FMFG_BETC | CHAR | 10 | |
| MOD_ALLOW | Modification Allowed | FMFG_MOD_ALLOW | CHAR | 1 | |
| CANCEL_ALLOW | Cancellation Allowed | FMFG_CANCEL_ALLOW | CHAR | 1 | |
| PAY_METHOD | List of Respected Payment Methods | DZWELS | CHAR | 10 | |
| BPN | Business Partner Number | FMFG_BPN | T880 | CHAR | 6 |
| REP_FREQ | Reporting Frequency | FMFG_REP_FREQ | CHAR | 3 | |
| FMFGUS_KEY | United States Federal Government Fields | FMFG_US_KEY | CHAR | 22 | |
| RFM_PSST_RULE | PSST Grouping Rule | RFM_PSST_RULE | CHAR | 4 | |
| RFM_PSST_GROUP | PSST Group | RFM_PSST_GROUP_ID | CHAR | 10 | |
| PARGB | Trading partner's business area | PARGB | * | CHAR | 4 |
| AUFPL_OAA | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL_OAA | Internal counter | CIM_COUNT | NUMC | 8 | |
| VLCENDCU | End Customer (Central Business Partner) | VLC_ENDCU | CHAR | 10 | |
| WRF_CHARSTC1 | Characteristic Value 1 | WRF_CHARSTC1 | CHAR | 18 | |
| WRF_CHARSTC2 | Characteristic Value 2 | WRF_CHARSTC2 | CHAR | 18 | |
| WRF_CHARSTC3 | Characteristic Value 3 | WRF_CHARSTC3 | CHAR | 18 | |
| ARSNUM | Number of reservation/dependent requirements | WTYSC_RSNUM | * | NUMC | 10 |
| ARSPOS | Item number of reservation/dependent requirements | WTYSC_RSPOS | NUMC | 4 | |
| WTYSC_CLMITEM | Claim item number | WTYSC_CLMITEM | CHAR | 16 | |
| ZFIELD | Character Field with Length 10 | CHAR10 | CHAR | 10 | |
| LADGR | Loading Group | LADGR | * | CHAR | 4 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VBAP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBAP | ABFOR | C: CN | T691K |
| VBAP | ABGRS | C: CN | TKKAA |
| VBAP | ABGRU | C: CN | TVAG |
| VBAP | AD01PROFNR | 1: CN | AD01C_PROF |
| VBAP | ADICC | 1: CN | CSPCICC |
| VBAP | ADMOI | 1: CN | CSPCMOI |
| VBAP | ADPRI | 1: CN | CSPCPRI |
| VBAP | AUFNR | C: CN | AUFK |
| VBAP | BEDAE | C: CN | T459A |
| VBAP | BONUS | C: CN | TVBO |
| VBAP | BPN | : | T880 |
| VBAP | BWTAR | C: CN | T149D |
| VBAP | CHARG | C: CN | MCHA |
| VBAP | CLINT | 1: CN | KLAH |
| VBAP | EQART | : | T370K |
| VBAP | EQUNR | : | EQUI |
| VBAP | FAKSP | C: CN | TVFS |
| VBAP | FERC_IND | : | FERC_C7 |
| VBAP | FSH_COLLECTION | : | FSH_COLLECTIONS |
| VBAP | FSH_SEASON | : | FSH_SEASONS |
| VBAP | FSH_SEASON_YEAR | : | FSH_SEASONS |
| VBAP | FSH_THEME | : | FSH_THEMES |
| VBAP | GEWEI | C: CN | T006 |
| VBAP | GSBER | C: CN | TGSB |
| VBAP | J_1BCFOP | 1: CN | J_1BAG |
| VBAP | J_1BTAXLW1 | C: CN | J_1BATL1 |
| VBAP | J_1BTAXLW2 | C: CN | J_1BATL2 |
| VBAP | J_1BTAXLW3 | 1: CN | J_1BATL3 |
| VBAP | J_1BTAXLW4 | 1: CN | J_1BATL4A |
| VBAP | J_1BTAXLW5 | 1: CN | J_1BATL5 |
| VBAP | J_1BTXSDC | C: CN | J_1BTXSDC |
| VBAP | J_3GBELNRI | : | J_3GBELK |
| VBAP | J_3GLVART | : | J_3GLEIART |
| VBAP | J_3GPOSNRI | : | J_3GBELP |
| VBAP | KALSM_K | 1: CN | T683 |
| VBAP | KALVAR | 1: CN | TCK03 |
| VBAP | KMEIN | C: CN | T006 |
| VBAP | KNTTP | C: CN | T163K |
| VBAP | KNUMA_AG | C: CN | KONA |
| VBAP | KNUMA_PI | C: CN | KONA |
| VBAP | KONDM | C: CN | T178 |
| VBAP | KOSCH | 1: CN | T190S |
| VBAP | KTGRM | C: CN | TVKM |
| VBAP | LGORT | C: CN | T001L |
| VBAP | LPRIO | C: CN | TPRIO |
| VBAP | MAGRV | C: CN | TVEGR |
| VBAP | MANDT | 1: CN | T000 |
| VBAP | MATKL | C: CN | T023 |
| VBAP | MATNR | C: CN | MARA |
| VBAP | MATWA | C: CN | MARA |
| VBAP | MEINS | C: CN | T006 |
| VBAP | MFRGR | 1: CN | TMFG |
| VBAP | MSR_REFUND_CODE | 1: CN | MSR_C_RET_REFUND |
| VBAP | MSR_RET_REASON | 1: CN | MSR_C_RET_REASON |
| VBAP | MTVFP | C: CN | TMVF |
| VBAP | MVGR1 | C: CN | TVM1 |
| VBAP | MVGR2 | C: CN | TVM2 |
| VBAP | MVGR3 | C: CN | TVM3 |
| VBAP | MVGR4 | C: CN | TVM4 |
| VBAP | MVGR5 | C: CN | TVM5 |
| VBAP | OBJNR | C: CN | ONR00 |
| VBAP | PLAVO | 1: CN | TVZP |
| VBAP | PMATN | C: CN | MARA |
| VBAP | PRBME | C: CN | T006 |
| VBAP | PRODH | C: CN | T179 |
| VBAP | PROVG | C: CN | TVPR |
| VBAP | PR_F_F | : | ESD_TOPR |
| VBAP | PR_F_L | : | ESD_TOPR |
| VBAP | PR_L_L | : | ESD_TOPR |
| VBAP | PSTYV | 1: CN | TVPT |
| VBAP | PS_PSP_PNR | C: CN | PRPS |
| VBAP | ROUTE | C: CN | TVRO |
| VBAP | SERAIL | : | T377P |
| VBAP | SERNR | C: CN | SNUM |
| VBAP | SERVICE_DOC_TYPE | : | CRMC_PROC_TYPE |
| VBAP | SKOPF | C: CN | WSOH |
| VBAP | SOBKZ | C: CN | T148 |
| VBAP | SPART | C: CN | TSPA |
| VBAP | SUGRD | C: CN | TVSU |
| VBAP | UKONM | C: CN | T178 |
| VBAP | UPMAT | C: CN | MARA |
| VBAP | VBELN | 1: CN | VBAK |
| VBAP | VKAUS | C: CN | TVLV |
| VBAP | VKGRU | 1: CN | TVRMAVK |
| VBAP | VOLEH | C: CN | T006 |
| VBAP | VPMAT | C: CN | MARA |
| VBAP | VPWRK | C: CN | T001W |
| VBAP | VRKME | C: CN | T006 |
| VBAP | VSTEL | C: CN | TVST |
| VBAP | WAERK | C: CN | TCURC |
| VBAP | WKTNR | C: CN | VBAK |
| VBAP | WKTPS | C: CN | VBAP |
| VBAP | ZAPCGKI | : | /ILE/TV01 |
| VBAP | ZIEME | C: CN | T006 |