SAP ABAP Table OIUREP_ENTTY_LOG (Log table for master data entity changes)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA (Application Component) Production and Revenue Accounting
     ⤷ OIU (Package) PRA Production and Revenue Accounting (Upstream Business)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIUREP_ENTTY_LOG	Table Relationship Diagram
Short Description	Log table for master data entity changes

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	RPT_YYYYMM	☑	OIUREP_RPT_YYYYMM	OIUREP_RPT_YYYYMM	NUMC	6	0	Reporting Year and Month
3	AGENCY	☑	OIUREP_ROY_AGENCY	CHAR3	CHAR	3	0	Agency for Reporting	OIUREP_ROY_AGY
4	OIL_GAS_IND	☑	OIUREP_OIL_GAS_IND	OIUREP_OIL_GAS_IND	CHAR	1	0	Oil and Gas Indicator
5	ORG_LEVEL1_NO	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
6	EFF_YYYYMM	☑	OIUREP_EFF_YYYYMM	OIUREP_EFF_YYYYMM	NUMC	6	0	Effective Year and Month
7	PROPERTY_NO	☑	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	T8JV
8	DOI_NO	☑	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
9	WL_NO	☑	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
10	WC_NO	☑	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
11	MP_NO	☑	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
12	AGENCY_LEASE	☑	OIUREP_AGENCY_LEASE	OIUREP_AGENCY_LEASE	CHAR	15	0	Agency assigned Lease No.	OIUREP_AGY_LSE
13	DB_ACTION	☐	OIUREP_CHANGE_TYPE	OIUREP_CHANGE_TYPE	CHAR	1	0	Type of change (Insert, Delete or Update)
14	LSE_ALLOC_FAC	☐	OIUREP_LSE_ALLOC_FAC	OIUREP_LSE_ALLOC_FAC	DEC	9	8	Lease Allocation Factor
15	UNIT_PROP_FLAG	☐	OIUREP_UNIT_PROP_FLAG	CHAR1	CHAR	1	0	Unit Property Flag
16	PAYOR_FRACTION	☐	OIUREP_REPORT_FACTOR	OIUREP_PAYOR_FRACTION	DEC	9	8	Report factor for royalty reporting
17	ENTL_FLAG	☐	OIUY1_ENTL_FLAG	OIUY1_FLAG	CHAR	1	0	Entitlement Flag
18	ROY_OBLIGATION	☐	OIUY1_ROY_OBLG	OIUY1_FLAG	CHAR	1	0	Royalty Obligation (Y/N)
19	.INCLUDE	☐				0	0	Creator and date/time created
20	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
21	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
22	PERCENT_REPORTED	☐	OIUREP_REPORT_FACTOR	OIUREP_PAYOR_FRACTION	DEC	9	8	Report factor for royalty reporting

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIUREP_ENTTY_LOG	AGENCY	OIUREP_ROY_AGY	AGENCY
2	OIUREP_ENTTY_LOG	AGENCY_LEASE	OIUREP_AGY_LSE	AGENCY_LEASE
3	OIUREP_ENTTY_LOG	DOI_NO	OIU_DO_DI	DOI_NO
4	OIUREP_ENTTY_LOG	MANDT	T000	MANDT
5	OIUREP_ENTTY_LOG	MP_NO	OIU_PR_MP	MP_NO
6	OIUREP_ENTTY_LOG	ORG_LEVEL1_NO	T001	BUKRS
7	OIUREP_ENTTY_LOG	PROPERTY_NO	T8JV	VNAME
8	OIUREP_ENTTY_LOG	WC_NO	OIU_PR_WC	WC_NO
9	OIUREP_ENTTY_LOG	WL_NO	OIU_PR_WELL	WL_NO

History

Last changed by/on	SAP	20110809
SAP Release Created in	600