SAP ABAP View V_OIUDODO_VENBAL (Vendors w/ pay code=09 (Balancing), w/o MMS Recon.flag)

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

View Type	D	Database View
Database View	V_OIUDODO_VENBAL
Short Description	Vendors w/ pay code=09 (Balancing), w/o MMS Recon.flag
Root table	OIU_DO_DO	Division of Interest Ownership

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	OIU_DO_DO	OIU_DO_DO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	OIU_DO_DO	CUST_VEND_CD		EQ	'V'		AND	0	0
2	OIU_DO_DO	PAY_CD		EQ	'9'		AND	0	0
3	OIU_DO_DO	MMS_RECON_FL		EQ	' '		AND	0	0
4	OIU_DO_DO	ENTY_CD		EQ	'02'		OR	0	0
5	OIU_DO_DO	ENTY_CD		EQ	'03'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	*	OIU_DO_DO	*		☐		☐
2	MANDT	OIU_DO_DO	MANDT		☐	MANDT	☐	Client
3	BUKRS	OIU_DO_DO	BUKRS		☐	BUKRS	☐	Company Code
4	VNAME	OIU_DO_DO	VNAME		☐	JV_NAME	☐	Joint venture
5	DOI_NO	OIU_DO_DO	DOI_NO		☐	OIU_DOI_NO	☐	Division of interest (DOI)
6	CUST_VEND_CD	OIU_DO_DO	CUST_VEND_CD		☐	OIU_CUST_VEND_CD	☐	Customer/Vendor Indicator
7	OWN_NO	OIU_DO_DO	OWN_NO		☐	OIU_OWN_NO	☐	PRA owner
8	OWN_INT_TYPE_CD	OIU_DO_DO	OWN_INT_TYPE_CD		☐	OIU_PART_INT_TYPE	☐	Participant Interest Type
9	OWN_ISQ_NO	OIU_DO_DO	OWN_ISQ_NO		☐	OIU_OWN_ISQ_NO	☐	Owner Interest Sequence Number
10	EFF_FROM_DT	OIU_DO_DO	EFF_FROM_DT		☐	OIU_EFF_FROM_DT	☐	Effective from date
11	EFF_TO_DT	OIU_DO_DO	EFF_TO_DT		☐	OIU_EFF_TO_DT	☐	Effective To Date
12	DO_NO	OIU_DO_DO	DO_NO		☐	OIU_DO_NO	☐	Division of Interest Number
13	JIB_OFFS_FL	OIU_DO_DO	JIB_OFFS_FL		☐	OIU_JIB_OFFS_FL	☐	Joint Interest Billing Offset Flag
14	NRI_PC	OIU_DO_DO	NRI_PC		☐	OIU_NRI_PC	☐	Net Revenue Interest Percent
15	SUSP_CD	OIU_DO_DO	SUSP_CD		☐	OIU_SUSP_CD	☐	Suspense Reason Code
16	TAX_FREE_CD	OIU_DO_DO	TAX_FREE_CD		☐	OIU_TAX_FREE_CD	☐	Tax Free Code
17	BG_NO	OIU_DO_DO	BG_NO		☐	OIU_BG_NO	☐	Bearer Group Number
18	PYOUT_CD	OIU_DO_DO	PYOUT_CD		☐	OIU_PYOUT_CD	☐	Payout Code
19	PAY_CD	OIU_DO_DO	PAY_CD		☐	OIU_PAY_CD	☐	Pay Code
20	ENTL_CD	OIU_DO_DO	ENTL_CD		☐	OIU_ENTL_CD	☐	Entitlement Code
21	SSC_FL	OIU_DO_DO	SSC_FL		☐	OIU_SSC_FL	☐	Sliding Scale Indicator Flag
22	MMS_POP_COMP_FL	OIU_DO_DO	MMS_POP_COMP_FL		☐	OIU_MMS_POP_COMP_FL	☐	MMS Percent of Proceeds Flag
23	DUAL_ACCT_FL	OIU_DO_DO	DUAL_ACCT_FL		☐	OIU_DUAL_ACCT_FL	☐	Dual Accounting Flag
24	ENTY_CD	OIU_DO_DO	ENTY_CD		☐	OIU_ENTY_CD	☐	Entity Code
25	ACCT_ENT_FL	OIU_DO_DO	ACCT_ENT_FL		☐	OIU_ACCT_ENT_FL	☐	Accounting Entry Override Flag
26	INT_CAT_CD	OIU_DO_DO	INT_CAT_CD		☐	OIU_INT_CAT_CD	☐	Interest Category
27	MIN_ROY_DT	OIU_DO_DO	MIN_ROY_DT		☐	OIU_MIN_ROY_DT	☐	Minimum Royalty Date
28	DO_CURR	OIU_DO_DO	DO_CURR		☐	WAERS	☐	Currency Key
29	MIN_ROY_AM	OIU_DO_DO	MIN_ROY_AM		☐	OIU_MIN_ROY_AM	☐	Minimum Royalty Amount
30	ADV_ARRS_CD	OIU_DO_DO	ADV_ARRS_CD		☐	OIU_ADV_ARRS_CD	☐	Advance Arrears Payment Code
31	CARR_BG_CD	OIU_DO_DO	CARR_BG_CD		☐	OIU_CARR_BG_CD	☐	Carried bearer group code
32	LSE_USE_PMT_CD	OIU_DO_DO	LSE_USE_PMT_CD		☐	OIU_LSE_USE_PMT_CD	☐	Pay on Lease Use Fuel
33	JIB_PARTN	OIU_DO_DO	JIB_PARTN		☐	OIU_JIB_PARTN	☐	JIB Partner
34	PP_KUNNR	OIU_DO_DO	PP_KUNNR		☐	OIU_PP_KUNNR	☐	Production Payment Owner
35	MMS_RECON_FL	OIU_DO_DO	MMS_RECON_FL		☐	OIU_MMS_RECON_FL	☐	MMS Reconciliation Flag
36	OIU_CRUSER	OIU_DO_DO	OIU_CRUSER		☐	ERNAM	☐	Name of Person who Created the Object
37	OIU_TIMESTAMP	OIU_DO_DO	OIU_TIMESTAMP		☐	TZNTSTMPS	☐	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	46C