SAP ABAP Table MCWMHDB (Technical view of MCWMHD)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ LVS (Package) Application development Warehouse Management (WM)

Basic Data

Table Category	INTTAB	Structure
Structure	MCWMHDB	Table Relationship Diagram
Short Description	Technical view of MCWMHD

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	.INCLUDE	☐				0	0	Update Indicator for Statistics Updating
2	SUPKZ	☐	SUPKZ	SUPKZ	CHAR	1	0	Statistics update indicator (post in/post out)
3	.INCLUDE	☐				0	0	Communication structure for warehouse controlling header
4	.INCLUDE	☐				0	0	Additional tax/data fields for warehouse controlling header
5	TB_PDATU	☐	LTBK_PDATU	DATUM	DATS	8	0	Date of Planned Execution of Transfer Request
6	TB_PZEIT	☐	LTBK_PZEIT	UZEIT	TIMS	6	0	Time of Planned Execution of Transfer Requirement
7	TB_BDATU	☐	LTBK_BDATU	DATUM	DATS	8	0	Creation Date of Transfer Request
8	TB_BZEIT	☐	LTBK_BZEIT	UZEIT	TIMS	6	0	Creation time of transfer request
9	TB_UNAME	☐	LVS_BNAME	USNAM	CHAR	12	0	User Name
10	TB_STATU	☐	LTBK_STATU	LTBK_STATU	CHAR	1	0	Header Status of Transfer Requirement
11	TB_ANZPS	☐	LTBK_ANZPS	LTBK_ANZPS	DEC	4	0	Number of Transfer Requirement Items
12	TB_BRGEW	☐	LTBK_BRGEW	DEC8_3	DEC	11	3	Total Weight of Transfer Request
13	TB_GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
14	TB_VLTYP	☐	T333_VLTYP	LGTYP	CHAR	3	0	Source Storage Type	*
15	TB_VLPLA	☐	T333_VLPLA	LGPLA	CHAR	10	0	Source storage bin	*
16	TB_VKDYN	☐	T333_VKDYN	XFELD	CHAR	1	0	Indicator: dynamic source bin
17	TB_NLTYP	☐	T333_NLTYP	LGTYP	CHAR	3	0	Destination Storage Type	*
18	TB_NLPLA	☐	T333_NLPLA	LGPLA	CHAR	10	0	Destination Storage Bin	*
19	TB_NKDYN	☐	T333_NKDYN	XFELD	CHAR	1	0	Indicator: dynamic destination bin
20	VB_VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
21	VB_ROUTE	☐	ROUTE	ROUTE	CHAR	6	0	Route	*
22	VB_BEROT	☐	BEROT	BEROT	CHAR	20	0	Picked items location
23	VB_LPRIO	☐	LPRIO	LPRIO	NUMC	2	0	Delivery priority	*
24	VB_KODAT	☐	KODAT	DATUM	DATS	8	0	Picking Date
25	VB_LDDAT	☐	LDDAT	DATUM	DATS	8	0	Loading Date
26	VB_BTGEW	☐	GSGEW	MENG15	QUAN	15	3	Total Weight
27	VB_GEWEI	☐	GEWEI	MEINS	UNIT	3	0	Weight Unit	*
28	VB_VOLUM	☐	VOLUM_15	MENG15	QUAN	15	3	Volume
29	VB_VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	*
30	VB_KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
31	.INCLUDE	☐				0	0	Communication structure for wareh.contr.perf.figure header
32	TAPSC	☐	MCWM_TAPSC	MCZAEHLER	DEC	9	0	Number of TO items for order
33	.INCLUDE	☐				0	0	Communication struct.for wareh.contr.header (cust.fields)
34	DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
35	.INCLUDE	☐				0	0	Appendix TO header
36	CNTPS	☐	LTAK1CNTPS	TAPOS	NUMC	4	0	Current number of items in TO
37	NIDRU	☐	RL03ANIDRU	XFELD	CHAR	1	0	Do not print transfer order
38	ACTDA	☐	LTAK1ACTDA	XFELD	CHAR	1	0	Actual data recorded
39	TEIL2	☐	LTAK1TEIL2	XFELD	CHAR	1	0	Indicator: Partial processing for 2-step picking allocation
40	TEILD	☐	LTAK1TEILD	XFELD	CHAR	1	0	Indicator: Partial proc. for direct picking dur.2-step pickg
41	BITEM	☐	LTAK1BITEM	XFELD	CHAR	1	0	Only Block TO Items During Confirmation
42	KOMIM	☐	LVS_KOMIM	LVS_KOMIM	CHAR	1	0	Adopt Pick Quantity as Del. Qty in Delivery / Post GI
43	EINLM	☐	LVS_EINLM	LVS_EINLM	CHAR	1	0	Adopt putaway quantity as qty in delivery / Post GR
44	.INCLUDE	☐				0	0	WM transfer order header
45	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
46	LGNUM	☐	LGNUM	LGNUM	CHAR	3	0	Warehouse Number / Warehouse Complex	T300
47	TANUM	☐	TANUM	TANUM	NUMC	10	0	Transfer Order Number
48	BWART	☐	BWART	BWART	CHAR	3	0	Movement type (inventory management)	T156
49	BWLVS	☐	BWLVS	BWLVS	NUMC	3	0	Movement Type for Warehouse Management	T333
50	TBPRI	☐	TBPRI	TBPRI	CHAR	1	0	Transfer Priority
51	TRART	☐	LVS_TRART	LVS_TRART	CHAR	1	0	Shipment Type	T333A
52	BDATU	☐	LTAK_BDATU	DATUM	DATS	8	0	Creation Date of Transfer Order
53	BZEIT	☐	LTAK_BZEIT	UZEIT	TIMS	6	0	Creation time of transfer order
54	BNAME	☐	LVS_BNAME	USNAM	CHAR	12	0	User Name
55	REFNR	☐	LVS_REFNR	LVS_REFNR	CHAR	10	0	Group	T311
56	TBNUM	☐	TBNUM	TBNUM	NUMC	10	0	Transfer Requirement Number	*
57	UBNUM	☐	UBNUM	UBNUM	NUMC	10	0	Posting Change Number
58	VBELN	☐	VBELN	VBELN	CHAR	10	0	Sales and Distribution Document Number	*
59	KQUIT	☐	LTAK_KQUIT	XFELD	CHAR	1	0	Indicator: Confirmation
60	QDATU	☐	LTAK_QDATU	DATUM	DATS	8	0	Date of Confirmation
61	MBLNR	☐	MBLNR	BELNR	CHAR	10	0	Number of Material Document
62	MJAHR	☐	MJAHR	GJAHR	NUMC	4	0	Year of material document
63	BETYP	☐	LVS_BETYP	LVS_BETYP	CHAR	1	0	Requirement Type	T308
64	BENUM	☐	LVS_BENUM	LVS_BENUM	CHAR	10	0	Requirement Number
65	DRUKZ	☐	LVS_DRUKZ	LVS_DRUKZ	CHAR	2	0	Indicator: form and sort code for printing transfer orders	T329F
66	DRUCK	☐	LTAK_DRUCK	XFELD	CHAR	1	0	Indicator: Transfer Order is Printed
67	TEILK	☐	LSAM_TEILK	XFELD	CHAR	1	0	Ind.: partial supply for documents in multiple processing
68	KR2SO	☐	LTAK_KR2SO	LTAK_KR2SO	CHAR	1	0	Indicator: Call up R/2 immediately (RM posting)
69	KR2KU	☐	LTAK_KR2KU	XFELD	CHAR	1	0	Indicator: R/2 control accumulated (RM posting)
70	KDISO	☐	LTAK_KDISO	XFELD	CHAR	1	0	Indicator: Pass on diff. to R/2 immediately (RM posting)
71	KZPLA	☐	LVS_KZPLA	XFELD	CHAR	1	0	Indicator: preplanned transfer order
72	PLDAT	☐	LVS_PLDAT	DATUM	DATS	8	0	Planned execution date for a transfer order
73	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
74	LZNUM	☐	LVS_LZNUM	LVS_LZNUM	CHAR	20	0	Additional Reference Number for Transport
75	BDART	☐	BDART	BDART	CHAR	2	0	Requirement type
76	PKNUM	☐	PKNUM	PKNUM	CHAR	7	0	Control cycle number	*
77	PKPOS	☐	PKPOS	PKPOS	NUMC	3	0	Kanban item number / control cycle item
78	KZLEI	☐	LVS_KZLEI	LVS_KZLEI	CHAR	1	0	Indicator for performance data
79	KISTZ	☐	LVS_KISTZ	LVS_KISTZ	CHAR	1	0	Indicator: Actual time required in TO
80	KISTP	☐	LVS_KISTP	XFELD	CHAR	1	0	Indicator: Input requirement for actual data
81	PERNR	☐	LTAK_PERNR	PERNR	NUMC	8	0	Personnel Number of User
82	SOLWM	☐	LTAK_SOLWM	PW_QUAN13	QUAN	13	3	Planned Transfer Order Processing Time From WM
83	SOLEX	☐	LTAK_SOLEX	PW_QUAN13	QUAN	13	3	Planned Transfer Order Processing Time from External System
84	ISTWM	☐	LTAK_ISTWM	PW_QUAN13	QUAN	13	3	Actual Time of the WM Transfer Order
85	ZEIEI	☐	LVS_ZEIEI	MEINS	UNIT	3	0	Time unit for performance data	*
86	HRSTS	☐	LTAK_HRSTS	LTAK_HRSTS	CHAR	1	0	Transfer Order Human Resources (HR) Status
87	STDAT	☐	LTAK_STDAT	DATUM	DATS	8	0	Start Date of the Transfer Order
88	ENDAT	☐	LTAK_ENDAT	DATUM	DATS	8	0	Transfer Order End Date
89	STUZT	☐	LTAK_STUZT	UZEIT	TIMS	6	0	Start time of the transfer order
90	ENUZT	☐	LTAK_ENUZT	UZEIT	TIMS	6	0	Transfer Order End Time
91	L2SKA	☐	LTAK_L2SKA	LVS_2SKTAART	CHAR	1	0	Transfer Order Type in 2-Step Picking
92	MINWM	☐	LTAK_MINWM	XFELD	CHAR	1	0	Transfer order transfers no real storage bin stock
93	LGTOR	☐	LGTOR	LGTOR	CHAR	3	0	Door for Warehouse Number	*
94	LGBZO	☐	LGBZO	LGBZO	CHAR	10	0	Staging Area for Warehouse Complex	*
95	KZVEP	☐	LVS_KZVEP	LVS_KZVEP	CHAR	1	0	Indicator: Connection to packaging in WM
96	SWABW	☐	LVS_SWABW	LVS_SWABW	NUMC	4	0	Threshold value of planned/actual time deviation as percent
97	AUSFB	☐	LVS_AUSFB	LVS_AUSFB	CHAR	4	0	TO processing comment (code)	T339
98	SPEZI	☐	LTAK_SPEZI	LTAK_SPEZI	CHAR	1	0	Indicator special reference
99	VBTYP	☐	VBTYP	VBTYP	CHAR	1	0	SD document category
100	QUEUE	☐	LRF_QUEUE	LRF_QUEUE	CHAR	10	0	Queue	*
101	KGVNQ	☐	LVS_KGVNQ	XFELD	CHAR	1	0	Indicator: Separate confirmation possible
102	TAPRI	☐	TAPRI	LPRIO	NUMC	2	0	Transfer order priority	*
103	KVQUI	☐	LTAK_KVQUI	XFELD	CHAR	1	0	Indicator: Material pick has been confirmed
104	HUCON	☐	LTAK_HUCON	HUCON	CHAR	1	0	Indicator, confirm HU
105	NOITM	☐	LTAK_CNTPS	TAPOS	NUMC	4	0	Current number of items in TO
106	KZTRM	☐	LTAK_KZTRM	XFELD	CHAR	1	0	TRM Interface Active
107	LATER	☐	LTAK_LATER	LTAK_LATER	CHAR	1	0	Delayed Update of Outbound Delivery
108	PASSD	☐	LTAK_PASSD	XFELD	CHAR	1	0	Confirmation Data Transferred To Delivery
109	MULTL	☐	LVS_MULTL	XFELD	CHAR	1	0	Transfer Order for Multiple Deliveries

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MCWMHDB	AUSFB	T339	AUSFB		C	CN
2	MCWMHDB	BETYP	T308	BETYP	REF	C	CN
3	MCWMHDB	BWART	T156	BWART
4	MCWMHDB	BWLVS	T333	BWLVS
5	MCWMHDB	DRUKZ	T329F	DRUKZ	REF	C	CN
6	MCWMHDB	LGNUM	T300	LGNUM
7	MCWMHDB	REFNR	T311	REFNR	REF	C	CN
8	MCWMHDB	TRART	T333A	TRART	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in