S412

SSR Margin Report | #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
OIRIPBLNR FK Business location identifier (IS-Oil MRN)
MATNR FK Material Number
OISTYP FK Service type
Column Name Description
💲 Statistics Currency (STWAE):
OIRCOMMNET SSR - Location net commission
OIRCOMMVAT SSR - Location vat on commission
OIRPFEENET SSR - Location net participation fee
OIRPFEEVAT SSR - Location net participation vat
OIRFUGR SSR-Location fuel sales gross
OIREBV EBV cost
OIRFCFEES SSR Fleet Card processing fees
OIRCHFEES SSR Clearing house processing fees
OIRFREIGHT Freight cost
OIRPURPR Purchase cost of material
OIRFUNET Fuel sales net
OIRFUVAT Fuel sales vat
Column Name Description
📏 Sales unit (VRKME):
FKIMG Actual billed quantity
📏 Base Unit of Measure (BASME):
FKLMG Billing quantity in stock keeping unit
Column Name Description
SPTAG Period to analyze - current date
Column Name Description
MCUPD Indicator whether statistical record was updated Show values
Column Name Description Domain name
PERIV Fiscal Year Variant PERIV
VWDAT Pointer to administrative data VWDAT
Master Data Relations Join Conditions
Base Unit of Measure
  • S412.MANDT == T006.MANDT
  • S412.BASME == T006.MSEHI
Client S412.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • S412.MATNR == MARA.MATNR
  • S412.MANDT == MARA.MANDT
Business location identifier (IS-Oil MRN)
  • Business location identifier (IS-Oil MRN)
  • Client
Service type
Statistics Currency
  • S412.MANDT == TCURC.MANDT
  • S412.STWAE == TCURC.WAERS
Sales unit
  • S412.MANDT == T006.MANDT
  • S412.VRKME == T006.MSEHI
SD Document Currency
  • S412.MANDT == TCURC.MANDT
  • S412.WAERK == TCURC.WAERS