S441

IS-U Industry Statistics | #transactional | Component: Statistics
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
CITY_CODE FK City code for city/street file
BRANCHE FK Industry sector
KTOKLASSE FK Account Class
BUKRS FK Company Code
SPARTE FK Division
AKLASSE FK Billing Class
TARIFTYP FK Rate category
TARIFNR FK Rate key
Column Name Description
💲 Transaction Currency (TWAERS):
NETTOBTR Net amount of billing line item
Column Name Description
📏 Unit of measurement for billing (MASSBILL):
I_ABRMENGE Billing quantity: energy
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
Billing Class
  • Billing Class
  • Client
Company Code
  • S441.MANDT == T001.MANDT
  • S441.BUKRS == T001.BUKRS
City code for city/street file
  • ?
  • Client
  • City code for city/street file
  • S441.[column in domain "LAND1"] == ADRCITY.COUNTRY
  • S441.MANDT == ADRCITY.CLIENT
  • S441.CITY_CODE == ADRCITY.CITY_CODE
Account Class
  • Account Class
  • Client
Client S441.MANDT == T000.MANDT
Unit of measurement for billing
  • S441.MANDT == T006.MANDT
  • S441.MASSBILL == T006.MSEHI
Division
  • S441.MANDT == TSPA.MANDT
  • S441.SPARTE == TSPA.SPART
Rate key
  • S441.MANDT == ETRF.MANDT
  • S441.TARIFNR == ETRF.TARIFNR
Rate category
  • S441.MANDT == ETTA.MANDT
  • S441.TARIFTYP == ETTA.TARIFTYP
Transaction Currency
  • S441.MANDT == TCURC.MANDT
  • S441.TWAERS == TCURC.WAERS