SAP ABAP Table ROIREDTF (Display structure for payment card transaction)

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	ROIREDTF	Table Relationship Diagram
Short Description	Display structure for payment card transaction

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	POSNR	☐	POSNR	POSNR	NUMC	6	0	Item number of the SD document	*
2	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
3	UPLNR	☐	OIRE_UPLNR	CHAR10	CHAR	10	0	SSR PC: DTF payment card transaction number (internal)
4	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
5	BLPLACE	☐	OIRE_BLPLACE	OIRE_BLPLACE	CHAR	2	0	SSR PC: Black list storage place	OIREBLSTPL
6	BLPLACET	☐	OIRE_BLPLACET	CHAR30	CHAR	30	0	SSR PC: Black list storage place text
7	TOTAL	☐	OIRE_TOTAL	WERTV7	CURR	13	2	SSR PC: Total amount of the PC transaction
8	TOTALW	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
9	OCFEE	☐	OIRE_OCFEE	WERTV6	CURR	11	2	SSR PC: Fee paid by oil company to clearing house
10	OCFEEW	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
11	DEFEE	☐	OIRE_DEFEE	WERTV6	CURR	11	2	SSR PC: Participation fee of the service station partner
12	DEFEEW	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
13	BLCHK	☐	OIRE_BLCHK	OIRE_BLCHK	CURR	15	2	SSR PC: Black list check amount
14	BLCHKW	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
15	CHCHK	☐	OIRE_CHCHK	OIRE_CHCHK	CURR	15	2	SSR PC: Clearing house check amount
16	CHCHKW	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
17	DEKUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
18	DEINVDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
19	DEFIBDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
20	CHKUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	*
21	CHINVDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
22	CHFIBDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
23	DTFTAB_TXT	☐	OIRE_DTFTAB_TXT	CHAR16	CHAR	16	0	SSR PC: Text field for name of DTF table
24	CCINS_TXT	☐	OIRE_CCINST	TEXT30	CHAR	30	0	SSR PC: Payment card type texts
25	CCTYP_TXT	☐	OIRE_CCTYPT	TEXT30	CHAR	30	0	SSR PC: Text to describe the payment card category
26	COMPR_TXT	☐	OIRE_COMPREST	OIRE_COMPREST	CHAR	30	0	SSR PC: Complaint result text
27	VALST_TXT	☐	OIRE_DESCR	TEXT50	CHAR	50	0	SSR PC: Descriptive text
28	SPREST	☐	OIRE_SPREST	OIRE_SPREST	CHAR	30	0	SSR PC: Split result text
29	DENAME	☐	NAME1	TEXT30	CHAR	30	0	Name
30	CHNAME	☐	NAME1	TEXT30	CHAR	30	0	Name
31	ACCESS_DTF	☐	OIRE_ACCESS	OIRE_ACCESS	NUMC	1	0	SSR PC: Access sequence for function OIRE_READ_DTF
32	PBLNR_TXT	☐	NAME1	TEXT30	CHAR	30	0	Name
33	CHOBJT	☐	OIRE_CHOBJT	CHAR30	CHAR	30	0	SSR PC: Clearing house name
34	HELP_FIELD	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
35	DEINV	☐	OIRE_DEINV	VBELN	CHAR	10	0	SSR PC: Invoice number to the dealer	*
36	CHINV	☐	OIRE_CHINV	VBELN	CHAR	10	0	SSR PC: Number of invoice for clearing house	*
37	DEFIB	☐	OIRE_DEFIB	BELNR	CHAR	10	0	SSR PC: FI document to the dealer
38	CHFIB	☐	OIRE_CHFIB	BELNR	CHAR	10	0	SSR PC: FI document for clearing house
39	PCMONTH	☐	OIRE_MONTH	NUMC2	NUMC	2	0	SSR PC: Month of the expiry of the payment card
40	PCYEAR	☐	OIRE_YEAR	NUMC2	NUMC	2	0	SSR PC: Year of the expiry of the payment card
41	CHDISC	☐	OIRE_CHDISC	WERTV6	CURR	11	2	SSR PC: Discount received from the clearing house/FCC
42	CHDISC_WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
43	.INCLUDE	☐				0	0	Structure to capture the PC indicators
44	FCIND	☐	OIRE_FCIND	CHAR1	CHAR	1	0	SSR PC: Fleet card
45	ECIND	☐	OIRE_ECIND	CHAR1	CHAR	1	0	SSR PC: EC card indicator
46	CCIND	☐	OIRE_CCIND	CHAR1	CHAR	1	0	SSR PC: Credit card indicator
47	CAIND	☐	OIRE_CAIND	CHAR1	CHAR	1	0	SSR PC: Cash indicator
48	.INCLUDE	☐				0	0	SSR PC: Header fields of the DTF table
49	UPLDAT	☐	OIRE_UPLDAT	DATS	DATS	8	0	SSR PC: Upload date
50	UPLTIM	☐	OIRE_UPLTIM	TIME	TIMS	6	0	SSR PC: Upload time
51	PBLNR	☐	OIF_PBLNR	OIF_PBLNR	CHAR	10	0	Business location identifier (IS-Oil MRN)	*
52	TERMID	☐	OIRE_TERMID	CHAR20	CHAR	20	0	SSR PC: Terminal ID at business location
53	TERMNR	☐	OIRE_TERMNR	NUMC10	NUMC	10	0	SSR PC: Receipt number of terminal at bus. location
54	CASHIER	☐	OIRE_CASHIER	CHAR10	CHAR	10	0	SSR PC: Number of the cashier
55	CSHNAME	☐	OIRE_CSHNAME	CHAR35	CHAR	35	0	SSR PC: Name of the cashier
56	VKDAT	☐	OIRE_VKDAT	DATS	DATS	8	0	SSR PC: Sales date at the service station
57	VKTIM	☐	OIRE_VKTIM	OIRE_TIME	TIMS	6	0	SSR PC: Time of sale
58	CCNUM	☐	OIRE_CCNUM	OIRE_CCNUM	CHAR	25	0	SSR PC: Payment card number
59	SSR_CCINS	☐	OIRE_CCINS	OIRE_CCINS	CHAR	4	0	SSR PC: Payment card type	OIREPCTYP
60	SSR_ADDINFO	☐	OIRE_ADDINFO	CHAR20	CHAR	20	0	SSR PC: Additional payment card information
61	SSR_CCTYP	☐	OIRE_CCTYP	OIRE_CCTYP	CHAR	2	0	SSR PC: Payment card category	OIREPCCAT
62	CCFOL	☐	CCFOL	CHAR10	CHAR	10	0	Payment cards: Payment card suffix
63	DATAB	☐	OIRE_DATAB	DATS	DATS	8	0	SSR PC: Valid from date of the payment card
64	DATBI	☐	OIRE_DATBI	DATS	DATS	8	0	SSR PC: Expiry date of payment card
65	AUTNR	☐	OIRE_AUTNR	CHAR20	CHAR	20	0	SSR PC: Authorization number
66	BLVER	☐	OIRE_BLVER	CHAR20	CHAR	20	0	SSR PC: Version of black list
67	BLDAT	☐	OIRE_BLDAT	DATS	DATS	8	0	SSR PC: Black list date
68	BRTWR	☐	OIRE_BRTWR	WERTV7	CURR	13	2	SSR PC: Gross value
69	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
70	CGUID	☐	CARD_GUID	SYSUUID	RAW	16	0	GUID of a Payment Card
71	ENCTP	☐	CCSECA_ENCTYPE	CCSECA_ENCTYPE	CHAR	1	0	Type of Encryption
72	CRYPTIC_HASH	☐	CCSECA_CRYPTIC_HASH		CHAR	40	0	Hash Value of a Payment Card Number
73	.INCLUDE	☐				0	0	EC Card fields (Payment Cards)
74	TRCNR	☐	OIRE_TRCNR	NUMC10	NUMC	10	0	SSR PC: Trace number
75	AID	☐	OIRE_ECAID	CHAR08	CHAR	8	0	SSR PC: Authorization ID for EC cards
76	AIDPA	☐	OIRE_ECAIDPA	CHAR10	CHAR	10	0	SSR PC: Authorization ID parameter
77	ECTYP	☐	OIRE_ECTYP	CCTYP	CHAR	2	0	SSR PC: EC card type	*
78	ECFOL	☐	OIRE_ECFOL	NUMC2	NUMC	2	0	SSR PC: EC card suffix
79	ECBHS	☐	OIRE_ECBHS	CHAR2	CHAR	2	0	SSR PC: Industry main key
80	ECBLZ	☐	OIRE_ECBLZ	CHAR10	CHAR	10	0	SSR PC: Bank number
81	ECSEP	☐	OIRE_ECSEP	CHAR1	CHAR	1	0	SSR PC: Field separator
82	ECKTO	☐	OIRE_ECKTO	NUMC24	NUMC	24	0	SSR PC: Account number of the customer
83	ECPRZ	☐	OIRE_ECPRZ	NUMC1	NUMC	1	0	SSR PC: Check digit of account number
84	ISSUER	☐	OIRE_ISSUER	CHAR2	CHAR	2	0	SSR PC: EC card issuer
85	.INCLUDE	☐				0	0	Fleet card fields (Payment Cards)
86	MILES	☐	OIRE_MILES	NUMC6	NUMC	6	0	SSR PC: Odometer reading
87	VEHICLE	☐	OIRE_VEHICLE	CHAR6	CHAR	6	0	SSR PC: Number of the vehicle (fleet cards)
88	DRIVER	☐	OIRE_DRIVER	CHAR6	CHAR	6	0	SSR PC: Driver number (for fleet cards)
89	.INCLUDE	☐				0	0	Payment card specific status fields
90	VAL_ROUTINE	☐	OIRE_VAL_BADI	OIRE_VAL_BADI	CHAR	20	0	SSR PC: Validation routine	OIRE_VAL_VAL
91	SPRES	☐	OIRE_SPRES	OIRE_SPRES	CHAR	4	0	SSR PC: Splitting result	OIRESPRES
92	COMPFL	☐	OIRE_COMPFL	OIRE_COMPFL	CHAR	1	0	SSR PC: Complaint status flag
93	COMPRES	☐	OIRE_COMPRES	OIRE_COMPRES	CHAR	3	0	SSR PC: Complaint result	OIRECOMPRES
94	STORNO	☐	OIRE_STORNO	CHAR1	CHAR	1	0	SSR PC: Reversal indicator
95	SRCID	☐	OIRE_SRCID	OIRE_SRCID	CHAR	1	0	SSR PC: Data source indicator
96	DCIND	☐	OIRE_DCIND_HDR	OIRE_DCIND	CHAR	1	0	SSR PC: DTF - Debit/credit indicator for a PC transaction
97	STFLG	☐	OIRE_STFLG	CHAR1	CHAR	1	0	SSR PC: Statistical update of PC data
98	SLSTA	☐	OIRE_SLSTA	CHAR2	CHAR	2	0	SSR PC: Customer sales status	OIRESLSTA
99	WROFLAG	☐	OIRE_WROFLAG	OIRE_COMPFL	CHAR	1	0	SSR PC: Write off flag for complaint transactions
100	.INCLUDE	☐				0	0	Pointers
101	LINKYEAR	☐	OIRA_JAHR	GJAHR	NUMC	4	0	Document link number year
102	LINKNR	☐	OIRA_LINKNR	NUMC10	NUMC	10	0	Link number
103	SETTLDAT	☐	OIRE_SETTLDAT	DATS	DATS	8	0	SSR PC: Settlement date to the clearing house
104	SETTLNR	☐	OIRE_SETTLNR	OIRE_SETTLNR	CHAR	10	0	SSR PC: CH settlement and/or transmission document number	*
105	SETTITEM	☐	OIRE_SETTITEM	POSNR	NUMC	6	0	SSR PC: Settlement document item number	*
106	TRNSMNR	☐	OIRE_TRNSMNR	OIRE_SETTLNR	CHAR	10	0	SSR PC: Transmission number	*
107	DTFNR	☐	OIRE_VBELN	CHAR14	CHAR	14	0	SSR PC: Preceding DTF doc. number in case of a reversal
108	CHOBJ	☐	OIRE_CHOBJ	OIRE_CHOBJ	CHAR	6	0	SSR PC: Clearing house	OIRECH
109	RECON_NO	☐	OIRE_RECON_NO	OIRE_RECON_NO	CHAR	10	0	Reconciliation run number	*
110	RECON_DAT	☐	OIRE_RECON_DAT	DATS	DATS	8	0	Reconciliation run date
111	.INCLUDE	☐				0	0	Date, time and name of creation and change (IS-Oil SSR)
112	ERDAT	☐	OIF_ERDAT	DATS	DATS	8	0	Date Record Created on (Date)
113	ERTIM	☐	OIF_ERZEIT	TIME	TIMS	6	0	Time Record Created at (Time)
114	ERNAM	☐	OIF_ERNAM	USNAM	CHAR	12	0	User who Created Record
115	AEDAT	☐	OIF_AEDAT	DATS	DATS	8	0	Date Record Changed on (Date)
116	AETIM	☐	OIF_AEZEIT	TIME	TIMS	6	0	Time when Record Was Changed
117	AENAM	☐	OIF_AENAM	USNAM	CHAR	12	0	User who Changed Record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIREDTF	BLPLACE	OIREBLSTPL	BLPLACE		1	CN
2	ROIREDTF	BUKRS	T001	BUKRS		1	CN
3	ROIREDTF	CHOBJ	OIRECH	CHOBJ
4	ROIREDTF	COMPRES	OIRECOMPRES	COMPRES
5	ROIREDTF	SLSTA	OIRESLSTA	SLSTA	KEY
6	ROIREDTF	SPRES	OIRESPRES	SPRES
7	ROIREDTF	SSR_CCINS	OIREPCTYP	SSR_CCINS
8	ROIREDTF	SSR_CCTYP	OIREPCCAT	SSR_CCTYP	KEY	1	N
9	ROIREDTF	VAL_ROUTINE	OIRE_VAL_VAL	VAL_ROUTINE
10	ROIREDTF	WAERS	TCURC	WAERS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in