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

SAP table OIREUPLKXXXX has 3 primary key fields being MANDT,GJAHR,UPLNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

OIREUPLKXXXX foreign key relationships

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