SAP VBRP Billing Document: Item Data Table
Overview
VBRP is a standard SAP S/4HANA table that stores Billing Document: Item Data data. There are total 290 fields in the VBRP table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VBRP belongs to Billing (SD-BIL) module and is located in the package Application development R/3 invoice (VF).
In addition, following links provide an overview of foreign key relationships, if any, that link VBRP to other SAP tables and standard CDS views available based on VBRP table in S/4HANA 2020.
Techincal Settings of VBRP
Below are technical details of the table VBRP
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VBRP Fields
The following table gives you an overview of the fields available in VBRP
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| VBELN | Billing Document | VBELN_VF | VBRK | CHAR | 10 |
| POSNR | Billing Item | POSNR_VF | NUMC | 6 | |
| UEPOS | Higher-Level item in bill of material structures | UEPOS | NUMC | 6 | |
| FKIMG | Actual billed quantity | FKIMG | QUAN | 13 | |
| 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 | |
| MEINS | Base Unit of Measure | MEINS | T006 | UNIT | 3 |
| SMENG | Scale Quantity in base unit of measure | SMENG | QUAN | 13 | |
| FKLMG | Billing quantity in stockkeeping unit | FKLMG | QUAN | 13 | |
| LMENG | Required quantity for mat.management in stockkeeping units | LMENG | QUAN | 13 | |
| NTGEW | Net weight | NTGEW_15 | QUAN | 15 | |
| BRGEW | Gross weight | BRGEW_15 | QUAN | 15 | |
| GEWEI | Weight Unit | GEWEI | T006 | UNIT | 3 |
| VOLUM | Volume | VOLUM_15 | QUAN | 15 | |
| VOLEH | Volume unit | VOLEH | T006 | UNIT | 3 |
| GSBER | Business Area | GSBER | TGSB | CHAR | 4 |
| PRSDT | Date for Pricing and Exchange Rate | PRSDT | DATS | 8 | |
| FBUDA | Date on which services are rendered | FBUDA | DATS | 8 | |
| KURSK | Exchange Rate for Price Determination | KURSK | DEC | 9 | |
| NETWR | Net value of the billing item in document currency | NETWR_FP | CURR | 15 | |
| 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 | |
| VGTYP | Document Category of Preceding SD Document | VBTYPL_V | CHAR | 4 | |
| AUBEL | Sales Document | VBELN_VA | VBAK | CHAR | 10 |
| AUPOS | Sales Document Item | POSNR_VA | VBAP | NUMC | 6 |
| AUREF | Sales document was created from reference | AUREF | CHAR | 1 | |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| ARKTX | Short text for sales order item | ARKTX | 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 |
| PSTYV | Sales document item category | PSTYV | CHAR | 4 | |
| POSAR | Item Type | POSAR | CHAR | 1 | |
| PRODH | Product hierarchy | PRODH_D | T179 | CHAR | 18 |
| VSTEL | Shipping Point / Receiving Point | VSTEL | TVST | CHAR | 4 |
| ATPKZ | Replacement part | ATPKZ | CHAR | 1 | |
| SPART | Division | SPART | TSPA | CHAR | 2 |
| POSPA | Item number in the partner segment | POSPA | VBRP | NUMC | 6 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| ALAND | Departure country (country from which the goods are sent) | ALAND | T005 | CHAR | 3 |
| WKREG | Region in which plant is located | WKREG | T005S | CHAR | 3 |
| WKCOU | County in which plant is located | WKCOU | CHAR | 3 | |
| WKCTY | City in which plant is located | WKCTY | CHAR | 4 | |
| TAXM1 | Tax classification material | TAXM1 | CHAR | 1 | |
| TAXM2 | Tax classification 2 for material | TAXM2 | CHAR | 1 | |
| TAXM3 | Tax classification 3 for material | TAXM3 | CHAR | 1 | |
| TAXM4 | Tax Classification 4 Material | TAXM4 | CHAR | 1 | |
| TAXM5 | Tax classification 5 for material | TAXM5 | CHAR | 1 | |
| TAXM6 | Tax classification 6 for material | TAXM6 | CHAR | 1 | |
| TAXM7 | Tax classification 7 for material | TAXM7 | CHAR | 1 | |
| TAXM8 | Tax Classification 8 Material | TAXM8 | CHAR | 1 | |
| TAXM9 | Tax Classification 9 Material | TAXM9 | CHAR | 1 | |
| KOWRR | Statistical Values | KOWRR | CHAR | 1 | |
| PRSFD | Carry out pricing | PRSFD | CHAR | 1 | |
| SKTOF | Cash discount indicator | SKTOF | CHAR | 1 | |
| SKFBP | Amount eligible for cash discount in document currency | SKFBP | CURR | 13 | |
| KONDM | Material Price Group | KONDM | T178 | CHAR | 2 |
| KTGRM | Account Assignment Group for Material | KTGRM | TVKM | CHAR | 2 |
| KOSTL | Cost Center | KOSTL | CHAR | 10 | |
| BONUS | Volume rebate group | BONUS | TVBO | CHAR | 2 |
| PROVG | Commission group | PROVG | TVPR | CHAR | 2 |
| EANNR | European Article Number (EAN) - obsolete!!!!! | EANNR | CHAR | 13 | |
| VKGRP | Sales group | VKGRP | TVKGR | CHAR | 3 |
| VKBUR | Sales office | VKBUR | TVBUR | CHAR | 4 |
| SPARA | Division for order header | SPART_AK | TSPA | CHAR | 2 |
| SHKZG | Returns item | SHKZG_VF | CHAR | 1 | |
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | |
| ERDAT | Date on which the record was created | ERDAT | DATS | 8 | |
| ERZET | Entry time | ERZET | TIMS | 6 | |
| BWTAR | Valuation Type | BWTAR_D | T149D | CHAR | 10 |
| LGORT | Storage location | LGORT_D | T001L | CHAR | 4 |
| 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 | |
| UVPRS | Incomplete with respect to pricing | UVPRS | CHAR | 1 | |
| UVALL | Generally incomplete | UVALL | CHAR | 1 | |
| EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | |
| PRCTR | Profit Center | PRCTR | CHAR | 10 | |
| KVGR1 | Customer group 1 | KVGR1 | TVV1 | CHAR | 3 |
| KVGR2 | Customer group 2 | KVGR2 | TVV2 | CHAR | 3 |
| KVGR3 | Customer group 3 | KVGR3 | TVV3 | CHAR | 3 |
| KVGR4 | Customer group 4 | KVGR4 | TVV4 | CHAR | 3 |
| KVGR5 | Customer group 5 | KVGR5 | TVV5 | CHAR | 3 |
| 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 |
| MATWA | Material entered | MATWA | MARA | CHAR | 40 |
| BONBA | Rebate basis 1 | BONBA | CURR | 13 | |
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 |
| PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | |
| PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | |
| AUFNR | Order Number | AUFNR | AUFK | CHAR | 12 |
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | |
| CMPRE | Item credit price | CMPRE | CURR | 11 | |
| CMPNT | ID: Item with active credit function / relevant for credit | CMPNT | CHAR | 1 | |
| CUOBJ | Configuration | CUOBJ_VA | NUMC | 18 | |
| CUOBJ_CH | Internal object number of the batch classification | CUOBJ_CH | NUMC | 18 | |
| KOUPD | Condition Update | KOUPD | CHAR | 1 | |
| UECHA | Higher-Level Item of Batch Split Item | UECHA | NUMC | 6 | |
| XCHAR | Batch management indicator (internal) | XCHAR | CHAR | 1 | |
| ABRVW | Usage Indicator | ABRVW | TVLV | CHAR | 3 |
| SERNR | BOM explosion number | SERNR | SNUM | CHAR | 8 |
| BZIRK_AUFT | Sales district of sales order | BZIRK_AUFT | T171 | CHAR | 6 |
| KDGRP_AUFT | Customer group of sales order | KDGRP_AUFT | T151 | CHAR | 2 |
| KONDA_AUFT | Price group of sales order | KONDA_AUFT | T188 | CHAR | 2 |
| LLAND_AUFT | Country of destination of sales order | LLAND_AUFT | T005 | CHAR | 3 |
| MPROK | Status manual price change | MPROK | CHAR | 1 | |
| PLTYP_AUFT | Price list type of sales order | PLTYP_AUFT | T189 | CHAR | 2 |
| REGIO_AUFT | Region of sales order | REGIO_AUFT | T005S | CHAR | 3 |
| VKORG_AUFT | Sales organization of sales order | VKORG_AUFT | TVKO | CHAR | 4 |
| VTWEG_AUFT | Distribution channel of sales order | VTWEG_AUFT | TVTW | CHAR | 2 |
| ABRBG | Start of accounting settlement period | ABRBG | DATS | 8 | |
| PROSA | ID for material determination | PROSA | CHAR | 1 | |
| UEPVW | ID for higher-level item usage | UEPVW | CHAR | 1 | |
| AUTYP | SD Document Category | VBTYPL | CHAR | 4 | |
| STADAT | Statistics date | STADAT | DATS | 8 | |
| FPLNR | Billing plan number / invoicing plan number | FPLNR | FPLA | CHAR | 10 |
| FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | NUMC | 6 | |
| AKTNR | Promotion | WAKTION | WAKH | CHAR | 10 |
| KNUMA_PI | Sales Promotion | KNUMA_PI | KONA | CHAR | 10 |
| KNUMA_AG | Sales deal | KNUMA_AG | KONA | CHAR | 10 |
| MWSBP | Tax amount in document currency | MWSBP | CURR | 13 | |
| AUGRU_AUFT | Order Reason (Reason for the Business Transaction) | AUGRU | TVAU | CHAR | 3 |
| FAREG | Rule in billing plan/invoice plan | FAREG | CHAR | 1 | |
| UPMAT | Pricing reference material of main item | UPMAT | MARA | CHAR | 40 |
| UKONM | Material pricing group of main item | UKONM | T178 | CHAR | 2 |
| 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_1ARFZ | Reason for zero VAT | J_1ARFZVAT | J_1ARFZ | CHAR | 1 |
| J_1AREGIO | Region (State Province County) | REGIO | T005S | CHAR | 3 |
| J_1AGICD | Activity Code for Gross Income Tax | J_1AGICD_D | J_1AGICD | CHAR | 2 |
| J_1ADTYP | Distribution Type for Employment Tax | J_1ADTYP_D | J_1ADTYP | CHAR | 2 |
| J_1ATXREL | Tax relevant classification | J_1ATXREL_ | J_1ATXREL | CHAR | 10 |
| 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 |
| BRTWR | Gross value of the billing item in document currency | BRTWR_FP | CURR | 15 | |
| WKTNR | Value Contract No. | WKTNR | VBAK | CHAR | 10 |
| WKTPS | Value Contract Item | WKTPS | VBAP | NUMC | 6 |
| RPLNR | Payment card plan number of sales document | RPLNR_AU | FPLA | CHAR | 10 |
| KURSK_DAT | Translation date | WWERT_D | DATS | 8 | |
| WGRU1 | Material group hierarchy 1 | WGRU_HIE1 | CHAR | 18 | |
| WGRU2 | Material group hierarchy 2 | WGRU_HIE2 | CHAR | 18 | |
| KDKG1 | Customer condition group 1 | KDKG1 | TVKGG | CHAR | 2 |
| KDKG2 | Customer condition group 2 | KDKG2 | TVKGG | CHAR | 2 |
| KDKG3 | Customer condition group 3 | KDKG3 | TVKGG | CHAR | 2 |
| KDKG4 | Customer condition group 4 | KDKG4 | TVKGG | CHAR | 2 |
| KDKG5 | Customer condition group 5 | KDKG5 | TVKGG | CHAR | 2 |
| VKAUS | Usage Indicator | ABRVW | TVLV | CHAR | 3 |
| J_1AINDXP | Inflation Index | J_1AINDXP | J_1AINFT20 | CHAR | 5 |
| J_1AIDATEP | Indexing base date | J_1AIDATES | DATS | 8 | |
| KZFME | ID: Leading unit of measure for completing a transaction | KZFME | CHAR | 1 | |
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | |
| VERTT | Contract Type | RANTYP | CHAR | 1 | |
| VERTN | Contract Number | RANL | CHAR | 13 | |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| DELCO | Agreed Delivery Time | DELCO | CHAR | 3 | |
| BEMOT | Accounting Indicator | BEMOT | TBMOT | CHAR | 2 |
| RRREL | Revenue recognition category | RR_RELTYP | CHAR | 1 | |
| WMINR | Product catalog number | WMINR | WWMI | CHAR | 10 |
| VGBEL_EX | Document number of the reference document | VGBEL | CHAR | 10 | |
| VGPOS_EX | Item number of the reference item | VGPOS | NUMC | 6 | |
| LOGSYS | Logical system | LOGSYS | CHAR | 10 | |
| VGTYP_EX | Category of an external transaction or element | VGTYP_EX | CHAR | 3 | |
| 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 |
| MSR_ID | Process Identification Number | MSR_PROCESS_ID | CHAR | 10 | |
| MSR_REFUND_CODE | Returns Refund Code | MSR_RETURNS_REFUND_CODE | MSR_C_RET_REFUND | CHAR | 3 |
| MSR_RET_REASON | Return Reason | MSR_RETURNS_REASON | MSR_C_RET_REASON | CHAR | 3 |
| NRAB_KNUMH | Number of the Condition Record | KNUMH | CHAR | 10 | |
| NRAB_VALUE | Condition Value | KWERT | CURR | 13 | |
| DISPUTE_CASE | Dispute Case | DISPUTE_CASE | RAW | 16 | |
| FUND_USAGE_ITEM | Fund Usage Item | FUND_USAGE_ITEM | RAW | 16 | |
| FARR_RELTYPE | Revenue Accounting Type | FARR_RELTYPE | CHAR | 10 | |
| CLAIMS_TAXATION | Claims Taxation | CLAIMS_TAXATION | CHAR | 1 | |
| KURRF_DAT_ORIG | Translation date | WWERT_D | DATS | 8 | |
| SGT_RCAT | Requirement Segment | SGT_RCAT | CHAR | 40 | |
| SGT_SCAT | Stock Segment | SGT_SCAT | CHAR | 40 | |
| PREFE | Customs Preference | PREFE | CHAR | 1 | |
| AKKUR | Exchange rate for letter-of-credit procg in foreign trade | AKKUR | DEC | 9 | |
| WAERK | SD document currency | WAERK | CUKY | 5 | |
| DRAFT | Boolean Variable (X = True - = False Space = Unknown) | BOOLEAN | CHAR | 1 | |
| ACTIVEDOCUMENT | Sales and Distribution Document Number | VBELN | CHAR | 10 | |
| GRWRT | Statistical value for foreign trade | GRWRT | CURR | 13 | |
| FKSAA | Order-Related Billing Status (Item) | FKSAA | CHAR | 1 | |
| ABSTA | Rejection Status for Billing Document Request Item | ABSTA_BDR | CHAR | 1 | |
| ABGRU | Rejection Reason for Billing Document Request Item | ABGRU_BDR | CHAR | 2 | |
| MWSK1 | Tax on sales/purchases code | MWSKZ | CHAR | 2 | |
| PBD_ID | Preliminary Billing Document | PBD_ID | CHAR | 10 | |
| PBD_ITEM_ID | Preliminary Billing Document Item | PBD_ITEM_ID | NUMC | 6 | |
| CATS_OVERTIME_CATEGORY | Overtime Category | CATS_OVERTIME_CATEGORY | CHAR | 4 | |
| CONTR_DP_SETTL | Settlement of Down Payment from Sales Contract | CONTR_DP_SETTL_VF | CHAR | 1 | |
| PRODH_UNIV_SALES_PARNT_NODID | Node ID | NODID | CHAR | 40 | |
| REASON_CODE | Reason for Change in Expected Delivery Quantity | SD_ITEM_REASON_CODE | CHAR | 3 | |
| _DATAAGING | Data Filter Value for Data Aging | DATA_TEMPERATURE | DATS | 8 | |
| SPE_HERKL | Country of Origin of Material (Non-Preferential Origin) | HERKL | CHAR | 3 | |
| SPE_HERKR | Region of Origin of Material (Non-Preferential Origin) | HERKR | CHAR | 3 | |
| ITM_COMCO | Commodity Code | /SAPSLL/COMCO | CHAR | 30 | |
| DUMMY_BILLGDOCITEM_INCL_EEW_PS | Dummy function in length 1 | DUMMY | CHAR | 1 | |
| 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_ITEM_ID | Solution Order Item | CRMS4_SOLO_NUMBER_INT | NUMC | 6 | |
| /CWM/MENGE | Quantity in Parallel Unit of Measure | /CWM/MENGE | QUAN | 13 | |
| /CWM/MEINS | Parallel Unit of Measure | /CWM/MEINS | * | UNIT | 3 |
| VBTYP_ANA | SD Document Category | VBTYPL | CHAR | 4 | |
| FKART_ANA | Billing Type | FKART | * | CHAR | 4 |
| VKORG_ANA | Sales Organization | VKORG | CHAR | 4 | |
| VTWEG_ANA | Distribution Channel | VTWEG | CHAR | 2 | |
| KONDA_ANA | Customer Price Group | KONDA | * | CHAR | 2 |
| KDGRP_ANA | Customer Group | KDGRP | * | CHAR | 2 |
| LAND1_ANA | Destination Country/Region | LLAND | * | CHAR | 3 |
| REGIO_ANA | Region (State Province County) | REGIO | * | CHAR | 3 |
| CITYC_ANA | City Code | CITYC | * | CHAR | 4 |
| BZIRK_ANA | Sales District | BZIRK | * | CHAR | 6 |
| GBSTK_ANA | Overall Processing Status (Header/All Items) | GBSTK | CHAR | 1 | |
| VF_STATUS_ANA | SD Billing Status | VF_STATUS | CHAR | 1 | |
| KUNAG_ANA | Sold-To Party | KUNAG | * | CHAR | 10 |
| KUNRG_ANA | Payer | KUNRG | * | CHAR | 10 |
| FKDAT_ANA | Billing Date | FKDAT | DATS | 8 | |
| BUKRS_ANA | Company Code | BUKRS | CHAR | 4 | |
| COUNC_ANA | County Code | COUNC | * | CHAR | 3 |
| KNUMA_ANA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | |
| FKTYP_ANA | Billing Category | FKTYP | CHAR | 1 | |
| KNUMV_ANA | Number of the Document Condition | KNUMV | 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 | |
| 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 | |
| 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 | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL | Internal counter | CIM_COUNT | NUMC | 8 | |
| DPCNR | Down Payment Chain Number | /SAPPCE/DPCNR | CHAR | 10 | |
| DCPNR | Transaction Number | /SAPPCE/DPCPNR | NUMC | 3 | |
| DPNRB | Sequence Number of Accounting Document in Transaction | /SAPPCE/DPCPNRB | NUMC | 3 | |
| BOSFAR | Billing/Invoicing rule (w/o invoicing plan | BOSFAR | CHAR | 1 | |
| DP_BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | |
| DP_BUKRS | Company Code | BUKRS | CHAR | 4 | |
| DP_GJAHR | Fiscal Year | GJAHR | NUMC | 4 | |
| DP_BUZEI | Number of Line Item Within Accounting Document | BUZEI | NUMC | 3 | |
| PACKNO | Package number | PACKNO | ESLH | NUMC | 10 |
| PEROP_BEG | Period of Performance Start Date | FM_PEROP_SD_LOW | DATS | 8 | |
| PEROP_END | Period of Performance End Date | FM_PEROP_SD_HIGH | DATS | 8 | |
| FMFGUS_KEY | United States Federal Government Fields | FMFG_US_KEY | CHAR | 22 | |
| FSH_SEASON_YEAR | Season Year | FSH_SAISJ | CHAR | 4 | |
| FSH_SEASON | Season | FSH_SAISO | CHAR | 10 | |
| FSH_COLLECTION | Fashion Collection | FSH_COLLECTION | * | CHAR | 10 |
| FSH_THEME | Fashion Theme | FSH_THEME | 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 |
| J_3GBELNRI | Document Number | J_3GBELNRI | J_3GBELK | CHAR | 10 |
| J_3GPMAUFE | PM Order Number (Owner) | J_3GPMAUFE | AUFK | CHAR | 12 |
| J_3GPMAUFV | PM Order Number (Administrator) | J_3GPMAUFV | AUFK | CHAR | 12 |
| J_3GETYPA | Sending Recipient Type | J_3GETYPA | * | CHAR | 2 |
| J_3GETYPE | Receiving Recipient Type | J_3GETYPE | * | CHAR | 2 |
| J_3GORGUEB | Indicator: Across All Organizational Structures | J_3GORGUEB | CHAR | 1 | |
| PRS_WORK_PERIOD | Work Period (Internal Representation) | PRS_WORK_PERIOD | NUMC | 7 | |
| PPRCTR | Partner Profit Center | PPRCTR | * | 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 | |
| CAMPAIGN | Generic project planning: GUID from external R/3 system | CGPL_GUID16_R3 | RAW | 16 | |
| COMPREAS | Abbreviation for Complaints Reason | CMP_COMPREAS_COPY | CHAR | 4 | |
| 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 |
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 VBRP
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VBRP | ABFOR | C: CN | T691K |
| VBRP | ABRVW | C: CN | TVLV |
| VBRP | AKTNR | C: CN | WAKH |
| VBRP | ALAND | 1: CN | T005 |
| VBRP | AUBEL | C: CN | VBAK |
| VBRP | AUFNR | C: CN | AUFK |
| VBRP | AUGRU_AUFT | C: CN | TVAU |
| VBRP | AUPOS | C: CN | VBAP |
| VBRP | BEMOT | C: CN | TBMOT |
| VBRP | BONUS | C: CN | TVBO |
| VBRP | BWTAR | C: CN | T149D |
| VBRP | BZIRK_AUFT | C: CN | T171 |
| VBRP | CHARG | C: CN | MCHA |
| VBRP | FPLNR | C: CN | FPLA |
| VBRP | GEWEI | C: CN | T006 |
| VBRP | GSBER | C: CN | TGSB |
| VBRP | J_1ADTYP | 1: CN | J_1ADTYP |
| VBRP | J_1AGICD | 1: CN | J_1AGICD |
| VBRP | J_1AINDXP | 1: CN | J_1AINFT20 |
| VBRP | J_1AREGIO | 1: CN | T005S |
| VBRP | J_1ARFZ | 1: CN | J_1ARFZ |
| VBRP | J_1ATXREL | 1: CN | J_1ATXREL |
| VBRP | J_1BCFOP | 1: CN | J_1BAG |
| VBRP | J_1BTAXLW1 | 1: CN | J_1BATL1 |
| VBRP | J_1BTAXLW2 | 1: CN | J_1BATL2 |
| VBRP | J_1BTAXLW3 | 1: CN | J_1BATL3 |
| VBRP | J_1BTAXLW4 | 1: CN | J_1BATL4A |
| VBRP | J_1BTAXLW5 | 1: CN | J_1BATL5 |
| VBRP | J_1BTXSDC | 1: CN | J_1BTXSDC |
| VBRP | J_3GBELNRI | : | J_3GBELK |
| VBRP | J_3GPMAUFE | : | AUFK |
| VBRP | J_3GPMAUFV | : | AUFK |
| VBRP | KDGRP_AUFT | C: CN | T151 |
| VBRP | KDKG1 | C: CN | TVKGG |
| VBRP | KDKG2 | C: CN | TVKGG |
| VBRP | KDKG3 | C: CN | TVKGG |
| VBRP | KDKG4 | C: CN | TVKGG |
| VBRP | KDKG5 | C: CN | TVKGG |
| VBRP | KNUMA_AG | C: CN | KONA |
| VBRP | KNUMA_PI | C: CN | KONA |
| VBRP | KOKRS | C: CN | TKA01 |
| VBRP | KONDA_AUFT | C: CN | T188 |
| VBRP | KONDM | C: CN | T178 |
| VBRP | KTGRM | C: CN | TVKM |
| VBRP | KVGR1 | C: CN | TVV1 |
| VBRP | KVGR2 | C: CN | TVV2 |
| VBRP | KVGR3 | C: CN | TVV3 |
| VBRP | KVGR4 | C: CN | TVV4 |
| VBRP | KVGR5 | C: CN | TVV5 |
| VBRP | LGORT | C: CN | T001L |
| VBRP | LLAND_AUFT | C: CN | T005 |
| VBRP | MANDT | 1: CN | T000 |
| VBRP | MATKL | C: CN | T023 |
| VBRP | MATNR | C: CN | MARA |
| VBRP | MATWA | C: CN | MARA |
| VBRP | MEINS | C: CN | T006 |
| VBRP | MSR_REFUND_CODE | : | MSR_C_RET_REFUND |
| VBRP | MSR_RET_REASON | : | MSR_C_RET_REASON |
| VBRP | MVGR1 | C: CN | TVM1 |
| VBRP | MVGR2 | C: CN | TVM2 |
| VBRP | MVGR3 | C: CN | TVM3 |
| VBRP | MVGR4 | C: CN | TVM4 |
| VBRP | MVGR5 | C: CN | TVM5 |
| VBRP | PACKNO | : | ESLH |
| VBRP | PLTYP_AUFT | C: CN | T189 |
| VBRP | PMATN | C: CN | MARA |
| VBRP | POSPA | C: CN | VBRP |
| VBRP | PRODH | C: CN | T179 |
| VBRP | PROVG | C: CN | TVPR |
| VBRP | REGIO_AUFT | C: CN | T005S |
| VBRP | RPLNR | C: N | FPLA |
| VBRP | SERNR | C: CN | SNUM |
| VBRP | SERVICE_DOC_TYPE | : | CRMC_PROC_TYPE |
| VBRP | SPARA | C: CN | TSPA |
| VBRP | SPART | C: CN | TSPA |
| VBRP | UKONM | C: CN | T178 |
| VBRP | UPMAT | C: CN | MARA |
| VBRP | VBELN | 1: CN | VBRK |
| VBRP | VKAUS | C: CN | TVLV |
| VBRP | VKBUR | C: CN | TVBUR |
| VBRP | VKGRP | C: CN | TVKGR |
| VBRP | VKORG_AUFT | C: CN | TVKO |
| VBRP | VOLEH | C: CN | T006 |
| VBRP | VRKME | C: CN | T006 |
| VBRP | VSTEL | C: CN | TVST |
| VBRP | VTWEG_AUFT | C: CN | TVTW |
| VBRP | WERKS | C: CN | T001W |
| VBRP | WKREG | C: CN | T005S |
| VBRP | WKTNR | C: CN | VBAK |
| VBRP | WKTPS | C: CN | VBAP |
| VBRP | WMINR | 1: CN | WWMI |
| VBRP | ZAPCGKI | : | /ILE/TV01 |