S082

Purchasing: 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
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
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
WESGEO Goods receipt (vendor) at cost
WESGVO Goods receipt (vendor) at retail
WESGVP Goods receipt (vendor) 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
KMAGEO Goods issue (DC) at cost
KMAGVO Goods issue (DC) at retail
KMAGVP Goods issue (dist. center) at retail with tax
BVLGEO Order volume at cost
BVLGVO Order volume at retail
BVLGVP Order volume at retail with tax
BSTGEO Stock at cost
BSTGVO Stock at retail
BSTGVP Stock 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
Column Name Description
📏 Base Unit of Measure (BASME):
UMSMNG Sales quantity in base unit of measure
AUMMNG Promotion sales quantity in BUn
WESMNG Goods receipt (vendor) quantity in BUn
KMEMNG Goods receipt (distribution center) quantity in BUn
KMAMNG Goods issue (distribution center) quantity in BUn
BVLMNG Order volume quantity Retail
BSTMNG Stock quantity in base unit of measure
UBPVPM Revaluation at retail, plus, quantity
UBMVPM Revaluation at retail, minus, quantity
ZUGMNG Receipts quantity in BUn
ABGMNG Issues quantity in BUn
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
WESANZ Goods receipt (vendor) number of transactions MCZAEHLINT
KMEANZ Goods receipt (distribution center), no. of transactions MCZAEHLINT
KMAANZ Goods issue (distribution center), no. of transactions MCZAEHLINT
BVLANZ Order volume, number of transactions MCZAEHLINT
UBPVAZ Revaluation at retail, plus, no. of transactions MCZAEHLINT
UBMVAZ Revaluation at retail, minus, no. of transactions MCZAEHLINT
WESMAO Goods receipt margin (vendor+GR(DC)) PRZ32V
WESMAM Goods receipt margin with tax (vendor+GR(DC)) PRZ32V
UMSMAO Sales margin PRZ32V
UMSMAM Sales margin with tax PRZ32V
BVLMAO Order volume margin PRZ32V
BVLMAM Order volume margin with tax PRZ32V
BSTMAO Stock margin PRZ32V
BSTMAM Stock margin including tax PRZ32V
AUMMAO Promotion sales margin PRZ32V
AUMMAM Promotion sales margin with tax PRZ32V
RWMENG Range of coverage in days (quantity) BCSP4
RWWERT Range of coverage in days (value) BCSP4
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
Master Data Relations Join Conditions
Base Unit of Measure
  • S082.MANDT == T006.MANDT
  • S082.BASME == T006.MSEHI
Purchasing Group
  • Purchasing Group
  • Client
  • S082.EKGRP == T024.EKGRP
  • S082.MANDT == T024.MANDT
Purchasing organization
  • S082.MANDT == T024E.MANDT
  • S082.EKORG == T024E.EKORG
Purchasing area
  • Purchasing area
  • Client
  • S082.EKSGB == T026.EKSGB
  • S082.MANDT == T026.MANDT
Local Currency
  • S082.MANDT == TCURC.MANDT
  • S082.HWAER == TCURC.WAERS
Vendor's account number
  • S082.MANDT == LFA1.MANDT
  • S082.LIFNR == LFA1.LIFNR
Client S082.MANDT == T000.MANDT
Material Group
  • S082.MANDT == T023.MANDT
  • S082.MATKL == T023.MATKL
Plant
  • S082.MANDT == T001W.MANDT
  • S082.WERKS == T001W.WERKS