SAP ABAP Table OIRE_RECON_DET (Detailed reconciliation data)
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 | OIRE_RECON_DET |
![]() |
Short Description | Detailed reconciliation data |
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 | ![]() |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ![]() |
OIRE_UPLNR_RECON | OIRE_UPLNR | CHAR | 10 | 0 | Clearing House Upload Number (internal) | OIRE_RECON_ADM | |
3 | ![]() |
OIRE_POSNR_RECON | NUMC6 | NUMC | 6 | 0 | Item number of a recon. upload number | ||
4 | ![]() |
OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | OIFSPBL | |
5 | ![]() |
OIRE_CCINS | OIRE_CCINS | CHAR | 4 | 0 | SSR PC: Payment card type | OIREPCTYP | |
6 | ![]() |
OIRE_CCNUM | OIRE_CCNUM | CHAR | 25 | 0 | SSR PC: Payment card number | ||
7 | ![]() |
OIRE_SALES_TIMESTAMP_UTC | TZNTSTMPS | DEC | 15 | 0 | Sales timestamp (Format: YYYYMMDDhhmmss) | ||
8 | ![]() |
OIRE_TERMNR | NUMC10 | NUMC | 10 | 0 | SSR PC: Receipt number of terminal at bus. location | ||
9 | ![]() |
OIRE_BRTWR | WERTV7 | CURR | 13 | 2 | SSR PC: Gross value | ||
10 | ![]() |
WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
11 | ![]() |
OIRE_AUTNR | CHAR20 | CHAR | 20 | 0 | SSR PC: Authorization number | ||
12 | ![]() |
OIRE_SSMID | OIRE_SSMID | CHAR | 20 | 0 | SSR PC: Service station merchant ID | ||
13 | ![]() |
OIRE_SSMIDTX | OIRE_SSMIDTX | CHAR | 50 | 0 | SSR PC: Service station merchant ID text | ||
14 | ![]() |
OIRE_RECON_NO | OIRE_RECON_NO | CHAR | 10 | 0 | Reconciliation run number | * | |
15 | ![]() |
OIRE_SETTLNR | OIRE_SETTLNR | CHAR | 10 | 0 | SSR PC: CH settlement and/or transmission document number | * | |
16 | ![]() |
CARD_GUID | SYSUUID | RAW | 16 | 0 | GUID of a Payment Card | ||
17 | ![]() |
CCSECA_ENCTYPE | CCSECA_ENCTYPE | CHAR | 1 | 0 | Type of Encryption | ||
18 | ![]() |
CCSECA_CRYPTIC_HASH | CHAR | 40 | 0 | Hash Value of a Payment Card Number |
Foreign Keys
![]() |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
---|---|---|---|---|---|---|---|
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
![]() |
1 | OIRE_RECON_DET | CCINS | ![]() |
![]() |
REF | 1 | CN |
2 | OIRE_RECON_DET | MANDT | ![]() |
![]() |
KEY | 1 | CN |
3 | OIRE_RECON_DET | PBLNR | ![]() |
![]() |
REF | 1 | CN |
4 | OIRE_RECON_DET | UPLNR | ![]() |
![]() |
KEY | 1 | N |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |