S414

SSR DTF statistics | #transactional | Component: Service Station Retailing
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
BUKRS FK Company Code
PBLNR FK Business location identifier (IS-Oil MRN)
SSR_CCINS FK SSR PC: Payment card type
MATNR FK Material Number
VRKME_01 FK Sales unit
WAERS_02 FK Currency Key
CHOBJ FK SSR PC: Clearing house
STYP FK Service type
Column Name Description
💲 Currency Key (WAERS):
BRTWR SSR PC: Gross value
OCFEE SSR PC: Fee paid by oil company to clearing house
DEFEE SSR PC: Participation fee of the service station partner
CHDISC SSR PC: Discount received from the clearing house/FCC
Column Name Description
📏 Sales unit (VRKME):
MENGE SSR PC: Quantity sold at the business location
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
NUMHDR Number of DTF transaction headers OIRE_NUMHEAD
NUMITM Number of DTF transaction items OIRE_NUMHEAD
NUMHDR_FEE Number of DTF transaction headers OIRE_NUMHEAD
NUMITM_FEE Number of DTF transaction items OIRE_NUMHEAD
Master Data Relations Join Conditions
Company Code
  • S414.MANDT == T001.MANDT
  • S414.BUKRS == T001.BUKRS
SSR PC: Clearing house
  • SSR PC: Clearing house
  • Client
Client S414.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S414.MATNR == MARA.MATNR
  • S414.MANDT == MARA.MANDT
Business location identifier (IS-Oil MRN)
  • Business location identifier (IS-Oil MRN)
  • Client
SSR PC: Payment card type
  • SSR PC: Payment card type
  • Client
Service type
Sales unit
  • S414.MANDT == T006.MANDT
  • S414.VRKME == T006.MSEHI
Sales unit
  • S414.MANDT == T006.MANDT
  • S414.VRKME_01 == T006.MSEHI
Currency Key
  • S414.MANDT == TCURC.MANDT
  • S414.WAERS == TCURC.WAERS
Currency Key
  • S414.MANDT == TCURC.MANDT
  • S414.WAERS_02 == TCURC.WAERS