SAP ABAP Table ROIU_PR_WCTST (Maintenance Structure: OIU_PR_WCTST)

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_PR_WCTST	Table Relationship Diagram
Short Description	Maintenance Structure: OIU_PR_WCTST

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	MECLS	☐	OIU_ME_MECLS	OIU_ME_MECLS	CHAR	10	0	Measurement class	OIU_ME_CLASS
2	LWGOR_PC	☐	OIU_LWGOR_PC	OIU_PERCENT63	DEC	6	3	Lease Wide GOR Percent
3	TST_TYP_CD_DE	☐	OIU_TST_TYPE_CD_DE	OIU_TEXT25	CHAR	25	0	Test Type Code desc
4	EFF_FROM_DT	☐	OIU_EFF_FROM_DT	DATUM	DATS	8	0	Effective from date
5	EFF_FROM_TM	☐	OIU_EFF_FROM_TM	TIME	TIMS	6	0	Effective From Time
6	REF_EFF_FROM_DT	☐	OIU_EFF_FROM_DT_REF	DATUM	DATS	8	0	Reference effective from date
7	REF_EFF_FROM_TM	☐	OIU_EFF_FROM_TM_REF	TIME	TIMS	6	0	Reference Effective From Time
8	REF_TEST_DT	☐	OIU_TEST_DT	TZNTSTMPS	DEC	15	0	Test date
9	REF_WL_NO	☐	OIU_WL_NO_REF	OIU_WL_NO	CHAR	15	0	Reference well ID number	OIU_PR_WELL
10	REF_WC_NO	☐	OIU_WC_NO_REF	OIU_WC_NO	CHAR	5	0	Reference well completion number	OIU_PR_WC
11	WC_NAME	☐	OIU_WC_NM	OIU_TEXT35	CHAR	35	0	Well completion name
12	STRM_TYPE_DE	☐	OIU_STRM_TYPE_DE	OIU_TEXT50	CHAR	50	0	Stream Type Description
13	REF_STRM_TYPE_DE	☐	OIU_STRM_TYPE_DE	OIU_TEXT50	CHAR	50	0	Stream Type Description
14	REF_WC_NAME	☐	OIU_WC_NM	OIU_TEXT35	CHAR	35	0	Well completion name
15	REF_STRM_TYPE_CD	☐	OIU_STRM_TYPE_CD_REF	OIU_STRM_TYPE_CD	CHAR	1	0	Reference stream type code	OIU_PR_STRMT
16	WL_CLASS_CD	☐	OIU_WL_CLASS_CD	OIU_WL_CLASS_CD	CHAR	2	0	Well class code	OIU_PR_WLCLS
17	WL_CLASS_DE	☐	OIU_WL_CLASS_DE	OIU_TEXT50	CHAR	50	0	Well Class Description
18	STATUS_CD	☐	OIU_WC_STATUS_CD	OIU_WC_STATUS_CD	CHAR	2	0	Well completion status code	OIU_PR_WC_STS
19	STATUS_DE	☐	OIU_STATUS_DE	OIU_TEXT35	CHAR	35	0	Status description
20	PRD_MTH_CD	☐	OIU_PRD_MTH_CD	OIU_PRD_MTH_CD	CHAR	2	0	Producing method code	OIU_PR_PMCD
21	UOMGR_DESCR	☐	OIU_ME_UOMGR_TX	TEXT40	CHAR	40	0	Description of the unit of measure group
22	UOM_GRP	☐	OIU_ME_UOMGR	OIU_ME_UOMGR	CHAR	3	0	unit of measure group	OIU_ME_UOM_GR
23	PRD_MTH_DE	☐	OIU_PRD_MTH_DE	OIU_TEXT50	CHAR	50	0	Producing Method Description
24	FIELD	☐	OIU_FIELDID	OIU_FIELDID	CHAR	10	0	Field ID	OIU_PR_FIELD
25	FL_NAME	☐	OIU_FL_NM	OIU_TEXT35	CHAR	35	0	Field name
26	PF_NO	☐	OIU_PF_NO	OIU_PF_NO	CHAR	10	0	Platform number	OIU_PR_PF
27	PF_NAME	☐	OIU_PF_NAME	OIU_TEXT35	CHAR	35	0	Platform Name
28	XXDBACTION	☐	OIU_DBACTION	CHAR1	CHAR	1	0	Database Action Flag
29	DOCYR	☐	OIU_ME_DOCYR	GJAHR	NUMC	4	0	Meas. document year
30	METYP	☐	OIU_ME_METYP	OIU_ME_METYP	CHAR	10	0	Measurement Type	*
31	ME_DOCNR	☐	OIU_ME_DOCNR	BELNR	CHAR	10	0	Meas. document number
32	ME_DOCYR	☐	OIU_ME_DOCYR	GJAHR	NUMC	4	0	Meas. document year
33	DUR_HRS_U	☐	OIU_GEN_U	MEINS	UNIT	3	0	Oil Condency API Unit	*
34	DUR_MIN_U	☐	OIU_GEN_U	MEINS	UNIT	3	0	Oil Condency API Unit	*
35	N2_PC_U	☐	OIU_GEN_U	MEINS	UNIT	3	0	Oil Condency API Unit	*
36	CO2_PC_U	☐	OIU_GEN_U	MEINS	UNIT	3	0	Oil Condency API Unit	*
37	.INCLUDE	☐				0	0	Well Test
38	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
39	WCTST_NO	☐	OIU_WCTST_NO	OIU_DOCNR	CHAR	10	0	Well Test Number
40	DOC_YEAR	☐	OIU_DOC_YEAR	GJAHR	NUMC	4	0	Document year
41	WL_NO	☐	OIU_WL_NO	OIU_WL_NO	CHAR	15	0	Well ID number	OIU_PR_WELL
42	WC_NO	☐	OIU_WC_NO	OIU_WC_NO	CHAR	5	0	Well Completion Number	OIU_PR_WC
43	TEST_DT	☐	OIU_TEST_DT	TZNTSTMPS	DEC	15	0	Test date
44	STRM_TYPE_CD	☐	OIU_STRM_TYPE_CD	OIU_STRM_TYPE_CD	CHAR	1	0	Stream type code	OIU_PR_STRMT
45	TST_TYPE_CD	☐	OIU_TST_TYPE_CD	OIU_TST_TYPE_CD	CHAR	1	0	Test type
46	AL_FL	☐	OIU_AL_IND_CD	OIU_X_FLAG	CHAR	1	0	Allocation Indicator Code
47	OC_U	☐	OIU_OC_U	MEINS	UNIT	3	0	Oil condensate unit	T006
48	OC	☐	OIU_OC	MENGE	QUAN	13	3	Oil Condensate
49	WATER_U	☐	OIU_WATER_U	MEINS	UNIT	3	0	Water Unit	T006
50	WATER	☐	OIU_WATER	MENGE	QUAN	13	3	Water Quantity
51	DUR_HRS	☐	OIU_DUR_HRS	OIU_DUR_HRS	DEC	10	0	Duration Hours
52	DUR_MIN	☐	OIU_DUR_MIN	OIU_DUR_MIN	DEC	2	0	Duration Minutes
53	HEAT_VAL_U	☐	OIU_HEAT_VAL_U	MEINS	UNIT	3	0	Heating Value Unit	T006
54	HEAT_VAL	☐	OIU_HEAT_VAL	MENGE	QUAN	13	3	Heating value
55	GLG_U	☐	OIU_GLG_U	MEINS	UNIT	3	0	GLG Unit (Gas Lift Gas Unit)	T006
56	GLG	☐	OIU_GLG	MENGE	QUAN	13	3	Gas Lift (GLG)
57	GAS_U	☐	OIU_GAS_U	MEINS	UNIT	3	0	Gas Unit	T006
58	GAS	☐	OIU_GAS	MENGE	QUAN	13	3	Gas
59	NET_GAS_U	☐	OIU_NET_GAS_U	MEINS	UNIT	3	0	Net Gas Unit	T006
60	NET_GAS	☐	OIU_NET_GAS	MENGE	QUAN	13	3	Net Gas
61	N2_PC	☐	OIU_N2PC	MENGE	QUAN	13	3	N2 Percent
62	CO2_PC	☐	OIU_CO2PC	MENGE	QUAN	13	3	CO2 PC
63	CHO_SZ	☐	OIU_CHO_SZ	MENGE	QUAN	13	3	Choke size
64	CHO_SZ_U	☐	OIU_CHO_SZ_U	MEINS	UNIT	3	0	Choke size unit	T006
65	FLO_PS_U	☐	OIU_FLO_PS_U	MEINS	UNIT	3	0	Flow pressure unit (FLO PS unit)	T006
66	FLO_PS	☐	OIU_FLO_PS	MENGE	QUAN	13	3	Flow pressure (Flow PS)
67	TMP_U	☐	OIU_TMP_U	MEINS	UNIT	3	0	Temperature Unit	T006
68	TMP	☐	OIU_TMP	MENGE	QUAN	13	3	Temperature
69	BASE_DENSITY_U	☐	OIB_BDNEH	MEINS	UNIT	3	0	Unit for densities at standard/base conditions	T006
70	BASE_DENSITY	☐	OIB_BDICH	OIB_DICHT	FLTP	16	16	Oil/gas density at standard/base conditions
71	DENTYP	☐	OIB_DNTYP	OIB_DNTYP	CHAR	1	0	Density Type
72	.INCLUDE	☐				0	0	Creator and date/time created
73	OIU_CRUSER	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
74	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	ROIU_PR_WCTST	BASE_DENSITY_U	T006	MSEHI		1	CN
2	ROIU_PR_WCTST	CHO_SZ_U	T006	MSEHI	KEY	1	CN
3	ROIU_PR_WCTST	FIELD	OIU_PR_FIELD	FIELD	KEY	1	CN
4	ROIU_PR_WCTST	FLO_PS_U	T006	MSEHI		1	CN
5	ROIU_PR_WCTST	GAS_U	T006	MSEHI		1	CN
6	ROIU_PR_WCTST	GLG_U	T006	MSEHI		1	CN
7	ROIU_PR_WCTST	HEAT_VAL_U	T006	MSEHI		1	CN
8	ROIU_PR_WCTST	MECLS	OIU_ME_CLASS	MECLS	KEY	1	CN
9	ROIU_PR_WCTST	NET_GAS_U	T006	MSEHI		1	CN
10	ROIU_PR_WCTST	OC_U	T006	MSEHI	KEY	1	CN
11	ROIU_PR_WCTST	PF_NO	OIU_PR_PF	PF_NO	KEY	1	CN
12	ROIU_PR_WCTST	PRD_MTH_CD	OIU_PR_PMCD	PRD_MTH_CD	KEY	1	CN
13	ROIU_PR_WCTST	REF_STRM_TYPE_CD	OIU_PR_STRMT	STRM_TYPE_CD
14	ROIU_PR_WCTST	REF_WC_NO	OIU_PR_WC	WC_NO	KEY	1	CN
15	ROIU_PR_WCTST	REF_WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN
16	ROIU_PR_WCTST	STATUS_CD	OIU_PR_WC_STS	STATUS_CD	KEY	1	CN
17	ROIU_PR_WCTST	STRM_TYPE_CD	OIU_PR_STRMT	STRM_TYPE_CD
18	ROIU_PR_WCTST	TMP_U	T006	MSEHI		1	CN
19	ROIU_PR_WCTST	UOM_GRP	OIU_ME_UOM_GR	UOMGR	KEY	1	CN
20	ROIU_PR_WCTST	WATER_U	T006	MSEHI	KEY	1	CN
21	ROIU_PR_WCTST	WC_NO	OIU_PR_WC	WC_NO	KEY	1	CN
22	ROIU_PR_WCTST	WL_CLASS_CD	OIU_PR_WLCLS	WL_CLASS_CD		1	CN
23	ROIU_PR_WCTST	WL_NO	OIU_PR_WELL	WL_NO	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in