SAP ABAP Table OIU_DO_DO_WK (Division of Interest Ownership Worktable)

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	OIU_DO_DO_WK	Table Relationship Diagram
Short Description	Division of Interest Ownership Worktable

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	*
2	BUKRS	☑	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	VNAME	☑	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
4	DOI_NO	☑	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
5	CUST_VEND_CD	☑	OIU_CUST_VEND_CD	OIU_CUST_VEND_CD	CHAR	1	0	Customer/Vendor Indicator
6	OWN_NO	☑	OIU_OWN_NO	LIFNR	CHAR	10	0	PRA owner	LFA1
7	OWN_INT_TYPE_CD	☑	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	OIU_CM_PINTTY
8	OWN_ISQ_NO	☑	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
9	EFF_FROM_DT	☑	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
10	.INCLUDE	☐				0	0	Non-key-fields OIU_DO_DO
11	EFF_TO_DT	☐	OIU_EFF_TO_DT	DATUM	DATS	8	0	Effective To Date
12	DO_NO	☐	OIU_DO_NO	OIU_SYS_NO	NUMC	12	0	Division of Interest Number
13	JIB_OFFS_FL	☐	OIU_JIB_OFFS_FL	OIU_X_FLAG	CHAR	1	0	Joint Interest Billing Offset Flag
14	NRI_PC	☐	OIU_NRI_PC	OIU_PERCENT98	DEC	9	8	Net Revenue Interest Percent
15	SUSP_CD	☐	OIU_SUSP_CD	OIU_SUSP_CD	CHAR	3	0	Suspense Reason Code	OIU_CM_SUSP
16	TAX_FREE_CD	☐	OIU_TAX_FREE_CD	OIU_TAX_FREE_CD	CHAR	2	0	Tax Free Code	OIU_CM_TFC
17	BG_NO	☐	OIU_BG_NO	OIU_BG_NO	CHAR	2	0	Bearer Group Number
18	PYOUT_CD	☐	OIU_PYOUT_CD	OIU_PYOUT_CD	CHAR	1	0	Payout Code	OIU_CM_PAYOUT
19	PAY_CD	☐	OIU_PAY_CD	OIU_PAY_CD	CHAR	2	0	Pay Code
20	ENTL_CD	☐	OIU_ENTL_CD	OIU_ENTL_CD	CHAR	1	0	Entitlement Code
21	SSC_FL	☐	OIU_SSC_FL	OIU_X_FLAG	CHAR	1	0	Sliding Scale Indicator Flag
22	MMS_POP_COMP_FL	☐	OIU_MMS_POP_COMP_FL	OIU_X_FLAG	CHAR	1	0	MMS Percent of Proceeds Flag
23	DUAL_ACCT_FL	☐	OIU_DUAL_ACCT_FL	OIU_X_FLAG	CHAR	1	0	Dual Accounting Flag
24	ENTY_CD	☐	OIU_ENTY_CD	OIU_ENTITY_CD	CHAR	2	0	Entity Code
25	ACCT_ENT_FL	☐	OIU_ACCT_ENT_FL	OIU_X_FLAG	CHAR	1	0	Accounting Entry Override Flag
26	INT_CAT_CD	☐	OIU_INT_CAT_CD	OIU_INT_CAT_CD	CHAR	1	0	Interest Category
27	MIN_ROY_DT	☐	OIU_MIN_ROY_DT	DATUM	DATS	8	0	Minimum Royalty Date
28	DO_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
29	MIN_ROY_AM	☐	OIU_MIN_ROY_AM	WERT4	CURR	7	2	Minimum Royalty Amount
30	ADV_ARRS_CD	☐	OIU_ADV_ARRS_CD	OIU_ADV_ARRS_CD	CHAR	1	0	Advance Arrears Payment Code
31	CARR_BG_CD	☐	OIU_CARR_BG_CD	OIU_CARR_BG_CD	CHAR	2	0	Carried bearer group code
32	LSE_USE_PMT_CD	☐	OIU_LSE_USE_PMT_CD	OIU_LSE_USE_PMT_CD	CHAR	1	0	Pay on Lease Use Fuel
33	JIB_PARTN	☐	OIU_JIB_PARTN	KUNNR	CHAR	10	0	JIB Partner	KNA1
34	PP_KUNNR	☐	OIU_PP_KUNNR	LIFNR	CHAR	10	0	Production Payment Owner	OIUOW_PP
35	MMS_RECON_FL	☐	OIU_MMS_RECON_FL	OIU_X_FLAG	CHAR	1	0	MMS Reconciliation Flag
36	.INCLUDE	☐				0	0	Creator and date/time created
37	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
38	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	OIU_DO_DO_WK	BUKRS	T001	BUKRS	KEY	1	CN
2	OIU_DO_DO_WK	DOI_NO	OIU_DO_DI	DOI_NO		1	CN
3	OIU_DO_DO_WK	DO_CURR	TCURC	WAERS		1	CN
4	OIU_DO_DO_WK	JIB_PARTN	KNA1	KUNNR		1	CN
5	OIU_DO_DO_WK	OWN_INT_TYPE_CD	OIU_CM_PINTTY	OWN_INT_TYPE_CD	KEY	1	N
6	OIU_DO_DO_WK	OWN_NO	LFA1	LIFNR		1	CN
7	OIU_DO_DO_WK	PP_KUNNR	OIUOW_PP	OWN_NO		1	CN
8	OIU_DO_DO_WK	PYOUT_CD	OIU_CM_PAYOUT	PYOUT_CD		1	N
9	OIU_DO_DO_WK	SUSP_CD	OIU_CM_SUSP	SUSP_CD		1	CN
10	OIU_DO_DO_WK	TAX_FREE_CD	OIU_CM_TFC	TAX_FREE_CD	REF
11	OIU_DO_DO_WK	VNAME	OIU_DO_JV	VNAME		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in