OIRE_RECON_AGG SAP (Aggregated reconciliation data) Table details
Dictionary Type: Table
Description: Aggregated reconciliation data
Description: Aggregated reconciliation data
ABAP Code to SELECT data from OIRE_RECON_AGG
Related tables to OIRE_RECON_AGG
Access table OIRE_RECON_AGG
Related tables to OIRE_RECON_AGG
Access table OIRE_RECON_AGG
Table field list including key, data, relationships and ABAP select examples
OIRE_RECON_AGG is a standard SAP Table which is used to store Aggregated reconciliation data data and is available within R/3 SAP systems depending on the version and release level.
The OIRE_RECON_AGG table consists of various fields, each holding specific information or linking keys about Aggregated reconciliation data data available in SAP. These include UPLNR (Clearing House Upload Number (internal)), POSNR (Item number of a recon. upload number), PBLNR (Business location identifier (IS-Oil MRN)), CCINS (SSR PC: Payment card type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OIRE_RECON_AGG table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
UPLNR | Clearing House Upload Number (internal) | OIRE_UPLNR_RECON | CHAR | 10 | ALPHA | OIRE_UPLNR | OIRE_CHUNR | ||
POSNR | Item number of a recon. upload number | OIRE_POSNR_RECON | NUMC | 6 | NUMC6 | ||||
PBLNR | Business location identifier (IS-Oil MRN) | OIF_PBLNR | CHAR | 10 | OIFSPBL | ALPHA | OIF_PBLNR | OI0 | OIFB |
CCINS | SSR PC: Payment card type | OIRE_CCINS | CHAR | 4 | OIREPCTYP | OIRE_CCINS | OIRE_CCINS | ||
PERIOD_FROM | Sales period from (Format: YYYYMMDDhhmmss) | OIRE_PERIOD_FROM | DEC | 15 | TZNTSTMPS | ||||
PERIOD_TO | Sales period to (Format: YYYYMMDDhhmmss) | OIRE_PERIOD_TO | DEC | 15 | TZNTSTMPS | ||||
BRTWR | SSR PC: Gross value | OIRE_BRTWR | CURR | 13(2) | WERTV7 | ||||
WAERS | Currency Key | WAERS | CUKY | 5 | Assigned to domain | WAERS | FWS | ||
NO_DEBITS | SSR PC: Counter for number of debits | OIRE_COUNTER_DEBITS | NUMC | 8 | NUMC8 | ||||
NO_CREDITS | SSR PC: Counter for number of credits | OIRE_COUNTER_CREDITS | NUMC | 8 | NUMC8 | ||||
BRTWR_DEBITS | SSR PC: Gross value debits | OIRE_BRTWR_DEBITS | CURR | 13(2) | WERTV7 | ||||
BRTWR_CREDITS | SSR PC: Gross value credits | OIRE_BRTWR_CREDITS | CURR | 13(2) | WERTV7 | ||||
SSMID | SSR PC: Service station merchant ID | OIRE_SSMID | CHAR | 20 | OIRE_SSMID | ||||
SSMIDT | SSR PC: Service station merchant ID text | OIRE_SSMIDTX | CHAR | 50 | OIRE_SSMIDTX | ||||
RECON_NO | Reconciliation run number | OIRE_RECON_NO | CHAR | 10 | Assigned to domain | ALPHA | OIRE_RECON_NO | ||
SETTLNR | SSR PC: CH settlement and/or transmission document number | OIRE_SETTLNR | CHAR | 10 | Assigned to domain | ALPHA | OIRE_SETTLNR |
Key field | Non-key field |
How do I retrieve data from SAP table OIRE_RECON_AGG using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIRE_RECON_AGG to SELECT all data from the tableDATA: WA_OIRE_RECON_AGG TYPE OIRE_RECON_AGG.
SELECT SINGLE *
FROM OIRE_RECON_AGG
INTO CORRESPONDING FIELDS OF WA_OIRE_RECON_AGG
WHERE...
How to access SAP table OIRE_RECON_AGG
Within an ECC or HANA version of SAP you can also view further information about OIRE_RECON_AGG and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects