DB_WBRK_WBRP SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
DB_WBRK_WBRP is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The DB_WBRK_WBRP table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include WBELN (Agency Business: Document Number), POSNR (Agency business: Document item), LFART (Agency business: Billing document type), LFTYP (Agency business: Billing category).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP DB_WBRK_WBRP table view 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 | ALPHA | WBELN | |||
| POSNR | Agency business: Document item | WPOSNR_LF | NUMC | 6 | WPOSNR | ||||
| LFART | Agency business: Billing document type | WFART | CHAR | 4 | TMFK | WFART | WFA | ||
| LFTYP | Agency business: Billing category | WFTYP | CHAR | 2 | WFTYP | ||||
| WRART | Agency business: Payment type | WRART | CHAR | 4 | TMZR | WRART | WRA | ||
| WBTYP | Settlement request: Payment type | WBTYP | CHAR | 1 | WBTYP | ||||
| WRTYP | Entry category: payment | WRTYP | CHAR | 1 | WRTYP | ||||
| ABART | Settlement Type | NAFKT | CHAR | 1 | NAFKT | ||||
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | T683 | KALSM | |||
| KALSMD | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | T683 | KALSM | |||
| WFDAT | Agency business: Posting date | WFDAT | DATS | 8 | DATUM | ||||
| RFBSK | Status for transfer to accounting | WFBSK | CHAR | 1 | WFBSK | ||||
| LIFRE | Different Invoicing Party | LIFRE | CHAR | 10 | LFA1 | ALPHA | LIFNR | LRE | |
| LNRZB | Agency business: Payee | W_LIFZE | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
| KUNRE | Bill-to party | KUNRE | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
| KUNRG | Payer | KUNRG | CHAR | 10 | KNA1 | ALPHA | KUNNR | ||
| EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
| VKORG | Sales Organization | VKORG | CHAR | 4 | TVKO | VKORG | VKO | C_VKORG | |
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | TVTW | VTWEG | VTW | C_VTWEG | |
| SPART | Division | SPART | CHAR | 2 | TSPA | SPART | SPA | C_SPART | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| ERZET_K | Entry time | ERZET | TIMS | 6 | UZEIT | ||||
| ERDAT_K | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
| ERNAM_K | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| AEDAT_K | Changed On | AEDAT | DATS | 8 | DATUM | ||||
| BLDAT | Document Date in Document | BLDAT | DATS | 8 | DATUM | ||||
| XBLNR | Reference Document Number | XBLNR1 | CHAR | 16 | XBLNR1 | ||||
| ZUONR | Assignment Number | DZUONR | CHAR | 18 | ZUONR | ||||
| WAERL | Currency of Agency Document | WAERL | CUKY | 5 | TCURC | WAERS | FWS | ||
| WSTWAE | Agency Business: Statistics Currency | WSTWAE | CUKY | 5 | TCURC | WAERS | |||
| WKURS | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | |||
| STCUR | Exchange rate for statistics | STCUR | DEC | 9(5) | EXCRT | KURRF | |||
| KUFIX | Indicator: Fixing of exchange rate | WKUFIX | CHAR | 1 | XFELD | ||||
| WKURS_DAT | Translation Date | WWERT_D | DATS | 8 | DATUM | ||||
| BRTWR_K | Agenncy Business: Gross value in document currency | BRTWR_LF | CURR | 15(2) | WERTV8 | ||||
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
| ZBD1T | Cash (Prompt Payment) Discount Days | DZBDET | DEC | 3 | ZBDXT | ||||
| ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
| ZBD2T | Cash discount days 2 | DZBD2T | DEC | 3 | ZBDXT | ||||
| ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
| ZBD3T | Net Payment Terms Period | DZBD3T | DEC | 3 | ZBDXT | ||||
| ZLSCH | Payment Method | DZLSCH | CHAR | 1 | T042Z | ZLSCH | |||
| NETWR_K | Agency Business: Net value in document currency | NETWR_LF | CURR | 15(2) | WERTV8 | ||||
| NETWRD_K | Agency value: Net Value in Document Currency (Customer-Side) | NETWRD_LF | CURR | 15(2) | WERTV8 | ||||
| BRTWRD_K | Agency Business: Gross Value of Doc.Currency (Customr-Side) | BRTWRD_LF | CURR | 15(2) | WERTV8 | ||||
| ZTERMD | Terms of Payment Key for Customer | WZTERMD | CHAR | 4 | ZTERM | ||||
| ZBD1TD | Cash Discount Period for Customer | WZBD1TD | DEC | 3 | ZBDXT | ||||
| ZBD1PD | Cash discount percentage 1 customer | WZBD1PD | DEC | 5(3) | PRZ23 | ||||
| ZBD2TD | Cash discount period 2 customer | WZBD2TD | DEC | 3 | ZBDXT | ||||
| ZBD2PD | Cash Discount Percentage 2 Customer | WZBD2PD | DEC | 5(3) | PRZ23 | ||||
| ZBD3TD | Deadline for Customer Net Condition | WZBD3TD | DEC | 3 | ZBDXT | ||||
| ZLSCHD | Customer payment method | SCHZW_BSEGD | CHAR | 1 | T042Z | ZLSCH | |||
| GSKTOD | Amount eligible for cash discount in document currency | SKFBP | CURR | 13(2) | WERTV7 | ||||
| GSKTO | Amount eligible for cash discount in document currency | SKFBP | CURR | 13(2) | WERTV7 | ||||
| FKSTO | Billing document is cancelled | FKSTO | CHAR | 1 | XFELD | ||||
| KAPPL | Application | KAPPL | CHAR | 2 | T681A | KAPPL | KAP | ||
| KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
| KNUMVD | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
| STAFO_K | Update group for statistics update | STAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
| LFAKS | Agency business: cancelled (reversed) document | LFAKS | CHAR | 10 | WBRK | ALPHA | WBELN | ||
| KNUMA | Agreement (various conditions grouped together) | KNUMA | CHAR | 10 | KONA | ALPHA | KNUMA | VMBO | |
| LFART_RL | Remuneration List Type, Vendor Billing Document | WFART_RL | CHAR | 4 | WFART | ||||
| WFDAT_RL | Agency Business: Posting Date for the Remuneration List | WFDAT_RL | DATS | 8 | DATUM | ||||
| WBELN_RL | Agency Business: Document Number of Remuneration List | WBELN_RL | CHAR | 10 | WBRK | ALPHA | WBELN | WLR | |
| EKGRP | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
| VALTG | Additional value days | WVALTG | NUMC | 2 | TAGE2 | ||||
| VALDT | Fixed Value Date | WVALDT | DATS | 8 | DATUM | ||||
| MWSBK | Tax amount in document currency | MWSBP | CURR | 13(2) | WERTV7 | ||||
| MWSBKD | Tax amount in document currency (customer-side) | MWSBPD | CURR | 13(2) | WERTV7 | ||||
| NAVNK | Non-deductible input tax | NAVNW | CURR | 13(2) | WERT7 | ||||
| LOGSYS | Logical system | LOGSYS | CHAR | 10 | TBDLS | ALPHA | LOGSYS | ||
| DIEKZ | Service Indicator (Foreign Payment) | DIEKZ | CHAR | 1 | DIEKZ | ||||
| LANDL | Supplying Country | LANDL | CHAR | 3 | T005 | LAND1 | |||
| LZBKZ | State Central Bank Indicator | LZBKZ | CHAR | 3 | T015L | LZBKZ | |||
| KKBER | Credit control area | KKBER | CHAR | 4 | T014 | KKBER | KKB | ||
| LFGRU_K | Agency business: Reason for activity | WFGRU | CHAR | 3 | TMLFG | WFGRU | |||
| VALTGD | Additional Value Days (Customer) | WVALTD | NUMC | 2 | TAGE2 | ||||
| VALDTD | Fixed Value Date (Customer) | WVALDD | DATS | 8 | DATUM | ||||
| KIDNO | Payment Reference | KIDNO | CHAR | 30 | CHAR30 | ||||
| WDTYP | Agency Business: Document Category | DOCTYPE | CHAR | 1 | DOCTYPE | ||||
| WKURS_P1 | Agency business: Exchange rate of vendor payment currency | WKURS_P1 | DEC | 9(5) | KURSP | ||||
| WKURS_P2 | Agency business: Exchange rate of customer payment currency | WKURS_P2 | DEC | 9(5) | KURSP | ||||
| WPYCUR_P1 | Currency for automatic payment (vendor-side) | WPYCUR_P1 | CUKY | 5 | TCURC | WAERS | |||
| WPYCUR_P2 | Currency for automatic payment (customer-side) | WPYCUR_P2 | CUKY | 5 | TCURC | WAERS | |||
| ESTATUS | Agency business: Application status | WSTATE | CHAR | 4 | TMPA2 | WSTATE | |||
| KURST | Exchange Rate Type | KURST | CHAR | 4 | TCURV | KURST | KUT | ||
| VKBUR | Sales Office | VKBUR | CHAR | 4 | TVBUR | VKBUR | VKB | ||
| VKGRP | Sales Group | VKGRP | CHAR | 3 | TVKGR | VKGRP | VKG | ||
| 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 | ||||
| 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 | ALPHA | KOSTL | KOS | ||
| PRCTR | Profit Center | PRCTR | CHAR | 10 | 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 | ||||
| SETTLE_DOC | Global Trade Expenses: Settlement Document | WLF_EXP_SETTLE_DOC | CHAR | 10 | ALPHA | WBELN | |||
| ITEMCAT | Agency Business: Item Category | WSHKZG | CHAR | 1 | WSHKZG | ||||
| MATBF | Material in Respect of Which Stock is Managed | MATBF | CHAR | 18 | MATN1 | MATNR | |||
| EXP_CLASS | GT Expenses: Expense Class | WB2_EXPENSE_CLASS | CHAR | 3 | TWBEXCLASS | WB2_EXPENSE_CLASS | EXP_CLASS | ||
| EXP_CALC_TYPE | GT Expenses: Calculation Type | WB2_EXPENSE_CALC_TYPE | CHAR | 1 | WB2_EXPENSE_CALC_TYPE | ||||
| DOC_SETTLED | GT Expenses: Document Settled | WB2_EXP_DOCUMENT_SETTLED | CHAR | 1 | WB2_EXP_DOCUMENT_SETTLED | ||||
| REF_VALUE_REF | Ref. Field for GT Expenses Ref. Value (Currency, %, Unit) | WB2_EXPENSE_REF_VALUE_REF | CUKY | 5 | TCURC | WAERS | |||
| REF_VALUE | Global Trade Reference Value for Expenses | WB2_EXPENSE_REFERENCE_VALUE | CURR | 11(2) | WERTV6 | ||||
| POST_TYPE | GT Expenses: Posting Type of Expenses | WB2_EXPENSE_POSTING_TYPE | CHAR | 1 | TWBPOSTTYPE | WB2_EXPENSE_POSTING_TYPE | |||
| TEW_TYPE | Trading Execution Workbench Type | WB2_TEW_TYPE | CHAR | 4 | WB2_TEW_TYPE | TEW_TYPE2 | S_TEWTYPE | ||
| STEP | Business Process Step | WB2_STEP | CHAR | 4 | TEWSTEP | WB2_STEP | |||
| PARTNER_EXP | Business Partner | PRQ_PARNO | CHAR | 10 | ALPHA | PRQ_PARNO | |||
| GJAHRV | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
| REFSITE | Reference Site For Purchasing | WREFSITE | CHAR | 4 | WERKS_W |
| Key field | Non-key field |
How do I retrieve data from SAP table DB_WBRK_WBRP using ABAP code
The following ABAP code Example will allow you to do a basic selection on DB_WBRK_WBRP to SELECT all data from the tableDATA: WA_DB_WBRK_WBRP TYPE DB_WBRK_WBRP.
SELECT SINGLE *
FROM DB_WBRK_WBRP
INTO CORRESPONDING FIELDS OF WA_DB_WBRK_WBRP
WHERE...
How to access SAP table DB_WBRK_WBRP
Within an ECC or HANA version of SAP you can also view further information about DB_WBRK_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