SAP ABAP Table ROIU_DO_DO (Maintenance Structure: 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	Table Relationship Diagram
Short Description	Maintenance Structure: 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	.INCLUDE	☐				0	0	Division of Interest Ownership
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
5	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
6	CUST_VEND_CD	☐	OIU_CUST_VEND_CD	OIU_CUST_VEND_CD	CHAR	1	0	Customer/Vendor Indicator
7	OWN_NO	☐	OIU_OWN_NO	LIFNR	CHAR	10	0	PRA owner	LFA1
8	OWN_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
9	OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
10	EFF_FROM_DT	☐	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
11	.INCLUDE	☐				0	0	Non-key-fields OIU_DO_DO
12	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
13	DO_NO	☐	OIU_DO_NO	OIU_SYS_NO	NUMC	12	0	Division of Interest Number
14	JIB_OFFS_FL	☐	OIU_JIB_OFFS_FL	OIU_X_FLAG	CHAR	1	0	Joint Interest Billing Offset Flag
15	NRI_PC	☐	OIU_NRI_PC	OIU_PERCENT98	DEC	9	8	Net Revenue Interest Percent
16	SUSP_CD	☐	OIU_SUSP_CD	OIU_SUSP_CD	CHAR	3	0	Suspense Reason Code	OIU_CM_SUSP
17	TAX_FREE_CD	☐	OIU_TAX_FREE_CD	OIU_TAX_FREE_CD	CHAR	2	0	Tax Free Code	OIU_CM_TFC
18	BG_NO	☐	OIU_BG_NO	OIU_BG_NO	CHAR	2	0	Bearer Group Number
19	PYOUT_CD	☐	OIU_PYOUT_CD	OIU_PYOUT_CD	CHAR	1	0	Payout Code	OIU_CM_PAYOUT
20	PAY_CD	☐	OIU_PAY_CD	OIU_PAY_CD	CHAR	2	0	Pay Code
21	ENTL_CD	☐	OIU_ENTL_CD	OIU_ENTL_CD	CHAR	1	0	Entitlement Code
22	SSC_FL	☐	OIU_SSC_FL	OIU_X_FLAG	CHAR	1	0	Sliding Scale Indicator Flag
23	MMS_POP_COMP_FL	☐	OIU_MMS_POP_COMP_FL	OIU_X_FLAG	CHAR	1	0	MMS Percent of Proceeds Flag
24	DUAL_ACCT_FL	☐	OIU_DUAL_ACCT_FL	OIU_X_FLAG	CHAR	1	0	Dual Accounting Flag
25	ENTY_CD	☐	OIU_ENTY_CD	OIU_ENTITY_CD	CHAR	2	0	Entity Code
26	ACCT_ENT_FL	☐	OIU_ACCT_ENT_FL	OIU_X_FLAG	CHAR	1	0	Accounting Entry Override Flag
27	INT_CAT_CD	☐	OIU_INT_CAT_CD	OIU_INT_CAT_CD	CHAR	1	0	Interest Category
28	MIN_ROY_DT	☐	OIU_MIN_ROY_DT	DATUM	DATS	8	0	Minimum Royalty Date
29	DO_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
30	MIN_ROY_AM	☐	OIU_MIN_ROY_AM	WERT4	CURR	7	2	Minimum Royalty Amount
31	ADV_ARRS_CD	☐	OIU_ADV_ARRS_CD	OIU_ADV_ARRS_CD	CHAR	1	0	Advance Arrears Payment Code
32	CARR_BG_CD	☐	OIU_CARR_BG_CD	OIU_CARR_BG_CD	CHAR	2	0	Carried bearer group code
33	LSE_USE_PMT_CD	☐	OIU_LSE_USE_PMT_CD	OIU_LSE_USE_PMT_CD	CHAR	1	0	Pay on Lease Use Fuel
34	JIB_PARTN	☐	OIU_JIB_PARTN	KUNNR	CHAR	10	0	JIB Partner	KNA1
35	PP_KUNNR	☐	OIU_PP_KUNNR	LIFNR	CHAR	10	0	Production Payment Owner	OIUOW_PP
36	MMS_RECON_FL	☐	OIU_MMS_RECON_FL	OIU_X_FLAG	CHAR	1	0	MMS Reconciliation Flag
37	.INCLUDE	☐				0	0	Creator and date/time created
38	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
39	OIU_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
40	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag
41	S_DO_NO	☐	OIU_DO_NO	OIU_SYS_NO	NUMC	12	0	Division of Interest Number
42	BUTXT	☐	BUTXT	TEXT25	CHAR	25	0	Name of Company Code or Company
43	DOI_NM	☐	OIU_DOI_NM	OIU_TEXT30	CHAR	30	0	Division of Interest Name
44	COMB_PD_CD	☐	OIU_COMB_PD_CD	OIU_COMB_PD_CD	CHAR	3	0	Combined product code	OIUCM_COMB_PD_CD
45	CPCD_DESC	☐	OIU_CPCD_DESC	OIU_TEXT30	CHAR	30	0	Combined Product Code Description
46	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
47	ETEXT	☐	LTEXT_8JE	TEXT35	CHAR	35	0	Investment Type Description
48	PART_TYPE_DESC	☐	OIU_PART_INT_TYPE_DE	OIU_TEXT30	CHAR	30	0	Participant Interest Type Description
49	ENTY_DE	☐	OIU_ENTY_DE	CHAR30	CHAR	30	0	Entity type description
50	GRI_PC	☐	OIU_GRI_PC	OIU_PERCENT98	DEC	9	8	Gross Revenue Interest Decimal
51	PAY_DE	☐	OIU_PAY_DE	CHAR30	CHAR	30	0	Pay Description
52	SUSP_DESC	☐	OIU_SUSP_DESC	OIU_TEXT40	CHAR	40	0	Suspense Reason Description
53	TAX_FREE_DE	☐	OIU_TAX_FREE_DE	CHAR50	CHAR	50	0	Tax Free Code Description
54	DOI_START_DT	☐	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
55	TOT_NRI_PC	☐	OIU_TOT_NRI_PC	OIU_PERCENT98	DEC	9	8	Total Net Revenue Interest Percentage

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ROIU_DO_DO	BUKRS	T001	BUKRS	KEY	1	CN
2	ROIU_DO_DO	COMB_PD_CD	OIUCM_COMB_PD_CD	COMB_PD_CD
3	ROIU_DO_DO	DOI_NO	OIU_DO_DI	DOI_NO		1	CN
4	ROIU_DO_DO	DO_CURR	TCURC	WAERS		1	CN
5	ROIU_DO_DO	JIB_PARTN	KNA1	KUNNR		1	CN
6	ROIU_DO_DO	OWN_INT_TYPE_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD		1	CN
7	ROIU_DO_DO	OWN_NO	LFA1	LIFNR	KEY	1	CN
8	ROIU_DO_DO	PP_KUNNR	OIUOW_PP	OWN_NO		1	CN
9	ROIU_DO_DO	PYOUT_CD	OIU_CM_PAYOUT	PYOUT_CD		1	N
10	ROIU_DO_DO	SUSP_CD	OIU_CM_SUSP	SUSP_CD		1	CN
11	ROIU_DO_DO	TAX_FREE_CD	OIU_CM_TFC	TAX_FREE_CD	KEY	1	CN
12	ROIU_DO_DO	VNAME	OIU_DO_JV	VNAME		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in