S152

W&S: Rough Workload Estimate - Goods Issue | #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
WARTYP Goods category (promotional goods or normal goods) Show values
BELTYP Document category: rough workload estimate Show values
PLGTYP FK Planned picking storage type
PKOBER FK Planned picking area
LPRIO FK Delivery Priority
METYP FK Unit-of-measure load category according to workload criteria
VHART FK Packaging Material Type Rough Workload Estimate
TIMEL FK Time slot: Rough workload forecast
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
Column Name Description
WARTYP Goods category (promotional goods or normal goods) Show values
BELTYP Document category: rough workload estimate Show values
VZTTG Warehouse process Show values
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
BELNRL Last document number for database record RWE CHAR10
BELPSL Last document item for RWE database record CHAR6
Master Data Relations Join Conditions
Weight unit: Rough Workload Estimate and picking waves
  • S152.MANDT == T006.MANDT
  • S152.GEWEH == T006.MSEHI
Warehouse Number / Warehouse Complex
  • Warehouse Number / Warehouse Complex
  • Client
  • S152.LGNUM == T300.LGNUM
  • S152.MANDT == T300.MANDT
Delivery Priority
  • S152.MANDT == TPRIO.MANDT
  • S152.LPRIO == TPRIO.LPRIO
Client S152.MANDT == T000.MANDT
Unit-of-measure load category according to workload criteria
  • S152.MANDT == TMET.MANDT
  • S152.METYP == TMET.METYP
Planned picking area
  • Warehouse Number / Warehouse Complex
  • Planned picking storage type
  • Planned picking area
  • S152.MANDT == T30A.MANDT
  • S152.LGNUM == T30A.LGNUM
  • S152.PLGTYP == T30A.LGTYP
  • S152.PKOBER == T30A.KOBER
Planned picking storage type
  • Warehouse Number / Warehouse Complex
  • Client
  • Planned picking storage type
  • S152.LGNUM == T301.LGNUM
  • S152.MANDT == T301.MANDT
  • S152.PLGTYP == T301.LGTYP
Time slot: Rough workload forecast
  • ?
  • ?
  • Time slot: Rough workload forecast
  • S152.MANDT == TC37A.MANDT
  • S152.[column in domain "SCHGRUP"] == TC37A.SCHGRUP
  • S152.[column in domain "ENDDA"] == TC37A.ENDDA
  • S152.TIMEL == TC37A.KAPTPROG
Packaging Material Type Rough Workload Estimate
  • S152.MANDT == TVTY.MANDT
  • S152.VHART == TVTY.TRATY
Volume unit: Rough Workload Estimate and picking waves
  • S152.MANDT == T006.MANDT
  • S152.VOLEH == T006.MSEHI