S160

Perishables | #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
BTRKZ Plant category Show values
LIFNR FK Vendor's account number
MATKL FK Material Group
SATNR FK Cross-Plant Configurable Material
MATNR FK Material Number
Column Name Description
💲 Local Currency (HWAER):
BVLGEO Order volume at cost
BVLGVO Order volume at retail
BVLGVP Order volume at retail with tax
WESGEO Goods receipt (vendor) at cost
WESGVO Goods receipt (vendor) at retail
WESGVP Goods receipt (vendor) at retail with tax
RTEGEO Returns to vendor at cost
RTEGVO Returns to vendor at retail
RTEGVP Returns to vendor at retail with tax
ULVGEO Stock transport order at cost
ULVGVO Stock transport order at retail
ULVGVP Stock transport order at retail with tax
UAVGEO Stock transport order 2 (supplying site view) at cost
UAVGVO Stock transport order 2 (supplying site view) at retail
UAVGVP Stock transport order 2 (supplying site view) at retail w/T
KMAGEO Goods issue (DC) at cost
KMAGVO Goods issue (DC) at retail
KMAGVP Goods issue (dist. center) at retail with tax
KMEGEO Goods receipt (DC) at cost
KMEGVO Goods receipt (DC) at retail
KMEGVP Goods receipt (dist. center) at retail with tax
ULAGEO Goods clearing: issues at cost
ULAGVO Goods clearing: issues at retail
ULAGVP Goods clearing: issues at retail with tax
ULEGEO Goods clearing: receipts at cost
ULEGVO Goods clearing: receipts at retail
ULEGVP Goods clearing: receipts at retail with tax
BKSMEO Stock adjustment miscellaneous minus (cost)
BKSMVO Stock adjustment miscellaneous minus (retail)
BKSMVP Stock adjustment miscellaneous minus (retail with tax)
UMSGEO Sales at cost
UMSGVO Sales at retail
UMSGVP Sales at retail with tax
PRSNLS Sales deviation during sales
KAVGEO Sales order volume at cost
KAVGVO Sales order volume at retail
KAVGVP Sales order volume at retail with tax
Column Name Description
📏 Base Unit of Measure (BASME):
BVLMNG Order volume quantity Retail
WESMNG Goods receipt (vendor) quantity in BUn
RTEMNG Returns to vendor quantity in base unit of measure
ULVMNG Stock transport order quantity
UAVMNG Stock transport order 2 (supplying site view), quantity
KMAMNG Goods issue (distribution center) quantity in BUn
KMEMNG Goods receipt (distribution center) quantity in BUn
ULAMNG Goods clearing: issues quantity in BUn
ULEMNG Goods clearing: receipts quantity in BUn
BKSMMG Stock adjustment miscellaneous minus (quantity)
UMSMNG Sales quantity in base unit of measure
KAVMNG Sales order volume quantity
LIFMNG Deliveries to customers, quantity
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
MERK1 Characteristic 1 ATWRT
MERK2 Characteristic 2 ATWRT
MERK3 Characteristic 3 ATWRT
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
Department number
  • Department number
  • Client
  • S160.ABTNR == TSAB.ABTNR
  • S160.MANDT == TSAB.MANDT
Base Unit of Measure
  • S160.MANDT == T006.MANDT
  • S160.BASME == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • S160.EKGRP == T024.EKGRP
  • S160.MANDT == T024.MANDT
Local Currency
  • S160.MANDT == TCURC.MANDT
  • S160.HWAER == TCURC.WAERS
Vendor's account number
  • S160.MANDT == LFA1.MANDT
  • S160.LIFNR == LFA1.LIFNR
Client S160.MANDT == T000.MANDT
Material Group
  • S160.MANDT == T023.MANDT
  • S160.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S160.MATNR == MARA.MATNR
  • S160.MANDT == MARA.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • S160.SATNR == MARA.MATNR
  • S160.MANDT == MARA.MANDT
Plant
  • S160.MANDT == T001W.MANDT
  • S160.WERKS == T001W.WERKS