S159

W&S: Picking Waves | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
SSOUR Statistic(s) origin
VRSIO Version number in the information structure
SPMON Period to analyze - month
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
LGNUM FK Warehouse Number / Warehouse Complex
VBELN FK Delivery
PLGTYP FK Planned picking storage type
PKOBER FK Planned picking area
METYP FK Unit-of-measure load category according to workload criteria
VHART FK Packaging Material Type Rough Workload Estimate
Column Name Description
Column Name Description
📏 Weight unit: Rough Workload Estimate and picking waves (GEWEH):
MEGEW_E Weight for quantity +
MEGEW_R Weight for quantity -
MEGEW_D Weight for quantity
📏 Volume unit: Rough Workload Estimate and picking waves (VOLEH):
MEVOL_E Volume for quantity +
MEVOL_R Volume for quantity -
MEVOL_D Volume for quantity
Column Name Description
SPTAG Period to analyze - current date
VGLZT Comparison time for forming waves
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
METYP_E Quantity for unit-of-measure load category + DEC15_3
METYP_R Quantity for UoM handling group DEC15_3
METYP_D Quantity for unit-of-measure load category DEC15_3
BZEIT_E Processing time+ for quantity in hours DEC17_5
BZEIT_R Processing time- for quantity in hours DEC17_5
BZEIT_D Processing time for quantity in hours DEC17_5
VHART_E Packaging Materials for Packaging Material Type + DEC15_3
VHART_R Packaging Materials for Packaging Material Type DEC15_3
VHART_D Packaging Materials for Packaging Material Type DEC15_3
ANZBP_E Number of document items/schedule lines + MCZAEHLINT
ANZBP_R Number of document items/schedule lines - MCZAEHLINT
ANZBP_D Number of document items/schedule lines MCZAEHLINT
ABLAD Unloading Point TEXT25
Master Data Relations Join Conditions
Route schedule
  • S159.MANDT == VALW.MANDT
  • S159.AULWE == VALW.AULWE
Weight unit: Rough Workload Estimate and picking waves
  • S159.MANDT == T006.MANDT
  • S159.GEWEH == T006.MSEHI
Delivery Type
  • S159.MANDT == TVLK.MANDT
  • S159.LFART == TVLK.LFART
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • S159.LGNUM == T300.LGNUM
  • S159.MANDT == T300.MANDT
Delivery Priority
  • S159.MANDT == TPRIO.MANDT
  • S159.LPRIO == TPRIO.LPRIO
Client S159.MANDT == T000.MANDT
Unit-of-measure load category according to workload criteria
  • S159.MANDT == TMET.MANDT
  • S159.METYP == TMET.METYP
Planned picking area
  • Warehouse Number / Warehouse Complex
  • Planned picking storage type
  • Planned picking area
  • S159.MANDT == T30A.MANDT
  • S159.LGNUM == T30A.LGNUM
  • S159.PLGTYP == T30A.LGTYP
  • S159.PKOBER == T30A.KOBER
Sold-to Party
  • S159.MANDT == KNA1.MANDT
  • S159.PKUNAG == KNA1.KUNNR
Ship-to Party
  • S159.MANDT == KNA1.MANDT
  • S159.PKUNWE == KNA1.KUNNR
Planned picking storage type
  • Warehouse Number / Warehouse Complex
  • Client
  • Planned picking storage type
  • S159.LGNUM == T301.LGNUM
  • S159.MANDT == T301.MANDT
  • S159.PLGTYP == T301.LGTYP
Forwarding Agent
  • S159.MANDT == LFA1.MANDT
  • S159.PSPDNR == LFA1.LIFNR
Route
  • S159.MANDT == TVRO.MANDT
  • S159.ROUTE == TVRO.ROUTE
Packaging Material Type Rough Workload Estimate
  • S159.MANDT == TVTY.MANDT
  • S159.VHART == TVTY.TRATY
Sales Organization
  • S159.MANDT == TVKO.MANDT
  • S159.VKORG == TVKO.VKORG
Volume unit: Rough Workload Estimate and picking waves
  • S159.MANDT == T006.MANDT
  • S159.VOLEH == T006.MSEHI
Shipping Conditions
  • S159.MANDT == TVSB.MANDT
  • S159.VSBED == TVSB.VSBED
Shipping Point / Receiving Point
  • S159.MANDT == TVST.MANDT
  • S159.VSTEL == TVST.VSTEL