S009

CAS: Last Documents | #other | 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
VKORG FK Sales Organization
VTWEG FK Distribution Channel
SPART FK Division
KUNNR FK Customer Number
VBTYP SD Document Category Show values
Column Name Description
Column Name Description
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
VBTYP SD Document Category Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
BEL01 Sales and Distribution Document Number VBELN
BEL02 Sales and Distribution Document Number VBELN
BEL03 Sales and Distribution Document Number VBELN
BEL04 Sales and Distribution Document Number VBELN
BEL05 Sales and Distribution Document Number VBELN
BEL06 Sales and Distribution Document Number VBELN
BEL07 Sales and Distribution Document Number VBELN
BEL08 Sales and Distribution Document Number VBELN
BEL09 Sales and Distribution Document Number VBELN
BEL10 Sales and Distribution Document Number VBELN
BEL11 Sales and Distribution Document Number VBELN
BEL12 Sales and Distribution Document Number VBELN
BEL13 Sales and Distribution Document Number VBELN
BEL14 Sales and Distribution Document Number VBELN
BEL15 Sales and Distribution Document Number VBELN
BEL16 Sales and Distribution Document Number VBELN
BEL17 Sales and Distribution Document Number VBELN
BEL18 Sales and Distribution Document Number VBELN
BEL19 Sales and Distribution Document Number VBELN
BEL20 Sales and Distribution Document Number VBELN
Master Data Relations Join Conditions
Customer Number
  • S009.MANDT == KNA1.MANDT
  • S009.KUNNR == KNA1.KUNNR
Client S009.MANDT == T000.MANDT
Division
  • Sales Organization
  • Distribution Channel
  • Division
  • Client
  • S009.VKORG == TVTA.VKORG
  • S009.VTWEG == TVTA.VTWEG
  • S009.SPART == TVTA.SPART
  • S009.MANDT == TVTA.MANDT
Sales Organization
  • S009.MANDT == TVKO.MANDT
  • S009.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S009.VTWEG == TVTW.VTWEG
  • S009.MANDT == TVTW.MANDT