SAP ABAP Table DB_WBHK_WBHD (Generated Table for View)
Basic Data
Table Category | VIEW | General view structure |
General view structure | DB_WBHK_WBHD | 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 | TKONN | TKONN | TKONN | CHAR | 10 | 0 | Trading Contract: Trading Contract Number | ||
3 | TCTYP | TCTYP | TCTYP | CHAR | 4 | 0 | Trading Contract: Trading Contract Type | TB2BE | |
4 | KUNNR | KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
5 | BTBSTA | BTBSTA | BTBSTA | CHAR | 1 | 0 | Trading Contract: Application Status | TB2BA | |
6 | TKWAERS | TKWAERS | WAERS | CUKY | 5 | 0 | Trading Contract: Currency of Trading Contract | TCURC | |
7 | TKRATE | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
8 | ERNAM | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
9 | ERDAT | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
10 | ERZEIT | ERZEIT | UHRZT | TIMS | 6 | 0 | Time, at Which Record Was Added | ||
11 | AENAM | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
12 | AEDAT | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
13 | AEZEIT | AEZEIT | UHRZT | TIMS | 6 | 0 | Time of Change | ||
14 | VKORG | VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
15 | VTWEG | VTWEG | VTWEG | CHAR | 2 | 0 | Distribution Channel | TVKOV | |
16 | SPART | SPART | SPART | CHAR | 2 | 0 | Division | TVTA | |
17 | TKSACHB | TKSACHB | UNAME | CHAR | 12 | 0 | Trading Contract: Person Responsible | ||
18 | BSTNK | BSTNK | BSTNK | CHAR | 20 | 0 | Customer purchase order number | ||
19 | BSTDK | BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date | ||
20 | SDWRS | WAERK | WAERS | CUKY | 5 | 0 | SD document currency | TCURC | |
21 | TKRATE_SD | TKRATE_SD | KURRF | DEC | 9 | 5 | GT Exchange Rate Sales Order Currency / Local Currency | ||
22 | KURST_SD | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
23 | BUDAT | BUDAT | DATUM | DATS | 8 | 0 | Posting Date in the Document | ||
24 | PRSDT_SD | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
25 | KURST | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
26 | AUGRU | AUGRU | AUGRU | CHAR | 3 | 0 | Order reason (reason for the business transaction) | TVAU | |
27 | ABSSC | ABSSCHE_CM | ABSSCHE_CM | CHAR | 6 | 0 | Payment Guarantee Procedure | T691M | |
28 | LCNUM | LCNUM | LCNUM | CHAR | 10 | 0 | Financial doc. processing: Internal financial doc. number | AKKP | |
29 | AKPRZ | AKPRZ | PRZ32 | DEC | 5 | 2 | Depreciation percentage for financial document processing | ||
30 | LOGSYS | LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical system | TBDLS | |
31 | AUDAT | AUDAT | DATUM | DATS | 8 | 0 | Document Date (Date Received/Sent) | ||
32 | EXNUM | EXNUM | EXNUM | CHAR | 10 | 0 | Number of foreign trade data in MM and SD documents | ||
33 | FT_HEADER_COM | HKCOM | FLAG | CHAR | 1 | 0 | Trading Contract: Document is Complete | ||
34 | COMPLETE | HKCOM | FLAG | CHAR | 1 | 0 | Trading Contract: Document is Complete | ||
35 | ANGDT_SD | ANGDT_V | DATUM | DATS | 8 | 0 | Quotation/Inquiry is valid from | ||
36 | BNDDT_SD | BNDDT | DATUM | DATS | 8 | 0 | Date until which bid/quotation is binding (valid-to date) | ||
37 | SUBMI_SD | SUBMI_SD | CHAR10 | CHAR | 10 | 0 | Collective number (SD) | ||
38 | LIFSK_SD | LIFSK | LIFSP | CHAR | 2 | 0 | Delivery block (document header) | TVLS | |
39 | FAKSK_SD | FAKSK | FAKSP | CHAR | 2 | 0 | Billing block in SD document | TVFS | |
40 | NETWR_SD | NETWR_AK | WERTV8 | CURR | 15 | 2 | Net Value of the Sales Order in Document Currency | ||
41 | VKGRP | VKGRP | VKGRP | CHAR | 3 | 0 | Sales group | TVBVK | |
42 | VKBUR | VKBUR | VKBUR | CHAR | 4 | 0 | Sales office | TVKBZ | |
43 | AUTLF_SD | AUTLF | XFELD | CHAR | 1 | 0 | Complete delivery defined for each sales order? | ||
44 | VSBED_SD | VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | TVSB | |
45 | BSARK_SD | BSARK | BSARK | CHAR | 4 | 0 | Customer Order Type | T176 | |
46 | BSTZD_SD | BSTZD | BSTZD | CHAR | 4 | 0 | Customer purchase order number supplement | ||
47 | IHREZ_SD | IHREZ | TEXT12 | CHAR | 12 | 0 | Your Reference | ||
48 | BNAME_SD | BNAME_V | NAME | CHAR | 35 | 0 | Name of orderer | ||
49 | TELF1_SD | TELF1_VP | TELF1 | CHAR | 16 | 0 | Telephone Number | ||
50 | MAHZA_SD | MAHZA | PACK2 | DEC | 3 | 0 | Number of reminder notices, reminders for delivery purchase | ||
51 | MAHDT_SD | MAHDT | DATUM | DATS | 8 | 0 | Last Delivery Reminder Notice | ||
52 | TAXK1_SD | TAXK1_AK | TAXKD | CHAR | 1 | 0 | Alternative tax classification | ||
53 | TAXK2_SD | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | ||
54 | TAXK3_SD | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | ||
55 | TAXK4_SD | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | ||
56 | TAXK5_SD | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | ||
57 | TAXK6_SD | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | ||
58 | TAXK7_SD | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | ||
59 | TAXK8_SD | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | ||
60 | TAXK9_SD | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | ||
61 | XBLNR_SD | XBLNR_V1 | XBLNR1 | CHAR | 16 | 0 | Reference Document Number | ||
62 | VBTYP_SD | VBTYP_V | VBTYP | CHAR | 1 | 0 | Document category of preceding SD document | ||
63 | STCEG_L_SD | LAND1TX | LAND1 | CHAR | 3 | 0 | Tax Destination Country | T005 | |
64 | ANDTX_SD | LANDTX | LAND1 | CHAR | 3 | 0 | Tax Departure Country | T005 | |
65 | KVGR1_SD | KVGR1 | KVGR1 | CHAR | 3 | 0 | Customer group 1 | TVV1 | |
66 | KVGR2_SD | KVGR2 | KVGR2 | CHAR | 3 | 0 | Customer group 2 | TVV2 | |
67 | KVGR3_SD | KVGR3 | KVGR3 | CHAR | 3 | 0 | Customer group 3 | TVV3 | |
68 | KVGR4_SD | KVGR4 | KVGR4 | CHAR | 3 | 0 | Customer group 4 | TVV4 | |
69 | KVGR5_SD | KVGR5 | KVGR5 | CHAR | 3 | 0 | Customer group 5 | TVV5 | |
70 | AUART | AUART | AUART | CHAR | 4 | 0 | Sales Document Type | ||
71 | QUAN_COMPLETE | HKCOM_QUAN | FLAG | CHAR | 1 | 0 | Trading Contract: Quantities In Document Are Complete | ||
72 | KOKRS | KOKRS | CACCD | CHAR | 4 | 0 | Controlling Area | TKA01 | |
73 | KKBER | KKBER | KKBER | CHAR | 4 | 0 | Credit control area | T014 | |
74 | KNKLI | KNKLI | KUNNR | CHAR | 10 | 0 | Customer's account number with credit limit reference | KNA1 | |
75 | GRUPP | GRUPP_CM | GRUPP_CM | CHAR | 4 | 0 | Customer credit group | T691B | |
76 | SBGRP | SBGRP_CM | SBGRP_CM | CHAR | 3 | 0 | Credit Representative Group for Credit Management | T024B | |
77 | CTLPC | CTLPC_CM | CTLPC_CM | CHAR | 3 | 0 | Credit management: Risk category | ||
78 | CMWAE | WAERS_CM | WAERS | CUKY | 5 | 0 | Currency key of credit control area | TCURC | |
79 | CMFRE | CMFRE | DATUM | DATS | 8 | 0 | Release date of the document determined by credit management | ||
80 | CMNUP | CMNUP | DATUM | DATS | 8 | 0 | Date of next credit check of document | ||
81 | CMNGV | CMNGV | DATUM | DATS | 8 | 0 | Next date | ||
82 | AMTBL | AMTBL_CM | WERTV8 | CURR | 15 | 2 | Released credit value of the document | ||
83 | LFSPG | WLFSPG | WLFSPG | CHAR | 2 | 0 | Vendor billing document block: Document header | TMFS | |
84 | WKURS_DAT | WWERT_D | DATUM | DATS | 8 | 0 | Translation date | ||
85 | WBPCH | TC_LAST_CHANGED_FLAG | TC_LAST_CHANGED_FLAG | CHAR | 1 | 0 | Trading Contract Last Chngd Flag (Customer, Trader, Vendor) | ||
86 | KURRF | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
87 | TC_RELEASED | TC_RELEASED | TC_RELEASED | CHAR | 1 | 0 | Release Status for Follow-On Document Generation | ||
88 | TKONN_EX | TKONN_EX | TKONN_EX | CHAR | 30 | 0 | Trading Contract: External Document Number | ||
89 | TCCAT | TCCAT | TCCAT | CHAR | 1 | 0 | Trading Contract: Contract Category | ||
90 | WE_KUNNR | KUNNR | KUNNR | CHAR | 10 | 0 | Customer Number | KNA1 | |
91 | STCEG_L | LAND1TX | LAND1 | CHAR | 3 | 0 | Tax Destination Country | T005 | |
92 | LANDTX | LANDTX | LAND1 | CHAR | 3 | 0 | Tax Departure Country | T005 | |
93 | XEGDR | XEGDR | XFELD | CHAR | 1 | 0 | Indicator: Triangular deal within the EU ? | ||
94 | USE_CASE | WB2_USE_CASE_TYPE | WB2_USE_CASE_TYPE | CHAR | 2 | 0 | Use Case Type | ||
95 | TEW_TYPE | WB2_TEW_TYPE | WB2_TEW_TYPE | CHAR | 4 | 0 | Trading Execution Workbench Type | TEWTYPE | |
96 | SUCC_ARCH | WB2_SUCC_ARCHIVED | WB2_SUCC_ARCHIVED | CHAR | 1 | 0 | Network Archived | ||
97 | ABRVW | ABRVW | ABRVW | CHAR | 3 | 0 | Usage Indicator | TVLV | |
98 | KNUMV_SD | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
99 | PRICING_TYPE | WB2_PRICING_TYPE | WB2_PRICING_TYPE | CHAR | 1 | 0 | Definition of Pricing Procedure in Trading Contract | ||
100 | KALSM_SD | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | ||
101 | PS_PSP_PNR | PS_PSP_PNR | PS_POSNR | NUMC | 8 | 0 | Work Breakdown Structure Element (WBS Element) | PRPS | |
102 | TPOSN | TPOSN | TPOSN | NUMC | 6 | 0 | Trading Contract: Item Number | ||
103 | TPOSN_SUB | TPOSN_SUB | TPOSN | NUMC | 6 | 0 | Trading Contract: Sub-Item Number | ||
104 | ELIFN | ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
105 | EKORG | EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
106 | EKGRP | EKGRP | EKGRP | CHAR | 3 | 0 | Purchasing group | T024 | |
107 | IHREZ | IHREZ | TEXT12 | CHAR | 12 | 0 | Your Reference | ||
108 | EBDAT | EBDAT | DATUM | DATS | 8 | 0 | Purchasing Document Date | ||
109 | EINDT | WB2_DELDATE_MM | DATUM | DATS | 8 | 0 | Trading Contract: Delivery Date for Item Purchasing | ||
110 | LPEIN_INT | LPEIN_INT | PRGRS | CHAR | 1 | 0 | Date type (day, week, month, interval) | ||
111 | WAERS_PURCH | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
112 | TKRATE_MM | TKRATE_MM | KURRF | DEC | 9 | 5 | GT Exchange Rate Order Currency / Local Currency | ||
113 | KURST_MM | KURST | KURST | CHAR | 4 | 0 | Exchange Rate Type | TCURV | |
114 | ZTERM | WB2_DZTERM_MM | ZTERM | CHAR | 4 | 0 | Terms of Payment Key Purchasing | ||
115 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
116 | TERMDES_MM | TERMDES | BEZEI80 | CHAR | 80 | 0 | Trading Contract: Description of Terms of Payment | ||
117 | PRSDT_MM | WB2_PRSDT_MM | DATUM | DATS | 8 | 0 | Date for Pricing and Exchange Rate | ||
118 | ERZET | ERZET | UZEIT | TIMS | 6 | 0 | Entry time | ||
119 | WERK_MM | WERKS_D | WERKS | CHAR | 4 | 0 | Plant | ||
120 | INCO1_MM | WB2_INCO1_MM | INCO1 | CHAR | 3 | 0 | Incoterms Part 1 Purchasing | TINC | |
121 | INCO2_MM | WB2_INCO2_MM | INCO2 | CHAR | 28 | 0 | Incoterms Part 2 Purchasing | ||
122 | IHRAN | IHRAN | DATUM | DATS | 8 | 0 | Quotation Submission Date | ||
123 | EDATU_VBAK | WB2_DELDATE_SD | DATUM | DATS | 8 | 0 | Trading Contract: Delivery Date for Item Sales | ||
124 | PRGRS_VBAK | PRGRS_VBAK | PRGRS | CHAR | 1 | 0 | Proposed Period for Date | ||
125 | INCO1_SD | WB2_INCO1_SD | INCO1 | CHAR | 3 | 0 | Incoterms Part 1 Sales | TINC | |
126 | INCO2_SD | WB2_INCO2_SD | INCO2 | CHAR | 28 | 0 | Incoterms Part 2 Sales | ||
127 | ZTERM_SALES | WB2_DZTERM_SD | ZTERM | CHAR | 4 | 0 | Terms Of Payment Key Sales | ||
128 | TERMDES_SD | TERMDES | BEZEI80 | CHAR | 80 | 0 | Trading Contract: Description of Terms of Payment | ||
129 | VALDTD | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
130 | ZLSCH | SCHZW_BSEG | ZLSCH | CHAR | 1 | 0 | Payment Method | T042Z | |
131 | KDATB_MM | KDATB | DATUM | DATS | 8 | 0 | Start of Validity Period | ||
132 | KDATE_MM | KDATE | DATUM | DATS | 8 | 0 | End of Validity Period | ||
133 | AUSNR_MM | AUSCH | EBELN | CHAR | 10 | 0 | Bid invitation number | EKKO | |
134 | ANGNR_MM | ANGNR | ANGNR | CHAR | 10 | 0 | Quotation Number | ||
135 | VERKF_MM | EVERK | TEXT30 | CHAR | 30 | 0 | Responsible Salesperson at Vendor's Office | ||
136 | TELF1_MM | TELF0 | TEXT16 | CHAR | 16 | 0 | Vendor's Telephone Number | ||
137 | LLIEF_MM | LLIEF | LIFNR | CHAR | 10 | 0 | Supplying Vendor | LFA1 | |
138 | UNSEZ_MM | UNSEZ | TEXT12 | CHAR | 12 | 0 | Our Reference | ||
139 | EVERS_MM | EVERS | EVERS | CHAR | 2 | 0 | Shipping Instructions | T027A | |
140 | BSTAE_MM | BSTAE | BSTAE | CHAR | 4 | 0 | Confirmation Control Key | T163L | |
141 | KZABS_MM | KZABS | XFELD | CHAR | 1 | 0 | Order Acknowledgment Requirement | ||
142 | LABNR | LABNR | TEXT20 | CHAR | 20 | 0 | Order Acknowledgment Number | ||
143 | KZAZU | KZAZU_D | XFELD | CHAR | 1 | 0 | Order combination indicator | ||
144 | HKLA | HKLA | HKLA | CHAR | 1 | 0 | Trading Contract: Delivery Address Origin | ||
145 | POSPLIT | POSPLIT | POSPLIT | CHAR | 10 | 0 | Trading Contract: Manual Purchase Order Split | ||
146 | KUFIX | KUFIX | XFELD | CHAR | 1 | 0 | Indicator: Fixing of Exchange Rate | ||
147 | BSTYP | BSTYP_TC | BSTYP_TC | CHAR | 1 | 0 | Purchasing Document Category | ||
148 | BSART | BSART | BSART | CHAR | 4 | 0 | Order Type (Purchasing) | ||
149 | VSART | VSARTTR | VERSART | CHAR | 2 | 0 | Shipping type | T173 | |
150 | BSTKD_E | BSTKD_E | BSTKD | CHAR | 35 | 0 | Ship-to Party's Purchase Order Number | ||
151 | POSEX_E | POSEX_E | POSEX | CHAR | 6 | 0 | Item Number of the Underlying Purchase Order | ||
152 | BSTKD | BSTKD | BSTKD | CHAR | 35 | 0 | Customer purchase order number | ||
153 | BSTDK_E | BSTDK_E | DATUM | DATS | 8 | 0 | Ship-to party's PO date | ||
154 | KALSM_MM | KALSM_D | KALSM | CHAR | 6 | 0 | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | ||
155 | KNUMV_MM | KNUMV | KNUMV | CHAR | 10 | 0 | Number of the document condition | ||
156 | KURSK_SD | KURSK | KURRF | DEC | 9 | 5 | Exchange Rate for Pricing and Statistics | ||
157 | ABSSC_D | ABSSCHE_CM | ABSSCHE_CM | CHAR | 6 | 0 | Payment Guarantee Procedure | T691M | |
158 | AKPRZ_D | AKPRZ | PRZ32 | DEC | 5 | 2 | Depreciation percentage for financial document processing | ||
159 | ERDAT_D | ERDAT | DATUM | DATS | 8 | 0 | Date on which the record was created | ||
160 | ERNAM_D | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
161 | LCNUM_D | LCNUM | LCNUM | CHAR | 10 | 0 | Financial doc. processing: Internal financial doc. number | AKKP | |
162 | PRSDT_SD_D | PRSDT | DATUM | DATS | 8 | 0 | Date for pricing and exchange rate | ||
163 | BSTDK_D | BSTDK | DATUM | DATS | 8 | 0 | Customer purchase order date |
Foreign Keys
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |