VBRP SAP table for – Billing Document: Item Data

Here we would like to draw your attention to VBRP table in SAP. As we know it is being mainly used with the SAP SD-BIL (Billing in SD) component which is coming under SD module (Sales & Distribution). VBRP is a SAP standard transparent table used for storing Billing Document: Item Data related data in SAP. It comes under the package VF.

SAP VBRP table

Table VBRP technical data

TableVBRP
Data storingBilling Document: Item Data
ModuleSD
ComponentSD-BIL
SAP PackageVF
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP VBRP Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in VBRP table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • SMENG : Operation Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BONBA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • PAOBJNR : Profitability Segment Number (CO-PA)
    Its data type is N (Character String with Digits Only) with field length 10
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is N (Character String with Digits Only) with field length 8
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • CMPRE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • CMPNT
    Its data type is C (Character String) with field length 1
  • CUOBJ : Configuration (internal object number)
    Its data type is N (Character String with Digits Only) with field length 18
  • CUOBJ_CH
    Its data type is N (Character String with Digits Only) with field length 18
  • FKLMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KOUPD
    Its data type is C (Character String) with field length 1
  • UECHA
    Its data type is N (Character String with Digits Only) with field length 6
  • XCHAR
    Its data type is C (Character String) with field length 1
  • ABRVW
    Its data type is C (Character String) with field length 3
  • SERNR : BOM explosion number
    Its data type is C (Character String) with field length 8
  • BZIRK_AUFT
    Its data type is C (Character String) with field length 6
  • KDGRP_AUFT
    Its data type is C (Character String) with field length 2
  • KONDA_AUFT
    Its data type is C (Character String) with field length 2
  • LLAND_AUFT
    Its data type is C (Character String) with field length 3
  • MPROK
    Its data type is C (Character String) with field length 1
  • LMENG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • PLTYP_AUFT
    Its data type is C (Character String) with field length 2
  • REGIO_AUFT
    Its data type is C (Character String) with field length 3
  • VKORG_AUFT
    Its data type is C (Character String) with field length 4
  • VTWEG_AUFT
    Its data type is C (Character String) with field length 2
  • ABRBG
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PROSA
    Its data type is C (Character String) with field length 1
  • UEPVW
    Its data type is C (Character String) with field length 1
  • AUTYP : Order category
    Its data type is C (Character String) with field length 1
  • STADAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FPLNR : Billing plan number / invoicing plan number
    Its data type is C (Character String) with field length 10
  • NTGEW : Net Weight
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • FPLTR
    Its data type is N (Character String with Digits Only) with field length 6
  • AKTNR
    Its data type is C (Character String) with field length 10
  • KNUMA_PI
    Its data type is C (Character String) with field length 10
  • KNUMA_AG : Sales deal
    Its data type is C (Character String) with field length 10
  • PREFE
    Its data type is C (Character String) with field length 1
  • MWSBP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • AUGRU_AUFT
    Its data type is C (Character String) with field length 3
  • FAREG
    Its data type is C (Character String) with field length 1
  • UPMAT : Pricing reference material of main item
    Its data type is C (Character String) with field length 18
  • UKONM : Material pricing group of main item
    Its data type is C (Character String) with field length 2
  • BRGEW : Gross Weight
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CMPRE_FLT
    Its data type is F (Floating point number) with field length 8
  • ABFOR
    Its data type is C (Character String) with field length 2
  • ABGES
    Its data type is F (Floating point number) with field length 8
  • J_1ARFZ
    Its data type is C (Character String) with field length 1
  • J_1AREGIO
    Its data type is C (Character String) with field length 3
  • J_1AGICD
    Its data type is C (Character String) with field length 2
  • J_1ADTYP
    Its data type is C (Character String) with field length 2
  • J_1ATXREL : Tax relevant classification
    Its data type is C (Character String) with field length 10
  • J_1BCFOP
    Its data type is C (Character String) with field length 10
  • J_1BTAXLW1
    Its data type is C (Character String) with field length 3
  • GEWEI : Weight Unit
    Its data type is C (Character String) with field length 3
  • J_1BTAXLW2
    Its data type is C (Character String) with field length 3
  • J_1BTXSDC : SD tax code
    Its data type is C (Character String) with field length 2
  • BRTWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • WKTNR
    Its data type is C (Character String) with field length 10
  • WKTPS
    Its data type is N (Character String with Digits Only) with field length 6
  • RPLNR
    Its data type is C (Character String) with field length 10
  • KURSK_DAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • WGRU1
    Its data type is C (Character String) with field length 18
  • WGRU2
    Its data type is C (Character String) with field length 18
  • KDKG1
    Its data type is C (Character String) with field length 2
  • VOLUM : Volume
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KDKG2
    Its data type is C (Character String) with field length 2
  • KDKG3
    Its data type is C (Character String) with field length 2
  • KDKG4
    Its data type is C (Character String) with field length 2
  • KDKG5
    Its data type is C (Character String) with field length 2
  • VKAUS
    Its data type is C (Character String) with field length 3
  • J_1AINDXP
    Its data type is C (Character String) with field length 5
  • J_1AIDATEP
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • KZFME
    Its data type is C (Character String) with field length 1
  • MWSKZ : Tax on sales/purchases code
    Its data type is C (Character String) with field length 2
  • VERTT
    Its data type is C (Character String) with field length 1
  • VOLEH : Unit for the Volume
    Its data type is C (Character String) with field length 3
  • VERTN
    Its data type is C (Character String) with field length 13
  • SGTXT : Item Text
    Its data type is C (Character String) with field length 50
  • DELCO
    Its data type is C (Character String) with field length 3
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • RRREL
    Its data type is C (Character String) with field length 1
  • AKKUR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • WMINR
    Its data type is C (Character String) with field length 10
  • VGBEL_EX
    Its data type is C (Character String) with field length 10
  • VGPOS_EX
    Its data type is N (Character String with Digits Only) with field length 6
  • LOGSYS : Logical system
    Its data type is C (Character String) with field length 10
  • GSBER : Business Area
    Its data type is C (Character String) with field length 4
  • VGTYP_EX
    Its data type is C (Character String) with field length 3
  • J_1BTAXLW3
    Its data type is C (Character String) with field length 3
  • J_1BTAXLW4
    Its data type is C (Character String) with field length 3
  • J_1BTAXLW5
    Its data type is C (Character String) with field length 3
  • MSR_ID
    Its data type is C (Character String) with field length 10
  • MSR_REFUND_CODE
    Its data type is C (Character String) with field length 3
  • MSR_RET_REASON
    Its data type is C (Character String) with field length 3
  • NRAB_KNUMH
    Its data type is C (Character String) with field length 10
  • NRAB_VALUE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • DISPUTE_CASE
    Its data type is X (Byte string) with field length 16
  • PRSDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FUND_USAGE_ITEM
    Its data type is X (Byte string) with field length 16
  • CLAIMS_TAXATION
    Its data type is C (Character String) with field length 1
  • KURRF_DAT_ORIG
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VGTYP_EXT
    Its data type is C (Character String) with field length 4
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is CI_PRS_CPILS_2
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is /OLC/VBRP
  • AUFPL : Routing number of operations in the order
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL : Internal counter
    Its data type is N (Character String with Digits Only) with field length 8
  • DPCNR
    Its data type is C (Character String) with field length 10
  • VBELN : Sales and Distribution Document Number
    Its a key field. Its data type is C (Character String) with field length 10
  • FBUDA
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DCPNR
    Its data type is N (Character String with Digits Only) with field length 3
  • DPNRB
    Its data type is N (Character String with Digits Only) with field length 3
  • PEROP_BEG
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PEROP_END
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • FONDS
    Its data type is C (Character String) with field length 10
  • FISTL : Funds Center
    Its data type is C (Character String) with field length 16
  • FKBER : Functional Area
    Its data type is C (Character String) with field length 16
  • GRANT_NBR : Grant
    Its data type is C (Character String) with field length 20
  • KURSK
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • PRS_WORK_PERIOD : Work Period (Internal Representation)
    Its data type is N (Character String with Digits Only) with field length 7
  • PPRCTR : Partner Profit Center
    Its data type is C (Character String) with field length 10
  • PARGB : Trading partner’s business area
    Its data type is C (Character String) with field length 4
  • AUFPL_OAA
    Its data type is N (Character String with Digits Only) with field length 10
  • APLZL_OAA
    Its data type is N (Character String with Digits Only) with field length 8
  • CAMPAIGN
    Its data type is X (Byte string) with field length 16
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • COMPREAS
    Its data type is C (Character String) with field length 4
  • VBELV
    Its data type is C (Character String) with field length 10
  • POSNV
    Its data type is N (Character String with Digits Only) with field length 6
  • VGBEL : Document number of the reference document
    Its data type is C (Character String) with field length 10
  • VGPOS : Item number of the reference item
    Its data type is N (Character String with Digits Only) with field length 6
  • VGTYP
    Its data type is C (Character String) with field length 1
  • AUBEL : Sales Document
    Its data type is C (Character String) with field length 10
  • AUPOS : Sales Document Item
    Its data type is N (Character String with Digits Only) with field length 6
  • POSNR : Item number of the SD document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 6
  • AUREF
    Its data type is C (Character String) with field length 1
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • ARKTX
    Its data type is C (Character String) with field length 40
  • PMATN
    Its data type is C (Character String) with field length 18
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • PSTYV
    Its data type is C (Character String) with field length 4
  • POSAR
    Its data type is C (Character String) with field length 1
  • PRODH : Product Hierarchy
    Its data type is C (Character String) with field length 18
  • VSTEL
    Its data type is C (Character String) with field length 4
  • UEPOS
    Its data type is N (Character String with Digits Only) with field length 6
  • ATPKZ
    Its data type is C (Character String) with field length 1
  • SPART : Division
    Its data type is C (Character String) with field length 2
  • POSPA
    Its data type is N (Character String with Digits Only) with field length 6
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • ALAND : Departure country (country from which the goods are sent)
    Its data type is C (Character String) with field length 3
  • WKREG : Region in which plant is located
    Its data type is C (Character String) with field length 3
  • WKCOU
    Its data type is C (Character String) with field length 3
  • WKCTY
    Its data type is C (Character String) with field length 4
  • TAXM1 : Tax classification material
    Its data type is C (Character String) with field length 1
  • TAXM2 : Tax classification material
    Its data type is C (Character String) with field length 1
  • FKIMG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • TAXM3 : Tax classification material
    Its data type is C (Character String) with field length 1
  • TAXM4 : Tax Classification 4 Material
    Its data type is C (Character String) with field length 1
  • TAXM5
    Its data type is C (Character String) with field length 1
  • TAXM6
    Its data type is C (Character String) with field length 1
  • TAXM7
    Its data type is C (Character String) with field length 1
  • TAXM8
    Its data type is C (Character String) with field length 1
  • TAXM9
    Its data type is C (Character String) with field length 1
  • KOWRR
    Its data type is C (Character String) with field length 1
  • PRSFD
    Its data type is C (Character String) with field length 1
  • SKTOF
    Its data type is C (Character String) with field length 1
  • VRKME : Sales unit
    Its data type is C (Character String) with field length 3
  • SKFBP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KONDM : Material pricing group
    Its data type is C (Character String) with field length 2
  • KTGRM
    Its data type is C (Character String) with field length 2
  • KOSTL : Cost Center
    Its data type is C (Character String) with field length 10
  • BONUS
    Its data type is C (Character String) with field length 2
  • PROVG : Key for defining time intervals in a relationship
    Its data type is C (Character String) with field length 2
  • EANNR : European Article Number (EAN) – obsolete!!!!!
    Its data type is C (Character String) with field length 13
  • VKGRP : Sales group
    Its data type is C (Character String) with field length 3
  • VKBUR : Sales office
    Its data type is C (Character String) with field length 4
  • SPARA
    Its data type is C (Character String) with field length 2
  • UMVKZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • SHKZG : Debit/Credit Indicator
    Its data type is C (Character String) with field length 1
  • ERNAM : Name of Person who Created the Object
    Its data type is C (Character String) with field length 12
  • ERDAT : Date on which the record was created
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • ERZET : Entry time
    Its data type is T (Time (Time: HHMMSS)) with field length 6
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • STAFO
    Its data type is C (Character String) with field length 6
  • WAVWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • UMVKN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • KZWI3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI4
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI5
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI6
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • STCUR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 5
  • UVPRS
    Its data type is C (Character String) with field length 1
  • UVALL
    Its data type is C (Character String) with field length 1
  • EAN11 : International Article Number (EAN/UPC)
    Its data type is C (Character String) with field length 18
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • KVGR1
    Its data type is C (Character String) with field length 3
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • KVGR2
    Its data type is C (Character String) with field length 3
  • KVGR3
    Its data type is C (Character String) with field length 3
  • KVGR4
    Its data type is C (Character String) with field length 3
  • KVGR5
    Its data type is C (Character String) with field length 3
  • MVGR1
    Its data type is C (Character String) with field length 3
  • MVGR2 : Material group 2
    Its data type is C (Character String) with field length 3
  • MVGR3
    Its data type is C (Character String) with field length 3
  • MVGR4
    Its data type is C (Character String) with field length 3
  • MVGR5
    Its data type is C (Character String) with field length 3
  • MATWA
    Its data type is C (Character String) with field length 18
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.