S107

Season: Movements + Stock | #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
EKGRP FK Purchasing Group
WERKS FK Plant
LIFNR FK Vendor's account number
MATKL FK Material Group
SATNR FK Cross-Plant Configurable Material
MATNR FK Material Number
SAISJ Season Year
SAISO FK Season Category
PLGTP FK Price Band Category
Column Name Description
💲 Local Currency (HWAER):
UMSGEO Sales at cost
UMSGVO Sales at retail
UMSGVP Sales at retail with tax
PRSNLS Sales deviation during sales
AUMGEO Promotion sales at cost
AUMGVO Promotion sales at retail
AUMGVP Promotion sales at retail with tax
UBPGVO Revaluation at retail, plus
UBPGVP Revaluation at retail, plus, at retail with tax
UBMGVO Revaluation at retail, minus
UBMGVP Revaluation at retail, minus, at retail with tax
ZUGGEO Receipts at cost
ZUGGVO Receipts at retail
ZUGGVP Receipts at retail with tax
ABGGEO Issues at cost
ABGGVO Issues at retail
ABGGVP Issues at retail with tax
BBZGEO Order stock receipts at cost
BBZGVO Order stock receipts at retail
BBZGVP Order stock receipts at retail with tax
BBAGEO Order stock issues at cost
BBAGVO Order stock issues at retail
BBAGVP Order stock issues at retail with tax
KMAGEO Goods issue (DC) at cost
KMAGVO Goods issue (DC) at retail
KMAGVP Goods issue (dist. center) at retail with tax
ULEGEO Goods clearing: receipts at cost
ULEGVO Goods clearing: receipts at retail
ULEGVP Goods clearing: receipts at retail with tax
ULAGEO Goods clearing: issues at cost
ULAGVO Goods clearing: issues at retail
ULAGVP Goods clearing: issues at retail with tax
BSTGEO Stock at cost
BSTGVO Stock at retail
BSTGVP Stock at retail with tax
BBSGEO On-order stock at cost
BBSGVO On-order stock at retail
BBSGVP On-order stock at retail with tax
URSPVP Original retail price
FUMGVP Fictitious sales at retail with tax
FBSGVP Fictitious stock at retail with tax
SBSGEO End of season stock at cost
SBSGVO End of season stock at retail
SBSGVP End of season stock at retail with tax
Column Name Description
📏 Base Unit of Measure (BASME):
UMSMNG Sales quantity in base unit of measure
AUMMNG Promotion sales quantity in BUn
UBPVPM Revaluation at retail, plus, quantity
UBMVPM Revaluation at retail, minus, quantity
ZUGMNG Receipts quantity in BUn
ABGMNG Issues quantity in BUn
BBZMNG Order stock receipts quantity in BUn
BBAMNG Order stock issues quantity in BUn
KMAMNG Goods issue (distribution center) quantity in BUn
ULEMNG Goods clearing: receipts quantity in BUn
ULAMNG Goods clearing: issues quantity in BUn
BSTMNG Stock quantity in base unit of measure
BBSMNG On-order stock quantity in BUn
SBSMNG End of season stock quantity in BUn
Column Name Description
SPTAG Period to analyze - current date
ERSTZU First receipt
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
UBPVAZ Revaluation at retail, plus, no. of transactions MCZAEHLINT
UBMVAZ Revaluation at retail, minus, no. of transactions MCZAEHLINT
KMAANZ Goods issue (distribution center), no. of transactions MCZAEHLINT
ULEANZ Goods clearing: receipts, no. of transactions MCZAEHLINT
ULAANZ Goods clearing: issues, no. of transactions MCZAEHLINT
TAGEIV Days on sale, no. of MCZAEHLINT
AQMENG Sales quota (quantity) PRZ32V
AQWERT Sales quota (value) PRZ32V
UMSMAO Sales margin PRZ32V
UMSMAM Sales margin with tax PRZ32V
AUMMAO Promotion sales margin PRZ32V
AUMMAM Promotion sales margin with tax PRZ32V
BSTMAO Stock margin PRZ32V
BSTMAM Stock margin including tax PRZ32V
BBSMAO On-order stock margin PRZ32V
BBSMAM On-order stock margin with tax PRZ32V
UHMENG Inventory turn (quantity) PRZ32V
UHWERT Inventory turn (value) PRZ32V
JUMENG Annual inventory turn (quantity) PRZ32V
JUWERT Annual inventory turn (value) PRZ32V
GMROIO Gross margin return on inventory investment PRZ32V
GMROIM Gross margin return on inventory investment with tax PRZ32V
RWMENG Range of coverage in days (quantity) BCSP4
RWWERT Range of coverage in days (value) BCSP4
MERK1 Characteristic 1 ATWRT
MERK2 Characteristic 2 ATWRT
MERK3 Characteristic 3 ATWRT
WGRU2 Material group hierarchy 2 KLASSE
WGRU1 Material group hierarchy 1 KLASSE
ATINM1 Internal characteristic number, characteristic 1 ATINN
ATINM2 Internal characteristic number, characteristic 2 ATINN
ATINM3 Internal characteristic number, characteristic 3 ATINN
Master Data Relations Join Conditions
Base Unit of Measure
  • S107.MANDT == T006.MANDT
  • S107.BASME == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • S107.EKGRP == T024.EKGRP
  • S107.MANDT == T024.MANDT
Local Currency
  • S107.MANDT == TCURC.MANDT
  • S107.HWAER == TCURC.WAERS
Vendor's account number
  • S107.MANDT == LFA1.MANDT
  • S107.LIFNR == LFA1.LIFNR
Client S107.MANDT == T000.MANDT
Material Group
  • S107.MANDT == T023.MANDT
  • S107.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S107.MATNR == MARA.MATNR
  • S107.MANDT == MARA.MANDT
Price Band Category
  • S107.MANDT == TWPT.MANDT
  • S107.PLGTP == TWPT.PLGTP
Season Category
  • S107.MANDT == T6WSP.MANDT
  • S107.SAISO == T6WSP.SAISO
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • S107.SATNR == MARA.MATNR
  • S107.MANDT == MARA.MANDT
Plant
  • S107.MANDT == T001W.MANDT
  • S107.WERKS == T001W.WERKS