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

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS-SSR (Application Component) Service Station Retailing
     ⤷ OIR_E (Package) SSR Card processing (IS-Oil Sevice Station Retailing)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIREUPLKXXXX	Table Relationship Diagram
Short Description	SSR PC: Template for generated DTF tables (header)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☑				0	0	Keyfields of the DTF header
2	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
3	GJAHR	☑	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
4	UPLNR	☑	OIRE_UPLNR	CHAR10	CHAR	10	0	SSR PC: DTF payment card transaction number (internal)
5	.INCLUDE	☐				0	0	SSR PC: Header fields of the DTF table
6	UPLDAT	☐	OIRE_UPLDAT	DATS	DATS	8	0	SSR PC: Upload date
7	UPLTIM	☐	OIRE_UPLTIM	TIME	TIMS	6	0	SSR PC: Upload time
8	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	OIFSPBL
9	TERMID	☐	OIRE_TERMID	CHAR20	CHAR	20	0	SSR PC: Terminal ID at business location
10	TERMNR	☐	OIRE_TERMNR	NUMC10	NUMC	10	0	SSR PC: Receipt number of terminal at bus. location
11	CASHIER	☐	OIRE_CASHIER	CHAR10	CHAR	10	0	SSR PC: Number of the cashier
12	CSHNAME	☐	OIRE_CSHNAME	CHAR35	CHAR	35	0	SSR PC: Name of the cashier
13	VKDAT	☐	OIRE_VKDAT	DATS	DATS	8	0	SSR PC: Sales date at the service station
14	VKTIM	☐	OIRE_VKTIM	OIRE_TIME	TIMS	6	0	SSR PC: Time of sale
15	CCNUM	☐	OIRE_CCNUM	OIRE_CCNUM	CHAR	25	0	SSR PC: Payment card number
16	SSR_CCINS	☐	OIRE_CCINS	OIRE_CCINS	CHAR	4	0	SSR PC: Payment card type	OIREPCTYP
17	SSR_ADDINFO	☐	OIRE_ADDINFO	CHAR20	CHAR	20	0	SSR PC: Additional payment card information
18	SSR_CCTYP	☐	OIRE_CCTYP	OIRE_CCTYP	CHAR	2	0	SSR PC: Payment card category	OIREPCCAT
19	CCFOL	☐	CCFOL	CHAR10	CHAR	10	0	Payment cards: Payment card suffix
20	DATAB	☐	OIRE_DATAB	DATS	DATS	8	0	SSR PC: Valid from date of the payment card
21	DATBI	☐	OIRE_DATBI	DATS	DATS	8	0	SSR PC: Expiry date of payment card
22	AUTNR	☐	OIRE_AUTNR	CHAR20	CHAR	20	0	SSR PC: Authorization number
23	BLVER	☐	OIRE_BLVER	CHAR20	CHAR	20	0	SSR PC: Version of black list
24	BLDAT	☐	OIRE_BLDAT	DATS	DATS	8	0	SSR PC: Black list date
25	BRTWR	☐	OIRE_BRTWR	WERTV7	CURR	13	2	SSR PC: Gross value
26	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
27	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
28	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
29	CRYPTIC_HASH	☐	CCSECA_CRYPTIC_HASH		CHAR	40	0	Hash Value of a Payment Card Number
30	.INCLUDE	☐				0	0	EC Card fields (Payment Cards)
31	TRCNR	☐	OIRE_TRCNR	NUMC10	NUMC	10	0	SSR PC: Trace number
32	AID	☐	OIRE_ECAID	CHAR08	CHAR	8	0	SSR PC: Authorization ID for EC cards
33	AIDPA	☐	OIRE_ECAIDPA	CHAR10	CHAR	10	0	SSR PC: Authorization ID parameter
34	ECTYP	☐	OIRE_ECTYP	CCTYP	CHAR	2	0	SSR PC: EC card type	*
35	ECFOL	☐	OIRE_ECFOL	NUMC2	NUMC	2	0	SSR PC: EC card suffix
36	ECBHS	☐	OIRE_ECBHS	CHAR2	CHAR	2	0	SSR PC: Industry main key
37	ECBLZ	☐	OIRE_ECBLZ	CHAR10	CHAR	10	0	SSR PC: Bank number
38	ECSEP	☐	OIRE_ECSEP	CHAR1	CHAR	1	0	SSR PC: Field separator
39	ECKTO	☐	OIRE_ECKTO	NUMC24	NUMC	24	0	SSR PC: Account number of the customer
40	ECPRZ	☐	OIRE_ECPRZ	NUMC1	NUMC	1	0	SSR PC: Check digit of account number
41	ISSUER	☐	OIRE_ISSUER	CHAR2	CHAR	2	0	SSR PC: EC card issuer
42	.INCLUDE	☐				0	0	Fleet card fields (Payment Cards)
43	MILES	☐	OIRE_MILES	NUMC6	NUMC	6	0	SSR PC: Odometer reading
44	VEHICLE	☐	OIRE_VEHICLE	CHAR6	CHAR	6	0	SSR PC: Number of the vehicle (fleet cards)
45	DRIVER	☐	OIRE_DRIVER	CHAR6	CHAR	6	0	SSR PC: Driver number (for fleet cards)
46	.INCLUDE	☐				0	0	Payment card specific status fields
47	VAL_ROUTINE	☐	OIRE_VAL_BADI	OIRE_VAL_BADI	CHAR	20	0	SSR PC: Validation routine	OIRE_VAL_VAL
48	SPRES	☐	OIRE_SPRES	OIRE_SPRES	CHAR	4	0	SSR PC: Splitting result	OIRESPRES
49	COMPFL	☐	OIRE_COMPFL	OIRE_COMPFL	CHAR	1	0	SSR PC: Complaint status flag
50	COMPRES	☐	OIRE_COMPRES	OIRE_COMPRES	CHAR	3	0	SSR PC: Complaint result	OIRECOMPRES
51	STORNO	☐	OIRE_STORNO	CHAR1	CHAR	1	0	SSR PC: Reversal indicator
52	SRCID	☐	OIRE_SRCID	OIRE_SRCID	CHAR	1	0	SSR PC: Data source indicator
53	DCIND	☐	OIRE_DCIND_HDR	OIRE_DCIND	CHAR	1	0	SSR PC: DTF - Debit/credit indicator for a PC transaction
54	STFLG	☐	OIRE_STFLG	CHAR1	CHAR	1	0	SSR PC: Statistical update of PC data
55	SLSTA	☐	OIRE_SLSTA	CHAR2	CHAR	2	0	SSR PC: Customer sales status	OIRESLSTA
56	WROFLAG	☐	OIRE_WROFLAG	OIRE_COMPFL	CHAR	1	0	SSR PC: Write off flag for complaint transactions
57	.INCLUDE	☐				0	0	Pointers
58	LINKYEAR	☐	OIRA_JAHR	GJAHR	NUMC	4	0	Document link number year
59	LINKNR	☐	OIRA_LINKNR	NUMC10	NUMC	10	0	Link number
60	SETTLDAT	☐	OIRE_SETTLDAT	DATS	DATS	8	0	SSR PC: Settlement date to the clearing house
61	SETTLNR	☐	OIRE_SETTLNR	OIRE_SETTLNR	CHAR	10	0	SSR PC: CH settlement and/or transmission document number	*
62	SETTITEM	☐	OIRE_SETTITEM	POSNR	NUMC	6	0	SSR PC: Settlement document item number	*
63	TRNSMNR	☐	OIRE_TRNSMNR	OIRE_SETTLNR	CHAR	10	0	SSR PC: Transmission number	*
64	DTFNR	☐	OIRE_VBELN	CHAR14	CHAR	14	0	SSR PC: Preceding DTF doc. number in case of a reversal
65	CHOBJ	☐	OIRE_CHOBJ	OIRE_CHOBJ	CHAR	6	0	SSR PC: Clearing house	OIRECH
66	RECON_NO	☐	OIRE_RECON_NO	OIRE_RECON_NO	CHAR	10	0	Reconciliation run number	*
67	RECON_DAT	☐	OIRE_RECON_DAT	DATS	DATS	8	0	Reconciliation run date
68	.INCLUDE	☐				0	0	Date, time and name of creation and change in txn-data
69	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
70	ERTIM	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
71	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
72	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
73	AETIM	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
74	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
75	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIREUPLKXXXX	CHOBJ	OIRECH	CHOBJ
2	OIREUPLKXXXX	COMPRES	OIRECOMPRES	COMPRES
3	OIREUPLKXXXX	MANDT	T000	MANDT	KEY
4	OIREUPLKXXXX	PBLNR	OIFSPBL	PBLNR
5	OIREUPLKXXXX	SLSTA	OIRESLSTA	SLSTA	KEY
6	OIREUPLKXXXX	SPRES	OIRESPRES	SPRES
7	OIREUPLKXXXX	SSR_CCINS	OIREPCTYP	SSR_CCINS
8	OIREUPLKXXXX	SSR_CCTYP	OIREPCCAT	SSR_CCTYP
9	OIREUPLKXXXX	VAL_ROUTINE	OIRE_VAL_VAL	VAL_ROUTINE
10	OIREUPLKXXXX	WAERS	TCURC	WAERS	REF

History

Last changed by/on	SAP	20110901
SAP Release Created in