1. Home
  2. Resources
  3. SAP Tables
  4. OIREUPLKXXXX - SSR PC: Template for generated DTF tables (header)

SAP Table OIREUPLKXXXX

SSR PC: Template for generated DTF tables (header)

OIREUPLKXXXX (SSR PC: Template for generated DTF tables (header)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link OIREUPLKXXXX to other SAP tables.

Source: OIREUPLKXXXX (SSR PC: Template for generated DTF tables (header))

OIREUPLKXXXX table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
GJAHR Fiscal Year GJAHR NUMC 4 0
UPLNR SSR PC: DTF payment card transaction number (internal) OIRE_UPLNR CHAR 10 0
UPLDAT SSR PC: Upload date OIRE_UPLDAT DATS 8 0
UPLTIM SSR PC: Upload time OIRE_UPLTIM TIMS 6 0
PBLNR Business location identifier (IS-Oil MRN) OIF_PBLNR OIFSPBL CHAR 10 0
TERMID SSR PC: Terminal ID at business location OIRE_TERMID CHAR 20 0
TERMNR SSR PC: Receipt number of terminal at bus. location OIRE_TERMNR NUMC 10 0
CASHIER SSR PC: Number of the cashier OIRE_CASHIER CHAR 10 0
CSHNAME SSR PC: Name of the cashier OIRE_CSHNAME CHAR 35 0
VKDAT SSR PC: Sales date at the service station OIRE_VKDAT DATS 8 0
VKTIM SSR PC: Time of sale OIRE_VKTIM TIMS 6 0
CCNUM SSR PC: Payment card number OIRE_CCNUM CHAR 25 0
SSR_CCINS SSR PC: Payment card type OIRE_CCINS OIREPCTYP CHAR 4 0
SSR_ADDINFO SSR PC: Additional payment card information OIRE_ADDINFO CHAR 20 0
SSR_CCTYP SSR PC: Payment card category OIRE_CCTYP OIREPCCAT CHAR 2 0
CCFOL Payment cards: Payment card suffix CCFOL CHAR 10 0
DATAB SSR PC: Valid from date of the payment card OIRE_DATAB DATS 8 0
DATBI SSR PC: Expiry date of payment card OIRE_DATBI DATS 8 0
AUTNR SSR PC: Authorization number OIRE_AUTNR CHAR 20 0
BLVER SSR PC: Version of black list OIRE_BLVER CHAR 20 0
BLDAT SSR PC: Black list date OIRE_BLDAT DATS 8 0
BRTWR SSR PC: Gross value OIRE_BRTWR CURR 13 2
WAERS Currency Key WAERS TCURC CUKY 5 0
CGUID GUID of a Payment Card CARD_GUID RAW 16 0
ENCTP Type of Encryption CCSECA_ENCTYPE CHAR 1 0
1 Data in PCA_SECURITY_RAW
2 Data in CCSEC_ENC or CCSEC_ENCV
3 Data in CCARDEC
CRYPTIC_HASH Hash Value of a Payment Card Number CCSECA_CRYPTIC_HASH CHAR 40 0
TRCNR SSR PC: Trace number OIRE_TRCNR NUMC 10 0
AID SSR PC: Authorization ID for EC cards OIRE_ECAID CHAR 8 0
AIDPA SSR PC: Authorization ID parameter OIRE_ECAIDPA CHAR 10 0
ECTYP SSR PC: EC card type OIRE_ECTYP CHAR 2 0
ECFOL SSR PC: EC card suffix OIRE_ECFOL NUMC 2 0
ECBHS SSR PC: Industry main key OIRE_ECBHS CHAR 2 0
ECBLZ SSR PC: Bank number OIRE_ECBLZ CHAR 10 0
ECSEP SSR PC: Field separator OIRE_ECSEP CHAR 1 0
ECKTO SSR PC: Account number of the customer OIRE_ECKTO NUMC 24 0
ECPRZ SSR PC: Check digit of account number OIRE_ECPRZ NUMC 1 0
1
ISSUER SSR PC: EC card issuer OIRE_ISSUER CHAR 2 0
MILES SSR PC: Odometer reading OIRE_MILES NUMC 6 0
VEHICLE SSR PC: Number of the vehicle (fleet cards) OIRE_VEHICLE CHAR 6 0
DRIVER SSR PC: Driver number (for fleet cards) OIRE_DRIVER CHAR 6 0
VAL_ROUTINE SSR PC: Validation routine OIRE_VAL_BADI OIRE_VAL_VAL CHAR 20 0
SPRES SSR PC: Splitting result OIRE_SPRES OIRESPRES CHAR 4 0
COMPFL SSR PC: Complaint status flag OIRE_COMPFL CHAR 1 0
1 PC transaction marked as complaint, but not investigated yet
2 Complaint result determined, but not processed yet.
3 Complaint result determined and processed.
COMPRES SSR PC: Complaint result OIRE_COMPRES OIRECOMPRES CHAR 3 0
STORNO SSR PC: Reversal indicator OIRE_STORNO CHAR 1 0
SRCID SSR PC: Data source indicator OIRE_SRCID CHAR 1 0
1 Manual input of PC transaction
2 POS system
3 Clearing house
4 Reversal
DCIND SSR PC: DTF - Debit/credit indicator for a PC transaction OIRE_DCIND_HDR CHAR 1 0
D Debit
C Credit
STFLG SSR PC: Statistical update of PC data OIRE_STFLG CHAR 1 0
SLSTA SSR PC: Customer sales status OIRE_SLSTA OIRESLSTA CHAR 2 0
WROFLAG SSR PC: Write off flag for complaint transactions OIRE_WROFLAG CHAR 1 0
1 PC transaction marked as complaint, but not investigated yet
2 Complaint result determined, but not processed yet.
3 Complaint result determined and processed.
LINKYEAR Document link number year OIRA_JAHR NUMC 4 0
LINKNR Link number OIRA_LINKNR NUMC 10 0
SETTLDAT SSR PC: Settlement date to the clearing house OIRE_SETTLDAT DATS 8 0
SETTLNR SSR PC: CH settlement and/or transmission document number OIRE_SETTLNR CHAR 10 0
SETTITEM SSR PC: Settlement document item number OIRE_SETTITEM NUMC 6 0
TRNSMNR SSR PC: Transmission number OIRE_TRNSMNR CHAR 10 0
DTFNR SSR PC: Preceding DTF doc. number in case of a reversal OIRE_VBELN CHAR 14 0
CHOBJ SSR PC: Clearing house OIRE_CHOBJ OIRECH CHAR 6 0
RECON_NO Reconciliation run number OIRE_RECON_NO CHAR 10 0
RECON_DAT Reconciliation run date OIRE_RECON_DAT DATS 8 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
ERTIM Time of creation OI0_ERTIM TIMS 6 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
AEDAT Changed On AEDAT DATS 8 0
AETIM Time of day the record was changed OI0_AETIM TIMS 6 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0

OIREUPLKXXXX foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
OIREUPLKXXXX CHOBJ * OIRECH SSR PC: Clearing House table (IS-Oil SSR) MANDT
OIREUPLKXXXX CHOBJ OIREUPLKXXXX CHOBJ OIRECH SSR PC: Clearing House table (IS-Oil SSR) CHOBJ
OIREUPLKXXXX COMPRES * OIRECOMPRES SSR PC: Complaint results MANDT
OIREUPLKXXXX COMPRES OIREUPLKXXXX COMPRES OIRECOMPRES SSR PC: Complaint results COMPRES
OIREUPLKXXXX MANDT OIREUPLKXXXX MANDT T000 Clients MANDT
OIREUPLKXXXX PBLNR OIREUPLKXXXX PBLNR OIFSPBL Physical Location - Master Data PBLNR
OIREUPLKXXXX PBLNR OIREUPLKXXXX MANDT OIFSPBL Physical Location - Master Data MANDT
OIREUPLKXXXX SLSTA OIREUPLKXXXX SLSTA OIRESLSTA SSR PC: Sales status of the PC transactions SLSTA
OIREUPLKXXXX SLSTA SYST MANDT OIRESLSTA SSR PC: Sales status of the PC transactions MANDT
OIREUPLKXXXX SPRES OIREUPLKXXXX SPRES OIRESPRES SSR PC: Splitting Result SPRES
OIREUPLKXXXX SPRES * OIRESPRES SSR PC: Splitting Result MANDT
OIREUPLKXXXX SSR_CCINS OIREUPLKXXXX SSR_CCINS OIREPCTYP SSR PC: Payment Card Type SSR_CCINS
OIREUPLKXXXX SSR_CCINS * OIREPCTYP SSR PC: Payment Card Type MANDT
OIREUPLKXXXX SSR_CCTYP * OIREPCCAT SSR PC: Categories MANDT
OIREUPLKXXXX SSR_CCTYP OIREUPLKXXXX SSR_CCTYP OIREPCCAT SSR PC: Categories SSR_CCTYP
OIREUPLKXXXX VAL_ROUTINE OIREUPLKXXXX VAL_ROUTINE OIRE_VAL_VAL SSR PC: Validation routine VAL_ROUTINE
OIREUPLKXXXX WAERS OIREUPLKXXXX MANDT TCURC Currency Codes MANDT
OIREUPLKXXXX WAERS OIREUPLKXXXX WAERS TCURC Currency Codes WAERS