SAP ABAP Table ROIU_RV_VLTXNS2 (Valuation Transaction Level 2)

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_RV_VLTXNS2	Table Relationship Diagram
Short Description	Valuation Transaction Level 2

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	VLTXNS_NO	☐	OIU_VLTXNS_NO	OIU_SYS_NO	NUMC	12	0	Valuation Transaction Number
2	POS_NO	☐	OIU_POS_NO	NUMC3	NUMC	3	0	Position Number for
3	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
4	PRI_GEO_LOC	☐	OIU_PRI_GEO_LOC	OIU_PRI_GEO_LOC	CHAR	2	0	Primary geographical location (PRI geo. loc.)	*
5	SEC_GEO_LOC	☐	OIU_SEC_GEO_LOC	OIU_SEC_GEO_LOC	CHAR	3	0	Secondary geographic location	*
6	ONS_OFS_CD	☐	OIU_ONS_OFS_CD	OIU_ONS_OFS_CD	CHAR	1	0	Onshore/Offshore codes
7	SYSTEM_SRCE_CD	☐	OIU_VL_SRCE_CD	OIU_VL_SRCE_CD	CHAR	2	0	Valuation Transaction Source Code
8	PAY_CD	☐	OIU_PAY_CD	OIU_PAY_CD	CHAR	2	0	Pay Code
9	VNAME_TYPE_CD	☐	OIU_VNAME_TYPE_CD	OIU_PR_TYPE_CD	CHAR	2	0	Venture Usage Type
10	THEO_CND_TAX_FL	☐	OIU_THEO_CND_TAX_FL	OIU_X_FLAG	CHAR	1	0	Theoretical Condensate Tax Calculation Flag
11	CA_ALLOC_METH_CD	☐	OIU_CA_ALLOC_METH_CD	OIU_CA_ALLOC_METH_CD	CHAR	1	0	Allocation Method Code
12	RELATED_CT	☐	OIU_RELATED_CT	VBELN	CHAR	10	0	Related Contract	*
13	LVL_CD	☐	OIU_LVL_CD	OIU_LVL_CD	NUMC	2	0	Level Code
14	WI_OWN_NO	☐	OIU_WI_OWN_NO	KUNNR	CHAR	10	0	Working Interest Owner	*
15	WI_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	*
16	WI_OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
17	TR_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
18	TR_VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
19	TR_DOI	☐	OIU_DOI_NO	OIU_DOI_NO	CHAR	5	0	Division of interest (DOI)	*
20	NI_OWN_NO	☐	OIU_NI_OWN_NO	LIFNR	CHAR	10	0	Net Interest Owner	*
21	NI_INT_TYPE_CD	☐	OIU_PART_INT_TYPE	OIU_PART_INT_TYPE	CHAR	2	0	Participant Interest Type	*
22	NI_OWN_ISQ_NO	☐	OIU_OWN_ISQ_NO	OIU_OWN_ISQ_NO	CHAR	2	0	Owner Interest Sequence Number
23	NI_FRML_NO	☐	OIU_FRML_NO	OIU_FORMULA_NO	CHAR	8	0	Formula number	*
24	TOT_GRI_PC	☐	OIU_TOT_GRI_PC	OIU_PERCENT98	DEC	9	8	Total Gross Interest %
25	TOT_NRI_PC	☐	OIU_TOT_NRI_PC	OIU_PERCENT98	DEC	9	8	Total Net Revenue Interest Percentage
26	CT_DECM	☐	OIU_CT_DECM	OIU_PERCENT98	DEC	9	8	Contract Decimal
27	REL_CT_DECM	☐	OIU_REL_CT_DECM	OIU_PERCENT98	DEC	9	8	Relative Contract Decimal
28	SETT_DECM	☐	OIU_SETT_DECM	OIU_PERCENT98	DEC	9	8	Sett. Div. Decimal Amount
29	TOT_MKT_GRP_GRI	☐	OIU_TOT_MKT_GRP_GRI	OIU_PERCENT98	DEC	9	8	Total Market Groups GRI
30	MP_TYPE_CD	☐	OIU_MP_TYPE_CD	OIU_MP_TYPE_CD	CHAR	2	0	Measurement point type code	*
31	ORIG_MP_NO	☐	OIU_ORIG_MP_NO	OIU_MP_NO	CHAR	20	0	Original measurement point number	*
32	MP_TYPE_CD2	☐	OIU_MP_TYPE_CD	OIU_MP_TYPE_CD	CHAR	2	0	Measurement point type code	*
33	VL_TYPE_CD	☐	OIU_VT_CD	OIU_VL_TYPE_CD	CHAR	2	0	Volume type code	*
34	VL_CLS_CD	☐	OIU_VC_CD	OIU_VC_CD	CHAR	1	0	Volume class code
35	FRML_ACTL_FL	☐	OIU_ACTL_FL	OIU_X_FLAG	CHAR	1	0	Actual indicator
36	FRML_ENTL_FL	☐	OIU_ENTL_FL	OIU_X_FLAG	CHAR	1	0	Entitled Flag
37	FRML_SETT_FL	☐	OIU_SETT_FL	OIU_X_FLAG	CHAR	1	0	Settlement Flag
38	TOT_CT_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
39	TOT_CT_VL	☐	OIU_TOT_CT_VL	MENGE	QUAN	13	3	Total Contract Volume
40	TOT_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
41	TOT_GR_VL	☐	OIU_TOT_GR_VL	MENGE	QUAN	13	3	Total Gross Volume
42	ACTL_GR_VL	☐	OIU_ACTL_GR_VL_AM	MENGE	QUAN	13	3	Actual Gross Volume Amount
43	ACTL_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
44	ENTL_GR_VL	☐	OIU_ENTL_GR_VL_AM	MENGE	QUAN	13	3	Entitled Gross Volume Amount
45	ENTL_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
46	SETT_GR_VL	☐	OIU_SETT_GR_VL_AM	MENGE	QUAN	13	3	Settlement Gross Volume Amount
47	SETT_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
48	ACTL_ENERGY	☐	OIU_ACTL_ENERGY	MENGE	QUAN	13	3	Actual Energy
49	ACTL_ENERGY_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
50	ENTL_ENERGY	☐	OIU_ENTL_ENERGY	MENGE	QUAN	13	3	Entitlement Energy
51	ENTL_ENERGY_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
52	SETT_ENERGY	☐	OIU_SETT_ENERGY	MENGE	QUAN	13	3	Settlement Amount
53	SETT_ENERGY_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
54	UNCR_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
55	UNCR_GR_VL	☐	OIU_UNCR_GR_VL	MENGE	QUAN	13	3	Uncorrected Gross Volume
56	UNCR_SETT_GR_VL	☐	OIU_UNCR_SETT_GR_VL	MENGE	QUAN	13	3	Uncorr. Sett. Div. Gross Volume
57	RUN_TKT_NO	☐	OIU_RUN_TKT_NO	CHAR7	CHAR	7	0	Run Ticket Number
58	TOT_TKT_DAYS	☐	OIU_TOT_TKT_DAYS	NUMC05	NUMC	5	0	Total Number of Ticket Days
59	PRD_DAYS	☐	OIU_DAYS_PROD	OIU_DAYS_PROD	NUMC	2	0	Days produced
60	SALE_DT_TO	☐	OIU_SA_DT_TO	DATUM	DATS	8	0	Sales To-Date
61	SALE_DT_FROM	☐	OIU_SA_DT_FROM	DATUM	DATS	8	0	Sales From-Date
62	TANK_METER	☐	OIU_MP_NO	OIU_MP_NO	CHAR	20	0	Measurement point number	*
63	GRV_AM	☐	OIU_STD_DENSITY	MENGE	QUAN	13	3	Standard Density
64	DENSITY_U	☐	OIB_BDNEH	MEINS	UNIT	3	0	Unit for densities at standard/base conditions	*
65	DNTYP	☐	OIB_DNTYP	OIB_DNTYP	CHAR	1	0	Density Type
66	HEAT_VALUE_FCT_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
67	ACT_HEAT_VAL_FCT	☐	OIU_ACT_HEAT_VAL_FCT	MENGE	QUAN	13	3	Actual Heating Factor
68	SET_HEAT_VAL_FCT	☐	OIU_SET_HEAT_VAL_FCT	MENGE	QUAN	13	3	Sett. Stmt. Heating Factor
69	CT_HEAT_VA_FCT_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
70	CT_HEAT_VAL_FCT	☐	OIU_CT_HEAT_VAL_FCT	MENGE	QUAN	13	3	Contract Heating Factor
71	VL_TIMESTAMP	☐	TZNTSTMPS	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
72	TRNSP_NO	☐	OIU_TRNSP_NO	KUNNR	CHAR	10	0	Transporter number	*
73	TRNSP_REF_NO	☐	OIU_TRNSP_REF_NO	OIU_TEXT25	CHAR	25	0	Transporter Reference Number
74	TRNSP_ROU_CD	☐	OIU_TRNSP_ROU_CD	OIU_TRNSP_ROU_CD	CHAR	1	0	Transporter route code
75	GASLIFT_WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	*
76	GASLIFT_WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	*
77	REJ_RSN_CD	☐	OIU_REJ_RSN_CD	OIU_REJ_RSN_CD	CHAR	3	0	Rejection Reason Code	*
78	RA_PCT	☐	OIU_RA_PCT	OIU_PERCENT73	DEC	7	3	RA Formation Percent
79	TIK_PA_PC	☐	OIU_TIK_PA_PC	OIU_PERCENT73	DEC	7	3	Processing Agreements Percent
80	CA_WGB_CD	☐	OIU_CA_WGB_CD	OIU_CA_FPF_WGB_CD	CHAR	1	0	Wet Gas Balancing Code
81	CALC_WLR_FL	☐	OIU_CALC_WETLESRES_FL	OIU_X_FLAG	CHAR	1	0	Calc. WetLesRes
82	PCT_RET_LSE	☐	OIU_PCT_RET_LSE	OIU_PERCENT74	DEC	7	4	Percent Returned to Lease
83	ACTL_WLR_VL_AM	☐	OIU_ACTL_WLR_VL_AM	MENGE	QUAN	13	3	Act. Wet-less-Residue Vol. Amount
84	ACTL_WLR_VL_AM_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
85	ENTL_WLR_VL_AM	☐	OIU_ENTL_WLR_VL_AM	MENGE	QUAN	13	3	Entl. Wet-less-Residue Vol. Amount
86	ENTL_WLR_VL_AM_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
87	SETT_WLR_VL_AM	☐	OIU_SETT_WLR_VL_AM	MENGE	QUAN	13	3	Sett. Wet-less-Residue Vol. Amount
88	SETT_WLR_VL_AM_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
89	ENT_VL_ALLOC_DEC	☐	OIU_ENT_VL_ALLOC_DEC	OIU_PERCENT98	DEC	9	8	Entitled Volume Allocation Decimal
90	ENT_ENG_ALLC_DEC	☐	OIU_ENT_ENG_ALLC_DEC	OIU_PERCENT98	DEC	9	8	Entitled Energy Allocation Decimal
91	ENT_SET_GR_VL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
92	ENTL_SETT_GR_VL	☐	OIU_ENTL_SETT_GR_VL	MENGE	QUAN	13	3	Entitled Sett. Gross Volume
93	ENTL_SETT_ENG_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
94	ENTL_SETT_ENERGY	☐	OIU_ENTL_SETT_ENERGY	MENGE	QUAN	13	3	Entitiled Sett. Energy
95	COST_CENTER	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
96	LSE_VOL	☐	OIU_LSE_VOL	MENGE	QUAN	13	3	Lease Volume
97	LSE_VOL_U	☐	OIU_MEAS_U	MEINS	UNIT	3	0	Measurement unit	*
98	GPLT_VNAME	☐	OIU_GPLT_VNAME	JV_NAME	CHAR	6	0	Gas Plant Venture	*
99	GPLT_DOI_DOI	☐	OIU_GPLT_DOI_NO	OIU_DOI_NO	CHAR	5	0	Gasplant DOI No	*

History

Last changed by/on	SAP	20130529
SAP Release Created in