S414BIW1

S414BIW1 * SSR DTF statistics | #transactional | Component: Downstream
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
  • S414BIW1.MANDT == T001.MANDT
  • S414BIW1.BUKRS == T001.BUKRS
SSR PC: Clearing house
  • SSR PC: Clearing house
  • Client
  • S414BIW1.CHOBJ == OIRECH.CHOBJ
  • S414BIW1.MANDT == OIRECH.MANDT
Client S414BIW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S414BIW1.MATNR == MARA.MATNR
  • S414BIW1.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
  • S414BIW1.MANDT == T006.MANDT
  • S414BIW1.VRKME == T006.MSEHI
Sales unit
  • S414BIW1.MANDT == T006.MANDT
  • S414BIW1.VRKME_01 == T006.MSEHI
Currency Key
  • S414BIW1.MANDT == TCURC.MANDT
  • S414BIW1.WAERS == TCURC.WAERS
Currency Key
  • S414BIW1.MANDT == TCURC.MANDT
  • S414BIW1.WAERS_02 == TCURC.WAERS