S087

Material/add-on | #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
WERKS FK Plant
BTRKZ Plant category Show values
LIFNR FK Vendor's account number
MATKL FK Material Group
MATNR FK Material Number
Column Name Description
💲 Local Currency (HWAER):
RTEGEO Returns to vendor at cost
RTEGVO Returns to vendor at retail
RTEGVP Returns to vendor 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)
UBPGEO Revaluation at cost, plus
UBMGEO Revaluation at cost, minus
Column Name Description
📏 Base Unit of Measure (BASME):
RTEMNG Returns to vendor quantity in base unit of measure
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)
UBPEPM Revaluation at cost, plus, quantity
UBMEPM Revaluation at cost minus, 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
RTEANZ Returns to vendor, 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
UBPEAZ Revaluation at cost plus, no. of transactions MCZAEHLINT
UBMEAZ Revaluation at cost minus, no. of transactions MCZAEHLINT
Master Data Relations Join Conditions
Base Unit of Measure
  • S087.MANDT == T006.MANDT
  • S087.BASME == T006.MSEHI
Local Currency
  • S087.MANDT == TCURC.MANDT
  • S087.HWAER == TCURC.WAERS
Vendor's account number
  • S087.MANDT == LFA1.MANDT
  • S087.LIFNR == LFA1.LIFNR
Client S087.MANDT == T000.MANDT
Material Group
  • S087.MANDT == T023.MANDT
  • S087.MATKL == T023.MATKL
Material Number
  • Material Number
  • Client
  • S087.MATNR == MARA.MATNR
  • S087.MANDT == MARA.MANDT
Plant
  • S087.MANDT == T001W.MANDT
  • S087.WERKS == T001W.WERKS