SAP ABAP Table OIUREP_ROY_LOG (Changes to master data for reporting)
Hierarchy
☛
IS-OIL (Software Component) IS-OIL
⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
⤷ OIU_REP (Package) Production, Tax & Royalty Reporting
⤷ IS-OIL-PRA-REP-ROY (Application Component) Royalty Reporting
⤷ OIU_REP (Package) Production, Tax & Royalty Reporting
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | OIUREP_ROY_LOG | Table Relationship Diagram |
Short Description | Changes to master data for reporting |
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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | TABLE_NAME | OIUREP_TABNAME | DBOBJ_NAME | CHAR | 16 | 0 | Table Name for the master data table for Royalty Reporting | ||
3 | RPT_YYYYMM | OIUREP_RPT_YYYYMM | OIUREP_RPT_YYYYMM | NUMC | 6 | 0 | Reporting Year and Month | ||
4 | EFF_YYYYMM | OIUREP_EFF_YYYYMM | OIUREP_EFF_YYYYMM | NUMC | 6 | 0 | Effective Year and Month | ||
5 | ORG_LEVEL1_NO | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | T001 | |
6 | AGENCY | OIUREP_ROY_AGENCY | CHAR3 | CHAR | 3 | 0 | Agency for Reporting | OIUREP_ROY_AGY | |
7 | OIL_GAS_IND | OIUREP_OIL_GAS_IND | OIUREP_OIL_GAS_IND | CHAR | 1 | 0 | Oil and Gas Indicator | ||
8 | TABLE_KEY | OIUREP_TABLE_NEWKEY | CHAR100 | CHAR | 100 | 0 | Table Key for Royalty Reporting Master Data | ||
9 | DB_ACTION | OIUREP_CHANGE_TYPE | OIUREP_CHANGE_TYPE | CHAR | 1 | 0 | Type of change (Insert, Delete or Update) | ||
10 | RECORD_VALUE | OIUREP_RECORD_VALUE | CHAR255 | CHAR | 255 | 0 | Record Contents | ||
11 | PPA_FLAG | OIUREP_RPT_PPA_FLAG | CHAR1 | CHAR | 1 | 0 | Reporting PPA Flag | ||
12 | .INCLUDE | 0 | 0 | Creator and date/time created | |||||
13 | OIU_CRUSER | ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
14 | OIU_TIMESTAMP | TZNTSTMPS | TZNTSTMPS | DEC | 15 | 0 | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | OIUREP_ROY_LOG | AGENCY | OIUREP_ROY_AGY | AGENCY | 1 | CN | |
2 | OIUREP_ROY_LOG | MANDT | T000 | MANDT | |||
3 | OIUREP_ROY_LOG | ORG_LEVEL1_NO | T001 | BUKRS |
History
Last changed by/on | SAP | 20050301 |
SAP Release Created in | 46C |