OIUREP_ENTTY_LOG SAP (Log table for master data entity changes) Table details
Dictionary Type: Table
Description: Log table for master data entity changes
Description: Log table for master data entity changes
ABAP Code to SELECT data from OIUREP_ENTTY_LOG
Related tables to OIUREP_ENTTY_LOG
Access table OIUREP_ENTTY_LOG
Related tables to OIUREP_ENTTY_LOG
Access table OIUREP_ENTTY_LOG
Table field list including key, data, relationships and ABAP select examples
OIUREP_ENTTY_LOG is a standard SAP Table which is used to store Log table for master data entity changes data and is available within R/3 SAP systems depending on the version and release level.
The OIUREP_ENTTY_LOG table consists of various fields, each holding specific information or linking keys about Log table for master data entity changes data available in SAP. These include RPT_YYYYMM (Reporting Year and Month), AGENCY (Agency for Reporting), OIL_GAS_IND (Oil and Gas Indicator), ORG_LEVEL1_NO (Company Code).. 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 OIUREP_ENTTY_LOG 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 | |||
RPT_YYYYMM | Reporting Year and Month | OIUREP_RPT_YYYYMM | NUMC | 6 | OIUREP_RPT_YYYYMM | ||||
AGENCY | Agency for Reporting | OIUREP_ROY_AGENCY | CHAR | 3 | OIUREP_ROY_AGY | CHAR3 | OIUREP_AGENCY | OIUREP_SH_ROY_AGY | |
OIL_GAS_IND | Oil and Gas Indicator | OIUREP_OIL_GAS_IND | CHAR | 1 | OIUREP_OIL_GAS_IND | OIUREP_OIL_GAS_IND | |||
ORG_LEVEL1_NO | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
EFF_YYYYMM | Effective Year and Month | OIUREP_EFF_YYYYMM | NUMC | 6 | OIUREP_EFF_YYYYMM | ||||
PROPERTY_NO | Joint Venture | JV_NAME | CHAR | 6 | T8JV | ALPHA | JV_NAME | JVV | |
DOI_NO | Division of interest (DOI) | OIU_DOI_NO | CHAR | 5 | OIU_DO_DI | ALPHA | OIU_DOI_NO | OIU_DOI | H_OIU_DO_DI |
WL_NO | Well ID number | OIU_WL_NO | CHAR | 15 | OIU_PR_WELL | ALPHA | OIU_WL_NO | OIU_WELL | H_OIU_PR_WELL |
WC_NO | Well Completion Number | OIU_WC_NO | CHAR | 5 | OIU_PR_WC | ALPHA | OIU_WC_NO | OIU_WC | H_OIU_PR_WC |
MP_NO | Measurement point number | OIU_MP_NO | CHAR | 20 | OIU_PR_MP | ALPHA | OIU_MP_NO | OIU_MP | H_OIU_PR_MP |
AGENCY_LEASE | Agency assigned Lease No. | OIUREP_AGENCY_LEASE | CHAR | 15 | OIUREP_AGY_LSE | OIUREP_AGENCY_LEASE | |||
DB_ACTION | Type of change (Insert, Delete or Update) | OIUREP_CHANGE_TYPE | CHAR | 1 | OIUREP_CHANGE_TYPE | ||||
LSE_ALLOC_FAC | Lease Allocation Factor | OIUREP_LSE_ALLOC_FAC | DEC | 9(8) | OIUREP_LSE_ALLOC_FAC | ||||
UNIT_PROP_FLAG | Unit Property Flag | OIUREP_UNIT_PROP_FLAG | CHAR | 1 | CHAR1 | ||||
PAYOR_FRACTION | Report factor for royalty reporting | OIUREP_REPORT_FACTOR | DEC | 9(8) | OIUREP_PAYOR_FRACTION | ||||
ENTL_FLAG | Entitlement Flag | OIUY1_ENTL_FLAG | CHAR | 1 | OIUY1_FLAG | ||||
ROY_OBLIGATION | Royalty Obligation (Y/N) | OIUY1_ROY_OBLG | CHAR | 1 | OIUY1_FLAG | ||||
OIU_CRUSER | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
OIU_TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TZNTSTMPS | DEC | 15 | TZNTSTMPS | ||||
PERCENT_REPORTED | Report factor for royalty reporting | OIUREP_REPORT_FACTOR | DEC | 9(8) | OIUREP_PAYOR_FRACTION |
Key field | Non-key field |
How do I retrieve data from SAP table OIUREP_ENTTY_LOG using ABAP code
The following ABAP code Example will allow you to do a basic selection on OIUREP_ENTTY_LOG to SELECT all data from the tableDATA: WA_OIUREP_ENTTY_LOG TYPE OIUREP_ENTTY_LOG.
SELECT SINGLE *
FROM OIUREP_ENTTY_LOG
INTO CORRESPONDING FIELDS OF WA_OIUREP_ENTTY_LOG
WHERE...
How to access SAP table OIUREP_ENTTY_LOG
Within an ECC or HANA version of SAP you can also view further information about OIUREP_ENTTY_LOG 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