SAP ABAP Table V_OIUDODO_VENBAL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_OIUDODO_VENBAL	Table Relationship Diagram
Short Description	Generated Table for View

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

History

Last changed by/on	SAP	20130529
SAP Release Created in