VBRP SAP (Billing Document: Item Data) Table details

Dictionary Type: Table
Description: Billing Document: Item Data




ABAP Code to SELECT data from VBRP
Related tables to VBRP
Access table VBRP




Table field list including key, data, relationships and ABAP select examples

VBRP is a standard SAP Table which is used to store Billing Document: Item Data data and is available within R/3 SAP systems depending on the version and release level.

The VBRP table consists of various fields, each holding specific information or linking keys about Billing Document: Item Data data available in SAP. These include VBELN (Billing Document), POSNR (Billing item), UEPOS (Higher-level item in bill of material structures), FKIMG (Actual Invoiced Quantity).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP VBRP table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
VBELNBilling Document VBELN_VFCHAR10VBUKALPHAVBELNVF
POSNRBilling item POSNR_VFNUMC6VBUPPOSNR
UEPOSHigher-level item in bill of material structures UEPOSNUMC6VBUPPOSNR
FKIMGActual Invoiced Quantity FKIMGQUAN13(3) MENG13
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
UMVKZNumerator (factor) for conversion of sales quantity into SKU UMVKZDEC5UMBSZ
UMVKNDenominator (Divisor) for Conversion of Sales Qty into SKU UMVKNDEC5UMBSN
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
SMENGScale quantity in base unit of measure SMENGQUAN13(3) MENG13
FKLMGBilling quantity in stockkeeping unit FKLMGQUAN13(3) MENG13
LMENGRequired quantity for mat.management in stockkeeping units LMENGQUAN13(3) MENG13
NTGEWNet weight NTGEW_15QUAN15(3) MENG15
BRGEWGross weight BRGEW_15QUAN15(3) MENG15
GEWEIWeight Unit GEWEIUNIT3T006CUNITMEINS
VOLUMVolume VOLUM_15QUAN15(3) MENG15
VOLEHVolume unit VOLEHUNIT3T006CUNITMEINS
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
PRSDTDate for pricing and exchange rate PRSDTDATS8DATUM
FBUDADate on which services rendered FBUDADATS8DATUM
KURSKExchange Rate for Price Determination KURSKDEC9(5) EXCRTKURRF
NETWRNet value of the billing item in document currency NETWR_FPCURR15(2) WERTV8
VBELVOriginating document VBELVCHAR10VBUKALPHAVBELN
POSNVOriginating item POSNVNUMC6VBUPPOSNR
VGBELDocument number of the reference document VGBELCHAR10VBUKALPHAVBELN
VGPOSItem number of the reference item VGPOSNUMC6VBUPPOSNR
VGTYPDocument category of preceding SD document VBTYP_VCHAR1VBTYP
AUBELSales Document VBELN_VACHAR10VBUKALPHAVBELNAUN
AUPOSSales Document Item POSNR_VANUMC6VBUPPOSNRAPO
AUREFSales document was created from reference AUREFCHAR1XFELD
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
ARKTXShort text for sales order item ARKTXCHAR40TEXT40
PMATNPricing Reference Material PMATNCHAR18MARAMATN1MATNRMAT
CHARGBatch Number CHARG_DCHAR10MCHACHARGCHA
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
PSTYVSales document item category PSTYVCHAR4Assigned to domainPSTYV
POSARItem type POSARCHAR1POSAR
PRODHProduct hierarchy PRODH_DCHAR18T179PRODHVPR
VSTELShipping Point/Receiving Point VSTELCHAR4TVSTVSTELVST
ATPKZReplacement part ATPKZCHAR1ATPKZ
SPARTDivision SPARTCHAR2TSPASPARTSPAC_SPART
POSPAItem number in the partner segment POSPANUMC6VBUPPOSNR
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
ALANDDeparture country (country from which the goods are sent) ALANDCHAR3T005LAND1VAL
WKREGRegion in which plant is located WKREGCHAR3T005SREGIO
WKCOUCounty in which plant is located WKCOUCHAR3CHAR3
WKCTYCity in which plant is located WKCTYCHAR4CHAR4
TAXM1Tax classification material TAXM1CHAR1Assigned to domainTAXKM
TAXM2Tax classification 2 for material TAXM2CHAR1Assigned to domainTAXKM
TAXM3Tax classification 3 for material TAXM3CHAR1Assigned to domainTAXKM
TAXM4Tax Classification 4 Material TAXM4CHAR1Assigned to domainTAXKM
TAXM5Tax classification 5 for material TAXM5CHAR1Assigned to domainTAXKM
TAXM6Tax classification 6 for material TAXM6CHAR1Assigned to domainTAXKM
TAXM7Tax classification 7 for material TAXM7CHAR1Assigned to domainTAXKM
TAXM8Tax Classification 8 Material TAXM8CHAR1Assigned to domainTAXKM
TAXM9Tax Classification 9 Material TAXM9CHAR1Assigned to domainTAXKM
KOWRRStatistical values KOWRRCHAR1KOWRR
PRSFDCarry out pricing PRSFDCHAR1PRSFD
SKTOFCash discount indicator SKTOFCHAR1XFELD
SKFBPAmount eligible for cash discount in document currency SKFBPCURR13(2) WERTV7
KONDMMaterial Pricing Group KONDMCHAR2T178KONDMVKM
KTGRMAccount assignment group for this material KTGRMCHAR2TVKMKTGRM
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
BONUSVolume rebate group BONUSCHAR2TVBOBONUS
PROVGCommission group PROVGCHAR2TVPRPROVG
EANNREuropean Article Number (EAN) - obsolete!!!!! EANNRCHAR13CHAR13EAN
VKGRPSales Group VKGRPCHAR3TVKGRVKGRPVKG
VKBURSales Office VKBURCHAR4TVBURVKBURVKB
SPARADivision for order header SPART_AKCHAR2TSPASPARTSPA
SHKZGReturns item SHKZG_VFCHAR1SHKZG_VF
ERNAMName of Person who Created the Object ERNAMCHAR12USNAM
ERDATDate on Which Record Was Created ERDATDATS8DATUM
ERZETEntry time ERZETTIMS6UZEIT
BWTARValuation Type BWTAR_DCHAR10T149DBWTARBWT
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
STAFOUpdate group for statistics update STAFOCHAR6Assigned to domainALPHASTAFOMCF
WAVWRCost in document currency WAVWRCURR13(2) WERTV7
KZWI1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KZWI2Subtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
KZWI3Subtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
KZWI4Subtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
KZWI5Subtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
KZWI6Subtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
STCURExchange rate for statistics (Exch.rate at time of creation) STCUR_APDEC9(5) KURRF
UVPRSIncomplete with respect to pricing UVPRSCHAR1XFELD
UVALLGenerally incomplete UVALLCHAR1XFELD
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
KVGR1Customer group 1 KVGR1CHAR3TVV1KVGR1
KVGR2Customer group 2 KVGR2CHAR3TVV2KVGR2
KVGR3Customer group 3 KVGR3CHAR3TVV3KVGR3
KVGR4Customer group 4 KVGR4CHAR3TVV4KVGR4
KVGR5Customer group 5 KVGR5CHAR3TVV5KVGR5
MVGR1Material group 1 MVGR1CHAR3TVM1MVGR1
MVGR2Material group 2 MVGR2CHAR3TVM2MVGR2
MVGR3Material group 3 MVGR3CHAR3TVM3MVGR3
MVGR4Material group 4 MVGR4CHAR3TVM4MVGR4
MVGR5Material group 5 MVGR5CHAR3TVM5MVGR5
MATWAMaterial entered MATWACHAR18MARAMATN1MATNRMAT
BONBARebate basis 1 BONBACURR13(2) WERTV7
KOKRSControlling Area KOKRSCHAR4TKA01CACCDCAC
PAOBJNRProfitability Segment Number (CO-PA) RKEOBJNRNUMC10RKEOBJNR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element) PS_PSP_PNRNUMC8Assigned to domainKONPRPS_POSNR
AUFNROrder Number AUFNRCHAR12AUFKALPHAAUFNRANR
TXJCDTax Jurisdiction TXJCDCHAR15Assigned to domainTXJCDTXJ
CMPREItem credit price CMPRECURR11(2) WERTV6
CMPNTID: Item with active credit function / relevant for credit CMPNTCHAR1XFELD
CUOBJConfiguration CUOBJ_VANUMC18CUOBJ
CUOBJ_CHInternal object number of the batch classification CUOBJ_CHNUMC18CUOBJ
KOUPDCondition update KOUPDCHAR1XFELD
UECHAHigher-Level Item of Batch Split Item UECHANUMC6Assigned to domainPOSNR
XCHARBatch management indicator (internal) XCHARCHAR1XFELD
ABRVWUsage Indicator ABRVWCHAR3TVLVABRVW
SERNRBOM explosion number SERNRCHAR8SNUMSERNR
BZIRK_AUFTSales district of sales order BZIRK_AUFTCHAR6T171BZIRK
KDGRP_AUFTCustomer group of sales order KDGRP_AUFTCHAR2T151KDGRPVKD
KONDA_AUFTPrice group of sales order KONDA_AUFTCHAR2T188KONDAVKA
LLAND_AUFTCountry of destination of sales order LLAND_AUFTCHAR3T005LAND1VLL
MPROKStatus manual price change MPROKCHAR1MPROK
PLTYP_AUFTPrice list type of sales order PLTYP_AUFTCHAR2T189PLTYPVPL
REGIO_AUFTRegion of sales order REGIO_AUFTCHAR3T005SREGIO
VKORG_AUFTSales organization of sales order VKORG_AUFTCHAR4TVKOVKORGVKO
VTWEG_AUFTDistribution channel of sales order VTWEG_AUFTCHAR2TVTWVTWEGVTW
ABRBGStart of accounting settlement period ABRBGDATS8DATUM
PROSAID for material determination PROSACHAR1PROSA
UEPVWID for higher-level item usage UEPVWCHAR1UEPVW
AUTYPSD document category VBTYPCHAR1VBTYP
STADATStatistics date STADATDATS8DATUM
FPLNRBilling plan number / invoicing plan number FPLNRCHAR10FPLAFPLNR
FPLTRItem for billing plan/invoice plan/payment cards FPLTRNUMC6Assigned to domainFPLTR
AKTNRCOUPON WAKTIONCHAR10WAKHALPHAWAKTIONWAK
KNUMA_PIPromotion KNUMA_PICHAR10KONAALPHAKNUMAVPIVMBO
KNUMA_AGSales deal KNUMA_AGCHAR10KONAALPHAKNUMAVK1VMBO
PREFEPreference indicator in export/import PREFECHAR1PREFE
MWSBPTax amount in document currency MWSBPCURR13(2) WERTV7
AUGRU_AUFTOrder reason (reason for the business transaction) AUGRUCHAR3TVAUAUGRU
FAREGRule in billing plan/invoice plan FAREGCHAR1FAREG
UPMATPricing reference material of main item UPMATCHAR18MARAMATN1MATNR
UKONMMaterial pricing group of main item UKONMCHAR2T178KONDM
CMPRE_FLTItem credit price CMPRE_FLTFLTP16(16) FLTP
ABFORForm of payment guarantee ABSFORM_CMCHAR2T691KABSFORM_CM
ABGESGuaranteed (factor between 0 and 1) ABGES_CMFLTP16(16) FLTP
J_1ARFZReason for zero VAT J_1ARFZVATCHAR1J_1ARFZJ_1ARFZVAT
J_1AREGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
J_1AGICDActivity Code for Gross Income Tax J_1AGICD_DCHAR2J_1AGICDJ_1AGICD2
J_1ADTYPDistribution Type for Employment Tax J_1ADTYP_DCHAR2J_1ADTYPJ_1ADTYP
J_1ATXRELTax relevant classification J_1ATXREL_CHAR10J_1ATXRELJ_1ATXREL
J_1BCFOPCFOP Code and Extension J_1BCFOPCHAR10J_1BAGCFOBRJ_1BCFOP
J_1BTAXLW1Tax law: ICMS J_1BTAXLW1CHAR3J_1BATL1ALPHAJ_1BTAXLW1
J_1BTAXLW2Tax law: IPI J_1BTAXLW2CHAR3J_1BATL2ALPHAJ_1BTAXLW2
J_1BTXSDCSD tax code J_1BTXSDC_CHAR2J_1BTXSDCJ_1BTXSDC
BRTWRGross value of the billing item in document currency BRTWR_FPCURR15(2) WERTV8
WKTNRValue contract no. WKTNRCHAR10VBUKALPHAVBELN
WKTPSValue contract item WKTPSNUMC6VBUPPOSNR
RPLNRPayment card plan number of sales document RPLNR_AUCHAR10FPLAFPLNR
KURSK_DATTranslation Date WWERT_DDATS8DATUM
WGRU1Material group hierarchy 1 WGRU_HIE1CHAR18KLASSE
WGRU2Material group hierarchy 2 WGRU_HIE2CHAR18KLASSE
KDKG1Customer condition group 1 KDKG1CHAR2TVKGGKDKGR
KDKG2Customer condition group 2 KDKG2CHAR2TVKGGKDKGR
KDKG3Customer condition group 3 KDKG3CHAR2TVKGGKDKGR
KDKG4Customer condition group 4 KDKG4CHAR2TVKGGKDKGR
KDKG5Customer condition group 5 KDKG5CHAR2TVKGGKDKGR
VKAUSUsage Indicator ABRVWCHAR3TVLVABRVW
J_1AINDXPInflation Index J_1AINDXPCHAR5J_1AINFT20J_1AINDXP
J_1AIDATEPIndexing base date J_1AIDATESDATS8J_1AUDATEP
KZFMEID: Leading unit of measure for completing a transaction KZFMECHAR1KZFME
MWSKZTax on sales/purchases code MWSKZCHAR2Assigned to domainMWSKZ
VERTTContract Type RANTYPCHAR1RANTYP
VERTNContract Number RANLCHAR13ALPHARANLRAN
SGTXTItem Text SGTXTCHAR50TEXT50
DELCOAgreed delivery time DELCOCHAR3DELCO
BEMOTAccounting Indicator BEMOTCHAR2TBMOTBEMOT
RRRELRevenue recognition category RR_RELTYPCHAR1RR_RELTYP
AKKURExchange rate for letter-of-credit procg in foreign trade AKKURDEC9(5) KURRF
WMINRProduct catalog number WMINRCHAR10WWMIWMINRWMIWPC1
VGBEL_EXDocument number of the reference document VGBELCHAR10Assigned to domainALPHAVBELN
VGPOS_EXItem number of the reference item VGPOSNUMC6Assigned to domainPOSNR
LOGSYSLogical system LOGSYSCHAR10Assigned to domainALPHALOGSYS
VGTYP_EXCategory of an external transaction or element VGTYP_EXCHAR3VORG_TYP
J_1BTAXLW3ISS Tax Law J_1BTAXLW3CHAR3J_1BATL3ALPHAJ_1BTAXLW3
J_1BTAXLW4COFINS Tax Law J_1BTAXLW4CHAR3J_1BATL4AALPHAJ_1BTAXLW4
J_1BTAXLW5PIS Tax Law J_1BTAXLW5CHAR3J_1BATL5ALPHAJ_1BTAXLW5
MSR_IDProcess Identification Number MSR_PROCESS_IDCHAR10ALPHAMSR_PROCESS_ID
MSR_REFUND_CODEReturns Refund Code MSR_RETURNS_REFUND_CODECHAR3MSR_C_RET_REFUNDMSR_RETURNS_REFUND_CODE
MSR_RET_REASONReturn Reason MSR_RETURNS_REASONCHAR3MSR_C_RET_REASONMSR_RETURNS_REASON
NRAB_KNUMHCondition record number KNUMHCHAR10KNUMB
NRAB_VALUECondition value KWERTCURR13(2) WERTV7
DISPUTE_CASEDispute Case DISPUTE_CASERAW16SDBIL_RAW16
FUND_USAGE_ITEMFund Usage Item FUND_USAGE_ITEMRAW16SDBIL_RAW16
CLAIMS_TAXATIONClaims Taxation CLAIMS_TAXATIONCHAR1CLAIMS_TAXATION
KURRF_DAT_ORIGTranslation Date WWERT_DDATS8DATUM
VGTYP_EXTExtension of SD document category of preceding document TDD_VBTYP_EXT_VCHAR4DOM_VBTYP_EXT
Z_PRS_OFFSHORE 0
Z_PRS_BILL_FLAG 0
Z_PRS_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
Z_PRS_CHARGELEVL 0
.INCLU--AP 0
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLInternal counter CIM_COUNTNUMC8CIM_COUNT
.INCLU--AP 0
AUDATDocument Date (Date Received/Sent) AUDATDATS8DATUM
EDATUSchedule line date EDATUDATS8DATUM
PLAUFZPrice protection period /SAPHT/SW_PLAUFZNUMC3NUM3
PLAUEZUnit for price protection /SAPHT/SW_PLAUEZCHAR1KDZEH
CONTNBRContract number /SAPHT/SW_CONTNBRCHAR10Assigned to domainALPHAVBELN
CONTITMContract item number /SAPHT/SW_CONTITMNUMC6Assigned to domainPOSNR
.INCLU--AP 0
DPCNRDown Payment Chain Number /SAPPCE/DPCNRCHAR10ALPHA/SAPPCE/DPCNR
DCPNRTransaction Number /SAPPCE/DPCPNRNUMC3NUM03
DPNRBSequence Number of Accounting Document in Transaction /SAPPCE/DPCPNRBNUMC3NUM03
.INCLU--AP 0
BOSFARBilling/Invoicing rule (w/o invoicing plan BOSFARCHAR1BOSFAR
DP_BELNRAccounting Document Number BELNR_DCHAR10ALPHABELNRBLN
DP_BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
DP_GJAHRFiscal Year GJAHRNUMC4GJAHRGJAHRGJR
DP_BUZEINumber of Line Item Within Accounting Document BUZEINUMC3BUZEIBUZ
.INCLU--AP 0
PACKNOPackage number PACKNONUMC10ESLHPACKNO
.INCLU--AP 0
PEROP_BEGPeriod of Performance Start Date FM_PEROP_SD_LOWDATS8DATUM
PEROP_ENDPeriod of Performance End Date FM_PEROP_SD_HIGHDATS8DATUM
.INCLU--AP 0
FONDSFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
.INCLU--AP 0
J_3GBELNRIDocument Number J_3GBELNRICHAR10J_3GBELKALPHAJ_3GBELNRJ2QJ_3GB
J_3GPMAUFEPM Order Number (Owner) J_3GPMAUFECHAR12AUFKALPHAAUFNRANR
J_3GPMAUFVPM Order Number (Administrator) J_3GPMAUFVCHAR12AUFKALPHAAUFNRANR
J_3GETYPASending Recipient Type J_3GETYPACHAR2Assigned to domainJ_3GETYP
J_3GETYPEReceiving Recipient Type J_3GETYPECHAR2Assigned to domainJ_3GETYP
J_3GORGUEBIndicator: Across All Organizational Structures J_3GORGUEBCHAR1CHAR1
.INCLU--AP 0
PRS_WORK_PERIODWork Period (Internal Representation) PRS_WORK_PERIODNUMC7PRSWPPRS_WORK_PERIOD
.INCLU--AP 0
PPRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
PARGBTrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
.INCLU--AP 0
AUFPL_OAARouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZL_OAAInternal counter CIM_COUNTNUMC8CIM_COUNT
.INCLU--AP 0
CAMPAIGNGeneric project planning: GUID from external R/3 system CGPL_GUID16_R3RAW16SYSUUID
.INCLU--AP 0
COMPREASAbbreviation for Complaints Reason CMP_COMPREAS_COPYCHAR4CMP_COMPREAS_COPY
.INCLU--AP 0
YYCALLIDCall Center ID YCALLIDCHAR3Assigned to domainYCALLID

Key field Non-key field



How do I retrieve data from SAP table VBRP using ABAP code

The following ABAP code Example will allow you to do a basic selection on VBRP to SELECT all data from the table
DATA: WA_VBRP TYPE VBRP.

SELECT SINGLE *
FROM VBRP
INTO CORRESPONDING FIELDS OF WA_VBRP
WHERE...

How to access SAP table VBRP

Within an ECC or HANA version of SAP you can also view further information about VBRP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!