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_VFCHAR10VBUKSales Document
POSNRPOSNR_VFNUMC6VBUPItem (SD)
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_VCHAR1Cat
AUBELVBELN_VACHAR10VBUKAuto. debit creation
AUPOSPOSNR_VANUMC6VBUPAuto. debit creation
AUREFAUREFCHAR1Referenced sales document
MATNRMATNRCHAR18MARAMaterial
ARKTXARKTXCHAR40Description
PMATNPMATNCHAR18MARAPricing Ref. Matl
CHARGCHARG_DCHAR10MCHAPricing Ref. Matl
MATKLMATKLCHAR9T023Material Group
PSTYVPSTYVCHAR4
*
Item category
POSARPOSARCHAR1Item type
PRODHPRODH_DCHAR18T179Item type
VSTELVSTELCHAR4TVSTShipping Point/Receiving Pt
ATPKZATPKZCHAR1Replacement part
SPARTSPARTCHAR2TSPADivision
POSPAPOSPANUMC6VBUPPartner item
WERKSWERKS_DCHAR4T001WPartner item
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_AKCHAR2TSPASales Office
SHKZGSHKZG_VFCHAR1Debit/Credit Ind.
ERNAMERNAMCHAR12Created by
ERDATERDATDATS8Created on
ERZETERZETTIMS6Time
BWTARBWTAR_DCHAR10T149DTime
LGORTLGORT_DCHAR4T001LTime
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
PAOBJNRRKEOBJNRNUMC10Controlling Area
PS_PSP_PNRPS_PSP_PNRNUMC8
*
WBS Element
AUFNRAUFNRCHAR12AUFKOrder
TXJCDTXJCDCHAR15
*
Tax Jurisdiction
CMPRECMPRECURR11(2)Credit price
CMPNTCMPNTCHAR1Credit funct. active
CUOBJCUOBJ_VANUMC18Internal object no.
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
AUTYPVBTYPCHAR1Usage of HL item
STADATSTADATDATS8Statistics date
FPLNRFPLNRCHAR10FPLABilling plan number
FPLTRFPLTRNUMC6
*
Item
AKTNRWAKTIONCHAR10WAKHItem
KNUMA_PIKNUMA_PICHAR10KONAPromotion
KNUMA_AGKNUMA_AGCHAR10KONASales deal
PREFEPREFECHAR1Preference auth.
MWSBPMWSBPCURR13(2)Tax amount
AUGRU_AUFTAUGRUCHAR3TVAUTax amount
FAREGFAREGCHAR1Billing rule
UPMATUPMATCHAR18MARAMnItm PrcRefMatl
UKONMUKONMCHAR2T178MnItem MatPricingGrp
CMPRE_FLTCMPRE_FLTFLTP16(16)Credit price
ABFORABSFORM_CMCHAR2T691KCredit price
ABGESABGES_CMFLTP16(16)
J_1ARFZJ_1ARFZVATCHAR1J_1ARFZ
J_1AREGIOREGIOCHAR3T005S
J_1AGICDJ_1AGICD_DCHAR2J_1AGICD
J_1ADTYPJ_1ADTYP_DCHAR2J_1ADTYP
J_1ATXRELJ_1ATXREL_CHAR10J_1ATXREL
J_1BCFOPJ_1BCFOPCHAR10J_1BAGCFOP
J_1BTAXLW1J_1BTAXLW1CHAR3J_1BATL1ICMS law
J_1BTAXLW2J_1BTAXLW2CHAR3J_1BATL2IPI law
J_1BTXSDCJ_1BTXSDC_CHAR2J_1BTXSDCIPI law
BRTWRBRTWR_FPCURR15(2)Gross value
WKTNRWKTNRCHAR10VBUKValue contract no.
WKTPSWKTPSNUMC6VBUPValue contract item
RPLNRRPLNR_AUCHAR10FPLAPaym.card plan no.
KURSK_DATWWERT_DDATS8Paym.card plan no.
WGRU1WGRU_HIE1CHAR18Paym.card plan no.
WGRU2WGRU_HIE2CHAR18Paym.card plan no.
KDKG1KDKG1CHAR2TVKGGCondition group 1
KDKG2KDKG2CHAR2TVKGGCondition group 2
KDKG3KDKG3CHAR2TVKGGCondition group 3
KDKG4KDKG4CHAR2TVKGGCondition group 4
KDKG5KDKG5CHAR2TVKGGCondition group 5
VKAUSABRVWCHAR3TVLVModel
J_1AINDXPJ_1AINDXPCHAR5J_1AINFT20Inflation Index
J_1AIDATEPJ_1AIDATESDATS8Inflation index date
KZFMEKZFMECHAR1Leading UoM
MWSKZMWSKZCHAR2
*
Tax code
VERTTRANTYPCHAR1Tax code
VERTNRANLCHAR13Tax code
SGTXTSGTXTCHAR50Text
DELCODELCOCHAR3Delivery time
BEMOTBEMOTCHAR2TBMOTAccounting Indicator
RRRELRR_RELTYPCHAR1Accounting Indicator
AKKURAKKURDEC9(5)Ex.rate-LettOfCredit
WMINRWMINRCHAR10WWMICatalog
VGBEL_EXVGBELCHAR10
*
Ext. Reference Document
VGPOS_EXVGPOSNUMC6
*
Ext. Reference Document
LOGSYSLOGSYSCHAR10
*
Logical system
VGTYP_EXVGTYP_EXCHAR3Category
J_1BTAXLW3J_1BTAXLW3CHAR3J_1BATL3ISS Law
J_1BTAXLW4J_1BTAXLW4CHAR3J_1BATL4ACOFINS Law
J_1BTAXLW5J_1BTAXLW5CHAR3J_1BATL5PIS Law
MSR_IDMSR_PROCESS_IDCHAR10PIS Law
MSR_REFUND_CODEMSR_RETURNS_REFUND_CODECHAR3MSR_C_RET_REFUNDPIS Law
MSR_RET_REASONMSR_RETURNS_REASONCHAR3MSR_C_RET_REASONPIS Law
NRAB_KNUMHKNUMHCHAR10PIS Law
NRAB_VALUEKWERTCURR13(2)PIS Law
DISPUTE_CASEDISPUTE_CASERAW16Dispute Case
FUND_USAGE_ITEMFUND_USAGE_ITEMRAW16Fund Usage Item
FARR_RELTYPEFARR_RELTYPECHAR10Rev. Accounting Type
CLAIMS_TAXATIONCLAIMS_TAXATIONCHAR1Claims Taxation
KURRF_DAT_ORIGWWERT_DDATS8Claims Taxation
VGTYP_EXTTDD_VBTYP_EXT_VCHAR4Claims Taxation
SGT_RCATSGT_RCATCHAR16Requirement Segment
SGT_SCATSGT_SCATCHAR16Stock Segment
.INCLUDECI_PRS_CPILS_2Stock Segment
.APPEND/OLC/VBRPStock Segment
AUFPLCO_AUFPLNUMC10Stock Segment
APLZLCIM_COUNTNUMC8Stock Segment
.APPEND/SAPPCE/VBRP_FI_DPCStock Segment
DPCNR/SAPPCE/DPCNRCHAR10Stock Segment
DCPNR/SAPPCE/DPCPNRNUMC3Stock Segment
DPNRB/SAPPCE/DPCPNRBNUMC3Stock Segment
.APPENDAFM_PEROP_SD_VBRPStock Segment
PEROP_BEGFM_PEROP_SD_LOWDATS8Stock Segment
PEROP_ENDFM_PEROP_SD_HIGHDATS8Stock Segment
.APPENDFMFG_VBRP_APPStock Segment
FMFGUS_KEYFMFG_US_KEYCHAR22Stock Segment
.APPENDGMADDONVBRPStock Segment
FONDSBP_GEBERCHAR10
*
Stock Segment
FISTLFISTLCHAR16
*
Funds Center
FKBERFKBERCHAR16
*
Functional Area
GRANT_NBRGM_GRANT_NBRCHAR20Functional Area
BUDGET_PDFM_BUDGET_PERIODCHAR10
*
Functional Area
.APPENDPRS_VBRP_CPILSFunctional Area
PRS_WORK_PERIODPRS_WORK_PERIODNUMC7Work Period
.APPENDRRICB_VBRPWork Period
PPRCTRPPRCTRCHAR10
*
Partner Profit Ctr
PARGBPARGBCHAR4
*
Trading part.BA
.APPENDVBRPOLC_APPTrading part.BA
AUFPL_OAACO_AUFPLNUMC10Trading part.BA
APLZL_OAACIM_COUNTNUMC8Trading part.BA
.APPENDVBRP_CMPDTrading part.BA
CAMPAIGNCGPL_GUID16_R3RAW16Trading part.BA
.APPENDVBRP_COMPLAINTTrading part.BA
COMPREASCMP_COMPREAS_COPYCHAR4Trading part.BA






comments powered by Disqus