S207

MAP: Store Planning Structure | #transactional | Component: Obsolete Functionality
Column Name Description
MANDT FK Client
SPMON Period to analyze - month
SAISO FK Season Category
VKORG FK Sales Organization
VTWEG FK Distribution Channel
BZIRK FK Sales District
WERKS FK Plant
VRSIO Version number in the information structure
SPTAG Period to analyze - current date
SPWOC Period to analyze - week
SPBUP Period to analyze - posting period
SSOUR Statistic(s) origin
Column Name Description
💲 Database Currency for Planning Data in a Planning Scenario (PSWAE):
UBPGVP Revaluation at retail, plus, at retail with tax
UBMGVP Revaluation at retail, minus, at retail with tax
UBPGVO Revaluation at retail, plus
UBMGVO Revaluation at retail, minus
PRSNLS Sales deviation during sales
UMSGVP Sales at retail with tax
UMSGVO Sales at retail
UMSGEO Sales at cost
WESGVP Goods receipt (vendor) at retail with tax
WESGVO Goods receipt (vendor) at retail
WESGEO Goods receipt (vendor) at cost
BKIMVP Stock adjustment inventory difference minus (retail w/tax)
BKIMVO Stock adjustment inventory difference minus (retail)
BKIMEO Stock adjustment inventory difference minus (cost)
RTEGVP Returns to vendor at retail with tax
RTEGVO Returns to vendor at retail
RTEGEO Returns to vendor at cost
BKSPGVP Stock adjustment miscellaneous + retail with tax
BKSPGVO Stock Adjustment Miscellaneous + Retail
BKSPGEO Stock adjustment miscellaneous + (cost)
BKSMGVP Stock adjustment miscellaneous - retail with tax
BKSMGVO Stock Adjustment Miscellaneous - Retail
BKSMGEO Stock adjustment miscellaneous - cost
ZUGSGVP Miscellaneous receipts at retail with tax
ZUGSGVO Miscellaneous receipts at retail
ZUGSGEO Miscellaneous receipts at cost
ABGSGVP Misc Issues at Retail With Tax
ABGSGVO Miscellaneous Issues at Retail
ABGSGEO Miscellaneous Issues at Cost
ZUGGVP Receipts at retail with tax
ZUGGVO Receipts at retail
ZUGGEO Receipts at cost
ABGGVP Issues at retail with tax
ABGGVO Issues at retail
ABGGEO Issues at cost
BSTGVP Stock at retail with tax
BSTGVO Stock at retail
BSTGEO Stock at cost
ZUKGVP Additional purchase at retail with tax
ZUKGVO Additional purchase at retail
ZUKGEO Receipts at cost
VEDGVP Budget Released at Retail With Tax
VEDGVO Budget Released at Retail
VEDGEO Budget Released at Cost
Column Name Description
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Sales District
  • S207.MANDT == T171.MANDT
  • S207.BZIRK == T171.BZIRK
Purchasing organization
  • S207.MANDT == T024E.MANDT
  • S207.EKORG == T024E.EKORG
Client S207.MANDT == T000.MANDT
Database Currency for Planning Data in a Planning Scenario
  • S207.MANDT == TCURC.MANDT
  • S207.PSWAE == TCURC.WAERS
Season Category
  • S207.MANDT == T6WSP.MANDT
  • S207.SAISO == T6WSP.SAISO
Sales Organization
  • S207.MANDT == TVKO.MANDT
  • S207.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S207.VTWEG == TVTW.VTWEG
  • S207.MANDT == TVTW.MANDT
Plant
  • S207.MANDT == T001W.MANDT
  • S207.WERKS == T001W.WERKS