SAP ABAP Table ROIRE_RECON_LISTD (SSR PC Recon ALV Display Proposed Reconciliation-Detail 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)
⤷ 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_LISTD | Table Relationship Diagram |
Short Description | SSR PC Recon ALV Display Proposed Reconciliation-Detail Data |
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 Recon: Structure type for Detailed Data View | |||||
3 | .INCLUDE | 0 | 0 | Generated Table for View | |||||
4 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
5 | UPLNR | OIRE_UPLNR_RECON | OIRE_UPLNR | CHAR | 10 | 0 | Clearing House Upload Number (internal) | OIRE_RECON_ADM | |
6 | POSNR | OIRE_POSNR_RECON | NUMC6 | NUMC | 6 | 0 | Item number of a recon. upload number | ||
7 | UPLDAT | OIRE_UPLDAT | DATS | DATS | 8 | 0 | SSR PC: Upload date | ||
8 | UPLTIM | OIRE_UPLTIM | TIME | TIMS | 6 | 0 | SSR PC: Upload time | ||
9 | CHOBJ | OIRE_CHOBJ | OIRE_CHOBJ | CHAR | 6 | 0 | SSR PC: Clearing house | OIRECH | |
10 | BRTWR_ADM | OIRE_BRTWR_TOTAL | WERTV7 | CURR | 13 | 2 | SSR PC: Total Value (of Upload) | ||
11 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | TCURC | |
12 | NO_TRANX | OIRE_COUNTER_TRANX | NUMC8 | NUMC | 8 | 0 | SSR PC: Counter for number of transactions | ||
13 | COUNTER_CH | OIRE_COUNTER_CH | NUMC6 | NUMC | 6 | 0 | Counter from the clearing house | ||
14 | DET_AGG_IND | OIRE_DET_AGG_IND | OIRE_DET_AGG_IND | CHAR | 1 | 0 | Detail/Aggregation indicator (values: D or A) | ||
15 | PBLNR | OIF_PBLNR | OIF_PBLNR | CHAR | 10 | 0 | Business location identifier (IS-Oil MRN) | OIFSPBL | |
16 | CCINS | OIRE_CCINS | OIRE_CCINS | CHAR | 4 | 0 | SSR PC: Payment card type | OIREPCTYP | |
17 | CCNUM | OIRE_CCNUM | OIRE_CCNUM | CHAR | 25 | 0 | SSR PC: Payment card number | ||
18 | TERMNR | OIRE_TERMNR | NUMC10 | NUMC | 10 | 0 | SSR PC: Receipt number of terminal at bus. location | ||
19 | BRTWR_DET | OIRE_BRTWR | WERTV7 | CURR | 13 | 2 | SSR PC: Gross value | ||
20 | AUTNR | OIRE_AUTNR | CHAR20 | CHAR | 20 | 0 | SSR PC: Authorization number | ||
21 | SSMID | OIRE_SSMID | OIRE_SSMID | CHAR | 20 | 0 | SSR PC: Service station merchant ID | ||
22 | SSMIDT | OIRE_SSMIDTX | OIRE_SSMIDTX | CHAR | 50 | 0 | SSR PC: Service station merchant ID text | ||
23 | RECON_NO | OIRE_RECON_NO | OIRE_RECON_NO | CHAR | 10 | 0 | Reconciliation run number | * | |
24 | SETTLNR | OIRE_SETTLNR | OIRE_SETTLNR | CHAR | 10 | 0 | SSR PC: CH settlement and/or transmission document number | * | |
25 | SALES_TIMESTMP | OIRE_SALES_TIMESTAMP_UTC | TZNTSTMPS | DEC | 15 | 0 | Sales timestamp (Format: YYYYMMDDhhmmss) | ||
26 | VKDAT | OIRE_VKDAT | DATS | DATS | 8 | 0 | SSR PC: Sales date at the service station | ||
27 | VKTIM | OIRE_VKTIM | OIRE_TIME | TIMS | 6 | 0 | SSR PC: Time of sale | ||
28 | CCNUM_MASK | OIRE_CCNUM | OIRE_CCNUM | CHAR | 25 | 0 | SSR PC: Payment card number | ||
29 | CH_AMT | OIRE_CHMAT | WERT11 | CURR | 11 | 2 | SSR PC Reconciliation -Transaction Amount per Clearing House | ||
30 | PBL_AMT | OIRE_PBLAMT | WERT11 | CURR | 11 | 2 | SSR PC Reconciliation Transaction Amount per Service Station | ||
31 | DIFFERENCE | OIRE_DIFFER | WERT11 | CURR | 11 | 2 | SSR PC Reconciliation Difference Amount between CH and S Stn | ||
32 | COMPFL | OIRE_COMPFL | OIRE_COMPFL | CHAR | 1 | 0 | SSR PC: Complaint status flag | ||
33 | COMPRES | OIRE_COMPRES | OIRE_COMPRES | CHAR | 3 | 0 | SSR PC: Complaint result | * | |
34 | CH_TABIX | TABIX_D | TABIX | INT4 | 10 | 0 | Field defined as in SY-TABIX | ||
35 | DTF_TABIX | TABIX_D | TABIX | INT4 | 10 | 0 | Field defined as in SY-TABIX |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ROIRE_RECON_LISTD | CCINS | OIREPCTYP | SSR_CCINS | REF | 1 | CN |
2 | ROIRE_RECON_LISTD | CHOBJ | OIRECH | CHOBJ | REF | 1 | CN |
3 | ROIRE_RECON_LISTD | MANDT | T000 | MANDT | KEY | 1 | CN |
4 | ROIRE_RECON_LISTD | PBLNR | OIFSPBL | PBLNR | REF | 1 | CN |
5 | ROIRE_RECON_LISTD | UPLNR | OIRE_RECON_ADM | UPLNR | KEY | 1 | N |
6 | ROIRE_RECON_LISTD | WAERS | TCURC | WAERS | REF | 1 | CN |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 46C |