WBRP SAP table for – Agency business: Item

Here we would like to draw your attention to WBRP table in SAP. As we know it is being mainly used with the SAP LO-AB (Agency Business (Global Trade) in LO) component which is coming under LO module (Logistics). WBRP is a SAP standard transparent table used for storing Agency business: Item related data in SAP. It comes under the package WZRE.

SAP WBRP table

Table WBRP technical data

TableWBRP
Data storingAgency business: Item
ModuleLO
ComponentLO-AB
SAP PackageWZRE
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP WBRP 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 WBRP table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • AUFNR : Order Number
    Its data type is C (Character String) with field length 12
  • SETTL_STATUS_I_V
    Its data type is C (Character String) with field length 1
  • SETTL_STATUS_I_C
    Its data type is C (Character String) with field length 1
  • SETTL_BLOCK_I_V
    Its data type is C (Character String) with field length 2
  • SETTL_BLOCK_I_C
    Its data type is C (Character String) with field length 2
  • SETTL_ITEM_REL
    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
  • FBUDA
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is J1B_APPEND_LOC_AB
  • NETPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • J_1BNBM
    Its data type is C (Character String) with field length 16
  • J_1BMATUSE
    Its data type is C (Character String) with field length 1
  • J_1BMATORG
    Its data type is C (Character String) with field length 1
  • J_1BOWNPRO
    Its data type is C (Character String) with field length 1
  • J_1BINDUST
    Its data type is C (Character String) with field length 2
  • J_1BCFOP
    Its data type is C (Character String) with field length 10
  • J_1BTXSDC : SD tax code
    Its data type is C (Character String) with field length 2
  • J_1BTAXLW1
    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_1BTAXLW3
    Its data type is C (Character String) with field length 3
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) 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
  • SAKTO : Cost Element
    Its data type is C (Character String) with field length 10
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is FSL_WBRP
  • SERVCONF_ITEM
    Its data type is N (Character String with Digits Only) with field length 10
  • STATUS : AC: Context Status
    Its data type is C (Character String) with field length 4
  • IV_CHECK_TYPE_I
    Its data type is C (Character String) with field length 1
  • WFKME
    Its data type is C (Character String) with field length 3
  • REFSITE
    Its data type is C (Character String) with field length 4
  • POSNR_MAIN
    Its data type is N (Character String with Digits Only) with field length 6
  • POSNR_SUB_EXIST
    Its data type is C (Character String) with field length 1
  • DISTRIB_STATUS
    Its data type is C (Character String) with field length 1
  • NO_TEXT_I
    Its data type is C (Character String) with field length 1
  • CWM_MENGE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CWM_MEINS
    Its data type is C (Character String) with field length 3
  • UMREZ : Numerator for Conversion to Base Units of Measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • CWM_UOM_TYPE
    Its data type is C (Character String) with field length 1
  • REF_NUMBER
    Its data type is C (Character String) with field length 32
  • REF_ITEM_NUMBER
    Its data type is N (Character String with Digits Only) with field length 10
  • REF_TYPE : Valid Reference Types in Structure Repository
    Its data type is C (Character String) with field length 2
  • ITEM_INTRA_REL
    Its data type is C (Character String) with field length 1
  • GRWRT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • GRWRTD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • POSTING_RULE_K_I
    Its data type is C (Character String) with field length 2
  • POSTING_RULE_D_I
    Its data type is C (Character String) with field length 2
  • WEIGHT_VOLUME
    Its data type is C (Character String) with field length 1
  • UMREN : Denominator for conversion to base units of measure
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • PS_PSP_PNR : Work Breakdown Structure Element (WBS Element)
    Its data type is N (Character String with Digits Only) with field length 8
  • INCO1_P
    Its data type is C (Character String) with field length 3
  • INCO2_P
    Its data type is C (Character String) with field length 28
  • KOKRSD
    Its data type is C (Character String) with field length 4
  • PRCTRD
    Its data type is C (Character String) with field length 10
  • KOSTLD
    Its data type is C (Character String) with field length 10
  • PAOBJNRD
    Its data type is N (Character String with Digits Only) with field length 10
  • AUFNRD
    Its data type is C (Character String) with field length 12
  • PS_PSP_PNRD
    Its data type is N (Character String with Digits Only) with field length 8
  • FPRME
    Its data type is C (Character String) with field length 3
  • GSBERD
    Its data type is C (Character String) with field length 4
  • COLL_STATUS_I
    Its data type is C (Character String) with field length 1
  • COLL_BLOCK_I
    Its data type is C (Character String) with field length 2
  • COLL_REL
    Its data type is C (Character String) with field length 1
  • CUSTOMER : DSWP: Customer Number
    Its data type is C (Character String) with field length 10
  • INVC_ITEM_ID
    Its data type is C (Character String) with field length 10
  • REFERENCE_ID
    Its data type is C (Character String) with field length 35
  • REF_ITEM_ID
    Its data type is C (Character String) with field length 10
  • FPUMZ
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • SCHEME_ID
    Its data type is C (Character String) with field length 60
  • SCHEME_A_ID
    Its data type is C (Character String) with field length 60
  • AGENCY_ID_CODE
    Its data type is C (Character String) with field length 3
  • REF_NUMBER_2
    Its data type is C (Character String) with field length 32
  • REF_ITEM_NUM_2
    Its data type is N (Character String with Digits Only) with field length 10
  • REF_TYPE_2
    Its data type is C (Character String) with field length 2
  • FPUMN
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • MEINS : Base Unit of Measure
    Its data type is C (Character String) with field length 3
  • WBELN
    Its a key field. 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
  • BRGEW : Gross Weight
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • GEWEI : Weight Unit
    Its data type is C (Character String) with field length 3
  • VOLUM : Volume
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • VOLEH : Unit for the Volume
    Its data type is C (Character String) with field length 3
  • STAFO
    Its data type is C (Character String) with field length 6
  • MTART : Material type
    Its data type is C (Character String) with field length 4
  • NETWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BRTWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KZWI1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • 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
  • KZWI2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • 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
  • BONBA
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EFFWR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • 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
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • KOWRR
    Its data type is C (Character String) with field length 1
  • SKTOF
    Its data type is C (Character String) with field length 1
  • SKFBP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • NETWRD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BRTWRD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • KZWI1D
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI2D
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI3D
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI4D
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZWI5D
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MATKL : Material Group
    Its data type is C (Character String) with field length 9
  • KZWI6D
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BONBAD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SKFBPD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EFFWRD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MWSBPD
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • WBELNV
    Its data type is C (Character String) with field length 10
  • POSNRV
    Its data type is N (Character String with Digits Only) with field length 6
  • LFTYPV
    Its data type is C (Character String) with field length 2
  • GJAHRV
    Its data type is N (Character String with Digits Only) with field length 4
  • AKTNR
    Its data type is C (Character String) with field length 10
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • LFGRU
    Its data type is C (Character String) with field length 3
  • ARKTX
    Its data type is C (Character String) with field length 40
  • INFNR : Number of purchasing info record
    Its data type is C (Character String) with field length 10
  • IDNLF
    Its data type is C (Character String) with field length 35
  • MWSBP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • EBONF
    Its data type is C (Character String) with field length 1
  • BONUS
    Its data type is C (Character String) with field length 2
  • EBON2
    Its data type is C (Character String) with field length 2
  • EBON3
    Its data type is C (Character String) with field length 2
  • MWSKZ : Tax on sales/purchases code
    Its data type is C (Character String) with field length 2
  • LTSNR : Vendor Subrange
    Its data type is C (Character String) with field length 6
  • EKKOL : Condition Group with Vendor
    Its data type is C (Character String) with field length 4
  • PUNEI
    Its data type is C (Character String) with field length 3
  • ANZPU
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KOLIF
    Its data type is C (Character String) with field length 10
  • NAVNW
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BWTAR : Valuation type
    Its data type is C (Character String) with field length 10
  • BWTTY : Valuation Category
    Its data type is C (Character String) with field length 1
  • GSBER : Business 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
  • MWSK2
    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
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • CHARG : Batch Number
    Its data type is C (Character String) with field length 10
  • WUVPRS
    Its data type is C (Character String) with field length 1
  • WBELN_V
    Its data type is C (Character String) with field length 10
  • POSNR_V
    Its data type is N (Character String with Digits Only) with field length 6
  • FTYPV_V
    Its data type is C (Character String) with field length 2
  • ITEMCAT
    Its data type is C (Character String) with field length 1
  • MATBF
    Its data type is C (Character String) with field length 18
  • PRSDT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • MWERT_IM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MWERT_PR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • MWERT_UM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • CONTRACT
    Its data type is C (Character String) with field length 10
  • CONTRACT_TYPE
    Its data type is C (Character String) with field length 1
  • CONTRACT_ITEM
    Its data type is N (Character String with Digits Only) with field length 6
  • IDNLF_TYPE
    Its data type is C (Character String) with field length 4
  • ITEM_STATUS
    Its data type is C (Character String) with field length 1
  • ITEM_CANCELED
    Its data type is C (Character String) with field length 1
  • GUID_REF
    Its data type is X (Byte string) with field length 16
  • [ FREE ] SUBSCRIBE
    RECEIVE UPDATES & SAP ARTICLES RIGHT IN YOUR INBOX.