S014

CAS Document Information | #other | Component: Data Collection
Column Name Description
MANDT 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
💲 Statistics Currency (STWAE):
MIN_VALUE Lowest document value
MAX_VALUE Highest doc.value
DELTA_VAL Mean value of documents
SUM_VALUE Total document value
OFF_VALUE Open value
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
OFF_COUNT Number of open documents MCZAEHLER
OFF_POSI Number of open document items MCZAEHLER
BEL_COUNT Number of documents MCZAEHLER
POSI_COUNT Number of line items MCZAEHLER
Master Data Relations Join Conditions
Customer Number
  • S014.MANDT == KNA1.MANDT
  • S014.KUNNR == KNA1.KUNNR
Division
  • S014.MANDT == TSPA.MANDT
  • S014.SPART == TSPA.SPART
Sales Organization
  • S014.MANDT == TVKO.MANDT
  • S014.VKORG == TVKO.VKORG
Distribution Channel
  • Distribution Channel
  • Client
  • S014.VTWEG == TVTW.VTWEG
  • S014.MANDT == TVTW.MANDT