SAP ABAP Table ROIU_DO_DO_INCL (Non-key-fields OIU_DO_DO)

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	INTTAB	Structure
Structure	ROIU_DO_DO_INCL	Table Relationship Diagram
Short Description	Non-key-fields OIU_DO_DO

Delivery and Maintenance

Pool/cluster
Delivery Class
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	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
2	DO_NO	☐	OIU_DO_NO	OIU_SYS_NO	NUMC	12	0	Division of Interest Number
3	JIB_OFFS_FL	☐	OIU_JIB_OFFS_FL	OIU_X_FLAG	CHAR	1	0	Joint Interest Billing Offset Flag
4	NRI_PC	☐	OIU_NRI_PC	OIU_PERCENT98	DEC	9	8	Net Revenue Interest Percent
5	SUSP_CD	☐	OIU_SUSP_CD	OIU_SUSP_CD	CHAR	3	0	Suspense Reason Code	OIU_CM_SUSP
6	TAX_FREE_CD	☐	OIU_TAX_FREE_CD	OIU_TAX_FREE_CD	CHAR	2	0	Tax Free Code	OIU_CM_TFC
7	BG_NO	☐	OIU_BG_NO	OIU_BG_NO	CHAR	2	0	Bearer Group Number
8	PYOUT_CD	☐	OIU_PYOUT_CD	OIU_PYOUT_CD	CHAR	1	0	Payout Code	OIU_CM_PAYOUT
9	PAY_CD	☐	OIU_PAY_CD	OIU_PAY_CD	CHAR	2	0	Pay Code
10	ENTL_CD	☐	OIU_ENTL_CD	OIU_ENTL_CD	CHAR	1	0	Entitlement Code
11	SSC_FL	☐	OIU_SSC_FL	OIU_X_FLAG	CHAR	1	0	Sliding Scale Indicator Flag
12	MMS_POP_COMP_FL	☐	OIU_MMS_POP_COMP_FL	OIU_X_FLAG	CHAR	1	0	MMS Percent of Proceeds Flag
13	DUAL_ACCT_FL	☐	OIU_DUAL_ACCT_FL	OIU_X_FLAG	CHAR	1	0	Dual Accounting Flag
14	ENTY_CD	☐	OIU_ENTY_CD	OIU_ENTITY_CD	CHAR	2	0	Entity Code
15	ACCT_ENT_FL	☐	OIU_ACCT_ENT_FL	OIU_X_FLAG	CHAR	1	0	Accounting Entry Override Flag
16	INT_CAT_CD	☐	OIU_INT_CAT_CD	OIU_INT_CAT_CD	CHAR	1	0	Interest Category
17	MIN_ROY_DT	☐	OIU_MIN_ROY_DT	DATUM	DATS	8	0	Minimum Royalty Date
18	DO_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
19	MIN_ROY_AM	☐	OIU_MIN_ROY_AM	WERT4	CURR	7	2	Minimum Royalty Amount
20	ADV_ARRS_CD	☐	OIU_ADV_ARRS_CD	OIU_ADV_ARRS_CD	CHAR	1	0	Advance Arrears Payment Code
21	CARR_BG_CD	☐	OIU_CARR_BG_CD	OIU_CARR_BG_CD	CHAR	2	0	Carried bearer group code
22	LSE_USE_PMT_CD	☐	OIU_LSE_USE_PMT_CD	OIU_LSE_USE_PMT_CD	CHAR	1	0	Pay on Lease Use Fuel
23	JIB_PARTN	☐	OIU_JIB_PARTN	KUNNR	CHAR	10	0	JIB Partner	KNA1
24	PP_KUNNR	☐	OIU_PP_KUNNR	LIFNR	CHAR	10	0	Production Payment Owner	OIUOW_PP
25	MMS_RECON_FL	☐	OIU_MMS_RECON_FL	OIU_X_FLAG	CHAR	1	0	MMS Reconciliation Flag
26	.INCLUDE	☐				0	0	Creator and date/time created
27	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
28	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	ROIU_DO_DO_INCL	DO_CURR	TCURC	WAERS		1	CN
2	ROIU_DO_DO_INCL	JIB_PARTN	KNA1	KUNNR		1	CN
3	ROIU_DO_DO_INCL	PP_KUNNR	OIUOW_PP	OWN_NO		1	CN
4	ROIU_DO_DO_INCL	PYOUT_CD	OIU_CM_PAYOUT	PYOUT_CD		1	N
5	ROIU_DO_DO_INCL	SUSP_CD	OIU_CM_SUSP	SUSP_CD		1	CN
6	ROIU_DO_DO_INCL	TAX_FREE_CD	OIU_CM_TFC	TAX_FREE_CD

History

Last changed by/on	SAP	20130529
SAP Release Created in