SAP Tables

Share |

VBRP SAP Table - Billing Document: Item Data


VBRP is a standard SAP Table which is used to store Billing Document: Item Data information. This is available within R/3 SAP systems depending on the version and release level. Below is the standard documentation available and a few details of the fields which make up this table. You can also view this information 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 ask a question or add useful hints, tips and screen shots specific to this SAP table dictionary 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_VFNUMC6VBUPBilling item
UEPOSUEPOSNUMC6VBUPHigher-level item in bill of material structures
FKIMGFKIMGQUAN13(3)Actual Invoiced Quantity
VRKMEVRKMEUNIT3T006Sales unit
UMVKZUMVKZDEC5Numerator (factor) for conversion of sales quantity into SKU
UMVKNUMVKNDEC5Denominator (Divisor) for Conversion of Sales Qty into SKU
MEINSMEINSUNIT3T006Base Unit of Measure
SMENGSMENGQUAN13(3)Scale quantity in base unit of measure
FKLMGFKLMGQUAN13(3)Billing quantity in stockkeeping unit
LMENGLMENGQUAN13(3)Required quantity for mat.management in stockkeeping units
NTGEWNTGEW_15QUAN15(3)Net weight
BRGEWBRGEW_15QUAN15(3)Gross weight
GEWEIGEWEIUNIT3T006Weight Unit
VOLUMVOLUM_15QUAN15(3)Volume
VOLEHVOLEHUNIT3T006Volume unit
GSBERGSBERCHAR4TGSBBusiness Area
PRSDTPRSDTDATS8Date for pricing and exchange rate
FBUDAFBUDADATS8Date on which services rendered
KURSKKURSKDEC9(5)Exchange Rate for Price Determination
NETWRNETWR_FPCURR15(2)Net value of the billing item in document currency
VBELVVBELVCHAR10VBUKOriginating document
POSNVPOSNVNUMC6VBUPOriginating item
VGBELVGBELCHAR10VBUKDocument number of the reference document
VGPOSVGPOSNUMC6VBUPItem number of the reference item
VGTYPVBTYP_VCHAR1Document category of preceding SD document
AUBELVBELN_VACHAR10VBUKSales Document
AUPOSPOSNR_VANUMC6VBUPSales Document Item
AUREFAUREFCHAR1Sales document was created from reference
MATNRMATNRCHAR18MARAMaterial Number
ARKTXARKTXCHAR40Short text for sales order item
PMATNPMATNCHAR18MARAPricing Reference Material
CHARGCHARG_DCHAR10MCHABatch Number
MATKLMATKLCHAR9T023Material Group
PSTYVPSTYVCHAR4
*
Sales document item category
POSARPOSARCHAR1Item type
PRODHPRODH_DCHAR18T179Product hierarchy
VSTELVSTELCHAR4TVSTShipping Point/Receiving Point
ATPKZATPKZCHAR1Replacement part
SPARTSPARTCHAR2TSPADivision
POSPAPOSPANUMC6VBUPItem number in the partner segment
WERKSWERKS_DCHAR4T001WPlant
ALANDALANDCHAR3T005Departure country (country from which the goods are sent)
WKREGWKREGCHAR3T005SRegion in which plant is located
WKCOUWKCOUCHAR3County in which plant is located
WKCTYWKCTYCHAR4City in which plant is located
TAXM1TAXM1CHAR1
*
Tax classification material
TAXM2TAXM2CHAR1
*
Tax classification 2 for material
TAXM3TAXM3CHAR1
*
Tax classification 3 for material
TAXM4TAXM4CHAR1
*
Tax Classification 4 Material
TAXM5TAXM5CHAR1
*
Tax classification 5 for material
TAXM6TAXM6CHAR1
*
Tax classification 6 for material
TAXM7TAXM7CHAR1
*
Tax classification 7 for material
TAXM8TAXM8CHAR1
*
Tax Classification 8 Material
TAXM9TAXM9CHAR1
*
Tax Classification 9 Material
KOWRRKOWRRCHAR1Statistical values
PRSFDPRSFDCHAR1Carry out pricing
SKTOFSKTOFCHAR1Cash discount indicator
SKFBPSKFBPCURR13(2)Amount eligible for cash discount in document currency
KONDMKONDMCHAR2T178Material Pricing Group
KTGRMKTGRMCHAR2TVKMAccount assignment group for this material
KOSTLKOSTLCHAR10
*
Cost Center
BONUSBONUSCHAR2TVBOVolume rebate group
PROVGPROVGCHAR2TVPRCommission group
EANNREANNRCHAR13European Article Number (EAN) - obsolete!!!!!
VKGRPVKGRPCHAR3TVKGRSales Group
VKBURVKBURCHAR4TVBURSales Office
SPARASPART_AKCHAR2TSPADivision for order header
SHKZGSHKZG_VFCHAR1Returns item
ERNAMERNAMCHAR12Name of Person who Created the Object
ERDATERDATDATS8Date on Which Record Was Created
ERZETERZETTIMS6Entry time
BWTARBWTAR_DCHAR10T149DValuation Type
LGORTLGORT_DCHAR4T001LStorage Location
STAFOSTAFOCHAR6
*
Update group for statistics update
WAVWRWAVWRCURR13(2)Cost in document currency
KZWI1KZWI1CURR13(2)Subtotal 1 from pricing procedure for condition
KZWI2KZWI2CURR13(2)Subtotal 2 from pricing procedure for condition
KZWI3KZWI3CURR13(2)Subtotal 3 from pricing procedure for condition
KZWI4KZWI4CURR13(2)Subtotal 4 from pricing procedure for condition
KZWI5KZWI5CURR13(2)Subtotal 5 from pricing procedure for condition
KZWI6KZWI6CURR13(2)Subtotal 6 from pricing procedure for condition
STCURSTCUR_APDEC9(5)Exchange rate for statistics (Exch.rate at time of creation)
UVPRSUVPRSCHAR1Incomplete with respect to pricing
UVALLUVALLCHAR1Generally incomplete
EAN11EAN11CHAR18International Article Number (EAN/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 1
KOKRSKOKRSCHAR4TKA01Controlling Area
PAOBJNRRKEOBJNRNUMC10Profitability Segment Number (CO-PA)
PS_PSP_PNRPS_PSP_PNRNUMC8
*
Work Breakdown Structure Element (WBS Element)
AUFNRAUFNRCHAR12AUFKOrder Number
TXJCDTXJCDCHAR15
*
Tax Jurisdiction
CMPRECMPRECURR11(2)Item credit price
CMPNTCMPNTCHAR1ID: Item with active credit function / relevant for credit
CUOBJCUOBJ_VANUMC18Configuration
CUOBJ_CHCUOBJ_CHNUMC18Internal object number of the batch classification
KOUPDKOUPDCHAR1Condition update
UECHAUECHANUMC6
*
Higher-Level Item of Batch Split Item
XCHARXCHARCHAR1Batch management indicator (internal)
ABRVWABRVWCHAR3TVLVUsage Indicator
SERNRSERNRCHAR8SNUMBOM explosion number
BZIRK_AUFTBZIRK_AUFTCHAR6T171Sales district of sales order
KDGRP_AUFTKDGRP_AUFTCHAR2T151Customer group of sales order
KONDA_AUFTKONDA_AUFTCHAR2T188Price group of sales order
LLAND_AUFTLLAND_AUFTCHAR3T005Country of destination of sales order
MPROKMPROKCHAR1Status manual price change
PLTYP_AUFTPLTYP_AUFTCHAR2T189Price list type of sales order
REGIO_AUFTREGIO_AUFTCHAR3T005SRegion of sales order
VKORG_AUFTVKORG_AUFTCHAR4TVKOSales organization of sales order
VTWEG_AUFTVTWEG_AUFTCHAR2TVTWDistribution channel of sales order
ABRBGABRBGDATS8Start of accounting settlement period
PROSAPROSACHAR1ID for material determination
UEPVWUEPVWCHAR1ID for higher-level item usage
AUTYPVBTYPCHAR1SD document category
STADATSTADATDATS8Statistics date
FPLNRFPLNRCHAR10FPLABilling plan number / invoicing plan number
FPLTRFPLTRNUMC6
*
Item for billing plan/invoice plan/payment cards
AKTNRWAKTIONCHAR10WAKHPromotion
KNUMA_PIKNUMA_PICHAR10KONAPromotion
KNUMA_AGKNUMA_AGCHAR10KONASales deal
PREFEPREFECHAR1Preference indicator in export/import
MWSBPMWSBPCURR13(2)Tax amount in document currency
AUGRU_AUFTAUGRUCHAR3TVAUOrder reason (reason for the business transaction)
FAREGFAREGCHAR1Rule in billing plan/invoice plan
UPMATUPMATCHAR18MARAPricing reference material of main item
UKONMUKONMCHAR2T178Material pricing group of main item
CMPRE_FLTCMPRE_FLTFLTP16(16)Item credit price
ABFORABSFORM_CMCHAR2T691KForm of payment guarantee
ABGESABGES_CMFLTP16(16)Guaranteed (factor between 0 and 1)
J_1ARFZJ_1ARFZVATCHAR1J_1ARFZReason for zero VAT
J_1AREGIOREGIOCHAR3T005SRegion (State, Province, County)
J_1AGICDJ_1AGICD_DCHAR2J_1AGICDActivity Code for Gross Income Tax
J_1ADTYPJ_1ADTYP_DCHAR2J_1ADTYPDistribution Type for Employment Tax
J_1ATXRELJ_1ATXREL_CHAR10J_1ATXRELTax relevant classification
J_1BCFOPJ_1BCFOPCHAR10J_1BAGCFOP Code and Extension
J_1BTAXLW1J_1BTAXLW1CHAR3J_1BATL1Tax law: ICMS
J_1BTAXLW2J_1BTAXLW2CHAR3J_1BATL2Tax law: IPI
J_1BTXSDCJ_1BTXSDC_CHAR2J_1BTXSDCSD tax code
BRTWRBRTWR_FPCURR15(2)Gross value of the billing item in document currency
WKTNRWKTNRCHAR10VBUKValue contract no.
WKTPSWKTPSNUMC6VBUPValue contract item
RPLNRRPLNR_AUCHAR10FPLAPayment card plan number of sales document
KURSK_DATWWERT_DDATS8Translation Date
WGRU1WGRU_HIE1CHAR18Material group hierarchy 1
WGRU2WGRU_HIE2CHAR18Material group hierarchy 2
KDKG1KDKG1CHAR2TVKGGCustomer condition group 1
KDKG2KDKG2CHAR2TVKGGCustomer condition group 2
KDKG3KDKG3CHAR2TVKGGCustomer condition group 3
KDKG4KDKG4CHAR2TVKGGCustomer condition group 4
KDKG5KDKG5CHAR2TVKGGCustomer condition group 5
VKAUSABRVWCHAR3TVLVUsage Indicator
J_1AINDXPJ_1AINDXPCHAR5J_1AINFT20Inflation Index
J_1AIDATEPJ_1AIDATESDATS8Indexing base date
KZFMEKZFMECHAR1ID: Leading unit of measure for completing a transaction
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
VERTTRANTYPCHAR1Contract Type
VERTNRANLCHAR13Contract Number
SGTXTSGTXTCHAR50Item Text
DELCODELCOCHAR3Agreed delivery time
BEMOTBEMOTCHAR2TBMOTAccounting Indicator
RRRELRR_RELTYPCHAR1Revenue recognition category
AKKURAKKURDEC9(5)Exchange rate for letter-of-credit procg in foreign trade
WMINRWMINRCHAR10WWMIProduct catalog number
VGBEL_EXVGBELCHAR10
*
Document number of the reference document
VGPOS_EXVGPOSNUMC6
*
Item number of the reference item
LOGSYSLOGSYSCHAR10
*
Logical system
VGTYP_EXVGTYP_EXCHAR3Category of an external transaction or element
J_1BTAXLW3J_1BTAXLW3CHAR3J_1BATL3ISS Tax Law
J_1BTAXLW4J_1BTAXLW4CHAR3J_1BATL4ACOFINS Tax Law
J_1BTAXLW5J_1BTAXLW5CHAR3J_1BATL5PIS Tax Law
MSR_IDMSR_PROCESS_IDCHAR10Process Identification Number
MSR_REFUND_CODEMSR_RETURNS_REFUND_CODECHAR3MSR_C_RET_REFUNDReturns Refund Code
MSR_RET_REASONMSR_RETURNS_REASONCHAR3MSR_C_RET_REASONReturn Reason
NRAB_KNUMHKNUMHCHAR10Condition record number
NRAB_VALUEKWERTCURR13(2)Condition value
DISPUTE_CASEDISPUTE_CASERAW16Dispute Case
FUND_USAGE_ITEMFUND_USAGE_ITEMRAW16Fund Usage Item
FARR_RELTYPEFARR_RELTYPECHAR10Revenue Accounting Type
CLAIMS_TAXATIONCLAIMS_TAXATIONCHAR1Claims Taxation
KURRF_DAT_ORIGWWERT_DDATS8Translation Date
VGTYP_EXTTDD_VBTYP_EXT_VCHAR4Extension of SD document category of preceding document
SGT_RCATSGT_RCATCHAR16Requirement Segment
SGT_SCATSGT_SCATCHAR16Stock Segment
.APPEND/OLC/VBRPOLC append to VBRP
AUFPLCO_AUFPLNUMC10Routing number of operations in the order
APLZLCIM_COUNTNUMC8Internal counter
.APPEND/SAPPCE/VBRP_FI_DPCVBRP Append for Down Payment Chain
DPCNR/SAPPCE/DPCNRCHAR10Down Payment Chain Number
DCPNR/SAPPCE/DPCPNRNUMC3Transaction Number
DPNRB/SAPPCE/DPCPNRBNUMC3Sequence Number of Accounting Document in Transaction
.APPENDAFM_PEROP_SD_VBRPPeriod of Performance
PEROP_BEGFM_PEROP_SD_LOWDATS8Period of Performance Start Date
PEROP_ENDFM_PEROP_SD_HIGHDATS8Period of Performance End Date
.APPENDFMFG_VBRP_APPUS Federal VBRP Append Structure
FMFGUS_KEYFMFG_US_KEYCHAR22United States Federal Government Fields
.APPENDGMADDONVBRPGrants Mgmt: Additional FM fields to VBRP
FONDSBP_GEBERCHAR10
*
Fund
FISTLFISTLCHAR16
*
Funds Center
FKBERFKBERCHAR16
*
Functional Area
GRANT_NBRGM_GRANT_NBRCHAR20Grant
BUDGET_PDFM_BUDGET_PERIODCHAR10
*
FM: Budget Period
.APPENDPRS_VBRP_CPILSCommercial Project Inception & Lean Staffing appending VBRP
PRS_WORK_PERIODPRS_WORK_PERIODNUMC7Work Period (Internal Representation)
.APPENDRRICB_VBRPEnhancements for RRICB / DP93
PPRCTRPPRCTRCHAR10
*
Partner Profit Center
PARGBPARGBCHAR4
*
Trading partner's business area
.APPENDVBRPOLC_APPVBRP Append for Operation level costing
AUFPL_OAACO_AUFPLNUMC10Routing number of operations in the order
APLZL_OAACIM_COUNTNUMC8Internal counter
.APPENDVBRP_CMPDTPM Campaign Determination: APPEND to VBRP
CAMPAIGNCGPL_GUID16_R3RAW16Generic project planning: GUID from external R/3 system
.APPENDVBRP_COMPLAINTComplaint Management
COMPREASCMP_COMPREAS_COPYCHAR4Abbreviation for Complaints Reason


Key field
Non-key field




comments powered by Disqus