SAP ABAP Table S159 (W&S: Picking Waves)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷
CRM (Application Component) Customer Relationship Management
⤷
CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷
MCS (Package) R/3 application development: Logistics Information Warehouse
⤷
⤷
⤷
Basic Data
| Table Category | TRANSP | Transparent table |
| Transparent table | S159 |
|
| Short Description | W&S: Picking Waves |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | A | Application Table (Master- and Transaction Data) |
| 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 | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
SSOUR | SSOUR | CHAR | 4 | 0 | Statistic(s) origin | ||
| 3 | |
VRSIO | VRSIO | CHAR | 3 | 0 | Version number in the information structure | * | |
| 4 | |
SPMON | MCPERIOD | NUMC | 6 | 0 | Period to analyze - month | ||
| 5 | |
SPTAG | DATUM | DATS | 8 | 0 | Period to analyze - current date | ||
| 6 | |
SPWOC | MCPERIOD | NUMC | 6 | 0 | Period to analyze - week | ||
| 7 | |
SPBUP | MCPERIOD | NUMC | 6 | 0 | Period to analyze - posting period | ||
| 8 | |
LGNUM | LGNUM | CHAR | 3 | 0 | Warehouse Number / Warehouse Complex | T300 | |
| 9 | |
VBELN_VL | VBELN | CHAR | 10 | 0 | Delivery | VBUK | |
| 10 | |
MCL_PLGTYP | LGTYP | CHAR | 3 | 0 | Planned picking storage type | T301 | |
| 11 | |
MCL_PKOBER | KOBER | CHAR | 3 | 0 | Planned picking area | T30A | |
| 12 | |
METYP | MEITY | CHAR | 1 | 0 | Unit-of-measure load category according to workload criteria | TMET | |
| 13 | |
MCL_VHARTL | TRATY | CHAR | 4 | 0 | Packaging Material Type Rough Workload Estimate | TVTY | |
| 14 | |
PERIV | PERIV | CHAR | 2 | 0 | Fiscal Year Variant | * | |
| 15 | |
VWDAT | VWDAT | NUMC | 10 | 0 | Pointer to administrative data | ||
| 16 | |
MCL_GEWEH | MEINS | UNIT | 3 | 0 | Weight unit: Rough Workload Estimate and picking waves | T006 | |
| 17 | |
MCL_VOLEH | MEINS | UNIT | 3 | 0 | Volume unit: Rough Workload Estimate and picking waves | T006 | |
| 18 | |
MCL_METYPE | DEC15_3 | DEC | 15 | 3 | Quantity for unit-of-measure load category + | ||
| 19 | |
MCL_METYPR | DEC15_3 | DEC | 15 | 3 | Quantity for UoM handling group | ||
| 20 | |
MCL_METYPD | DEC15_3 | DEC | 15 | 3 | Quantity for unit-of-measure load category | ||
| 21 | |
MCL_MEGEWE | MENG8 | QUAN | 15 | 3 | Weight for quantity + | ||
| 22 | |
MCL_MEGEWR | MENG8 | QUAN | 15 | 3 | Weight for quantity - | ||
| 23 | |
MCL_MEGEWD | MENG8 | QUAN | 15 | 3 | Weight for quantity | ||
| 24 | |
MCL_MEVOLE | MENG8 | QUAN | 15 | 3 | Volume for quantity + | ||
| 25 | |
MCL_MEVOLR | MENG8 | QUAN | 15 | 3 | Volume for quantity - | ||
| 26 | |
MCL_MEVOLD | MENG8 | QUAN | 15 | 3 | Volume for quantity | ||
| 27 | |
MCL_BZEITE | DEC17_5 | DEC | 17 | 5 | Processing time+ for quantity in hours | ||
| 28 | |
MCL_BZEITR | DEC17_5 | DEC | 17 | 5 | Processing time- for quantity in hours | ||
| 29 | |
MCL_BZEITD | DEC17_5 | DEC | 17 | 5 | Processing time for quantity in hours | ||
| 30 | |
MCL_VHARTE | DEC15_3 | DEC | 15 | 3 | Packaging Materials for Packaging Material Type + | ||
| 31 | |
MCL_VHARTR | DEC15_3 | DEC | 15 | 3 | Packaging Materials for Packaging Material Type | ||
| 32 | |
MCL_VHARTD | DEC15_3 | DEC | 15 | 3 | Packaging Materials for Packaging Material Type | ||
| 33 | |
MCL_ANZBPE | MCZAEHLINT | INT4 | 10 | 0 | Number of document items/schedule lines + | ||
| 34 | |
MCL_ANZBPR | MCZAEHLINT | INT4 | 10 | 0 | Number of document items/schedule lines - | ||
| 35 | |
MCL_ANZBPD | MCZAEHLINT | INT4 | 10 | 0 | Number of document items/schedule lines | ||
| 36 | |
VKORG | VKORG | CHAR | 4 | 0 | Sales Organization | TVKO | |
| 37 | |
VSTEL | VSTEL | CHAR | 4 | 0 | Shipping Point/Receiving Point | TVST | |
| 38 | |
ABLAD | TEXT25 | CHAR | 25 | 0 | Unloading Point | ||
| 39 | |
ROUTE | ROUTE | CHAR | 6 | 0 | Route | TVRO | |
| 40 | |
AULWE | AULWE | CHAR | 10 | 0 | Route Schedule | VALW | |
| 41 | |
VSBED | VSBED | CHAR | 2 | 0 | Shipping conditions | TVSB | |
| 42 | |
LPRIO | LPRIO | NUMC | 2 | 0 | Delivery priority | TPRIO | |
| 43 | |
LFART | LFART | CHAR | 4 | 0 | Delivery Type | TVLK | |
| 44 | |
SPDNR | LIFNR | CHAR | 10 | 0 | Carrier | LFA1 | |
| 45 | |
KUNWE | KUNNR | CHAR | 10 | 0 | Ship-to party | KNA1 | |
| 46 | |
KUNAG | KUNNR | CHAR | 10 | 0 | Sold-to party | KNA1 | |
| 47 | |
MCL_VGLZT | UZEIT | TIMS | 6 | 0 | Comparison time for forming waves |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | S159 | AULWE | |
|
REF | 1 | CN |
| 2 | S159 | GEWEH | |
|
KEY | 1 | C |
| 3 | S159 | LFART | |
|
|||
| 4 | S159 | LGNUM | |
|
|||
| 5 | S159 | LPRIO | |
|
|||
| 6 | S159 | MANDT | |
|
|||
| 7 | S159 | METYP | |
|
KEY | 1 | CN |
| 8 | S159 | PKOBER | |
|
|||
| 9 | S159 | PKUNAG | |
|
|||
| 10 | S159 | PKUNWE | |
|
|||
| 11 | S159 | PLGTYP | |
|
|||
| 12 | S159 | PSPDNR | |
|
|||
| 13 | S159 | ROUTE | |
|
|||
| 14 | S159 | VBELN | |
|
|||
| 15 | S159 | VHART | |
|
|||
| 16 | S159 | VKORG | |
|
|||
| 17 | S159 | VOLEH | |
|
KEY | 1 | C |
| 18 | S159 | VSBED | |
|
|||
| 19 | S159 | VSTEL | |
|
History
| Last changed by/on | SAP | 20050411 |
| SAP Release Created in |