SAP ABAP Table ROIRE_RECON_LIST_DTF (SSR PC Recon ALV Display for Aggregated Data - DTF Source)

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	INTTAB	Structure
Structure	ROIRE_RECON_LIST_DTF	Table Relationship Diagram
Short Description	SSR PC Recon ALV Display for Aggregated Data - DTF Source

Delivery and Maintenance

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

Foreign Keys

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

History

Last changed by/on	SAP	20110901
SAP Release Created in	46C