WBRP SAP (Agency business: Item) Table details
Dictionary Type: Table
Description: Agency business: Item
Description: Agency business: Item
Table field list including key, data, relationships and ABAP select examples
WBRP is a standard SAP Table which is used to store Agency business: Item data and is available within R/3 SAP systems depending on the version and release level.
The WBRP table consists of various fields, each holding specific information or linking keys about Agency business: Item data available in SAP. These include WBELN (Agency Business: Document Number), POSNR (Agency business: Document item), MATNR (Material Number), MATKL (Material Group).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP WBRP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
WBELN | Agency Business: Document Number | WBELN_AG | CHAR | 10 | WBRK | ALPHA | WBELN | ||
POSNR | Agency business: Document item | WPOSNR_LF | NUMC | 6 | WPOSNR | ||||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
MWSKZ | Agency business: Tax code (input tax) | MWSKZ_LF | CHAR | 2 | T007A | MWSKZ | |||
MWSK2 | Agency business: Tax code (output tax) | MWSKZ_RB | CHAR | 2 | T007A | MWSKZ | |||
PRSDT | Date for pricing and exchange rate | PRSDT | DATS | 8 | DATUM | ||||
MENGE | Vendor billing document: actual quantity billed | WFIMG | QUAN | 13(3) | MENGE13 | ||||
NETPR | Vendor billing document: net price in document currency | WNETPR | CURR | 11(2) | WERTV6 | ||||
PEINH | Price Unit of Vendor Billing Document Item | WEINH | DEC | 5 | DEC5 | ||||
WFKME | Vendor billing document: unit of measure | WFKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
UMREZ | Numerator converting qty in vendor bill.doc. to base unit | UMWFZ | DEC | 5 | UMBSZ | ||||
UMREN | Factor for converting qty in vendor bill. doc. to base unit | UMWFN | DEC | 5 | UMBSN | ||||
FPRME | Billing price unit | WFPRME | UNIT | 3 | T006 | CUNIT | MEINS | ||
FPUMZ | Vendor billing doc.: numerator for converting BPUn to PBUn | WPUMZ | DEC | 5 | UMBSZ | ||||
FPUMN | Vendor billing doc.: denominator for converting BPUn to PBUn | WPUMN | DEC | 5 | UMBSZ | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | T006 | CUNIT | MEINS | ||
NTGEW | Net Weight | WLF_NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
BRGEW | Gross Weight | WLF_BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
VOLUM | Volume | WLF_VOLUM_15 | QUAN | 15(3) | MENG15 | ||||
VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
NETWR | Net value of the item in document currency | NETWR_LFP | CURR | 15(2) | WERTV8 | ||||
BRTWR | Gross value of the item in document currency | BRTWR_LFP | CURR | 15(2) | WERTV8 | ||||
KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
BONBA | Rebate basis 1 | BONBA | CURR | 13(2) | WERTV7 | ||||
EFFWR | Effective Value of Item | WLF_EFFWR | CURR | 13(2) | WERTV7 | ||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
ERZET | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
KOWRR | Statistical Values | WKOWRR | CHAR | 1 | WKOWRR | ||||
SKTOF | Cash discount indicator | SKTOF | CHAR | 1 | XFELD | ||||
SKFBP | Amount eligible for cash discount in document currency | SKFBP | CURR | 13(2) | WERTV7 | ||||
NETWRD | Net value of the item in document currency (customer-side) | NETWRD_LFP | CURR | 15(2) | WERTV8 | ||||
BRTWRD | Gross value of item in document currency (customer-side) | BRTWRD_LFP | CURR | 15(2) | WERTV8 | ||||
KZWI1D | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
KZWI2D | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
KZWI3D | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
KZWI4D | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
KZWI5D | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
KZWI6D | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
BONBAD | Rebate basis 1 | BONBA | CURR | 13(2) | WERTV7 | ||||
SKFBPD | Amount qualifying for cash discount in doc. currency (cust.) | SKFBPD | CURR | 13(2) | WERTV7 | ||||
EFFWRD | Effective value of the item (customer-side) | EFFWRD | CURR | 13(2) | WERTV7 | ||||
MWSBPD | Tax amount in document currency (customer-side) | MWSBPD | CURR | 13(2) | WERTV7 | ||||
WBELNV | Agency business: Document number of the reference document | WBELNV | CHAR | 10 | CHAR10 | ||||
POSNRV | Item number of the reference document item | WPOSNRV | NUMC | 6 | NUMC6 | ||||
LFTYPV | Agency Business: Document Category of Preceding Document | WFTYPV | CHAR | 2 | WFTYPV | ||||
GJAHRV | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
LFGRU | Agency business: Reason for activity | WFGRU | CHAR | 3 | TMLFG | WFGRU | |||
ARKTX | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
MWSBP | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
EBONF | Item Relevant to Subsequent (Period-End Rebate) Settlement | EBONY | CHAR | 1 | XFELD | ||||
BONUS | Settlement Group 1 (Purchasing) | EBONU | CHAR | 2 | EBONU | ||||
EBON2 | Settlement Group 2 (Rebate Settlement, Purchasing) | EBON2 | CHAR | 2 | EBONU | ||||
EBON3 | Settlement Group 3 (Rebate Settlement, Purchasing) | EBON3 | CHAR | 2 | EBONU | ||||
LTSNR | Vendor Subrange | LTSNR | CHAR | 6 | WYT1 | LTSNR | |||
EKKOL | Condition Group with Vendor | EKKOG | CHAR | 4 | CHAR4 | ||||
PUNEI | Points unit | PUNEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
ANZPU | Number of Points | ANZPU | QUAN | 13(3) | MENG13 | ||||
KOLIF | Prior Vendor | KOLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
NAVNW | Non-deductible input tax | NAVNW | CURR | 13(2) | WERT7 | ||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | T149C | BWTTY | |||
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
PAOBJNR | Profitability Segment Number (CO-PA) | RKEOBJNR | NUMC | 10 | RKEOBJNR | ||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
KOKRS | Controlling Area | KOKRS | CHAR | 4 | TKA01 | CACCD | CAC | ||
CHARG | Batch Number | CHARG_D | CHAR | 10 | MCH1 | CHARG | CHA | ||
WUVPRS | Agency business: Item incomplete re. price determination | WUVPRS | CHAR | 1 | XFELD | ||||
WBELN_V | Triggering document of the agency document | WBELN_V | CHAR | 10 | CHAR10 | ||||
POSNR_V | Triggering item in the agency document | POSNR_V | NUMC | 6 | NUMC6 | ||||
FTYPV_V | Agency Business: Document Category of Triggering Document | WFTYP_V | CHAR | 2 | WFTYP_V | ||||
ITEMCAT | Agency Business: Item Category | WSHKZG | CHAR | 1 | WSHKZG | ||||
MATBF | Material in Respect of Which Stock is Managed | MATBF | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
MWERT_IM | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
MWERT_PR | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
MWERT_UM | Net Value in Document Currency | NETWR | CURR | 15(2) | WERTV8 | ||||
CONTRACT | Referencing Contract Number | WCONTRACT | CHAR | 10 | ALPHA | WCONTRACT | |||
CONTRACT_TYPE | Contract Type for Contract Number | WCONTRACT_TYPE | CHAR | 1 | WCONTRACT_TYPE | ||||
CONTRACT_ITEM | Referencing Contract Item Number | WCONTRACT_ITEM | NUMC | 6 | NUMC6 | ||||
IDNLF_TYPE | AB: Article Number Type - Vendor | WLF_IDNLF_TYPE | CHAR | 4 | TMVMT | WLF_IDNLF_TYPE | |||
ITEM_STATUS | Agency Business: Item Status | WLF_ITEM_STATUS | CHAR | 1 | WLF_ITEM_STATUS | ||||
ITEM_CANCELED | Item Was Canceled | WLF_ITEM_CANCELED | CHAR | 1 | WLF_ITEM_CANCELED | ||||
GUID_REF | AB: GUID of Reference Document | WLF_GUID_REFERENCE | RAW | 16 | |||||
BEMOT | Accounting Indicator | BEMOT | CHAR | 2 | TBMOT | BEMOT | |||
AUFNR | Order Number | AUFNR | CHAR | 12 | AUFK | ALPHA | AUFNR | ANR | |
SETTL_STATUS_I_V | AB: Settlement Status - Item - Vendor | WLF_SETTLEMENT_STATUS_ITEM_V | CHAR | 1 | WLF_SETTLEMENT_STATUS_ITEM | ||||
SETTL_STATUS_I_C | AB: Settlement Status - Item - Customer | WLF_SETTLEMENT_STATUS_ITEM_C | CHAR | 1 | WLF_SETTLEMENT_STATUS_ITEM | ||||
SETTL_BLOCK_I_V | AB: Settlement Block - Item - Vendor | WLF_SETTLEMENT_BLOCK_ITEM_V | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK | |||
SETTL_BLOCK_I_C | AB: Settlement Block - Item - Customer | WLF_SETTLEMENT_BLOCK_ITEM_C | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK | |||
SETTL_ITEM_REL | AB: Item Settlement Relevance | WLF_SETTLEMENT_ITEM_RELEVANCE | CHAR | 1 | WLF_SETTLEMENT_ITEM_RELEVANCE | ||||
CUOBJ | Configuration | CUOBJ_VA | NUMC | 18 | CUOBJ | ||||
FBUDA | Date on which services rendered | FBUDA | DATS | 8 | DATUM | ||||
.INCLU--AP | 0 | ||||||||
J_1BNBM | Brazilian NCM Code | J_1BNBMCO1 | CHAR | 16 | T604F | STEUC | |||
J_1BMATUSE | Usage of the material | J_1BMATUSE | CHAR | 1 | J_1BMATUSE | ||||
J_1BMATORG | Origin of the material | J_1BMATORG | CHAR | 1 | J_1BMATORG | ||||
J_1BOWNPRO | Produced in-house | J_1BOWNPRO | CHAR | 1 | XFELD | ||||
J_1BINDUST | Material CFOP category | J_1BINDUS3 | CHAR | 2 | ALPHA | J_1BINDUS3 | |||
J_1BCFOP | CFOP Code and Extension | J_1BCFOP | CHAR | 10 | J_1BAG | CFOBR | J_1BCFOP | ||
J_1BTXSDC | SD tax code | J_1BTXSDC_ | CHAR | 2 | J_1BTXSDC | J_1BTXSDC | |||
J_1BTAXLW1 | Tax law: ICMS | J_1BTAXLW1 | CHAR | 3 | J_1BATL1 | ALPHA | J_1BTAXLW1 | ||
J_1BTAXLW2 | Tax law: IPI | J_1BTAXLW2 | CHAR | 3 | J_1BATL2 | ALPHA | J_1BTAXLW2 | ||
J_1BTAXLW3 | ISS Tax Law | J_1BTAXLW3 | CHAR | 3 | J_1BATL3 | ALPHA | J_1BTAXLW3 | ||
J_1BTAXLW4 | COFINS Tax Law | J_1BTAXLW4 | CHAR | 3 | J_1BATL4A | ALPHA | J_1BTAXLW4 | ||
J_1BTAXLW5 | PIS Tax Law | J_1BTAXLW5 | CHAR | 3 | J_1BATL5 | ALPHA | J_1BTAXLW5 | ||
.INCLU--AP | 0 | ||||||||
SAKTO | G/L Account Number | SAKNR | CHAR | 10 | SKA1 | ALPHA | SAKNR | SAK | C_SAKNR |
.INCLU--AP | 0 | ||||||||
SERVCONF_ITEM | FSL: Service Confirmation Item | FSL_SERVCONF_ITEM | NUMC | 10 | FSL_SERVCONF_ITEM | ||||
STATUS | FSL: User Status for Item | FSL_STATUS | CHAR | 4 | FSL_STAT_CUST | FSL_STATUS | |||
.INCLU--AP | 0 | ||||||||
IV_CHECK_TYPE_I | Type of Check (Item) | WLF_IV_CHECK_TYPE_ITEM | CHAR | 1 | WLF_IV_CHECK_TYPE_ITEM | ||||
.INCLU--AP | 0 | ||||||||
REFSITE | Reference Site For Purchasing | WREFSITE | CHAR | 4 | WERKS_W | ||||
.INCLU--AP | 0 | ||||||||
POSNR_MAIN | Main Item for Item | WLF_POSNR_MAIN | NUMC | 6 | Assigned to domain | WPOSNR | |||
POSNR_SUB_EXIST | Subitems Exist | WLF_POSNR_SUB_EXIST | CHAR | 1 | XFELD | ||||
DISTRIB_STATUS | AB: Status Distribution of Item | WLF_DISTRIBUTION_STATUS | CHAR | 1 | WLF_DISTRIBUTION_STATUS | ||||
NO_TEXT_I | No Texts Exist | WLF_NO_TEXT | CHAR | 1 | XFELD | ||||
CWM_MENGE | Quantity in Parallel Unit of Measure | WLF_CWM_MENGE | QUAN | 13(3) | MENG13 | ||||
CWM_MEINS | AB: Parallel Unit of Measure | WLF_CWM_MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CWM_UOM_TYPE | AB: Type of the Parallel Unit of Measure | WLF_CWM_UOM_TYPE | CHAR | 1 | WLF_CWM_UOM_TYPE | ||||
REF_NUMBER | Reference Document for Agency Document | WLF_REF_NUMBER | CHAR | 32 | WLF_REF_NUMBER | ||||
REF_ITEM_NUMBER | Reference Document Item for Agency Document | WLF_REF_ITEM_NUMBER | NUMC | 10 | WLF_REF_ITEM_NUMBER | ||||
REF_TYPE | Reference Document Category | WLF_REF_TYPE | CHAR | 2 | WFTYP_V | ||||
ITEM_INTRA_REL | Document Item is Relevant for Intrastat Declarations | WLF_ITEM_INTRASTAT_RELEVANT | CHAR | 1 | WLF_ITEM_INTRASTAT_RELEVANT | ||||
GRWRT | Statistical value for foreign trade | GRWRT | CURR | 13(2) | GRWRT | ||||
GRWRTD | Statistical Value for Foreign Trade (Customer-Side) | GRWRTD | CURR | 13(2) | GRWRT | ||||
POSTING_RULE_K_I | AB: Creditor Posting Rule - Item | WLF_POSTING_RULE_K_ITEM | CHAR | 2 | TMPR | WLF_POSTING_RULE | |||
POSTING_RULE_D_I | AB: Debtor Posting Rule - Item | WLF_POSTING_RULE_D_ITEM | CHAR | 2 | TMPR | WLF_POSTING_RULE | |||
WEIGHT_VOLUME | Level on which You Enter Weight and Volume | WLF_WEIGHT_VOLUME_LEVEL | CHAR | 1 | WLF_WEIGHT_VOLUME_LEVEL | ||||
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | NUMC | 8 | PRPS | KONPR | PS_POSNR | ||
.INCLU--AP | 0 | ||||||||
INCO1_P | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2_P | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
KOKRSD | Customer Controlling Area | WLF_KOKRS_CUSTOMER | CHAR | 4 | TKA01 | CACCD | |||
PRCTRD | Customer Profit Center | WLF_PRCTR_CUSTOMER | CHAR | 10 | CEPC | ALPHA | PRCTR | ||
KOSTLD | Customer Cost Center | WLF_KOSTL_CUSTOMER | CHAR | 10 | CSKS | ALPHA | KOSTL | ||
PAOBJNRD | Customer Profitability Segment Number (CO-PA) | WLF_PAOBJNR_CUSTOMER | NUMC | 10 | RKEOBJNR | ||||
AUFNRD | Customer Order Number | WLF_AUFNR_CUSTOMER | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
PS_PSP_PNRD | Customer Work Breakdown Structure Element (WBS Element) | WLF_PS_PSP_PNR_CUSTOMER | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
GSBERD | Customer Business Area | WLF_GSBER_CUSTOMER | CHAR | 4 | TGSB | GSBER | |||
.INCLU--AP | 0 | ||||||||
COLL_STATUS_I | AB: Status for Collection of Settlement Request Item | WLF_COLLECTION_STATUS_ITEM | CHAR | 1 | WLF_COLLECTION_STATUS_ITEM | ||||
COLL_BLOCK_I | AB: Block Item for Collection of Settlement Requests | WLF_COLLECTION_BLOCK_ITEM | CHAR | 2 | TMSB | WLF_SETTLEMENT_BLOCK | |||
COLL_REL | AB: Relevance for Collection of Settlement Requests | WLF_COLLECTION_RELEVANCE | CHAR | 1 | WLF_COLLECTION_RELEVANCE | ||||
CUSTOMER | Customer | WLF_CUSTOMER | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
.INCLU--AP | 0 | ||||||||
INVC_ITEM_ID | BusinessTransactionDocumentItemID | WLF_BTD_ITEM_ID | CHAR | 10 | CHAR10 | ||||
REFERENCE_ID | BusinessTransactionDocumentID | WLF_REF_ID | CHAR | 35 | |||||
REF_ITEM_ID | BusinessTransactionDocumentItemID | WLF_REF_ITEM_ID | CHAR | 10 | CHAR10 | ||||
SCHEME_ID | AB: Identifier for the ID Scheme | WLF_SCHEME_ID | CHAR | 60 | CHAR60 | ||||
SCHEME_A_ID | AB: ID of the Organization that Maintains the ID Scheme | WLF_SCHEME_A_ID | CHAR | 60 | CHAR60 | ||||
AGENCY_ID_CODE | AB: Agency of Standard ID for Invoice Document | WLF_AGENCY_ID_CODE | CHAR | 3 | CHAR3 | ||||
.INCLU--AP | 0 | ||||||||
REF_NUMBER_2 | Additional Reference Document for Agency Document | WLF_REF_NUMBER_2 | CHAR | 32 | WLF_REF_NUMBER | ||||
REF_ITEM_NUM_2 | Additional Reference Document Item for Agency Document | WLF_REF_ITEM_NUMBER_2 | NUMC | 10 | WLF_REF_ITEM_NUMBER | ||||
REF_TYPE_2 | Additional Reference Document Category | WLF_REF_TYPE_2 | CHAR | 2 | WFTYP_V |
Key field | Non-key field |
How do I retrieve data from SAP table WBRP using ABAP code
The following ABAP code Example will allow you to do a basic selection on WBRP to SELECT all data from the tableDATA: WA_WBRP TYPE WBRP.
SELECT SINGLE *
FROM WBRP
INTO CORRESPONDING FIELDS OF WA_WBRP
WHERE...
How to access SAP table WBRP
Within an ECC or HANA version of SAP you can also view further information about WBRP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects