SAP ABAP Table OIURV03_DTL_ZE (Valuation Transactions Level 1 - Zero Volume)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-PRA-REV (Application Component) Revenue
     ⤷ OIU_RV03 (Package) MP to Well Completion Split Out

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	OIURV03_DTL_ZE	Table Relationship Diagram
Short Description	Valuation Transactions Level 1 - Zero Volume

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	DOC_NO	☑	OIURV_DOCNR	OIU_MP_NO	CHAR	20	0	Val. document number	*
3	DOC_YEAR	☑	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
4	SEQ_NO	☑	OIU_DOC_LINENR	OIU_DOC_LINENR	NUMC	5	0	Document Line Number
5	LINE_NO	☑	OIU_DOC_LINENR	OIU_DOC_LINENR	NUMC	5	0	Document Line Number
6	DN_NO	☐	OIU_DN_NO	OIU_DN_NO	CHAR	20	0	Delivery network number	OIU_PR_DN
7	SALE_DT	☐	OIU_SALE_DT	DATUM	DATS	8	0	Sales Date / Month
8	FREQ_CD	☐	OIU_FREQ_CD	OIU_FREQ_CD	CHAR	1	0	Frequency
9	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
10	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
11	MP_NO	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	OIU_PR_MP
12	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	OIU_CM_MAT_PRCD
13	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
14	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	OIU_DO_JV
15	DOI_NO	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	OIU_DO_DI
16	CT_NO	☐	OIU_CT_NO	OIUCM_CONTRACT_NUMBER	CHAR	10	0	Contract Number	OIU_RV_CT
17	CT_TYPE_CD	☐	OIU_CT_TYPE_CD	OIU_CT_TYPE_CD	CHAR	2	0	Contract Type	*
18	UNIT_VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
19	MAJPD_CD	☐	OIU_MAJPD_CD	OIU_MAJPD_CD	CHAR	1	0	Major product code
20	SCHOOL_DIST_CD	☐	OIU_SCHOOL_DIST_CD	OIU_SCHOOL_DIST_CD	CHAR	3	0	School district code	*
21	TAX_CLASS	☐	OIU_TAX_CLS	OIU_TAX_CLS	CHAR	4	0	Tax Class	*
22	VL_TYPE_CD	☐	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	*
23	VL_CLS_CD	☐	OIU_VC_CD	OIU_VC_CD	CHAR	1	0	Volume class code
24	LVL_CD	☐	OIU_LVL_CD	OIU_LVL_CD	NUMC	2	0	Level Code
25	WI_OWN_NO	☐	OIU_WI_OWN_NO	KUNNR	CHAR	10	0	Working Interest Owner	*
26	WI_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	*
27	WI_OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
28	NI_OWN_NO	☐	OIU_NI_OWN_NO	LIFNR	CHAR	10	0	Net Interest Owner	*
29	NI_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	*
30	NI_OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
31	ORIG_MP_NO	☐	OIU_ORIG_MP_NO	OIU_MP_NO	CHAR	20	0	Original measurement point number	*
32	MP_TYPE_CD	☐	OIU_MP_TYPE_CD	OIU_MP_TYPE_CD	CHAR	2	0	Measurement point type code	*
33	FRML_NO	☐	OIU_FRML_NO	OIU_FORMULA_NO	CHAR	8	0	Formula number	OIU_RV_FRML
34	PPA_RSN_CD	☐	OIU_PPA_RSN_CD	OIU_PPA_RSN_CD	CHAR	2	0	Prior Period Adjustment Reason Code	OIU_CM_PPARSN
35	REJ_RSN_CD	☐	OIU_REJ_RSN_CD	OIU_REJ_RSN_CD	CHAR	3	0	Rejection Reason Code	*
36	REJ_ZV_CD	☐	OIU_REJ_ZVCD	OIU_REJ_ZVCD	CHAR	2	0	Valuation REJ ZV code
37	DOI_SUM_FL	☐	OIU_DOI_SUM_FL	OIU_X_FLAG	CHAR	1	0	Summarize RD to DOI Level Flag
38	REJ_REPRCS_FL	☐	OIU_REJ_REPRCS_FL	OIU_X_FLAG	CHAR	1	0	Reject Reprocess Flag
39	SYSTEM_SRCE_CD	☐	OIU_VL_SRCE_CD	OIU_VL_SRCE_CD	CHAR	2	0	Valuation Transaction Source Code

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIURV03_DTL_ZE	BUKRS	T001	BUKRS	KEY	1	CN
2	OIURV03_DTL_ZE	CT_NO	OIU_RV_CT	CT_NO	KEY	1	CN
3	OIURV03_DTL_ZE	DN_NO	OIU_PR_DN	DN_NO	KEY	1	CN
4	OIURV03_DTL_ZE	DOI_NO	OIU_DO_DI	DOI_NO	KEY	1	CN
5	OIURV03_DTL_ZE	FRML_NO	OIU_RV_FRML	FRML_NO	KEY	1	CN
6	OIURV03_DTL_ZE	MATNR	OIU_CM_MAT_PRCD	MATNR	KEY	1	CN
7	OIURV03_DTL_ZE	MP_NO	OIU_PR_MP	MP_NO	KEY	1	CN
8	OIURV03_DTL_ZE	PPA_RSN_CD	OIU_CM_PPARSN	PPA_RSN_CD		1	CN
9	OIURV03_DTL_ZE	VNAME	OIU_DO_JV	VNAME	KEY	1	CN
10	OIURV03_DTL_ZE	WC_NO	OIU_PR_WC	WC_NO	KEY	1	CN
11	OIURV03_DTL_ZE	WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN

History

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