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)
⤷ 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 |