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
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 DB_WBHK_WBHD ABRVW TVLV ABRVW REF 1 CN
2 DB_WBHK_WBHD ABSSC T691M ABSSC REF 1 CN
3 DB_WBHK_WBHD ABSSC_D T691M ABSSC REF 1 CN
4 DB_WBHK_WBHD ANDTX_SD T005 LAND1 REF 1 CN
5 DB_WBHK_WBHD AUGRU TVAU AUGRU REF 1 CN
6 DB_WBHK_WBHD AUSNR_MM EKKO EBELN REF 1 CN
7 DB_WBHK_WBHD BSARK_SD T176 BSARK REF 1 CN
8 DB_WBHK_WBHD BSTAE_MM T163L BSTAE REF 1 CN
9 DB_WBHK_WBHD BTBSTA TB2BA BTBSTA REF 1 CN
10 DB_WBHK_WBHD CMWAE TCURC WAERS    
11 DB_WBHK_WBHD EKGRP T024 EKGRP REF 1 CN
12 DB_WBHK_WBHD EKORG T024E EKORG REF 1 CN
13 DB_WBHK_WBHD ELIFN LFA1 LIFNR KEY 1 CN
14 DB_WBHK_WBHD EVERS_MM T027A EVERS REF 1 CN
15 DB_WBHK_WBHD FAKSK_SD TVFS FAKSP REF 1 CN
16 DB_WBHK_WBHD GRUPP T691B GRUPP    
17 DB_WBHK_WBHD INCO1_MM TINC INCO1 REF 1 CN
18 DB_WBHK_WBHD INCO1_SD TINC INCO1 REF 1 CN
19 DB_WBHK_WBHD KKBER T014 KKBER    
20 DB_WBHK_WBHD KNKLI KNA1 KUNNR    
21 DB_WBHK_WBHD KOKRS TKA01 KOKRS REF 1 CN
22 DB_WBHK_WBHD KUNNR KNA1 KUNNR REF 1 CN
23 DB_WBHK_WBHD KURST TCURV KURST REF 1 CN
24 DB_WBHK_WBHD KURST_MM TCURV KURST REF 1 CN
25 DB_WBHK_WBHD KURST_SD TCURV KURST REF 1 CN
26 DB_WBHK_WBHD KVGR1_SD TVV1 KVGR1 REF 1 CN
27 DB_WBHK_WBHD KVGR2_SD TVV2 KVGR2 REF 1 CN
28 DB_WBHK_WBHD KVGR3_SD TVV3 KVGR3 REF 1 CN
29 DB_WBHK_WBHD KVGR4_SD TVV4 KVGR4 REF 1 CN
30 DB_WBHK_WBHD KVGR5_SD TVV5 KVGR5 REF 1 CN
31 DB_WBHK_WBHD LANDTX T005 LAND1    
32 DB_WBHK_WBHD LCNUM AKKP LCNUM REF 1 CN
33 DB_WBHK_WBHD LCNUM_D AKKP LCNUM REF    
34 DB_WBHK_WBHD LFSPG TMFS LFSPG 1 CN
35 DB_WBHK_WBHD LIFSK_SD TVLS LIFSP REF 1 CN
36 DB_WBHK_WBHD LLIEF_MM LFA1 LIFNR REF 1 CN
37 DB_WBHK_WBHD LOGSYS TBDLS LOGSYS KEY 1 CN
38 DB_WBHK_WBHD MANDT T000 MANDT KEY 1 CN
39 DB_WBHK_WBHD PS_PSP_PNR PRPS PSPNR REF C CN
40 DB_WBHK_WBHD SBGRP T024B SBGRP    
41 DB_WBHK_WBHD SDWRS TCURC WAERS REF 1 CN
42 DB_WBHK_WBHD SPART TVTA SPART REF 1 CN
43 DB_WBHK_WBHD STCEG_L T005 LAND1    
44 DB_WBHK_WBHD STCEG_L_SD T005 LAND1 REF 1 CN
45 DB_WBHK_WBHD TCTYP TB2BE TCTYP REF 1 CN
46 DB_WBHK_WBHD TEW_TYPE TEWTYPE TEW_TYPE REF 1 CN
47 DB_WBHK_WBHD TKWAERS TCURC WAERS REF 1 CN
48 DB_WBHK_WBHD VKBUR TVKBZ VKBUR REF C CN
49 DB_WBHK_WBHD VKGRP TVBVK VKGRP REF C CN
50 DB_WBHK_WBHD VKORG TVKO VKORG REF 1 CN
51 DB_WBHK_WBHD VSART T173 VSART REF 1 CN
52 DB_WBHK_WBHD VSBED_SD TVSB VSBED REF 1 CN
53 DB_WBHK_WBHD VTWEG TVKOV VTWEG REF 1 CN
54 DB_WBHK_WBHD WAERS_PURCH TCURC WAERS REF 1 CN
55 DB_WBHK_WBHD WE_KUNNR KNA1 KUNNR    
56 DB_WBHK_WBHD ZLSCH T042Z ZLSCH REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in