S081

Purchasing: Stock | #transactional | Component: Data Collection
Column Name Description
MANDT FK Client
EKORG FK Purchasing organization
EKSGB FK Purchasing area
EKGRP FK Purchasing Group
LIFNR FK Vendor's account number
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
  • S081.MANDT == T006.MANDT
  • S081.BASME == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • S081.EKGRP == T024.EKGRP
  • S081.MANDT == T024.MANDT
Purchasing organization
  • S081.MANDT == T024E.MANDT
  • S081.EKORG == T024E.EKORG
Purchasing area
  • Purchasing area
  • Client
  • S081.EKSGB == T026.EKSGB
  • S081.MANDT == T026.MANDT
Local Currency
  • S081.MANDT == TCURC.MANDT
  • S081.HWAER == TCURC.WAERS
Vendor's account number
  • S081.MANDT == LFA1.MANDT
  • S081.LIFNR == LFA1.LIFNR
Client S081.MANDT == T000.MANDT
Material Group
  • S081.MANDT == T023.MANDT
  • S081.MATKL == T023.MATKL
Plant
  • S081.MANDT == T001W.MANDT
  • S081.WERKS == T001W.WERKS