SAP Tables | Sales and Distribution | Billing(SD-BIL) SAP SD

Share |

VBRP SAP Billing Document: Item Data Table


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 view further information about Table VBRP and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

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

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)

==>View Table relationships


Dictionary fields for SAP Table VBRP

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3 T000Client
VBELNVBELN_VFCHAR10 VBUKBilling Document
POSNRPOSNR_VFNUMC6 VBUPBilling item
UEPOSUEPOSNUMC6 VBUPHigher-level item in bill of material structures
FKIMGFKIMGQUAN13(3) Actual Invoiced Quantity
VRKMEVRKMEUNIT3 T006Sales unit
UMVKZUMVKZDEC5 Numerator (factor) for conversion of sales quantity into SKU
UMVKNUMVKNDEC5 Denominator (Divisor) for Conversion of Sales Qty into SKU
MEINSMEINSUNIT3 T006Base 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
GEWEIGEWEIUNIT3 T006Weight Unit
VOLUMVOLUM_15QUAN15(3) Volume
VOLEHVOLEHUNIT3 T006Volume unit
GSBERGSBERCHAR4 TGSBBusiness Area
PRSDTPRSDTDATS8 Date for pricing and exchange rate
FBUDAFBUDADATS8 Date on which services rendered
KURSKKURSKDEC9(5) Exchange Rate for Price Determination
NETWRNETWR_FPCURR15(2) Net value of the billing item in document currency
VBELVVBELVCHAR10 VBUKOriginating document
POSNVPOSNVNUMC6 VBUPOriginating item
VGBELVGBELCHAR10 VBUKDocument number of the reference document
VGPOSVGPOSNUMC6 VBUPItem number of the reference item
VGTYPVBTYP_VCHAR1 Document category of preceding SD document
AUBELVBELN_VACHAR10 VBUKSales Document
AUPOSPOSNR_VANUMC6 VBUPSales Document Item
AUREFAUREFCHAR1 Sales document was created from reference
MATNRMATNRCHAR18 MARAMaterial Number
ARKTXARKTXCHAR40 Short text for sales order item
PMATNPMATNCHAR18 MARAPricing Reference Material
CHARGCHARG_DCHAR10 MCHABatch Number
PSTYVPSTYVCHAR4
*
Sales document item category
POSARPOSARCHAR1 Item type
PRODHPRODH_DCHAR18 T179Product hierarchy
VSTELVSTELCHAR4 TVSTShipping Point/Receiving Point
ATPKZATPKZCHAR1 Replacement part
POSPAPOSPANUMC6 VBUPItem number in the partner segment
WERKSWERKS_DCHAR4 T001WPlant
ALANDALANDCHAR3 T005Departure country (country from which the goods are sent)
WKREGWKREGCHAR3 T005SRegion in which plant is located
WKCOUWKCOUCHAR3 County in which plant is located
WKCTYWKCTYCHAR4 City 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
KOWRRKOWRRCHAR1 Statistical values
PRSFDPRSFDCHAR1 Carry out pricing
SKTOFSKTOFCHAR1 Cash discount indicator
SKFBPSKFBPCURR13(2) Amount eligible for cash discount in document currency
KONDMKONDMCHAR2 T178Material Pricing Group
KTGRMKTGRMCHAR2 TVKMAccount assignment group for this material
KOSTLKOSTLCHAR10
*
Cost Center
BONUSBONUSCHAR2 TVBOVolume rebate group
PROVGPROVGCHAR2 TVPRCommission group
EANNREANNRCHAR13 European Article Number (EAN) - obsolete!!!!!
VKGRPVKGRPCHAR3 TVKGRSales Group
VKBURVKBURCHAR4 TVBURSales Office
SPARASPART_AKCHAR2 TSPADivision for order header
SHKZGSHKZG_VFCHAR1 Returns item
ERNAMERNAMCHAR12 Name of Person who Created the Object
ERDATERDATDATS8 Date on Which Record Was Created
ERZETERZETTIMS6 Entry time
BWTARBWTAR_DCHAR10 T149DValuation Type
LGORTLGORT_DCHAR4 T001LStorage 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)
UVPRSUVPRSCHAR1 Incomplete with respect to pricing
UVALLUVALLCHAR1 Generally incomplete
EAN11EAN11CHAR18 International Article Number (EAN/UPC)
PRCTRPRCTRCHAR10
*
Profit Center
KVGR2KVGR2CHAR3 TVV2Customer group 2
KVGR3KVGR3CHAR3 TVV3Customer group 3
KVGR4KVGR4CHAR3 TVV4Customer group 4
KVGR5KVGR5CHAR3 TVV5Customer group 5
MVGR2MVGR2CHAR3 TVM2Material group 2
MVGR3MVGR3CHAR3 TVM3Material group 3
MVGR4MVGR4CHAR3 TVM4Material group 4
MVGR5MVGR5CHAR3 TVM5Material group 5
MATWAMATWACHAR18 MARAMaterial entered
BONBABONBACURR13(2) Rebate basis 1
KOKRSKOKRSCHAR4 TKA01Controlling Area
PAOBJNRRKEOBJNRNUMC10 Profitability Segment Number (CO-PA)
PS_PSP_PNRPS_PSP_PNRNUMC8
*
Work Breakdown Structure Element (WBS Element)
AUFNRAUFNRCHAR12 AUFKOrder Number
TXJCDTXJCDCHAR15
*
Tax Jurisdiction
CMPRECMPRECURR11(2) Item credit price
CMPNTCMPNTCHAR1 ID: Item with active credit function / relevant for credit
CUOBJCUOBJ_VANUMC18 Configuration
CUOBJ_CHCUOBJ_CHNUMC18 Internal object number of the batch classification
KOUPDKOUPDCHAR1 Condition update
UECHAUECHANUMC6
*
Higher-Level Item of Batch Split Item
XCHARXCHARCHAR1 Batch management indicator (internal)
ABRVWABRVWCHAR3 TVLVUsage Indicator
SERNRSERNRCHAR8 SNUMBOM explosion number
BZIRK_AUFTBZIRK_AUFTCHAR6 T171Sales district of sales order
KDGRP_AUFTKDGRP_AUFTCHAR2 T151Customer group of sales order
KONDA_AUFTKONDA_AUFTCHAR2 T188Price group of sales order
LLAND_AUFTLLAND_AUFTCHAR3 T005Country of destination of sales order
MPROKMPROKCHAR1 Status manual price change
PLTYP_AUFTPLTYP_AUFTCHAR2 T189Price list type of sales order
REGIO_AUFTREGIO_AUFTCHAR3 T005SRegion of sales order
VKORG_AUFTVKORG_AUFTCHAR4 TVKOSales organization of sales order
VTWEG_AUFTVTWEG_AUFTCHAR2 TVTWDistribution channel of sales order
ABRBGABRBGDATS8 Start of accounting settlement period
PROSAPROSACHAR1 ID for material determination
UEPVWUEPVWCHAR1 ID for higher-level item usage
AUTYPVBTYPCHAR1 SD document category
STADATSTADATDATS8 Statistics date
FPLNRFPLNRCHAR10 FPLABilling plan number / invoicing plan number
FPLTRFPLTRNUMC6
*
Item for billing plan/invoice plan/payment cards
AKTNRWAKTIONCHAR10 WAKHPromotion
KNUMA_PIKNUMA_PICHAR10 KONAPromotion
KNUMA_AGKNUMA_AGCHAR10 KONASales deal
PREFEPREFECHAR1 Preference indicator in export/import
MWSBPMWSBPCURR13(2) Tax amount in document currency
AUGRU_AUFTAUGRUCHAR3 TVAUOrder reason (reason for the business transaction)
FAREGFAREGCHAR1 Rule in billing plan/invoice plan
UPMATUPMATCHAR18 MARAPricing reference material of main item
UKONMUKONMCHAR2 T178Material pricing group of main item
CMPRE_FLTCMPRE_FLTFLTP16(16) Item credit price
ABFORABSFORM_CMCHAR2 T691KForm of payment guarantee
ABGESABGES_CMFLTP16(16) Guaranteed (factor between 0 and 1)
J_1ARFZJ_1ARFZVATCHAR1 J_1ARFZReason for zero VAT
J_1AGICDJ_1AGICD_DCHAR2 J_1AGICDActivity Code for Gross Income Tax
J_1ADTYPJ_1ADTYP_DCHAR2 J_1ADTYPDistribution Type for Employment Tax
J_1ATXRELJ_1ATXREL_CHAR10 J_1ATXRELTax relevant classification
J_1BCFOPJ_1BCFOPCHAR10 J_1BAGCFOP Code and Extension
J_1BTAXLW1J_1BTAXLW1CHAR3 J_1BATL1Tax law: ICMS
J_1BTAXLW2J_1BTAXLW2CHAR3 J_1BATL2Tax law: IPI
J_1BTXSDCJ_1BTXSDC_CHAR2 J_1BTXSDCSD tax code
BRTWRBRTWR_FPCURR15(2) Gross value of the billing item in document currency
WKTNRWKTNRCHAR10 VBUKValue contract no.
WKTPSWKTPSNUMC6 VBUPValue contract item
RPLNRRPLNR_AUCHAR10 FPLAPayment card plan number of sales document
KURSK_DATWWERT_DDATS8 Translation Date
WGRU1WGRU_HIE1CHAR18 Material group hierarchy 1
WGRU2WGRU_HIE2CHAR18 Material group hierarchy 2
KDKG1KDKG1CHAR2 TVKGGCustomer condition group 1
KDKG2KDKG2CHAR2 TVKGGCustomer condition group 2
KDKG3KDKG3CHAR2 TVKGGCustomer condition group 3
KDKG4KDKG4CHAR2 TVKGGCustomer condition group 4
KDKG5KDKG5CHAR2 TVKGGCustomer condition group 5
VKAUSABRVWCHAR3 TVLVUsage Indicator
J_1AINDXPJ_1AINDXPCHAR5 J_1AINFT20Inflation Index
J_1AIDATEPJ_1AIDATESDATS8 Indexing base date
KZFMEKZFMECHAR1 ID: Leading unit of measure for completing a transaction
MWSKZMWSKZCHAR2
*
Tax on sales/purchases code
VERTTRANTYPCHAR1 Contract Type
VERTNRANLCHAR13 Contract Number
SGTXTSGTXTCHAR50 Item Text
DELCODELCOCHAR3 Agreed delivery time
BEMOTBEMOTCHAR2 TBMOTAccounting Indicator
RRRELRR_RELTYPCHAR1 Revenue recognition category
AKKURAKKURDEC9(5) Exchange rate for letter-of-credit procg in foreign trade
WMINRWMINRCHAR10 WWMIProduct catalog number
VGBEL_EXVGBELCHAR10
*
Document number of the reference document
VGPOS_EXVGPOSNUMC6
*
Item number of the reference item
LOGSYSLOGSYSCHAR10
*
Logical system
VGTYP_EXVGTYP_EXCHAR3 Category of an external transaction or element
J_1BTAXLW3J_1BTAXLW3CHAR3 J_1BATL3ISS Tax Law
J_1BTAXLW4J_1BTAXLW4CHAR3 J_1BATL4ACOFINS Tax Law
J_1BTAXLW5J_1BTAXLW5CHAR3 J_1BATL5PIS Tax Law
MSR_IDMSR_PROCESS_IDCHAR10 Process Identification Number
MSR_REFUND_CODEMSR_RETURNS_REFUND_CODECHAR3 MSR_C_RET_REFUNDReturns Refund Code
MSR_RET_REASONMSR_RETURNS_REASONCHAR3 MSR_C_RET_REASONReturn Reason
NRAB_KNUMHKNUMHCHAR10 Condition record number
NRAB_VALUEKWERTCURR13(2) Condition value
DISPUTE_CASEDISPUTE_CASERAW16 Dispute Case
FUND_USAGE_ITEMFUND_USAGE_ITEMRAW16 Fund Usage Item
CLAIMS_TAXATIONCLAIMS_TAXATIONCHAR1 Claims Taxation
KURRF_DAT_ORIGWWERT_DDATS8 Translation Date
VGTYP_EXTTDD_VBTYP_EXT_VCHAR4 Extension of SD document category of preceding document
.APPEND/OLC/VBRP OLC append to VBRP
AUFPLCO_AUFPLNUMC10 Routing number of operations in the order
APLZLCIM_COUNTNUMC8 Internal counter
.APPEND/SAPHT/SW_VBRP ##### VBRP
AUDATAUDATDATS8 Document Date (Date Received/Sent)
EDATUEDATUDATS8 Schedule line date
PLAUFZ/SAPHT/SW_PLAUFZNUMC3 Price protection period
PLAUEZ/SAPHT/SW_PLAUEZCHAR1 Unit for price protection
CONTNBR/SAPHT/SW_CONTNBRCHAR10
*
Contract number
CONTITM/SAPHT/SW_CONTITMNUMC6
*
Contract item number
.APPEND/SAPPCE/VBRP_FI_DPC VBRP Append for Down Payment Chain
DPCNR/SAPPCE/DPCNRCHAR10 Down Payment Chain Number
DCPNR/SAPPCE/DPCPNRNUMC3 Transaction Number
DPNRB/SAPPCE/DPCPNRBNUMC3 Sequence Number of Accounting Document in Transaction
.APPENDADBOSDP IBU A&D/E&C, Anzahlungsabwicklung ohne Fakturierungsplan
BOSFARBOSFARCHAR1 Billing/Invoicing rule (w/o invoicing plan
DP_BELNRBELNR_DCHAR10 Accounting Document Number
DP_BUKRSBUKRSCHAR4
*
Company Code
DP_GJAHRGJAHRNUMC4 Fiscal Year
DP_BUZEIBUZEINUMC3 Number of Line Item Within Accounting Document
.APPENDADBOSVBRP # VBRP #######
PACKNOPACKNONUMC10 ESLHPackage number
.APPENDAFM_PEROP_SD_VBRP Period of Performance
PEROP_BEGFM_PEROP_SD_LOWDATS8 Period of Performance Start Date
PEROP_ENDFM_PEROP_SD_HIGHDATS8 Period of Performance End Date
.APPENDGMADDONVBRP Grants Mgmt: Additional FM fields to VBRP
FONDSBP_GEBERCHAR10
*
Fund
FISTLFISTLCHAR16
*
Funds Center
FKBERFKBERCHAR16
*
Functional Area
GRANT_NBRGM_GRANT_NBRCHAR20 Grant
BUDGET_PDFM_BUDGET_PERIODCHAR10
*
FM: Budget Period
.APPENDJ_3GVBRPA VBRP##CEM####
.INCLUDEJ_3GVBRPS Include Structure Billing Item (CEM)
J_3GBELNRIJ_3GBELNRICHAR10 J_3GBELKDocument Number
J_3GPMAUFEJ_3GPMAUFECHAR12 AUFKPM Order Number (Owner)
J_3GPMAUFVJ_3GPMAUFVCHAR12 AUFKPM Order Number (Administrator)
J_3GETYPAJ_3GETYPACHAR2
*
Sending Recipient Type
J_3GETYPEJ_3GETYPECHAR2
*
Receiving Recipient Type
J_3GORGUEBJ_3GORGUEBCHAR1 Indicator: Across All Organizational Structures
.APPENDPRS_VBRP_CPILS Commercial Project Inception & Lean Staffing appending VBRP
PRS_WORK_PERIODPRS_WORK_PERIODNUMC7 Work Period (Internal Representation)
.APPENDRRICB_VBRP Enhancements for RRICB / DP93
PPRCTRPPRCTRCHAR10
*
Partner Profit Center
PARGBPARGBCHAR4
*
Trading partner's business area
.APPENDVBRPOLC_APP VBRP Append for Operation level costing
AUFPL_OAACO_AUFPLNUMC10 Routing number of operations in the order
APLZL_OAACIM_COUNTNUMC8 Internal counter
.APPENDVBRP_CMPD TPM Campaign Determination: APPEND to VBRP
CAMPAIGNCGPL_GUID16_R3RAW16 Generic project planning: GUID from external R/3 system
.APPENDVBRP_COMPLAINT Complaint Management
COMPREASCMP_COMPREAS_COPYCHAR4 Abbreviation for Complaints Reason


Key field
Non-key field


Relations between VBRP and other tables


ADMIX-Help structure for reading via ADK in LDB(SD)
      VBUK-Sales Document: Header Status and Admin. Data
            VBRK-Billing Document: Header Data
                  NAST-Message status
                  VBFA-Sales Document Flow
                  VBRP-Billing Document: Item Data
                  KONV-Conditions (Transaction Data)
                  VBPA-Sales Document: Partner
                  SADR-Address Management: Company data
                  VBSSSK-Table Generated for View VBSSSK
                  EIKP-Foreign Trade: Export/Import Header Data
                  EIPO-Foreign Trade: Export/Import: Item Data
                  STXH-STXD SAPscript text file header
                  STXL-STXD SAPscript text file lines
                  VBRL-Sales Document: Invoice List


KNVK-Customer Master Contact Partner
      KNA1-General Data in Customer Master
            KNVV-Customer Master Sales Data
            KNVP-Customer Master Partner Functions
            VBAP-Sales Document: Item Data
            LIPS-SD document: Delivery: Item data
            VBRP-Billing Document: Item Data
            VBKA-Sales Activities


VBRK-Billing Document: Header Data
      VBUK-Sales Doc.: Header Status and Administrative Data
      VBPA-Sales Document: Partner
      VBRP-Billing Document: Item Data
            VBFA-Sales Document Flow
            VBFAVG-Sales document: Cumulative records,followed by doc
            VBPAPO-Item partner of sales document (for LDB)
            KONV-Conditions (Transaction Data)




comments powered by Disqus