OIRE_RECON_AGG

Aggregated reconciliation data | #transactional | Component: Service Station Retailing
Column Name Description
MANDT FK Client
UPLNR Clearing House Upload Number (internal)
POSNR Item number of a recon. upload number
Column Name Description
💲 Currency Key (WAERS):
BRTWR SSR PC: Gross value
BRTWR_DEBITS SSR PC: Gross value debits
BRTWR_CREDITS SSR PC: Gross value credits
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
PERIOD_FROM Sales period from (Format: YYYYMMDDhhmmss) TZNTSTMPS
PERIOD_TO Sales period to (Format: YYYYMMDDhhmmss) TZNTSTMPS
NO_DEBITS SSR PC: Counter for number of debits NUMC8
NO_CREDITS SSR PC: Counter for number of credits NUMC8
SSMID SSR PC: Service station merchant ID OIRE_SSMID
SSMIDT SSR PC: Service station merchant ID text OIRE_SSMIDTX
RECON_NO Reconciliation run number OIRE_RECON_NO
SETTLNR SSR PC: CH settlement and/or transmission document number OIRE_SETTLNR
Master Data Relations Join Conditions
SSR PC: Payment card type
  • SSR PC: Payment card type
  • Client
Client OIRE_RECON_AGG.MANDT == T000.MANDT
Business location identifier (IS-Oil MRN)
  • Business location identifier (IS-Oil MRN)
  • Client
  • OIRE_RECON_AGG.PBLNR == OIFSPBL.PBLNR
  • OIRE_RECON_AGG.MANDT == OIFSPBL.MANDT