S106

Season: Stock | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
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
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
SSOUR Statistic(s) origin
Column Name Description
💲 Local Currency (HWAER):
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
Column Name Description
📏 Base Unit of Measure (BASME):
BSTMNG Stock quantity in base unit of measure
BBSMNG On-order 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
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
  • S106.MANDT == T006.MANDT
  • S106.BASME == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • S106.EKGRP == T024.EKGRP
  • S106.MANDT == T024.MANDT
Local Currency
  • S106.MANDT == TCURC.MANDT
  • S106.HWAER == TCURC.WAERS
Vendor's account number
  • S106.MANDT == LFA1.MANDT
  • S106.LIFNR == LFA1.LIFNR
Client S106.MANDT == T000.MANDT
Material Group
  • S106.MANDT == T023.MANDT
  • S106.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S106.MATNR == MARA.MATNR
  • S106.MANDT == MARA.MANDT
Price Band Category
  • S106.MANDT == TWPT.MANDT
  • S106.PLGTP == TWPT.PLGTP
Season Category
  • S106.MANDT == T6WSP.MANDT
  • S106.SAISO == T6WSP.SAISO
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • S106.SATNR == MARA.MATNR
  • S106.MANDT == MARA.MANDT
Plant
  • S106.MANDT == T001W.MANDT
  • S106.WERKS == T001W.WERKS