OIREUPLKXXXX SAP table for – SSR PC: Template for generated DTF tables (header)

Here we would like to draw your attention to OIREUPLKXXXX 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). OIREUPLKXXXX is a SAP standard transp table used for storing SSR PC: Template for generated DTF tables (header) related data in SAP. It comes under the package OIR_E.

SAP OIREUPLKXXXX table

Table OIREUPLKXXXX technical data

TableOIREUPLKXXXX
Data storingSSR PC: Template for generated DTF tables (header)
ModuleIS-OIL
Sub ModuleIS-OIL-DS-SSR
SAP PackageOIR_E
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIREUPLKXXXX 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 OIREUPLKXXXX table.

  • .INCLUDE : Keyfields of the DTF header
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • UPLNR : SSR PC: DTF payment card transaction number (internal)
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : SSR PC: Header fields of the DTF table
  • UPLDAT : SSR PC: Upload date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPLTIM : SSR PC: Upload time
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • PBLNR : Business location identifier (IS-Oil MRN)
    Its data type is CHAR (Character String) with field length 10
  • TERMID : SSR PC: Terminal ID at business location
    Its data type is CHAR (Character String) with field length 20
  • TERMNR : SSR PC: Receipt number of terminal at bus. location
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • CASHIER : SSR PC: Number of the cashier
    Its data type is CHAR (Character String) with field length 10
  • CSHNAME : SSR PC: Name of the cashier
    Its data type is CHAR (Character String) with field length 35
  • VKDAT : SSR PC: Sales date at the service station
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VKTIM : SSR PC: Time of sale
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • CCNUM : SSR PC: Payment card number
    Its data type is CHAR (Character String) with field length 25
  • SSR_CCINS : SSR PC: Payment card type
    Its data type is CHAR (Character String) with field length 4
  • SSR_ADDINFO : SSR PC: Additional payment card information
    Its data type is CHAR (Character String) with field length 20
  • SSR_CCTYP : SSR PC: Payment card category
    Its data type is CHAR (Character String) with field length 2
  • CCFOL : Payment cards: Payment card suffix
    Its data type is CHAR (Character String) with field length 10
  • DATAB : SSR PC: Valid from date of the payment card
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATBI : SSR PC: Expiry date of payment card
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AUTNR : SSR PC: Authorization number
    Its data type is CHAR (Character String) with field length 20
  • BLVER : SSR PC: Version of black list
    Its data type is CHAR (Character String) with field length 20
  • BLDAT : SSR PC: Black list date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • 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
  • 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
  • .INCLUDE : EC Card fields (Payment Cards)
  • TRCNR : SSR PC: Trace number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • AID : SSR PC: Authorization ID for EC cards
    Its data type is CHAR (Character String) with field length 8
  • AIDPA : SSR PC: Authorization ID parameter
    Its data type is CHAR (Character String) with field length 10
  • ECTYP : SSR PC: EC card type
    Its data type is CHAR (Character String) with field length 2
  • ECFOL : SSR PC: EC card suffix
    Its data type is NUMC (Character String with Digits Only) with field length 2
  • ECBHS : SSR PC: Industry main key
    Its data type is CHAR (Character String) with field length 2
  • ECBLZ : SSR PC: Bank number
    Its data type is CHAR (Character String) with field length 10
  • ECSEP : SSR PC: Field separator
    Its data type is CHAR (Character String) with field length 1
  • ECKTO : SSR PC: Account number of the customer
    Its data type is NUMC (Character String with Digits Only) with field length 24
  • ECPRZ : SSR PC: Check digit of account number
    Its data type is NUMC (Character String with Digits Only) with field length 1
  • ISSUER : SSR PC: EC card issuer
    Its data type is CHAR (Character String) with field length 2
  • .INCLUDE : Fleet card fields (Payment Cards)
  • MILES : SSR PC: Odometer reading
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • VEHICLE : SSR PC: Number of the vehicle (fleet cards)
    Its data type is CHAR (Character String) with field length 6
  • DRIVER : SSR PC: Driver number (for fleet cards)
    Its data type is CHAR (Character String) with field length 6
  • .INCLUDE : Payment card specific status fields
  • VAL_ROUTINE : SSR PC: Validation routine
    Its data type is CHAR (Character String) with field length 20
  • SPRES : SSR PC: Splitting result
    Its data type is CHAR (Character String) with field length 4
  • COMPFL : SSR PC: Complaint status flag
    Its data type is CHAR (Character String) with field length 1
  • COMPRES : SSR PC: Complaint result
    Its data type is CHAR (Character String) with field length 3
  • STORNO : SSR PC: Reversal indicator
    Its data type is CHAR (Character String) with field length 1
  • SRCID : SSR PC: Data source indicator
    Its data type is CHAR (Character String) with field length 1
  • DCIND : SSR PC: DTF – Debit/credit indicator for a PC transaction
    Its data type is CHAR (Character String) with field length 1
  • STFLG : SSR PC: Statistical update of PC data
    Its data type is CHAR (Character String) with field length 1
  • SLSTA : SSR PC: Customer sales status
    Its data type is CHAR (Character String) with field length 2
  • WROFLAG : SSR PC: Write off flag for complaint transactions
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Pointers
  • LINKYEAR : Document link number year
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • LINKNR : Link number
    Its data type is NUMC (Character String with Digits Only) with field length 10
  • SETTLDAT : SSR PC: Settlement date to the clearing house
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • SETTLNR : SSR PC: CH settlement and/or transmission document number
    Its data type is CHAR (Character String) with field length 10
  • SETTITEM : SSR PC: Settlement document item number
    Its data type is NUMC (Character String with Digits Only) with field length 6
  • TRNSMNR : SSR PC: Transmission number
    Its data type is CHAR (Character String) with field length 10
  • DTFNR : SSR PC: Preceding DTF doc. number in case of a reversal
    Its data type is CHAR (Character String) with field length 14
  • CHOBJ : SSR PC: Clearing house
    Its data type is CHAR (Character String) with field length 6
  • RECON_NO : Reconciliation run number
    Its data type is CHAR (Character String) with field length 10
  • RECON_DAT : Reconciliation run date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLUDE : Date, time and name of creation and change in txn-data
  • ERDAT : Date on which the record was created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERTIM : Time of creation
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : Name of Person who Created the Object
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Last Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AETIM : Time of day the record was changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : Name of Person Who Changed Object
    Its data type is CHAR (Character String) with field length 12
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes