SAP ABAP Table DB_WBRK_WBRP (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | DB_WBRK_WBRP | Table Relationship Diagram |
Short Description | Generated Table for View |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | WBELN | WBELN_AG | WBELN | CHAR | 10 | 0 | Agency Business: Document Number | ||
3 | POSNR | WPOSNR_LF | WPOSNR | NUMC | 6 | 0 | Agency business: Document item | ||
4 | LFART | WFART | WFART | CHAR | 4 | 0 | Agency business: Billing document type | TMFK | |
5 | LFTYP | WFTYP | WFTYP | CHAR | 2 | 0 | Agency business: Billing category | ||
6 | WRART | WRART | WRART | CHAR | 4 | 0 | Agency business: Payment type | TMZR | |
7 | WBTYP | WBTYP | WBTYP | CHAR | 1 | 0 | Settlement request: Payment type | ||
8 | WRTYP | WRTYP | WRTYP | CHAR | 1 | 0 | Entry category: payment | ||
9 | ABART | NAFKT | NAFKT | CHAR | 1 | 0 | Settlement Type | ||
10 | KALSM | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | T683 | |
11 | KALSMD | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | T683 | |
12 | WFDAT | WFDAT | DATUM | DATS | 8 | 0 | Agency business: Posting date | ||
13 | RFBSK | WFBSK | WFBSK | CHAR | 1 | 0 | Status for transfer to accounting | ||
14 | LIFRE | LIFRE | LIFNR | CHAR | 10 | 0 | Different Invoicing Party | LFA1 | |
15 | LNRZB | W_LIFZE | LIFNR | CHAR | 10 | 0 | Agency business: Payee | LFA1 | |
16 | KUNRE | KUNRE | KUNNR | CHAR | 10 | 0 | Bill-to party | KNA1 | |
17 | KUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | KNA1 | |
18 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
19 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
20 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVTW | |
21 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TSPA | |
22 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
23 | ERZET_K | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
24 | ERDAT_K | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
25 | ERNAM_K | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
26 | AEDAT_K | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
27 | BLDAT | BLDAT | DATUM | DATS | 8 | 0 | Document Date in Document | ||
28 | XBLNR | XBLNR1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
29 | ZUONR | DZUONR | ZUONR | CHAR | 18 | 0 | Assignment number | ||
30 | WAERL | WAERL | WAERS | CUKY | 5 | 0 | Currency of Agency Document | TCURC | |
31 | WSTWAE | WSTWAE | WAERS | CUKY | 5 | 0 | Agency Business: Statistics Currency | TCURC | |
32 | WKURS | WKURS | KURSP | DEC | 9 | 5 | Exchange Rate | ||
33 | STCUR | STCUR | KURRF | DEC | 9 | 5 | Exchange rate for statistics | ||
34 | KUFIX | WKUFIX | XFELD | CHAR | 1 | 0 | Indicator: Fixing of exchange rate | ||
35 | WKURS_DAT | WWERT_D | DATUM | DATS | 8 | 0 | Translation date | ||
36 | BRTWR_K | BRTWR_LF | WERTV8 | CURR | 15 | 2 | Agenncy Business: Gross value in document currency | ||
37 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
38 | ZBD1T | DZBDET | ZBDXT | DEC | 3 | 0 | Cash (Prompt Payment) Discount Days | ||
39 | ZBD1P | DZBD1P | PRZ23 | DEC | 5 | 3 | Cash discount percentage 1 | ||
40 | ZBD2T | DZBD2T | ZBDXT | DEC | 3 | 0 | Cash discount days 2 | ||
41 | ZBD2P | DZBD2P | PRZ23 | DEC | 5 | 3 | Cash Discount Percentage 2 | ||
42 | ZBD3T | DZBD3T | ZBDXT | DEC | 3 | 0 | Net Payment Terms Period | ||
43 | ZLSCH | DZLSCH | ZLSCH | CHAR | 1 | 0 | Payment method | T042Z | |
44 | NETWR_K | NETWR_LF | WERTV8 | CURR | 15 | 2 | Agency Business: Net value in document currency | ||
45 | NETWRD_K | NETWRD_LF | WERTV8 | CURR | 15 | 2 | Agency value: Net Value in Document Currency (Customer-Side) | ||
46 | BRTWRD_K | BRTWRD_LF | WERTV8 | CURR | 15 | 2 | Agency Business: Gross Value of Doc.Currency (Customr-Side) | ||
47 | ZTERMD | WZTERMD | ZTERM | CHAR | 4 | 0 | Terms of Payment Key for Customer | ||
48 | ZBD1TD | WZBD1TD | ZBDXT | DEC | 3 | 0 | Cash Discount Period for Customer | ||
49 | ZBD1PD | WZBD1PD | PRZ23 | DEC | 5 | 3 | Cash discount percentage 1 customer | ||
50 | ZBD2TD | WZBD2TD | ZBDXT | DEC | 3 | 0 | Cash discount period 2 customer | ||
51 | ZBD2PD | WZBD2PD | PRZ23 | DEC | 5 | 3 | Cash Discount Percentage 2 Customer | ||
52 | ZBD3TD | WZBD3TD | ZBDXT | DEC | 3 | 0 | Deadline for Customer Net Condition | ||
53 | ZLSCHD | SCHZW_BSEGD | ZLSCH | CHAR | 1 | 0 | Customer payment method | T042Z | |
54 | GSKTOD | SKFBP | WERTV7 | CURR | 13 | 2 | Amount eligible for cash discount in document currency | ||
55 | GSKTO | SKFBP | WERTV7 | CURR | 13 | 2 | Amount eligible for cash discount in document currency | ||
56 | FKSTO | FKSTO | XFELD | CHAR | 1 | 0 | Billing document is cancelled | ||
57 | KAPPL | KAPPL | KAPPL | CHAR | 2 | 0 | Application | T681A | |
58 | KNUMV | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
59 | KNUMVD | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
60 | STAFO_K | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | TMCB | |
61 | LFAKS | LFAKS | WBELN | CHAR | 10 | 0 | Agency business: cancelled (reversed) document | WBRK | |
62 | KNUMA | KNUMA | KNUMA | CHAR | 10 | 0 | Agreement (various conditions grouped together) | KONA | |
63 | LFART_RL | WFART_RL | WFART | CHAR | 4 | 0 | Remuneration List Type, Vendor Billing Document | ||
64 | WFDAT_RL | WFDAT_RL | DATUM | DATS | 8 | 0 | Agency Business: Posting Date for the Remuneration List | ||
65 | WBELN_RL | WBELN_RL | WBELN | CHAR | 10 | 0 | Agency Business: Document Number of Remuneration List | WBRK | |
66 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
67 | VALTG | WVALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
68 | VALDT | WVALDT | DATUM | DATS | 8 | 0 | Fixed Value Date | ||
69 | MWSBK | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
70 | MWSBKD | MWSBPD | WERTV7 | CURR | 13 | 2 | Tax amount in document currency (customer-side) | ||
71 | NAVNK | NAVNW | WERT7 | CURR | 13 | 2 | Non-deductible input tax | ||
72 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
73 | DIEKZ | DIEKZ | DIEKZ | CHAR | 1 | 0 | Service indicator (foreign payment) | ||
74 | LANDL | LANDL | LAND1 | CHAR | 3 | 0 | Supplying Country | T005 | |
75 | LZBKZ | LZBKZ | LZBKZ | CHAR | 3 | 0 | State central bank indicator | T015L | |
76 | KKBER | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | T014 | |
77 | LFGRU_K | WFGRU | WFGRU | CHAR | 3 | 0 | Agency business: Reason for activity | TMLFG | |
78 | VALTGD | WVALTD | TAGE2 | NUMC | 2 | 0 | Additional Value Days (Customer) | ||
79 | VALDTD | WVALDD | DATUM | DATS | 8 | 0 | Fixed Value Date (Customer) | ||
80 | KIDNO | KIDNO | CHAR30 | CHAR | 30 | 0 | Payment Reference | ||
81 | WDTYP | DOCTYPE | DOCTYPE | CHAR | 1 | 0 | Agency Business: Document Category | ||
82 | WKURS_P1 | WKURS_P1 | KURSP | DEC | 9 | 5 | Agency business: Exchange rate of vendor payment currency | ||
83 | WKURS_P2 | WKURS_P2 | KURSP | DEC | 9 | 5 | Agency business: Exchange rate of customer payment currency | ||
84 | WPYCUR_P1 | WPYCUR_P1 | WAERS | CUKY | 5 | 0 | Currency for automatic payment (vendor-side) | TCURC | |
85 | WPYCUR_P2 | WPYCUR_P2 | WAERS | CUKY | 5 | 0 | Currency for automatic payment (customer-side) | TCURC | |
86 | ESTATUS | WSTATE | WSTATE | CHAR | 4 | 0 | Agency business: Application status | TMPA2 | |
87 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
88 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVBUR | |
89 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVKGR | |
90 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
91 | MATKL | MATKL | MATKL | CHAR | 9 | 0 | Material Group | T023 | |
92 | WERKS | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
93 | MWSKZ | MWSKZ_LF | MWSKZ | CHAR | 2 | 0 | Agency business: Tax code (input tax) | T007A | |
94 | MWSK2 | MWSKZ_RB | MWSKZ | CHAR | 2 | 0 | Agency business: Tax code (output tax) | T007A | |
95 | PRSDT | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
96 | MENGE | WFIMG | MENGE13 | QUAN | 13 | 3 | Vendor billing document: actual quantity billed | ||
97 | NETPR | WNETPR | WERTV6 | CURR | 11 | 2 | Vendor billing document: net price in document currency | ||
98 | PEINH | WEINH | DEC5 | DEC | 5 | 0 | Price Unit of Vendor Billing Document Item | ||
99 | WFKME | WFKME | MEINS | UNIT | 3 | 0 | Vendor billing document: unit of measure | T006 | |
100 | UMREZ | UMWFZ | UMBSZ | DEC | 5 | 0 | Numerator converting qty in vendor bill.doc. to base unit | ||
101 | UMREN | UMWFN | UMBSN | DEC | 5 | 0 | Factor for converting qty in vendor bill. doc. to base unit | ||
102 | FPRME | WFPRME | MEINS | UNIT | 3 | 0 | Billing price unit | T006 | |
103 | FPUMZ | WPUMZ | UMBSZ | DEC | 5 | 0 | Vendor billing doc.: numerator for converting BPUn to PBUn | ||
104 | FPUMN | WPUMN | UMBSZ | DEC | 5 | 0 | Vendor billing doc.: denominator for converting BPUn to PBUn | ||
105 | MEINS | MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
106 | NTGEW | WLF_NTGEW_15 | MENG15 | QUAN | 15 | 3 | Net Weight | ||
107 | BRGEW | WLF_BRGEW_15 | MENG15 | QUAN | 15 | 3 | Gross Weight | ||
108 | GEWEI | GEWEI | MEINS | UNIT | 3 | 0 | Weight Unit | T006 | |
109 | VOLUM | WLF_VOLUM_15 | MENG15 | QUAN | 15 | 3 | Volume | ||
110 | VOLEH | VOLEH | MEINS | UNIT | 3 | 0 | Volume unit | T006 | |
111 | STAFO | STAFO | STAFO | CHAR | 6 | 0 | Update group for statistics update | TMCB | |
112 | MTART | MTART | MTART | CHAR | 4 | 0 | Material type | T134 | |
113 | NETWR | NETWR_LFP | WERTV8 | CURR | 15 | 2 | Net value of the item in document currency | ||
114 | BRTWR | BRTWR_LFP | WERTV8 | CURR | 15 | 2 | Gross value of the item in document currency | ||
115 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
116 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
117 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
118 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
119 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
120 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
121 | BONBA | BONBA | WERTV7 | CURR | 13 | 2 | Rebate basis 1 | ||
122 | EFFWR | WLF_EFFWR | WERTV7 | CURR | 13 | 2 | Effective Value of Item | ||
123 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
124 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
125 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
126 | KOWRR | WKOWRR | WKOWRR | CHAR | 1 | 0 | Statistical Values | ||
127 | SKTOF | SKTOF | XFELD | CHAR | 1 | 0 | Cash discount indicator | ||
128 | SKFBP | SKFBP | WERTV7 | CURR | 13 | 2 | Amount eligible for cash discount in document currency | ||
129 | NETWRD | NETWRD_LFP | WERTV8 | CURR | 15 | 2 | Net value of the item in document currency (customer-side) | ||
130 | BRTWRD | BRTWRD_LFP | WERTV8 | CURR | 15 | 2 | Gross value of item in document currency (customer-side) | ||
131 | KZWI1D | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
132 | KZWI2D | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
133 | KZWI3D | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
134 | KZWI4D | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
135 | KZWI5D | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
136 | KZWI6D | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
137 | BONBAD | BONBA | WERTV7 | CURR | 13 | 2 | Rebate basis 1 | ||
138 | SKFBPD | SKFBPD | WERTV7 | CURR | 13 | 2 | Amount qualifying for cash discount in doc. currency (cust.) | ||
139 | EFFWRD | EFFWRD | WERTV7 | CURR | 13 | 2 | Effective value of the item (customer-side) | ||
140 | MWSBPD | MWSBPD | WERTV7 | CURR | 13 | 2 | Tax amount in document currency (customer-side) | ||
141 | WBELNV | WBELNV | CHAR10 | CHAR | 10 | 0 | Agency business: Document number of the reference document | ||
142 | POSNRV | WPOSNRV | NUMC6 | NUMC | 6 | 0 | Item number of the reference document item | ||
143 | LFTYPV | WFTYPV | WFTYPV | CHAR | 2 | 0 | Agency Business: Document Category of Preceding Document | ||
144 | AKTNR | WAKTION | WAKTION | CHAR | 10 | 0 | Promotion | WAKH | |
145 | LFGRU | WFGRU | WFGRU | CHAR | 3 | 0 | Agency business: Reason for activity | TMLFG | |
146 | ARKTX | TXZ01 | TEXT40 | CHAR | 40 | 0 | Short Text | ||
147 | INFNR | INFNR | INFNR | CHAR | 10 | 0 | Number of purchasing info record | EINA | |
148 | IDNLF | IDNLF | IDNEX | CHAR | 35 | 0 | Material Number Used by Vendor | ||
149 | MWSBP | MWSBP | WERTV7 | CURR | 13 | 2 | Tax amount in document currency | ||
150 | TXJCD | TXJCD | TXJCD | CHAR | 15 | 0 | Tax Jurisdiction | TTXJ | |
151 | EBONF | EBONY | XFELD | CHAR | 1 | 0 | Item Relevant to Subsequent (Period-End Rebate) Settlement | ||
152 | BONUS | EBONU | EBONU | CHAR | 2 | 0 | Settlement Group 1 (Purchasing) | ||
153 | EBON2 | EBON2 | EBONU | CHAR | 2 | 0 | Settlement Group 2 (Rebate Settlement, Purchasing) | ||
154 | EBON3 | EBON3 | EBONU | CHAR | 2 | 0 | Settlement Group 3 (Rebate Settlement, Purchasing) | ||
155 | LTSNR | LTSNR | LTSNR | CHAR | 6 | 0 | Vendor Subrange | WYT1 | |
156 | EKKOL | EKKOG | CHAR4 | CHAR | 4 | 0 | Condition Group with Vendor | ||
157 | PUNEI | PUNEI | MEINS | UNIT | 3 | 0 | Points unit | T006 | |
158 | ANZPU | ANZPU | MENG13 | QUAN | 13 | 3 | Number of Points | ||
159 | KOLIF | KOLIF | LIFNR | CHAR | 10 | 0 | Prior Vendor | LFA1 | |
160 | NAVNW | NAVNW | WERT7 | CURR | 13 | 2 | Non-deductible input tax | ||
161 | BWTAR | BWTAR_D | BWTAR | CHAR | 10 | 0 | Valuation type | T149D | |
162 | BWTTY | BWTTY_D | BWTTY | CHAR | 1 | 0 | Valuation Category | T149C | |
163 | GSBER | GSBER | GSBER | CHAR | 4 | 0 | Business Area | TGSB | |
164 | PAOBJNR | RKEOBJNR | RKEOBJNR | NUMC | 10 | 0 | Profitability Segment Number (CO-PA) | ||
165 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | ||
166 | PRCTR | PRCTR | PRCTR | CHAR | 10 | 0 | Profit Center | ||
167 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
168 | CHARG | CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCH1 | |
169 | WUVPRS | WUVPRS | XFELD | CHAR | 1 | 0 | Agency business: Item incomplete re. price determination | ||
170 | WBELN_V | WBELN_V | CHAR10 | CHAR | 10 | 0 | Triggering document of the agency document | ||
171 | POSNR_V | POSNR_V | NUMC6 | NUMC | 6 | 0 | Triggering item in the agency document | ||
172 | FTYPV_V | WFTYP_V | WFTYP_V | CHAR | 2 | 0 | Agency Business: Document Category of Triggering Document | ||
173 | SETTLE_DOC | WLF_EXP_SETTLE_DOC | WBELN | CHAR | 10 | 0 | Global Trade Expenses: Settlement Document | ||
174 | ITEMCAT | WSHKZG | WSHKZG | CHAR | 1 | 0 | Agency Business: Item Category | ||
175 | MATBF | MATBF | MATNR | CHAR | 18 | 0 | Material in Respect of Which Stock is Managed | ||
176 | EXP_CLASS | WB2_EXPENSE_CLASS | WB2_EXPENSE_CLASS | CHAR | 3 | 0 | GT Expenses: Expense Class | TWBEXCLASS | |
177 | EXP_CALC_TYPE | WB2_EXPENSE_CALC_TYPE | WB2_EXPENSE_CALC_TYPE | CHAR | 1 | 0 | GT Expenses: Calculation Type | ||
178 | DOC_SETTLED | WB2_EXP_DOCUMENT_SETTLED | WB2_EXP_DOCUMENT_SETTLED | CHAR | 1 | 0 | GT Expenses: Document Settled | ||
179 | REF_VALUE_REF | WB2_EXPENSE_REF_VALUE_REF | WAERS | CUKY | 5 | 0 | Ref. Field for GT Expenses Ref. Value (Currency, %, Unit) | TCURC | |
180 | REF_VALUE | WB2_EXPENSE_REFERENCE_VALUE | WERTV6 | CURR | 11 | 2 | Global Trade Reference Value for Expenses | ||
181 | POST_TYPE | WB2_EXPENSE_POSTING_TYPE | WB2_EXPENSE_POSTING_TYPE | CHAR | 1 | 0 | GT Expenses: Posting Type of Expenses | TWBPOSTTYPE | |
182 | TEW_TYPE | WB2_TEW_TYPE | WB2_TEW_TYPE | CHAR | 4 | 0 | Trading Execution Workbench Type | ||
183 | STEP | WB2_STEP | WB2_STEP | CHAR | 4 | 0 | Business Process Step | TEWSTEP | |
184 | PARTNER_EXP | PRQ_PARNO | PRQ_PARNO | CHAR | 10 | 0 | Business Partner | ||
185 | GJAHRV | GJAHR | GJAHR | NUMC | 4 | 0 | Fiscal Year | ||
186 | REFSITE | WREFSITE | WERKS_W | CHAR | 4 | 0 | Reference Site For Purchasing |
Foreign Keys
History
Last changed by/on | SAP | 20130603 |
SAP Release Created in |