SAP ABAP Table MCWBHD (Trading Contract: Business Data)

Hierarchy

☛ EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   ⤷ LO-GT-TC (Application Component) Trading Contract
     ⤷ WB2B_BW (Package) BW Connection: Global Trade Management

Basic Data

Table Category	INTTAB	Structure
Structure	MCWBHD	Table Relationship Diagram
Short Description	Trading Contract: Business Data

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	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
2	.INCLUDE	☐				0	0	Trading Contract: Communication Structure, Commercial Data
3	.INCLUDE	☐				0	0	Trading Contract: Commercial Data, Update Structure
4	.INCLUDE	☐				0	0	Trading Contract: Commercial Data
5	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
6	TKONN	☐	TKONN	TKONN	CHAR	10	0	Trading Contract: Trading Contract Number	WBHK
7	TPOSN	☐	TPOSN	TPOSN	NUMC	6	0	Trading Contract: Item Number
8	TPOSN_SUB	☐	TPOSN_SUB	TPOSN	NUMC	6	0	Trading Contract: Sub-Item Number
9	ELIFN	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
10	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
11	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
12	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
13	EBDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
14	EINDT	☐	WB2_DELDATE_MM	DATUM	DATS	8	0	Trading Contract: Delivery Date for Item Purchasing
15	LPEIN_INT	☐	LPEIN_INT	PRGRS	CHAR	1	0	Date type (day, week, month, interval)
16	WAERS_PURCH	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
17	TKRATE_MM	☐	TKRATE_MM	KURRF	DEC	9	5	GT Exchange Rate Order Currency / Local Currency
18	KURST_MM	☐	KURST	KURST	CHAR	4	0	Exchange Rate Type	TCURV
19	ZTERM	☐	WB2_DZTERM_MM	ZTERM	CHAR	4	0	Terms of Payment Key Purchasing
20	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
21	TERMDES_MM	☐	TERMDES	BEZEI80	CHAR	80	0	Trading Contract: Description of Terms of Payment
22	PRSDT_MM	☐	WB2_PRSDT_MM	DATUM	DATS	8	0	Date for Pricing and Exchange Rate
23	PRSDT_SD	☐	PRSDT	DATUM	DATS	8	0	Date for pricing and exchange rate
24	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
25	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
26	ERZET	☐	ERZET	UZEIT	TIMS	6	0	Entry time
27	WERK_MM	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
28	INCO1_MM	☐	WB2_INCO1_MM	INCO1	CHAR	3	0	Incoterms Part 1 Purchasing	TINC
29	INCO2_MM	☐	WB2_INCO2_MM	INCO2	CHAR	28	0	Incoterms Part 2 Purchasing
30	IHRAN	☐	IHRAN	DATUM	DATS	8	0	Quotation Submission Date
31	EDATU_VBAK	☐	WB2_DELDATE_SD	DATUM	DATS	8	0	Trading Contract: Delivery Date for Item Sales
32	PRGRS_VBAK	☐	PRGRS_VBAK	PRGRS	CHAR	1	0	Proposed Period for Date
33	INCO1_SD	☐	WB2_INCO1_SD	INCO1	CHAR	3	0	Incoterms Part 1 Sales	TINC
34	INCO2_SD	☐	WB2_INCO2_SD	INCO2	CHAR	28	0	Incoterms Part 2 Sales
35	ZTERM_SALES	☐	WB2_DZTERM_SD	ZTERM	CHAR	4	0	Terms Of Payment Key Sales
36	TERMDES_SD	☐	TERMDES	BEZEI80	CHAR	80	0	Trading Contract: Description of Terms of Payment
37	VALDTD	☐	VALDT	DATUM	DATS	8	0	Fixed value date
38	ZLSCH	☐	SCHZW_BSEG	ZLSCH	CHAR	1	0	Payment Method	T042Z
39	KDATB_MM	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
40	KDATE_MM	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
41	AUSNR_MM	☐	AUSCH	EBELN	CHAR	10	0	Bid invitation number	EKKO
42	ANGNR_MM	☐	ANGNR	ANGNR	CHAR	10	0	Quotation Number
43	VERKF_MM	☐	EVERK	TEXT30	CHAR	30	0	Responsible Salesperson at Vendor's Office
44	TELF1_MM	☐	TELF0	TEXT16	CHAR	16	0	Vendor's Telephone Number
45	LLIEF_MM	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	LFA1
46	UNSEZ_MM	☐	UNSEZ	TEXT12	CHAR	12	0	Our Reference
47	EVERS_MM	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
48	BSTAE_MM	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	T163L
49	KZABS_MM	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
50	LABNR	☐	LABNR	TEXT20	CHAR	20	0	Order Acknowledgment Number
51	KZAZU	☐	KZAZU_D	XFELD	CHAR	1	0	Order combination indicator
52	HKLA	☐	HKLA	HKLA	CHAR	1	0	Trading Contract: Delivery Address Origin
53	LCNUM	☐	LCNUM	LCNUM	CHAR	10	0	Financial doc. processing: Internal financial doc. number	AKKP
54	ABSSC	☐	ABSSCHE_CM	ABSSCHE_CM	CHAR	6	0	Payment Guarantee Procedure	T691M
55	AKPRZ	☐	AKPRZ	PRZ32	DEC	5	2	Depreciation percentage for financial document processing
56	POSPLIT	☐	POSPLIT	POSPLIT	CHAR	10	0	Trading Contract: Manual Purchase Order Split
57	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
58	BSTYP	☐	BSTYP_TC	BSTYP_TC	CHAR	1	0	Purchasing Document Category
59	BSART	☐	BSART	BSART	CHAR	4	0	Order Type (Purchasing)	*
60	.INCLU--AP	☐				0	0	WBHD Append
61	.INCLUDE	☐				0	0	Global Trade: New Fields WBHD
62	VSART	☐	VSARTTR	VERSART	CHAR	2	0	Shipping type	T173
63	BSTKD_E	☐	BSTKD_E	BSTKD	CHAR	35	0	Ship-to Party's Purchase Order Number
64	POSEX_E	☐	POSEX_E	POSEX	CHAR	6	0	Item Number of the Underlying Purchase Order
65	BSTKD	☐	BSTKD	BSTKD	CHAR	35	0	Customer purchase order number
66	BSTDK	☐	BSTDK	DATUM	DATS	8	0	Customer purchase order date
67	BSTDK_E	☐	BSTDK_E	DATUM	DATS	8	0	Ship-to party's PO date
68	KALSM_MM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	*
69	KNUMV_MM	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
70	KURSK_SD	☐	KURSK	KURRF	DEC	9	5	Exchange Rate for Pricing and Statistics
71	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator
72	.INCLUDE	☐				0	0	Trading Contract: Commercial data, dynamic part
73	BEZEI_LIFNR	☐	WLF_LINES	LINES	CHAR	80	0	Address Line
74	NAME1_LIFNR	☐	NAME1_ADRS	TEXT40	CHAR	40	0	Name 1 of an address
75	PLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
76	BEZEI_EKORG	☐	EKOTX	TEXT20	CHAR	20	0	Description of purchasing organization
77	BEZEI_EKGRP	☐	EKNAM	TEXT18	CHAR	18	0	Description of purchasing group
78	BEZEI_BSART	☐	BATXT	TEXT20	CHAR	20	0	Short Description of Purchasing Document Type
79	BEZEI_ZTERM	☐	BEZEI80	BEZEI80	CHAR	80	0	Description with lenght of 80
80	BEZEI_ZTERM_SD	☐	BEZEI80	BEZEI80	CHAR	80	0	Description with lenght of 80
81	BEZEI_WAERS	☐	XWAERSL	TEXT40	CHAR	40	0	Currency key long text
82	KETDAT_MM	☐	KETDAT	ETDAT	CHAR	10	0	Requested delivery date of the document
83	LPEIN_MM	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	TPRG
84	KETDAT_SD	☐	KETDAT	ETDAT	CHAR	10	0	Requested delivery date of the document
85	KPRGBZ_SD	☐	KPRGBZ	PRGBZ	CHAR	1	0	Date type of the requested delivery date	TPRG
86	LIFN2	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
87	PARTNER_DIF	☐	FLAG	FLAG	CHAR	1	0	General Flag
88	BEZEI_ZSCHL	☐	TEXT1_042Z	TEXT30	CHAR	30	0	Name of Payment Method in Language of the Country
89	BEZEI_EVERS_MM	☐	EVTXT	TEXT30	CHAR	30	0	Shipping Instructions: Description
90	.INCLU--AP	☐				0	0	Dynamic Data Part
91	KONV_CHANGE_MM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
92	KSTEU_MM	☐	KSTEU	KSTEU	CHAR	1	0	Condition control
93	KSTEU_SD	☐	KSTEU	KSTEU	CHAR	1	0	Condition control

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCWBHD	ABSSC	T691M	ABSSC	REF	1	CN
2	MCWBHD	AUSNR_MM	EKKO	EBELN	REF	1	CN
3	MCWBHD	BSTAE_MM	T163L	BSTAE	REF	1	CN
4	MCWBHD	EKGRP	T024	EKGRP	REF	1	CN
5	MCWBHD	EKORG	T024E	EKORG	REF	1	CN
6	MCWBHD	ELIFN	LFA1	LIFNR	KEY	1	CN
7	MCWBHD	EVERS_MM	T027A	EVERS	REF	1	CN
8	MCWBHD	INCO1_MM	TINC	INCO1	REF	1	CN
9	MCWBHD	INCO1_SD	TINC	INCO1	REF	1	CN
10	MCWBHD	KPRGBZ_SD	TPRG	PRGBZ	REF	1	CN
11	MCWBHD	KURST_MM	TCURV	KURST	REF	1	CN
12	MCWBHD	LCNUM	AKKP	LCNUM	REF
13	MCWBHD	LLIEF_MM	LFA1	LIFNR	REF	1	CN
14	MCWBHD	LPEIN_MM	TPRG	PRGBZ	REF	1	CN
15	MCWBHD	MANDT	T000	MANDT	KEY	1	CN
16	MCWBHD	TKONN	WBHK	TKONN	KEY	1	CN
17	MCWBHD	VSART	T173	VSART	REF	1	CN
18	MCWBHD	WAERS_PURCH	TCURC	WAERS	REF	1	CN
19	MCWBHD	ZLSCH	T042Z	ZLSCH	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	200