S077

STRPS: Movements | #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
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
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
RTEGEO Returns to vendor at cost
RTEGVO Returns to vendor at retail
RTEGVP Returns to 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
ULEGEO Goods clearing: receipts at cost
ULEGVO Goods clearing: receipts at retail
ULEGVP Goods clearing: receipts at retail with tax
ULAGEO Goods clearing: issues at cost
ULAGVO Goods clearing: issues at retail
ULAGVP Goods clearing: issues at retail with tax
AUEGEO Material transfer: receipts at cost
AUEGVO Material transfer: receipts at retail
AUEGVP Material transfer: receipts at retail with tax
AUAGEO Material transfer: issues at cost
AUAGVO Material transfer: issues at retail
AUAGVP Material transfer: issues at retail with tax
BKIPEO Stock adjustment inventory difference plus (cost)
BKIPVO Stock adjustment inventory difference plus (retail)
BKIPVP Stock adjustment inventory difference plus (at retail w/tax)
BKIMEO Stock adjustment inventory difference minus (cost)
BKIMVO Stock adjustment inventory difference minus (retail)
BKIMVP Stock adjustment inventory difference minus (retail w/tax)
BKSPEO Stock adjustment miscellaneous plus (cost)
BKSPVO Stock adjustment miscellaneous plus (retail)
BKSPVP Stock adjustment miscellaneous plus (retail with tax)
BKSMEO Stock adjustment miscellaneous minus (cost)
BKSMVO Stock adjustment miscellaneous minus (retail)
BKSMVP Stock adjustment miscellaneous minus (retail with tax)
BVLGEO Order volume at cost
BVLGVO Order volume at retail
BVLGVP Order volume at retail with tax
UBPGEO Revaluation at cost, plus
UBMGEO Revaluation at cost, minus
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
RTEMNG Returns to vendor quantity in base unit of measure
KMEMNG Goods receipt (distribution center) quantity in BUn
KMAMNG Goods issue (distribution center) quantity in BUn
ULEMNG Goods clearing: receipts quantity in BUn
ULAMNG Goods clearing: issues quantity in BUn
AUEMNG Material transfer: receipts quantity BUn
AUAMNG Material transfer: issues quantity BUn
BKIPMG Stock adjustment inventory difference plus (quantity)
BKIMMG Stock adjustment inventory difference minus (quantity)
BKSPMG Stock adjustment miscellaneous plus (quantity)
BKSMMG Stock adjustment miscellaneous minus (quantity)
BVLMNG Order volume quantity Retail
UBPEPM Revaluation at cost, plus, quantity
UBMEPM Revaluation at cost minus, quantity
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
RTEANZ Returns to vendor, no. of transactions MCZAEHLINT
KMEANZ Goods receipt (distribution center), no. of transactions MCZAEHLINT
KMAANZ Goods issue (distribution center), no. of transactions MCZAEHLINT
ULEANZ Goods clearing: receipts, no. of transactions MCZAEHLINT
ULAANZ Goods clearing: issues, no. of transactions MCZAEHLINT
AUEANZ Material transfer: receipts, no. transactions MCZAEHLINT
AUAANZ Material transfer: issues, no. of transactions MCZAEHLINT
BKIPAZ Stock adjustment inv. difference plus (no. of transactions) MCZAEHLINT
BKIMAZ Stock adjustment inv. difference minus (no. of transactions) MCZAEHLINT
BKSPAZ Stock adjustment miscellaneous plus (no. of transactions) MCZAEHLINT
BKSMAZ Stock adjustment miscellaneous minus (no. of transactions) MCZAEHLINT
BVLANZ Order volume, number of transactions MCZAEHLINT
UBPEAZ Revaluation at cost plus, no. of transactions MCZAEHLINT
UBMEAZ Revaluation at cost minus, no. of transactions MCZAEHLINT
UBPVAZ Revaluation at retail, plus, no. of transactions MCZAEHLINT
UBMVAZ Revaluation at retail, minus, no. of transactions MCZAEHLINT
Master Data Relations Join Conditions
Base Unit of Measure
  • S077.MANDT == T006.MANDT
  • S077.BASME == T006.MSEHI
Sales District
  • S077.MANDT == T171.MANDT
  • S077.BZIRK == T171.BZIRK
Purchasing organization
  • S077.MANDT == T024E.MANDT
  • S077.EKORG == T024E.EKORG
Local Currency
  • S077.MANDT == TCURC.MANDT
  • S077.HWAER == TCURC.WAERS
Client S077.MANDT == T000.MANDT
Material Group
  • S077.MANDT == T023.MANDT
  • S077.MATKL == T023.MATKL
Sales Organization
  • S077.MANDT == TVKO.MANDT
  • S077.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S077.VTWEG == TVTW.VTWEG
  • S077.MANDT == TVTW.MANDT
Plant
  • S077.MANDT == T001W.MANDT
  • S077.WERKS == T001W.WERKS