OIRE_RECON_DET SAP table for – Detailed reconciliation data

Here we would like to draw your attention to OIRE_RECON_DET 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_DET is a SAP standard transp table used for storing Detailed reconciliation data related data in SAP. It comes under the package OIR_E.

SAP OIRE_RECON_DET table

Table OIRE_RECON_DET technical data

TableOIRE_RECON_DET
Data storingDetailed 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_DET 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_DET 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
  • CCNUM : SSR PC: Payment card number
    Its data type is CHAR (Character String) with field length 25
  • SALES_TIMESTMP : Sales timestamp (Format: YYYYMMDDhhmmss)
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15
  • TERMNR : SSR PC: Receipt number of terminal at bus. location
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • 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
  • AUTNR : SSR PC: Authorization number
    Its data type is CHAR (Character String) with field length 20
  • 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
  • CGUID : GUID of a Payment Card
    Its data type is RAW (Byte string) with field length 16
  • ENCTP : Type of Encryption
    Its data type is CHAR (Character String) with field length 1
  • CRYPTIC_HASH : Hash Value of a Payment Card Number
    Its data type is CHAR (Character String) with field length 40