OIRE_RECON_AGG SAP table for – Aggregated reconciliation data

Here we would like to draw your attention to OIRE_RECON_AGG table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIRE_RECON_AGG is a SAP standard transp table used for storing Aggregated reconciliation data related data in SAP. It comes under the package OIR_E.

SAP OIRE_RECON_AGG table

Table OIRE_RECON_AGG technical data

TableOIRE_RECON_AGG
Data storingAggregated reconciliation data
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR_E
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIRE_RECON_AGG Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in OIRE_RECON_AGG table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • UPLNR : Clearing House Upload Number (internal)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • POSNR : Item number of a recon. upload number
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • PBLNR : Business location identifier (IS-Oil MRN)
    Its data type is CHAR (Character String) with field length 10
  • CCINS : SSR PC: Payment card type
    Its data type is CHAR (Character String) with field length 4
  • PERIOD_FROM : Sales period from (Format: YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • PERIOD_TO : Sales period to (Format: YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • BRTWR : SSR PC: Gross value
    Its data type is CURR (Currency Field) with field length 13
  • WAERS : Currency Key
    Its data type is CUKY (Currency key for a currency field) with field length 5
  • NO_DEBITS : SSR PC: Counter for number of debits
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • NO_CREDITS : SSR PC: Counter for number of credits
    Its data type is NUMC (Character String with Digits Only) with field length 8
  • BRTWR_DEBITS : SSR PC: Gross value debits
    Its data type is CURR (Currency Field) with field length 13
  • BRTWR_CREDITS : SSR PC: Gross value credits
    Its data type is CURR (Currency Field) with field length 13
  • SSMID : SSR PC: Service station merchant ID
    Its data type is CHAR (Character String) with field length 20
  • SSMIDT : SSR PC: Service station merchant ID text
    Its data type is CHAR (Character String) with field length 50
  • RECON_NO : Reconciliation run number
    Its data type is CHAR (Character String) with field length 10
  • SETTLNR : SSR PC: CH settlement and/or transmission document number
    Its data type is CHAR (Character String) with field length 10