S078

STRPS: Stock | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
EKORG FK Purchasing organization
VKORG FK Sales Organization
VTWEG FK Distribution Channel
BZIRK FK Sales District
BTRKZ Plant category Show values
WERKS FK Plant
WGRU2 Material group hierarchy 2
WGRU1 Material group hierarchy 1
MATKL FK Material Group
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
Column Name Description
📏 Base Unit of Measure (BASME):
BSTMNG Stock quantity in base unit of measure
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
BTRKZ Plant category Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Base Unit of Measure
  • S078.MANDT == T006.MANDT
  • S078.BASME == T006.MSEHI
Sales District
  • S078.MANDT == T171.MANDT
  • S078.BZIRK == T171.BZIRK
Purchasing organization
  • S078.MANDT == T024E.MANDT
  • S078.EKORG == T024E.EKORG
Local Currency
  • S078.MANDT == TCURC.MANDT
  • S078.HWAER == TCURC.WAERS
Client S078.MANDT == T000.MANDT
Material Group
  • S078.MANDT == T023.MANDT
  • S078.MATKL == T023.MATKL
Sales Organization
  • S078.MANDT == TVKO.MANDT
  • S078.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S078.VTWEG == TVTW.VTWEG
  • S078.MANDT == TVTW.MANDT
Plant
  • S078.MANDT == T001W.MANDT
  • S078.WERKS == T001W.WERKS