SAP Table

VBRP Billing Document: Item Data

SAP Table VBRP (Billing Document: Item Data) is part of the Sales and Distribution (SD) module in SAP. It stores detailed information about individual items in billing documents, such as materials, quantities, pricing, taxes, and delivery-related data. Each record in VBRP represents an item within a billing document (linked to header data in table VBRK) and includes fields for item-specific details like material number, billing quantity, and net value. VBRP is essential for invoice processing and serves as a key table for financial reporting and reconciliation in SAP.

SAP table VBRP has 3 primary key fields being MANDT,VBELN,POSNR.

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

/ Fields

VBRP columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 T000 MANDT
KeyVBELN Billing Document CHAR 10 0 VBRK VBELN_VF
KeyPOSNR Billing Item NUMC 6 0 POSNR_VF
UEPOS Higher-Level Item in Bill of Material Structures NUMC 6 0 UEPOS
FKIMG Actual billed quantity QUAN 13 3 FKIMG
VRKME Sales unit UNIT 3 0 T006 VRKME
UMVKZ Numerator (factor) for conversion of sales quantity into SKU DEC 5 0 UMVKZ
UMVKN Denominator (divisor) for conversion of sales Qty into SKU DEC 5 0 UMVKN
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
SMENG Scale Quantity in base unit of measure QUAN 13 3 SMENG
FKLMG Billing quantity in stock keeping unit QUAN 13 3 FKLMG
LMENG Required quantity for mat.management in stockkeeping units QUAN 13 3 LMENG
NTGEW Net weight QUAN 15 3 NTGEW_15
BRGEW Gross weight QUAN 15 3 BRGEW_15
GEWEI Weight Unit UNIT 3 0 T006 GEWEI
VOLUM Volume QUAN 15 3 VOLUM_15
VOLEH Volume unit UNIT 3 0 T006 VOLEH
GSBER Business Area CHAR 4 0 TGSB GSBER
PRSDT Date for Pricing and Exchange Rate DATS 8 0 PRSDT
FBUDA Date on which services are rendered DATS 8 0 FBUDA
KURSK Exchange Rate for Price Determination DEC 9 5 KURSK
NETWR Net Value of Billing item in Document Currency CURR 15 2 NETWR_FP
VBELV Originating Document CHAR 10 0 VBELV
POSNV Originating Item NUMC 6 0 POSNV
VGBEL Document number of the reference document CHAR 10 0 VGBEL
VGPOS Item number of the reference item NUMC 6 0 VGPOS
VGTYP Document Category of Preceding SD Document CHAR 4 0 VBTYPL_V
AUBEL Sales Document CHAR 10 0 VBAK VBELN_VA
AUPOS Sales Document Item NUMC 6 0 VBAP POSNR_VA
AUREF Sales document was created from reference CHAR 1 0 AUREF
MATNR Material Number CHAR 40 0 MARA MATNR
ARKTX Short text for sales order item CHAR 40 0 ARKTX
PMATN Pricing Reference Material CHAR 40 0 MARA PMATN
CHARG Batch Number CHAR 10 0 MCHA CHARG_D
MATKL Material Group CHAR 9 0 T023 MATKL
PSTYV Sales document item category CHAR 4 0 PSTYV
POSAR Item Type CHAR 1 0 POSAR
PRODH Product hierarchy CHAR 18 0 T179 PRODH_D
VSTEL Shipping Point / Receiving Point CHAR 4 0 TVST VSTEL
ATPKZ Replacement part CHAR 1 0 ATPKZ
SPART Division CHAR 2 0 TSPA SPART
POSPA Item Number in the Partner Segment NUMC 6 0 VBRP POSPA
WERKS Plant CHAR 4 0 T001W WERKS_D
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
WKREG Region in which plant is located CHAR 3 0 T005S WKREG
WKCOU County in which plant is located CHAR 3 0 WKCOU
WKCTY City in which plant is located CHAR 4 0 WKCTY
TAXM1 Tax classification material CHAR 1 0 TAXM1
TAXM2 Tax Classification 2 for Material CHAR 1 0 TAXM2
TAXM3 Tax Classification 3 for Material CHAR 1 0 TAXM3
TAXM4 Tax Classification 4 for Material CHAR 1 0 TAXM4
TAXM5 Tax Classification 5 for Material CHAR 1 0 TAXM5
TAXM6 Tax Classification 6 for Material CHAR 1 0 TAXM6
TAXM7 Tax Classification 7 for Material CHAR 1 0 TAXM7
TAXM8 Tax Classification 8 for Material CHAR 1 0 TAXM8
TAXM9 Tax Classification 9 for Material CHAR 1 0 TAXM9
KOWRR Statistical Values CHAR 1 0 KOWRR
PRSFD Carry out pricing CHAR 1 0 PRSFD
SKTOF Cash Discount Indicator CHAR 1 0 SKTOF
SKFBP Amount eligible for cash discount in document currency CURR 13 2 SKFBP
KONDM Material Price Group CHAR 2 0 T178 KONDM
KTGRM Account Assignment Group for Material CHAR 2 0 TVKM KTGRM
KOSTL Cost Center CHAR 10 0 KOSTL
BONUS Volume rebate group CHAR 2 0 TVBO BONUS
PROVG Commission Group CHAR 2 0 TVPR PROVG
EANNR European Article Number (EAN) - obsolete!!!!! CHAR 13 0 EANNR
VKGRP Sales group CHAR 3 0 TVKGR VKGRP
VKBUR Sales office CHAR 4 0 TVBUR VKBUR
SPARA Division for order header CHAR 2 0 TSPA SPART_AK
SHKZG Returns item CHAR 1 0 SHKZG_VF
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
ERZET Entry time TIMS 6 0 ERZET
BWTAR Valuation Type CHAR 10 0 T149D BWTAR_D
LGORT Storage location CHAR 4 0 T001L LGORT_D
STAFO Update Group for statistics update CHAR 6 0 STAFO
WAVWR Cost in Document Currency CURR 13 2 WAVWR
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
STCUR Exchange rate for statistics (Exch.rate at time of creation) DEC 9 5 STCUR_AP
UVPRS Incomplete with respect to pricing CHAR 1 0 UVPRS
UVALL Generally incomplete CHAR 1 0 UVALL
EAN11 International Article Number (EAN/UPC) CHAR 18 0 EAN11
PRCTR Profit Center CHAR 10 0 PRCTR
KVGR1 Customer Group 1 CHAR 3 0 TVV1 KVGR1
KVGR2 Customer Group 2 CHAR 3 0 TVV2 KVGR2
KVGR3 Customer Group 3 CHAR 3 0 TVV3 KVGR3
KVGR4 Customer Group 4 CHAR 3 0 TVV4 KVGR4
KVGR5 Customer Group 5 CHAR 3 0 TVV5 KVGR5
MVGR1 Material Group 1 CHAR 3 0 TVM1 MVGR1
MVGR2 Material Group 2 CHAR 3 0 TVM2 MVGR2
MVGR3 Material Group 3 CHAR 3 0 TVM3 MVGR3
MVGR4 Material Group 4 CHAR 3 0 TVM4 MVGR4
MVGR5 Material Group 5 CHAR 3 0 TVM5 MVGR5
MATWA Material Entered CHAR 40 0 MARA MATWA
BONBA Rebate Basis 1 CURR 13 2 BONBA
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
PAOBJNR Profitability Segment Number (CO-PA) NUMC 10 0 RKEOBJNR
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) NUMC 8 0 PS_PSP_PNR
AUFNR Order Number CHAR 12 0 AUFK AUFNR
TXJCD Tax Jurisdiction CHAR 15 0 TXJCD
CMPRE Item credit price CURR 11 2 CMPRE
CMPNT ID: Item with active credit function / relevant for credit CHAR 1 0 CMPNT
CUOBJ Configuration NUMC 18 0 CUOBJ_VA
CUOBJ_CH Internal object number of the batch classification NUMC 18 0 CUOBJ_CH
KOUPD Condition Update CHAR 1 0 KOUPD
UECHA Higher-Level Item of Batch Split Item NUMC 6 0 UECHA
XCHAR Batch management indicator (internal) CHAR 1 0 XCHAR
ABRVW Usage Indicator CHAR 3 0 TVLV ABRVW
SERNR BOM explosion number CHAR 8 0 SNUM SERNR
BZIRK_AUFT Sales district of sales order CHAR 6 0 T171 BZIRK_AUFT
KDGRP_AUFT Customer group of sales order CHAR 2 0 T151 KDGRP_AUFT
KONDA_AUFT Price group of sales order CHAR 2 0 T188 KONDA_AUFT
LLAND_AUFT Destination Country/Region of Sales Order CHAR 3 0 T005 LLAND_AUFT
MPROK Status manual price change CHAR 1 0 MPROK
PLTYP_AUFT Price list type of sales order CHAR 2 0 T189 PLTYP_AUFT
REGIO_AUFT Region of Sales Order CHAR 3 0 T005S REGIO_AUFT
VKORG_AUFT Sales organization of sales order CHAR 4 0 TVKO VKORG_AUFT
VTWEG_AUFT Distribution channel of sales order CHAR 2 0 TVTW VTWEG_AUFT
ABRBG Start of accounting settlement period DATS 8 0 ABRBG
PROSA ID for material determination CHAR 1 0 PROSA
UEPVW ID for higher-level item usage CHAR 1 0 UEPVW
AUTYP SD Document Category CHAR 4 0 VBTYPL
STADAT Statistics date DATS 8 0 STADAT
FPLNR Billing plan number / invoicing plan number CHAR 10 0 FPLA FPLNR
FPLTR Item for billing plan/invoice plan/payment cards NUMC 6 0 FPLTR
AKTNR Promotion CHAR 10 0 WAKH WAKTION
KNUMA_PI Sales Promotion CHAR 10 0 KONA KNUMA_PI
KNUMA_AG Sales Deal CHAR 10 0 KONA KNUMA_AG
MWSBP Tax Amount in Document Currency CURR 13 2 MWSBP
AUGRU_AUFT Order Reason (Reason for the Business Transaction) CHAR 3 0 TVAU AUGRU
FAREG Rule in billing plan/invoice plan CHAR 1 0 FAREG
UPMAT Pricing reference material of main item CHAR 40 0 MARA UPMAT
UKONM Material pricing group of main item CHAR 2 0 T178 UKONM
CMPRE_FLT Item Credit Price FLTP 16 16 CMPRE_FLT
ABFOR Form of payment guarantee CHAR 2 0 T691K ABSFORM_CM
ABGES Guaranteed (factor between 0 and 1) FLTP 16 16 ABGES_CM
J_1ARFZ Reason for Zero VAT CHAR 1 0 J_1ARFZ J_1ARFZVAT
J_1AREGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
J_1AGICD Activity Code for Gross Income Tax CHAR 2 0 J_1AGICD J_1AGICD_D
J_1ADTYP Distribution Type for Employment Tax CHAR 2 0 J_1ADTYP J_1ADTYP_D
J_1ATXREL Tax relevant classification CHAR 10 0 J_1ATXREL J_1ATXREL_
J_1BCFOP CFOP Code and Extension CHAR 10 0 J_1BAG J_1BCFOP
J_1BTAXLW1 Tax law: ICMS CHAR 3 0 J_1BATL1 J_1BTAXLW1
J_1BTAXLW2 Tax law: IPI CHAR 3 0 J_1BATL2 J_1BTAXLW2
J_1BTXSDC SD tax code CHAR 2 0 J_1BTXSDC J_1BTXSDC_
BRTWR Gross Value of the Billing Item in Document Currency CURR 15 2 BRTWR_FP
WKTNR Value Contract No. CHAR 10 0 VBAK WKTNR
WKTPS Value Contract Item NUMC 6 0 VBAP WKTPS
RPLNR Payment card plan number of sales document CHAR 10 0 FPLA RPLNR_AU
KURSK_DAT Translation date DATS 8 0 WWERT_D
WGRU1 Material group hierarchy 1 CHAR 18 0 WGRU_HIE1
WGRU2 Material group hierarchy 2 CHAR 18 0 WGRU_HIE2
KDKG1 Customer condition group 1 CHAR 2 0 TVKGG KDKG1
KDKG2 Customer condition group 2 CHAR 2 0 TVKGG KDKG2
KDKG3 Customer condition group 3 CHAR 2 0 TVKGG KDKG3
KDKG4 Customer condition group 4 CHAR 2 0 TVKGG KDKG4
KDKG5 Customer condition group 5 CHAR 2 0 TVKGG KDKG5
VKAUS Usage Indicator CHAR 3 0 TVLV ABRVW
J_1AINDXP Inflation Index CHAR 5 0 J_1AINFT20 J_1AINDXP
J_1AIDATEP Indexing base date DATS 8 0 J_1AIDATES
KZFME ID: Leading unit of measure for completing a transaction CHAR 1 0 KZFME
MWSKZ Tax on sales/purchases code CHAR 2 0 MWSKZ
VERTT Contract Type CHAR 1 0 RANTYP
VERTN Contract Number CHAR 13 0 RANL
SGTXT Item Text CHAR 50 0 SGTXT
DELCO Agreed Delivery Time CHAR 3 0 DELCO
BEMOT Accounting Indicator CHAR 2 0 TBMOT BEMOT
RRREL Revenue recognition category CHAR 1 0 RR_RELTYP
WMINR Product catalog number CHAR 10 0 WWMI WMINR
VGBEL_EX Document number of the reference document CHAR 10 0 VGBEL
VGPOS_EX Item number of the reference item NUMC 6 0 VGPOS
LOGSYS Logical system CHAR 10 0 LOGSYS
VGTYP_EX Category of an external transaction or element CHAR 3 0 VGTYP_EX
J_1BTAXLW3 ISS Tax Law CHAR 3 0 J_1BATL3 J_1BTAXLW3
J_1BTAXLW4 COFINS Tax Law CHAR 3 0 J_1BATL4A J_1BTAXLW4
J_1BTAXLW5 PIS Tax Law CHAR 3 0 J_1BATL5 J_1BTAXLW5
MSR_ID Process Identification Number CHAR 10 0 MSR_PROCESS_ID
MSR_REFUND_CODE Returns Refund Code CHAR 3 0 MSR_C_RET_REFUND MSR_RETURNS_REFUND_CODE
MSR_RET_REASON Return Reason CHAR 3 0 MSR_C_RET_REASON MSR_RETURNS_REASON
NRAB_KNUMH Number of the Condition Record CHAR 10 0 KNUMH
NRAB_VALUE Condition Value CURR 13 2 KWERT
DISPUTE_CASE Dispute Case RAW 16 0 DISPUTE_CASE
FUND_USAGE_ITEM Fund Usage Item RAW 16 0 FUND_USAGE_ITEM
FARR_RELTYPE Revenue Accounting Type CHAR 10 0 FARR_RELTYPE
CLAIMS_TAXATION Claims Taxation CHAR 1 0 CLAIMS_TAXATION
KURRF_DAT_ORIG Translation date DATS 8 0 WWERT_D
SGT_RCAT Requirement Segment CHAR 40 0 SGT_RCAT
SGT_SCAT Stock Segment CHAR 40 0 SGT_SCAT
PREFE Customs Preference CHAR 1 0 PREFE
AKKUR Exchange rate for letter-of-credit procg in foreign trade DEC 9 5 AKKUR
WAERK SD Document Currency CUKY 5 0 WAERK
DRAFT Boolean Variable (X = True, - = False, Space = Unknown) CHAR 1 0 BOOLEAN
ACTIVEDOCUMENT Sales and Distribution Document Number CHAR 10 0 VBELN
GRWRT Statistical value for foreign trade CURR 13 2 GRWRT
FKSAA Order-Related Billing Status (Item) CHAR 1 0 FKSAA
ABSTA Rejection Status for Billing Document Request Item CHAR 1 0 ABSTA_BDR
ABGRU Rejection Reason for Billing Document Request Item CHAR 2 0 ABGRU_BDR
MWSK1 Tax on sales/purchases code CHAR 2 0 MWSKZ
TXDAT_FROM Valid-From Date of the Tax Rate DATS 8 0 FOT_TXDAT_FROM
PBD_ID Preliminary Billing Document CHAR 10 0 PBD_ID
PBD_ITEM_ID Preliminary Billing Document Item NUMC 6 0 PBD_ITEM_ID
CATS_OVERTIME_CATEGORY Overtime Category CHAR 4 0 CATS_OVERTIME_CATEGORY
CONTR_DP_SETTL Settlement of Down Payment from Sales Contract CHAR 1 0 CONTR_DP_SETTL_VF
PRODH_UNIV_SALES_PARNT_NODID Node ID CHAR 40 0 NODID
TRANSIT_PLANT Transit Plant CHAR 4 0 TRANSIT_PLANT
VCM_CHAIN_CATEGORY Value Chain Category CHAR 4 0 VCM_CHAIN_CATEGORY
VCM_CHAIN_UUID GUID in 'CHAR' Format in Uppercase CHAR 32 0 GUID_32
REASON_CODE Reason for Return or Expected Delivery Quantity Change CHAR 3 0 SD_ITEM_REASON_CODE
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
SPE_HERKL Country/Region of Origin of Material (Non-Preferential Ori.) CHAR 3 0 HERKL
SPE_HERKR Region of Origin of Material (Non-Preferential Origin) CHAR 3 0 HERKR
ITM_COMCO Commodity Code CHAR 30 0 /SAPSLL/COMCO
VTKEY Identification of a Provider Contract CHAR 20 0 VTKEY_KK
VTPOS Contract: Item Number NUMC 6 0 VTPOS_KK
SRCDOC_PROCESS_TYPE Internal: Special Source Document Type for Billing CHAR 2 0 SRCDOC_PROCESS_TYPE
T2CCODE_CRCY_CONV_FACTOR Factor for calculating Amount in company code currency DEC 31 14 FINS_T2CCODE_CRCY_CONV_FACTOR
T2CNTRY_CRCY_CONV_FACTOR Factor for calculating Tax Amount in reporting currency DEC 31 14 FINS_T2CNTRY_CRCY_CONV_FACTOR
DUMMY_BILLGDOCITEM_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
SERVICE_DOC_TYPE Service Document Type CHAR 4 0 CRMC_PROC_TYPE FCO_SRVDOC_TYPE
SERVICE_DOC_ID Service Document ID CHAR 10 0 FCO_SRVDOC_ID
SERVICE_DOC_ITEM_ID Service Document Item ID NUMC 6 0 FCO_SRVDOC_ITEM_ID
SOLUTION_ORDER_ID Solution Order CHAR 10 0 CRMS4_SOLO_OBJECT_ID
SOLUTION_ORDER_ITEM_ID Solution Order Item NUMC 6 0 CRMS4_SOLO_NUMBER_INT
/CWM/MENGE Quantity in Parallel Unit of Measure QUAN 13 3 /CWM/MENGE
/CWM/MEINS Parallel Unit of Measure UNIT 3 0 * /CWM/MEINS
VBTYP_ANA SD Document Category CHAR 4 0 VBTYPL
FKART_ANA Billing Type CHAR 4 0 * FKART
VKORG_ANA Sales Organization CHAR 4 0 VKORG
VTWEG_ANA Distribution Channel CHAR 2 0 VTWEG
KONDA_ANA Customer Price Group CHAR 2 0 * KONDA
KDGRP_ANA Customer Group CHAR 2 0 * KDGRP
LAND1_ANA Destination Country/Region CHAR 3 0 * LLAND
REGIO_ANA Region (State, Province, County) CHAR 3 0 * REGIO
CITYC_ANA City Code CHAR 4 0 * CITYC
BZIRK_ANA Sales District CHAR 6 0 * BZIRK
GBSTK_ANA Overall Processing Status (Header/All Items) CHAR 1 0 GBSTK
VF_STATUS_ANA SD Billing Status CHAR 1 0 VF_STATUS
KUNAG_ANA Sold-to Party CHAR 10 0 * KUNAG
KUNRG_ANA Payer CHAR 10 0 * KUNRG
FKDAT_ANA Billing Date DATS 8 0 FKDAT
BUKRS_ANA Company Code CHAR 4 0 BUKRS
COUNC_ANA County Code CHAR 3 0 * COUNC
KNUMA_ANA Agreement (various conditions grouped together) CHAR 10 0 KNUMA
FKTYP_ANA Billing Category CHAR 1 0 FKTYP
KNUMV_ANA Number of the Document Condition CHAR 10 0 KNUMV
SFAKN_ANA Number of canceled billing document CHAR 10 0 SFAKN
KUNWE_ANA Ship-to Party CHAR 10 0 * KUNWE
KUNRE_ANA Bill-to Party CHAR 10 0 * KUNRE
PERVE_ANA Sales Employee NUMC 8 0 SALES_EMPL
PERZM_ANA Employee Responsible NUMC 8 0 RESP_EMPL
GLO_LOG_REF1_IT Commodity Code for Poland CHAR 25 0 GLO_LOG_REF1_IT
TXS_BUSINESS_TRANSACTION Tax Service Business Transaction CHAR 4 0 TXS_BUSINESS_TRANSACTION
TXS_MATERIAL_USAGE Tax Service Material Usage CHAR 1 0 TXS_MATERIAL_USAGE
TXS_USAGE_PURPOSE Tax Service Usage Purpose CHAR 25 0 TXS_USAGE_PURPOSE
ZAPCGKI Annexing package key NUMC 4 0 /ILE/TV01 /ILE/TAPCGK
APCGK_EXTENDI Extended key for annexing package NUMC 10 0 /ILE/TAPCGK_EXT
ZABDATI Annexing base date DATS 8 0 /ILE/TABDAT
AUFPL Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL Internal counter NUMC 8 0 CIM_COUNT
DPCNR Down Payment Chain Number CHAR 10 0 /SAPPCE/DPCNR
DCPNR Transaction Number NUMC 3 0 /SAPPCE/DPCPNR
DPNRB Sequence Number of Accounting Document in Transaction NUMC 3 0 /SAPPCE/DPCPNRB
BOSFAR Billing/Invoicing rule (w/o invoicing plan CHAR 1 0 BOSFAR
DP_BELNR Document Number of an Accounting Document CHAR 10 0 BELNR_D
DP_BUKRS Company Code CHAR 4 0 BUKRS
DP_GJAHR Fiscal Year NUMC 4 0 GJAHR
DP_BUZEI Number of Line Item Within Accounting Document NUMC 3 0 BUZEI
PACKNO Package number NUMC 10 0 ESLH PACKNO
PEROP_BEG Period of Performance Start Date DATS 8 0 FM_PEROP_SD_LOW
PEROP_END Period of Performance End Date DATS 8 0 FM_PEROP_SD_HIGH
FMFGUS_KEY United States Federal Government Fields CHAR 22 0 FMFG_US_KEY
FSH_SEASON_YEAR Season Year CHAR 4 0 FSH_SAISJ
FSH_SEASON Season CHAR 10 0 FSH_SAISO
FSH_COLLECTION Fashion Collection CHAR 10 0 * FSH_COLLECTION
FSH_THEME Fashion Theme CHAR 10 0 FSH_THEME
FONDS Fund CHAR 10 0 * BP_GEBER
FISTL Funds Center CHAR 16 0 * FISTL
FKBER Functional Area CHAR 16 0 * FKBER
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
BUDGET_PD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
J_3GBELNRI Document Number CHAR 10 0 J_3GBELK J_3GBELNRI
J_3GPMAUFE PM Order Number (Owner) CHAR 12 0 AUFK J_3GPMAUFE
J_3GPMAUFV PM Order Number (Administrator) CHAR 12 0 AUFK J_3GPMAUFV
J_3GETYPA Sending Recipient Type CHAR 2 0 * J_3GETYPA
J_3GETYPE Receiving Recipient Type CHAR 2 0 * J_3GETYPE
J_3GORGUEB Indicator: Across All Organizational Structures CHAR 1 0 J_3GORGUEB
PRS_WORK_PERIOD Work Period (Internal Representation) NUMC 7 0 PRS_WORK_PERIOD
PPRCTR Partner Profit Center CHAR 10 0 * PPRCTR
PARGB Trading partner's business area CHAR 4 0 * PARGB
AUFPL_OAA Routing number of operations in the order NUMC 10 0 CO_AUFPL
APLZL_OAA Internal counter NUMC 8 0 CIM_COUNT
CAMPAIGN Generic project planning: GUID from external R/3 system RAW 16 0 CGPL_GUID16_R3
COMPREAS Abbreviation for Complaints Reason CHAR 4 0 CMP_COMPREAS_COPY
WRF_CHARSTC1 Characteristic Value 1 CHAR 18 0 WRF_CHARSTC1
WRF_CHARSTC2 Characteristic Value 2 CHAR 18 0 WRF_CHARSTC2
WRF_CHARSTC3 Characteristic Value 3 CHAR 18 0 WRF_CHARSTC3
/ Relationships

VBRP foreign keys.

Table Field Check Table Description Check Field
VBRP ABFOR T691K Forms of payment guarantee ABSFO
VBRP ABRVW TVLV Check table for release orders: Usage ID ABRVW
VBRP AKTNR WAKH Promotion Header Data, IS-R MANDT
VBRP AKTNR WAKH Promotion Header Data, IS-R AKTNR
VBRP ALAND T005 Countries MANDT
VBRP ALAND T005 Countries LAND1
VBRP AUBEL VBAK Sales Document: Header Data MANDT
VBRP AUBEL VBAK Sales Document: Header Data VBELN
VBRP AUFNR AUFK Order master data AUFNR
VBRP AUGRU_AUFT TVAU Sales Documents: Order Reasons MANDT
VBRP AUGRU_AUFT TVAU Sales Documents: Order Reasons AUGRU
VBRP AUPOS VBAP Sales Document: Item Data VBELN
VBRP AUPOS VBAP Sales Document: Item Data POSNR
VBRP BEMOT TBMOT Accounting indicators MANDT
VBRP BEMOT TBMOT Accounting indicators BEMOT
VBRP BONUS TVBO Sales Rebate Groups MANDT
VBRP BONUS TVBO Sales Rebate Groups BONUS
VBRP BWTAR T149D Global Valuation Types MANDT
VBRP BWTAR T149D Global Valuation Types BWTAR
VBRP BZIRK_AUFT T171 Customers: Sales Districts MANDT
VBRP BZIRK_AUFT T171 Customers: Sales Districts BZIRK
VBRP CHARG MCHA Batches MANDT
VBRP CHARG MCHA Batches WERKS
VBRP CHARG MCHA Batches CHARG
VBRP FPLNR FPLA Billing Plan FPLNR
VBRP GEWEI T006 Units of Measurement MANDT
VBRP GEWEI T006 Units of Measurement MSEHI
VBRP GSBER TGSB Business Areas MANDT
VBRP GSBER TGSB Business Areas GSBER
VBRP J_1ADTYP J_1ADTYP Distribution Types for Gross Income Tax MANDT
VBRP J_1ADTYP J_1ADTYP Distribution Types for Gross Income Tax BUKRS
VBRP J_1AGICD J_1AGICD Activity codes for gross income tax declaration MANDT
VBRP J_1AGICD J_1AGICD Activity codes for gross income tax declaration LAND1
VBRP J_1AINDXP J_1AINFT20 Inflation: Index Definition MANDT
VBRP J_1AREGIO T005S Taxes: Region (Province) Key LAND1
VBRP J_1ARFZ J_1ARFZ Definition of reasons for zero VAT MANDT
VBRP J_1ATXREL J_1ATXREL Tax relevant classification MANDT
VBRP J_1ATXREL J_1ATXREL Tax relevant classification J_1ATXREL
VBRP J_1BCFOP J_1BAG CFOP MANDT
VBRP J_1BTAXLW4 J_1BATL4A Tax Laws COFINS MANDT
VBRP J_1BTAXLW5 J_1BATL5 PIS Tax Law MANDT
VBRP J_1BTXSDC J_1BTXSDC SD tax codes MANDT
VBRP J_3GBELNRI J_3GBELK Document File - Header Data MANDT
VBRP J_3GBELNRI J_3GBELK Document File - Header Data J_3GBELNRI
VBRP J_3GPMAUFE AUFK Order master data AUFNR
VBRP J_3GPMAUFV AUFK Order master data AUFNR
VBRP KDGRP_AUFT T151 Customers: Customer Groups MANDT
VBRP KDGRP_AUFT T151 Customers: Customer Groups KDGRP
VBRP KDKG1 TVKGG Customer Condition Groups (Customer Master) MANDT
VBRP KDKG1 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBRP KDKG2 TVKGG Customer Condition Groups (Customer Master) MANDT
VBRP KDKG2 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBRP KDKG3 TVKGG Customer Condition Groups (Customer Master) MANDT
VBRP KDKG3 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBRP KDKG4 TVKGG Customer Condition Groups (Customer Master) MANDT
VBRP KDKG4 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBRP KDKG5 TVKGG Customer Condition Groups (Customer Master) MANDT
VBRP KDKG5 TVKGG Customer Condition Groups (Customer Master) KDKGR
VBRP KNUMA_AG KONA Agreements MANDT
VBRP KNUMA_AG KONA Agreements KNUMA
VBRP KNUMA_PI KONA Agreements MANDT
VBRP KNUMA_PI KONA Agreements KNUMA
VBRP KOKRS TKA01 Controlling Areas MANDT
VBRP KONDA_AUFT T188 Conditions: Groups for Customer Classifications MANDT
VBRP KONDA_AUFT T188 Conditions: Groups for Customer Classifications KONDA
VBRP KONDM T178 Conditions: Groups for Materials MANDT
VBRP KONDM T178 Conditions: Groups for Materials KONDM
VBRP KTGRM TVKM Materials: Account Assignment Groups MANDT
VBRP KTGRM TVKM Materials: Account Assignment Groups KTGRM
VBRP KVGR1 TVV1 Customer Group 1 MANDT
VBRP KVGR1 TVV1 Customer Group 1 KVGR1
VBRP KVGR2 TVV2 Customer Group 2 MANDT
VBRP KVGR2 TVV2 Customer Group 2 KVGR2
VBRP KVGR3 TVV3 Customer Group 3 KVGR3
VBRP KVGR4 TVV4 Customer Group 4 MANDT
VBRP KVGR4 TVV4 Customer Group 4 KVGR4
VBRP KVGR5 TVV5 Customer Group 5 MANDT
VBRP KVGR5 TVV5 Customer Group 5 KVGR5
VBRP LGORT T001L Storage Locations MANDT
VBRP LGORT T001L Storage Locations WERKS
VBRP LLAND_AUFT T005 Countries MANDT
VBRP LLAND_AUFT T005 Countries LAND1
VBRP MANDT T000 Clients MANDT
VBRP MATKL T023 Material Groups MATKL
VBRP MATNR MARA General Material Data MANDT
VBRP MATNR MARA General Material Data MATNR
VBRP MATWA MARA General Material Data MANDT
VBRP MATWA MARA General Material Data MATNR
VBRP MEINS T006 Units of Measurement MANDT
VBRP MEINS T006 Units of Measurement MSEHI
VBRP MSR_REFUND_CODE MSR_C_RET_REFUND Returns Refund Codes MANDT
VBRP MSR_RET_REASON MSR_C_RET_REASON Multi-step returns - Returns reason MANDT
VBRP MVGR1 TVM1 Material Pricing Group 1 MVGR1
VBRP MVGR2 TVM2 Material Pricing Group 2 MVGR2
VBRP MVGR3 TVM3 Material Pricing Group 3 MVGR3
VBRP MVGR4 TVM4 Material Pricing Group 4 MANDT
VBRP MVGR4 TVM4 Material Pricing Group 4 MVGR4
VBRP MVGR5 TVM5 Material Pricing Group 5 MANDT
VBRP MVGR5 TVM5 Material Pricing Group 5 MVGR5
VBRP PACKNO ESLH Service Package Header Data PACKNO
VBRP PLTYP_AUFT T189 Conditions: Price List Types MANDT
VBRP PLTYP_AUFT T189 Conditions: Price List Types PLTYP
VBRP PMATN MARA General Material Data MANDT
VBRP PMATN MARA General Material Data MATNR
VBRP POSPA VBRP Billing Document: Item Data VBELN
VBRP POSPA VBRP Billing Document: Item Data POSNR
VBRP PRODH T179 Materials: Product Hierarchies PRODH
VBRP PROVG TVPR Commission Groups MANDT
VBRP PROVG TVPR Commission Groups PROVG
VBRP REGIO_AUFT T005S Taxes: Region (Province) Key LAND1
VBRP RPLNR FPLA Billing Plan FPLNR
VBRP SERNR SNUM BOM explosion number MANDT
VBRP SPARA TSPA Organizational Unit: Sales Divisions MANDT
VBRP SPARA TSPA Organizational Unit: Sales Divisions SPART
VBRP SPART TSPA Organizational Unit: Sales Divisions MANDT
VBRP SPART TSPA Organizational Unit: Sales Divisions SPART
VBRP UKONM T178 Conditions: Groups for Materials MANDT
VBRP UKONM T178 Conditions: Groups for Materials KONDM
VBRP UPMAT MARA General Material Data MANDT
VBRP UPMAT MARA General Material Data MATNR
VBRP VBELN VBRK Billing Document: Header Data VBELN
VBRP VKAUS TVLV Check table for release orders: Usage ID ABRVW
VBRP VKBUR TVBUR Organizational Unit: Sales Offices MANDT
VBRP VKGRP TVKGR Organizational Unit: Sales Groups MANDT
VBRP VKORG_AUFT TVKO Organizational Unit: Sales Organizations MANDT
VBRP VKORG_AUFT TVKO Organizational Unit: Sales Organizations VKORG
VBRP VOLEH T006 Units of Measurement MANDT
VBRP VOLEH T006 Units of Measurement MSEHI
VBRP VRKME T006 Units of Measurement MANDT
VBRP VRKME T006 Units of Measurement MSEHI
VBRP VSTEL TVST Organizational Unit: Shipping Points MANDT
VBRP VSTEL TVST Organizational Unit: Shipping Points VSTEL
VBRP VTWEG_AUFT TVTW Organizational Unit: Distribution Channels MANDT
VBRP VTWEG_AUFT TVTW Organizational Unit: Distribution Channels VTWEG
VBRP WERKS T001W Plants/Branches WERKS
VBRP WKREG T005S Taxes: Region (Province) Key LAND1
VBRP WKTNR VBAK Sales Document: Header Data MANDT
VBRP WKTNR VBAK Sales Document: Header Data VBELN
VBRP WKTPS VBAP Sales Document: Item Data VBELN
VBRP WKTPS VBAP Sales Document: Item Data POSNR
VBRP WMINR WWMI Product catalog MANDT
VBRP WMINR WWMI Product catalog WMINR
Back to SAP tables