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

Contribute (Add Comments)
Within the comments section below there is also an opportunity for you to add useful hints, tips and screen shots 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 Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3T000Client
VBELNVBELN_VFCHAR10VBUKBilling Document
POSNRPOSNR_VFNUMC6VBUPItem
UEPOSUEPOSNUMC6VBUPHigher-level item
FKIMGFKIMGQUAN13(3)Billed Quantity
VRKMEVRKMEUNIT3T006Sales unit
UMVKZUMVKZDEC5Numerator
UMVKNUMVKNDEC5Denominator
MEINSMEINSUNIT3T006Base Unit of Measure
SMENGSMENGQUAN13(3)Scale quantity
FKLMGFKLMGQUAN13(3)Billing qty in SKU
LMENGLMENGQUAN13(3)Required quantity
NTGEWNTGEW_15QUAN15(3)Net weight
BRGEWBRGEW_15QUAN15(3)Gross weight
GEWEIGEWEIUNIT3T006Weight unit
VOLUMVOLUM_15QUAN15(3)Volume
VOLEHVOLEHUNIT3T006Volume unit
GSBERGSBERCHAR4TGSBBusiness Area
PRSDTPRSDTDATS8Pricing date
FBUDAFBUDADATS8Serv.rendered date
KURSKKURSKDEC9(5)Exchange Rate
NETWRNETWR_FPCURR15(2)Net value
VBELVVBELVCHAR10VBUKOriginating document
POSNVPOSNVNUMC6VBUPItem
VGBELVGBELCHAR10VBUKReference document
VGPOSVGPOSNUMC6VBUPReference item
VGTYPVBTYP_VCHAR1Preceding doc.categ.
AUBELVBELN_VACHAR10VBUKSales Document
AUPOSPOSNR_VANUMC6VBUPSales Document Item
AUREFAUREFCHAR1Referenced sales document
MATNRMATNRCHAR18MARAMaterial
ARKTXARKTXCHAR40Description
PMATNPMATNCHAR18MARAPricing Ref. Matl
CHARGCHARG_DCHAR10MCHABatch
MATKLMATKLCHAR9T023Material Group
PSTYVPSTYVCHAR4
*
Item category
POSARPOSARCHAR1Item type
PRODHPRODH_DCHAR18T179Product hierarchy
VSTELVSTELCHAR4TVSTShipping Point/Receiving Pt
ATPKZATPKZCHAR1Replacement part
SPARTSPARTCHAR2TSPADivision
POSPAPOSPANUMC6VBUPPartner item
WERKSWERKS_DCHAR4T001WPlant
ALANDALANDCHAR3T005Country
WKREGWKREGCHAR3T005SRegion of dlv.plant
WKCOUWKCOUCHAR3County of dlv.plant
WKCTYWKCTYCHAR4City of deliv.plant
TAXM1TAXM1CHAR1
*
Tax class. material
TAXM2TAXM2CHAR1
*
TaxClass2-Matl.
TAXM3TAXM3CHAR1
*
TaxClass3-Matl.
TAXM4TAXM4CHAR1
*
TaxClass4-Matl.
TAXM5TAXM5CHAR1
*
TaxClass5-Matl.
TAXM6TAXM6CHAR1
*
TaxClass6-Matl.
TAXM7TAXM7CHAR1
*
TaxClass7-Matl.
TAXM8TAXM8CHAR1
*
TaxClass8-Matl.
TAXM9TAXM9CHAR1
*
TaxClass9-Matl.
KOWRRKOWRRCHAR1Statistical value
PRSFDPRSFDCHAR1Pricing
SKTOFSKTOFCHAR1Cash discount
SKFBPSKFBPCURR13(2)Cash disc.basis
KONDMKONDMCHAR2T178Material pricing grp
KTGRMKTGRMCHAR2TVKMAcct assignment grp
KOSTLKOSTLCHAR10
*
Cost Center
BONUSBONUSCHAR2TVBOVolume rebate group
PROVGPROVGCHAR2TVPRCommission group
EANNREANNRCHAR13EAN number
VKGRPVKGRPCHAR3TVKGRSales Group
VKBURVKBURCHAR4TVBURSales Office
SPARASPART_AKCHAR2TSPADivision
SHKZGSHKZG_VFCHAR1Returns
ERNAMERNAMCHAR12Created by
ERDATERDATDATS8Created on
ERZETERZETTIMS6Time
BWTARBWTAR_DCHAR10T149DValuation Type
LGORTLGORT_DCHAR4T001LStorage Location
STAFOSTAFOCHAR6
*
Update group (stats)
WAVWRWAVWRCURR13(2)Cost
KZWI1KZWI1CURR13(2)Subtotal 1
KZWI2KZWI2CURR13(2)Subtotal 2
KZWI3KZWI3CURR13(2)Subtotal 3
KZWI4KZWI4CURR13(2)Subtotal 4
KZWI5KZWI5CURR13(2)Subtotal 5
KZWI6KZWI6CURR13(2)Subtotal 6
STCURSTCUR_APDEC9(5)Exchange rate stats.
UVPRSUVPRSCHAR1Pricing
UVALLUVALLCHAR1General
EAN11EAN11CHAR18EAN/UPC
PRCTRPRCTRCHAR10
*
Profit Center
KVGR1KVGR1CHAR3TVV1Customer group 1
KVGR2KVGR2CHAR3TVV2Customer group 2
KVGR3KVGR3CHAR3TVV3Customer group 3
KVGR4KVGR4CHAR3TVV4Customer group 4
KVGR5KVGR5CHAR3TVV5Customer group 5
MVGR1MVGR1CHAR3TVM1Material group 1
MVGR2MVGR2CHAR3TVM2Material group 2
MVGR3MVGR3CHAR3TVM3Material group 3
MVGR4MVGR4CHAR3TVM4Material group 4
MVGR5MVGR5CHAR3TVM5Material group 5
MATWAMATWACHAR18MARAMaterial entered
BONBABONBACURR13(2)Rebate basis
KOKRSKOKRSCHAR4TKA01Controlling Area
PAOBJNRRKEOBJNRNUMC10Profitab. Segmt No.
PS_PSP_PNRPS_PSP_PNRNUMC8
*
WBS Element
AUFNRAUFNRCHAR12AUFKOrder
TXJCDTXJCDCHAR15
*
Tax Jurisdiction
CMPRECMPRECURR11(2)Credit price
CMPNTCMPNTCHAR1Credit funct. active
CUOBJCUOBJ_VANUMC18Configuration
CUOBJ_CHCUOBJ_CHNUMC18Internal object no.
KOUPDKOUPDCHAR1Condition update
UECHAUECHANUMC6
*
HigherLevelItemBatch
XCHARXCHARCHAR1Batch management
ABRVWABRVWCHAR3TVLVUsage
SERNRSERNRCHAR8SNUMBOM explosion number
BZIRK_AUFTBZIRK_AUFTCHAR6T171Sales distr.order
KDGRP_AUFTKDGRP_AUFTCHAR2T151CustomerGroupSlsOrd.
KONDA_AUFTKONDA_AUFTCHAR2T188Price group of order
LLAND_AUFTLLAND_AUFTCHAR3T005DestinCtry of order
MPROKMPROKCHAR1Manual price
PLTYP_AUFTPLTYP_AUFTCHAR2T189Price list order
REGIO_AUFTREGIO_AUFTCHAR3T005SRegion order
VKORG_AUFTVKORG_AUFTCHAR4TVKOSales org. of order
VTWEG_AUFTVTWEG_AUFTCHAR2TVTWDistribChannelOrder
ABRBGABRBGDATS8AcctSettlementStart
PROSAPROSACHAR1Mat.determ.active
UEPVWUEPVWCHAR1Usage of HL item
AUTYPVBTYPCHAR1SD document categ.
STADATSTADATDATS8Statistics date
FPLNRFPLNRCHAR10FPLABilling plan number
FPLTRFPLTRNUMC6
*
Item
AKTNRWAKTIONCHAR10WAKHPromotion
KNUMA_PIKNUMA_PICHAR10KONAPromotion
KNUMA_AGKNUMA_AGCHAR10KONASales deal
PREFEPREFECHAR1Preference auth.
MWSBPMWSBPCURR13(2)Tax amount
AUGRU_AUFTAUGRUCHAR3TVAUOrder reason
FAREGFAREGCHAR1Billing rule
UPMATUPMATCHAR18MARAMnItm PrcRefMatl
UKONMUKONMCHAR2T178MnItem MatPricingGrp
CMPRE_FLTCMPRE_FLTFLTP16(16)Credit price
ABFORABSFORM_CMCHAR2T691KPaymt guarantee form
ABGESABGES_CMFLTP16(16)Guaranteed
J_1ARFZJ_1ARFZVATCHAR1J_1ARFZReason 0 VAT
J_1AREGIOREGIOCHAR3T005SRegion
J_1AGICDJ_1AGICD_DCHAR2J_1AGICDActivity Code GI Tax
J_1ADTYPJ_1ADTYP_DCHAR2J_1ADTYPDistribution Type
J_1ATXRELJ_1ATXREL_CHAR10J_1ATXRELTax rel. classif.
J_1BCFOPJ_1BCFOPCHAR10J_1BAGCFOP
J_1BTAXLW1J_1BTAXLW1CHAR3J_1BATL1ICMS law
J_1BTAXLW2J_1BTAXLW2CHAR3J_1BATL2IPI law
J_1BTXSDCJ_1BTXSDC_CHAR2J_1BTXSDCTax code
BRTWRBRTWR_FPCURR15(2)Gross value
WKTNRWKTNRCHAR10VBUKValue contract no.
WKTPSWKTPSNUMC6VBUPValue contract item
RPLNRRPLNR_AUCHAR10FPLAPaym.ca.pl.no.-Sales
KURSK_DATWWERT_DDATS8Translation Date
WGRU1WGRU_HIE1CHAR18Material group 1
WGRU2WGRU_HIE2CHAR18Material group 2
KDKG1KDKG1CHAR2TVKGGCondition group 1
KDKG2KDKG2CHAR2TVKGGCondition group 2
KDKG3KDKG3CHAR2TVKGGCondition group 3
KDKG4KDKG4CHAR2TVKGGCondition group 4
KDKG5KDKG5CHAR2TVKGGCondition group 5
VKAUSABRVWCHAR3TVLVUsage
J_1AINDXPJ_1AINDXPCHAR5J_1AINFT20Inflation Index
J_1AIDATEPJ_1AIDATESDATS8Indexing base date
KZFMEKZFMECHAR1Leading UoM
MWSKZMWSKZCHAR2
*
Tax code
VERTTRANTYPCHAR1Contract Type
VERTNRANLCHAR13Contract Number
SGTXTSGTXTCHAR50Text
DELCODELCOCHAR3Delivery time
BEMOTBEMOTCHAR2TBMOTAccounting Indicator
RRRELRR_RELTYPCHAR1Rev. recognition cat.
AKKURAKKURDEC9(5)Ex.rate-LettOfCredit
WMINRWMINRCHAR10WWMICatalog
VGBEL_EXVGBELCHAR10
*
Reference document
VGPOS_EXVGPOSNUMC6
*
Reference item
LOGSYSLOGSYSCHAR10
*
Logical system
VGTYP_EXVGTYP_EXCHAR3Category
J_1BTAXLW3J_1BTAXLW3CHAR3J_1BATL3ISS Law
J_1BTAXLW4J_1BTAXLW4CHAR3J_1BATL4ACOFINS Law
J_1BTAXLW5J_1BTAXLW5CHAR3J_1BATL5PIS Law
MSR_IDMSR_PROCESS_IDCHAR10Process ID No.
MSR_REFUND_CODEMSR_RETURNS_REFUND_CODECHAR3MSR_C_RET_REFUNDRefund Code
MSR_RET_REASONMSR_RETURNS_REASONCHAR3MSR_C_RET_REASONReturn Reason
NRAB_KNUMHKNUMHCHAR10Condition record no.
NRAB_VALUEKWERTCURR13(2)Condition value
DISPUTE_CASEDISPUTE_CASERAW16Dispute Case
FUND_USAGE_ITEMFUND_USAGE_ITEMRAW16Fund Usage Item
FARR_RELTYPEFARR_RELTYPECHAR10Rev. Accounting Type
CLAIMS_TAXATIONCLAIMS_TAXATIONCHAR1Claims Taxation
KURRF_DAT_ORIGWWERT_DDATS8Translation Date
VGTYP_EXTTDD_VBTYP_EXT_VCHAR4Prec. cat. extens.
SGT_RCATSGT_RCATCHAR16Requirement Segment
SGT_SCATSGT_SCATCHAR16Stock Segment
AUFPLCO_AUFPLNUMC10Opertn task list no.
APLZLCIM_COUNTNUMC8Counter
DPCNR/SAPPCE/DPCNRCHAR10Down Payment Chain Number
DCPNR/SAPPCE/DPCPNRNUMC3Transaction Number
DPNRB/SAPPCE/DPCPNRBNUMC3Document Seq. No.
.APPENDAFM_PEROP_SD_VBRP
PEROP_BEGFM_PEROP_SD_LOWDATS8Period of Performance Start Date
PEROP_ENDFM_PEROP_SD_HIGHDATS8Period of Performance End Date
.APPENDFMFG_VBRP_APP
FMFGUS_KEYFMFG_US_KEYCHAR22US Government Fields
.APPENDGMADDONVBRP
FONDSBP_GEBERCHAR10
*
Fund
FISTLFISTLCHAR16
*
Funds Center
FKBERFKBERCHAR16
*
Functional Area
GRANT_NBRGM_GRANT_NBRCHAR20Grant
BUDGET_PDFM_BUDGET_PERIODCHAR10
*
Budget Period
.APPENDPRS_VBRP_CPILS
PRS_WORK_PERIODPRS_WORK_PERIODNUMC7Work Period
.APPENDRRICB_VBRP
PPRCTRPPRCTRCHAR10
*
Partner Profit Ctr
PARGBPARGBCHAR4
*
Trading part.BA
.APPENDVBRPOLC_APP
AUFPL_OAACO_AUFPLNUMC10Opertn task list no.
APLZL_OAACIM_COUNTNUMC8Counter
.APPENDVBRP_CMPD
CAMPAIGNCGPL_GUID16_R3RAW16CGPL_GUID
.APPENDVBRP_COMPLAINT
COMPREASCMP_COMPREAS_COPYCHAR4Abb. Complaints Reason







comments powered by Disqus