Table/Structure Field list used by SAP ABAP View V_OIRE_RECON_DET (DB view for the administrative and detailed reconciliation)
SAP ABAP View
V_OIRE_RECON_DET (DB view for the administrative and detailed reconciliation) is using
| # | Object Type | Object Name | Object Description | Note |
|---|---|---|---|---|
| 1 | OIRE_RECON_ADM - BRTWR | SSR PC: Total Value (of Upload) | ||
| 2 | OIRE_RECON_ADM - BRTWR | SSR PC: Total Value (of Upload) | ||
| 3 | OIRE_RECON_ADM - WAERS | Currency Key | ||
| 4 | OIRE_RECON_ADM - WAERS | Currency Key | ||
| 5 | OIRE_RECON_ADM - UPLTIM | SSR PC: Upload time | ||
| 6 | OIRE_RECON_ADM - UPLTIM | SSR PC: Upload time | ||
| 7 | OIRE_RECON_ADM - UPLDAT | SSR PC: Upload date | ||
| 8 | OIRE_RECON_ADM - UPLDAT | SSR PC: Upload date | ||
| 9 | OIRE_RECON_ADM - NO_TRANX | SSR PC: Counter for number of transactions | ||
| 10 | OIRE_RECON_ADM - DET_AGG_IND | Detail/Aggregation indicator (values: D or A) | ||
| 11 | OIRE_RECON_ADM - DET_AGG_IND | Detail/Aggregation indicator (values: D or A) | ||
| 12 | OIRE_RECON_ADM - COUNTER_CH | Counter from the clearing house | ||
| 13 | OIRE_RECON_ADM - COUNTER_CH | Counter from the clearing house | ||
| 14 | OIRE_RECON_ADM - CHOBJ | SSR PC: Clearing house | ||
| 15 | OIRE_RECON_ADM - CHOBJ | SSR PC: Clearing house | ||
| 16 | OIRE_RECON_ADM - NO_TRANX | SSR PC: Counter for number of transactions | ||
| 17 | OIRE_RECON_DET - RECON_NO | Reconciliation run number | ||
| 18 | OIRE_RECON_DET - RECON_NO | Reconciliation run number | ||
| 19 | OIRE_RECON_DET - SALES_TIMESTMP | Sales timestamp (Format: YYYYMMDDhhmmss) | ||
| 20 | OIRE_RECON_DET - SALES_TIMESTMP | Sales timestamp (Format: YYYYMMDDhhmmss) | ||
| 21 | OIRE_RECON_DET - SETTLNR | SSR PC: CH settlement and/or transmission document number | ||
| 22 | OIRE_RECON_DET - SETTLNR | SSR PC: CH settlement and/or transmission document number | ||
| 23 | OIRE_RECON_DET - SSMID | SSR PC: Service station merchant ID | ||
| 24 | OIRE_RECON_DET - SSMID | SSR PC: Service station merchant ID | ||
| 25 | OIRE_RECON_DET - SSMIDT | SSR PC: Service station merchant ID text | ||
| 26 | OIRE_RECON_DET - SSMIDT | SSR PC: Service station merchant ID text | ||
| 27 | OIRE_RECON_DET - TERMNR | SSR PC: Receipt number of terminal at bus. location | ||
| 28 | OIRE_RECON_DET - TERMNR | SSR PC: Receipt number of terminal at bus. location | ||
| 29 | OIRE_RECON_DET - UPLNR | Clearing House Upload Number (internal) | ||
| 30 | OIRE_RECON_DET - UPLNR | Clearing House Upload Number (internal) | ||
| 31 | OIRE_RECON_DET - POSNR | Item number of a recon. upload number | ||
| 32 | OIRE_RECON_DET - POSNR | Item number of a recon. upload number | ||
| 33 | OIRE_RECON_DET - PBLNR | Business location identifier (IS-Oil MRN) | ||
| 34 | OIRE_RECON_DET - PBLNR | Business location identifier (IS-Oil MRN) | ||
| 35 | OIRE_RECON_DET - MANDT | Client | ||
| 36 | OIRE_RECON_DET - MANDT | Client | ||
| 37 | OIRE_RECON_DET - CCNUM | SSR PC: Payment card number | ||
| 38 | OIRE_RECON_DET - CCNUM | SSR PC: Payment card number | ||
| 39 | OIRE_RECON_DET - CCINS | SSR PC: Payment card type | ||
| 40 | OIRE_RECON_DET - CCINS | SSR PC: Payment card type | ||
| 41 | OIRE_RECON_DET - BRTWR | SSR PC: Gross value | ||
| 42 | OIRE_RECON_DET - BRTWR | SSR PC: Gross value | ||
| 43 | OIRE_RECON_DET - AUTNR | SSR PC: Authorization number | ||
| 44 | OIRE_RECON_DET - AUTNR | SSR PC: Authorization number |