SAP Tables

Share |

VBRP SAP Table - Billing Document: Item Data

VBRP is a standard SAP Table available within R/3 SAP systems depending on your version and release level. Below is the standard documentation available for this table and a few details of the fields which make up this table. You can view this information and more if you enter the Table name VBRP into the relevant SAP transaction such as SE11 or SE80. You can also view the data contained in this database table via these transactions or alternatively use transaction SE16

Delivery Class = A - Application table containing master and transaction data

Within the comments section below there is also an opportunity for you to add useful hints, tips and information specific to this SAP object. This means that you and other users will be able to find these details quickly by simply searching on the object name VBRP or its description.



Dictionary fields for SAP Table VBRP
FieldData ElementData TypelengthChecktableDescription
MANDTMANDTCLNT000003T000Client
VBELNVBELN_VFCHAR000010VBUKBilling Document
POSNRPOSNR_VFNUMC000006VBUPItem
UEPOSUEPOSNUMC000006VBUPHigher-level item
FKIMGFKIMGQUAN000013Billed Quantity
VRKMEVRKMEUNIT000003T006Sales unit
UMVKZUMVKZDEC000005Numerator
UMVKNUMVKNDEC000005Denominator
MEINSMEINSUNIT000003T006Base Unit of Measure
SMENGSMENGQUAN000013Scale quantity
FKLMGFKLMGQUAN000013Billing qty in SKU
LMENGLMENGQUAN000013Required quantity
NTGEWNTGEW_15QUAN000015Net weight
BRGEWBRGEW_15QUAN000015Gross weight
GEWEIGEWEIUNIT000003T006Weight unit
VOLUMVOLUM_15QUAN000015Volume
VOLEHVOLEHUNIT000003T006Volume unit
GSBERGSBERCHAR000004TGSBBusiness Area
PRSDTPRSDTDATS000008Pricing date
FBUDAFBUDADATS000008Serv.rendered date
KURSKKURSKDEC000009Exchange Rate
NETWRNETWR_FPCURR000015Net value
VBELVVBELVCHAR000010VBUKOriginating document
POSNVPOSNVNUMC000006VBUPItem
VGBELVGBELCHAR000010VBUKReference document
VGPOSVGPOSNUMC000006VBUPReference item
VGTYPVBTYP_VCHAR000001Preceding doc.categ.
AUBELVBELN_VACHAR000010VBUKSales Document
AUPOSPOSNR_VANUMC000006VBUPSales Document Item
AUREFAUREFCHAR000001Referenced sales document
MATNRMATNRCHAR000018MARAMaterial
ARKTXARKTXCHAR000040Description
PMATNPMATNCHAR000018MARAPricing Ref. Matl
CHARGCHARG_DCHAR000010MCHABatch
MATKLMATKLCHAR000009T023Material Group
PSTYVPSTYVCHAR000004*Item category
POSARPOSARCHAR000001Item type
PRODHPRODH_DCHAR000018T179Product hierarchy
VSTELVSTELCHAR000004TVSTShipping Point/Receiving Pt
ATPKZATPKZCHAR000001Replacement part
SPARTSPARTCHAR000002TSPADivision
POSPAPOSPANUMC000006VBUPPartner item
WERKSWERKS_DCHAR000004T001WPlant
ALANDALANDCHAR000003T005Country
WKREGWKREGCHAR000003T005SRegion of dlv.plant
WKCOUWKCOUCHAR000003County of dlv.plant
WKCTYWKCTYCHAR000004City of deliv.plant
TAXM1TAXM1CHAR000001*Tax class. material
TAXM2TAXM2CHAR000001*TaxClass2-Matl.
TAXM3TAXM3CHAR000001*TaxClass3-Matl.
TAXM4TAXM4CHAR000001*TaxClass4-Matl.
TAXM5TAXM5CHAR000001*TaxClass5-Matl.
TAXM6TAXM6CHAR000001*TaxClass6-Matl.
TAXM7TAXM7CHAR000001*TaxClass7-Matl.
TAXM8TAXM8CHAR000001*TaxClass8-Matl.
TAXM9TAXM9CHAR000001*TaxClass9-Matl.
KOWRRKOWRRCHAR000001Statistical value
PRSFDPRSFDCHAR000001Pricing
SKTOFSKTOFCHAR000001Cash discount
SKFBPSKFBPCURR000013Cash disc.basis
KONDMKONDMCHAR000002T178Material pricing grp
KTGRMKTGRMCHAR000002TVKMAcct assignment grp
KOSTLKOSTLCHAR000010*Cost Center
BONUSBONUSCHAR000002TVBOVolume rebate group
PROVGPROVGCHAR000002TVPRCommission group
EANNREANNRCHAR000013EAN number
VKGRPVKGRPCHAR000003TVKGRSales Group
VKBURVKBURCHAR000004TVBURSales Office
SPARASPART_AKCHAR000002TSPADivision
SHKZGSHKZG_VFCHAR000001Returns
ERNAMERNAMCHAR000012Created by
ERDATERDATDATS000008Created on
ERZETERZETTIMS000006Time
BWTARBWTAR_DCHAR000010T149DValuation Type
LGORTLGORT_DCHAR000004T001LStorage Location
STAFOSTAFOCHAR000006*Update group (stats)
WAVWRWAVWRCURR000013Cost
KZWI1KZWI1CURR000013Subtotal 1
KZWI2KZWI2CURR000013Subtotal 2
KZWI3KZWI3CURR000013Subtotal 3
KZWI4KZWI4CURR000013Subtotal 4
KZWI5KZWI5CURR000013Subtotal 5
KZWI6KZWI6CURR000013Subtotal 6
STCURSTCUR_APDEC000009Exchange rate stats.
UVPRSUVPRSCHAR000001Pricing
UVALLUVALLCHAR000001General
EAN11EAN11CHAR000018EAN/UPC
PRCTRPRCTRCHAR000010*Profit Center
KVGR1KVGR1CHAR000003TVV1Customer group 1
KVGR2KVGR2CHAR000003TVV2Customer group 2
KVGR3KVGR3CHAR000003TVV3Customer group 3
KVGR4KVGR4CHAR000003TVV4Customer group 4
KVGR5KVGR5CHAR000003TVV5Customer group 5
MVGR1MVGR1CHAR000003TVM1Material group 1
MVGR2MVGR2CHAR000003TVM2Material group 2
MVGR3MVGR3CHAR000003TVM3Material group 3
MVGR4MVGR4CHAR000003TVM4Material group 4
MVGR5MVGR5CHAR000003TVM5Material group 5
MATWAMATWACHAR000018MARAMaterial entered
BONBABONBACURR000013Rebate basis
KOKRSKOKRSCHAR000004TKA01Controlling Area
PAOBJNRRKEOBJNRNUMC000010Profitab. Segmt No.
PS_PSP_PNRPS_PSP_PNRNUMC000008*WBS Element
AUFNRAUFNRCHAR000012AUFKOrder
TXJCDTXJCDCHAR000015*Tax Jurisdiction
CMPRECMPRECURR000011Credit price
CMPNTCMPNTCHAR000001Credit funct. active
CUOBJCUOBJ_VANUMC000018Configuration
CUOBJ_CHCUOBJ_CHNUMC000018Internal object no.
KOUPDKOUPDCHAR000001Condition update
UECHAUECHANUMC000006*HigherLevelItemBatch
XCHARXCHARCHAR000001Batch management
ABRVWABRVWCHAR000003TVLVUsage
SERNRSERNRCHAR000008SNUMBOM explosion number
BZIRK_AUFTBZIRK_AUFTCHAR000006T171Sales distr.order
KDGRP_AUFTKDGRP_AUFTCHAR000002T151CustomerGroupSlsOrd.
KONDA_AUFTKONDA_AUFTCHAR000002T188Price group of order
LLAND_AUFTLLAND_AUFTCHAR000003T005DestinCtry of order
MPROKMPROKCHAR000001Manual price
PLTYP_AUFTPLTYP_AUFTCHAR000002T189Price list order
REGIO_AUFTREGIO_AUFTCHAR000003T005SRegion order
VKORG_AUFTVKORG_AUFTCHAR000004TVKOSales org. of order
VTWEG_AUFTVTWEG_AUFTCHAR000002TVTWDistribChannelOrder
ABRBGABRBGDATS000008AcctSettlementStart
PROSAPROSACHAR000001Mat.determ.active
UEPVWUEPVWCHAR000001Usage of HL item
AUTYPVBTYPCHAR000001SD document categ.
STADATSTADATDATS000008Statistics date
FPLNRFPLNRCHAR000010FPLABilling plan number
FPLTRFPLTRNUMC000006*Item
AKTNRWAKTIONCHAR000010WAKHPromotion
KNUMA_PIKNUMA_PICHAR000010KONAPromotion
KNUMA_AGKNUMA_AGCHAR000010KONASales deal
PREFEPREFECHAR000001Preference auth.
MWSBPMWSBPCURR000013Tax amount
AUGRU_AUFTAUGRUCHAR000003TVAUOrder reason
FAREGFAREGCHAR000001Billing rule
UPMATUPMATCHAR000018MARAMnItm PrcRefMatl
UKONMUKONMCHAR000002T178MnItem MatPricingGrp
CMPRE_FLTCMPRE_FLTFLTP000016Credit price
ABFORABSFORM_CMCHAR000002T691KPaymt guarantee form
ABGESABGES_CMFLTP000016Guaranteed
J_1ARFZJ_1ARFZVATCHAR000001J_1ARFZReason 0 VAT
J_1AREGIOREGIOCHAR000003T005SRegion
J_1AGICDJ_1AGICD_DCHAR000002J_1AGICDActivity Code GI Tax
J_1ADTYPJ_1ADTYP_DCHAR000002J_1ADTYPDistribution Type
J_1ATXRELJ_1ATXREL_CHAR000010J_1ATXRELTax rel. classif.
J_1BCFOPJ_1BCFOPCHAR000010J_1BAGCFOP
J_1BTAXLW1J_1BTAXLW1CHAR000003J_1BATL1ICMS law
J_1BTAXLW2J_1BTAXLW2CHAR000003J_1BATL2IPI law
J_1BTXSDCJ_1BTXSDC_CHAR000002J_1BTXSDCTax code
BRTWRBRTWR_FPCURR000015Gross value
WKTNRWKTNRCHAR000010VBUKValue contract no.
WKTPSWKTPSNUMC000006VBUPValue contract item
RPLNRRPLNR_AUCHAR000010FPLAPaym.ca.pl.no.-Sales
KURSK_DATWWERT_DDATS000008Translation Date
WGRU1WGRU_HIE1CHAR000018Material group 1
WGRU2WGRU_HIE2CHAR000018Material group 2
KDKG1KDKG1CHAR000002TVKGGCondition group 1
KDKG2KDKG2CHAR000002TVKGGCondition group 2
KDKG3KDKG3CHAR000002TVKGGCondition group 3
KDKG4KDKG4CHAR000002TVKGGCondition group 4
KDKG5KDKG5CHAR000002TVKGGCondition group 5
VKAUSABRVWCHAR000003TVLVUsage
J_1AINDXPJ_1AINDXPCHAR000005J_1AINFT20Inflation Index
J_1AIDATEPJ_1AIDATESDATS000008Indexing base date
KZFMEKZFMECHAR000001Leading UoM
MWSKZMWSKZCHAR000002*Tax code
VERTTRANTYPCHAR000001Contract Type
VERTNRANLCHAR000013Contract Number
SGTXTSGTXTCHAR000050Text
DELCODELCOCHAR000003Delivery time
BEMOTBEMOTCHAR000002TBMOTAccounting Indicator
RRRELRR_RELTYPCHAR000001Rev. recognition cat.
AKKURAKKURDEC000009Ex.rate-LettOfCredit
WMINRWMINRCHAR000010WWMICatalog
VGBEL_EXVGBELCHAR000010*Reference document
VGPOS_EXVGPOSNUMC000006*Reference item
LOGSYSLOGSYSCHAR000010*Logical system
VGTYP_EXVGTYP_EXCHAR000003Category
J_1BTAXLW3J_1BTAXLW3CHAR000003J_1BATL3ISS Law
J_1BTAXLW4J_1BTAXLW4CHAR000003J_1BATL4ACOFINS Law
J_1BTAXLW5J_1BTAXLW5CHAR000003J_1BATL5PIS Law
MSR_IDMSR_PROCESS_IDCHAR000010Process ID No.
MSR_REFUND_CODEMSR_RETURNS_REFUND_CODECHAR000003MSR_C_RET_REFUNDRefund Code
MSR_RET_REASONMSR_RETURNS_REASONCHAR000003MSR_C_RET_REASONReturn Reason
NRAB_KNUMHKNUMHCHAR000010Condition record no.
NRAB_VALUEKWERTCURR000013Condition value
DISPUTE_CASEDISPUTE_CASERAW000016Dispute Case
FUND_USAGE_ITEMFUND_USAGE_ITEMRAW000016Fund Usage Item
CLAIMS_TAXATIONCLAIMS_TAXATIONCHAR000001Claims Taxation
AUFPLCO_AUFPLNUMC000010Opertn task list no.
APLZLCIM_COUNTNUMC000008Counter
PEROP_BEGFM_PEROP_SD_LOWDATS000008Period of Performance Start Date
PEROP_ENDFM_PEROP_SD_HIGHDATS000008Period of Performance End Date
FONDSBP_GEBERCHAR000010*Fund
FISTLFISTLCHAR000016*Funds Center
FKBERFKBERCHAR000016*Functional Area
GRANT_NBRGM_GRANT_NBRCHAR000020Grant
BUDGET_PDFM_BUDGET_PERIODCHAR000010*Budget Period
PRS_WORK_PERIODPRS_WORK_PERIODNUMC000007Work Period
PPRCTRPPRCTRCHAR000010*Partner Profit Ctr
PARGBPARGBCHAR000004*Trading part.BA
AUFPL_OAACO_AUFPLNUMC000010Opertn task list no.
APLZL_OAACIM_COUNTNUMC000008Counter
CAMPAIGNCGPL_GUID16_R3RAW000016CGPL_GUID
COMPREASCMP_COMPREAS_COPYCHAR000004Abb. Complaints Reason
DPNRB/SAPPCE/DPCPNRBNUMC000003Document Seq. No.
DPCNR/SAPPCE/DPCNRCHAR000010Down Payment Chain Number
DCPNR/SAPPCE/DPCPNRNUMC000003Transaction Number






comments powered by Disqus

Terms of Service     Contact Us     Privacy Policy     Useful SAP related sites