S413

SSR - Monthly/Daily Loc.Inv. | #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)
PKUNRG FK Payer
Column Name Description
💲 Statistics Currency (STWAE):
OIRCOMMNET SSR - Location net commission
OIRCOMMVAT SSR - Location vat on commission
OIRTOTGR SSR-Location total gros
OIRPYTCDGR SSR - Location payment card gross
OIRPFEENET SSR - Location net participation fee
OIRPFEEVAT SSR - Location net participation vat
OIRFLFUGR SSR - Location fleet card gross fuel sales
OIRDOPVAT SSR-Location fleet dealer owned products vat
OIRDOPGR SSR-Location fleet dealer owned products gross
OIRFUGR SSR-Location fuel sales gross
OIRREDUCT SSR-Location dealer daily claim reduction
Column Name Description
📏 Sales unit (VRKME):
FKIMG Actual billed quantity
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
Client S413.MANDT == T000.MANDT
Business location identifier (IS-Oil MRN)
  • Business location identifier (IS-Oil MRN)
  • Client
Payer
  • S413.MANDT == KNA1.MANDT
  • S413.PKUNRG == KNA1.KUNNR
Statistics Currency
  • S413.MANDT == TCURC.MANDT
  • S413.STWAE == TCURC.WAERS
Sales unit
  • S413.MANDT == T006.MANDT
  • S413.VRKME == T006.MSEHI
SD Document Currency
  • S413.MANDT == TCURC.MANDT
  • S413.WAERK == TCURC.WAERS