SAP ABAP Class CL_GHO_SIMU_DB (DB Layer)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-PN-ALN (Application Component) Production Allocation
     ⤷ APPL_GHO_SIMU_BE (Package) Backend Logic for Simulation

Properties

Class	CL_GHO_SIMU_DB
Short Description	DB Layer
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	APPL_GHO_SIMU_BE	Backend Logic for Simulation
Created	20101028	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_GHO_SIMU_DB has no forward declaration.

Interfaces

Class CL_GHO_SIMU_DB has no interface implemented.

Friends

Class CL_GHO_SIMU_DB has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	MO_ALLOC_PREPROCESSING	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_GHO_ALLOC_PREPROCESSING		Pre-Processing steps for allocation Engine	20110105
2	MO_CL_GHO_SIMU_DB	Static Attribute	Private	☐	Object reference (TYPE REF TO)	CL_GHO_SIMU_DB		DB Layer	20101109
3	MT_GHO_T_SIMU_H	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_H		Simulation Header Table	20101109
4	MT_GHO_T_SIMU_H_T	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_H_T		text table for simulation	20101109
5	MT_SIMU_CAP	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_CAP		Table type for Simulation capacities	20101215
6	MT_SIMU_CAP_DEL	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_CAP		Table type for Simulation capacities	20101215
7	MT_SIMU_DOWN	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_DOWNTIM		Table type for simulation downtime	20101203
8	MT_SIMU_DOWN_DEL	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_DOWNTIM		Table type for simulation downtime	20101203
9	MT_SIMU_FLOW_RATES_H	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_FLRT_H		Simulation Flow Rate header table type	20101228
10	MT_SIMU_FLOW_RATES_H_DEL	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_FLRT_H		Simulation Flow Rate header table type	20101229
11	MT_SIMU_FLOW_RATES_I	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_FLRT_I		Simulation Flow Rate item table type	20101228
12	MT_SIMU_FLOW_RATES_I_DEL	Instance attribute	Private	☐	Type reference (TYPE)	GHO_T_SIMU_FLRT_I		Simulation Flow Rate item table type	20101229

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CLASS_CONSTRUCTOR	Static method	Public	Constructor	CLASS_CONSTRUCTOR	20101109
2	CLEAR_BUFFER	Instance method	Public	Method	Clear Buffer - in DB	20101109
3	DELETE_SIMU_CAPACITIES	Instance method	Public	Method	Delete Simulation Capacities	20101215
4	DELETE_SIMU_DOWNTIMES	Instance method	Public	Method	Delete simulation downtimes	20101203
5	DELETE_SIMU_FLOWRATE_DETAILS	Instance method	Public	Method	Delete Simulation Flowrates	20101229
6	DELETE_SIMU_FLOW_RATE_DET	Instance method	Public	Method	Delete flow rate data	20110103
7	GET_INSTANCE	Static method	Public	Method	Gets the singleton instance of the DB Class	20101109
8	GET_SD_ALLOC_FOR_NETOBJ	Instance method	Public	Method	Get Standard Deviation based in allocation final results	20101229
9	GET_SD_WELLTEST_FOR_NETOBJ	Instance method	Public	Method	Get Standard Deviation based in allocation final results	20110105
10	INSERT_SIMU_CAPACITIES	Instance method	Public	Method	Insert Simulation Capacities	20101215
11	INSERT_SIMU_DOWNTIMES	Instance method	Public	Method	Insert Simulation Downtimes	20101203
12	INSERT_SIMU_FLOWRATE_DETAILS	Instance method	Public	Method	Insert Simulation Flow Rates	20101228
13	INSERT_SIMU_HDR_DETAILS	Instance method	Public	Method	Insert Simulation Details	20101109
14	RETRIEVE_SIMU_CAPACITIES	Instance method	Public	Method	Retrieve Simulation Capacities	20101216
15	RETRIEVE_SIMU_DOWNTIMES	Instance method	Public	Method	Retrieve Simulation Downtimes	20101206
16	RETRIEVE_SIMU_FLOWRATE_DETAILS	Instance method	Public	Method	Retrieve SimulationFlowrates	20101229
17	RETRIVE_NETID_INET	Instance method	Public	Method	Retrive Network ID ( char 8 )	20101215
18	RETRIVE_PN_TEXT	Instance method	Public	Method	Retrive Production Network Text	20101208
19	RETRIVE_SIMU_HDR_DETAILS	Instance method	Public	Method	Retrive Simulation Details	20101110
20	UPDATE_SIMU_CAPACITIES	Instance method	Public	Method	Update Simulation Capacities	20101215
21	UPDATE_SIMU_DOWNTIMES	Instance method	Public	Method	Update Simulation downtimes	20101203
22	UPDATE_SIMU_FLOW_RATE_DETAILS	Instance method	Public	Method	Update Simulation Flowrates	20101229
23	UPDATE_SIMU_HDR_DETAILS	Instance method	Public	Method	Update Simulation Details	20101217

Events

Class CL_GHO_SIMU_DB has no event.

Types

Class CL_GHO_SIMU_DB has no local type.

Method Signatures

Method CLASS_CONSTRUCTOR Signature

Method CLASS_CONSTRUCTOR on class CL_GHO_SIMU_DB has no parameter.
Method CLASS_CONSTRUCTOR on class CL_GHO_SIMU_DB has no exception.

Method CLEAR_BUFFER Signature

Method CLEAR_BUFFER on class CL_GHO_SIMU_DB has no parameter.
Method CLEAR_BUFFER on class CL_GHO_SIMU_DB has no exception.

Method DELETE_SIMU_CAPACITIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SIMU_CAP_DEL	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_CAP		Table type for Simulation capacities	20101215

Method DELETE_SIMU_CAPACITIES on class CL_GHO_SIMU_DB has no exception.

Method DELETE_SIMU_DOWNTIMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SIMU_DOWN_DEL	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_DOWNTIM		Table type for simulation downtime	20101203

Method DELETE_SIMU_DOWNTIMES on class CL_GHO_SIMU_DB has no exception.

Method DELETE_SIMU_FLOWRATE_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FLOWRATE_H	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_FLRT_H		Simulation Flow Rate header table type	20101229
2	Importing	IT_FLOWRATE_I	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_FLRT_I		Simulation Flow Rate item table type	20101229

Method DELETE_SIMU_FLOWRATE_DETAILS on class CL_GHO_SIMU_DB has no exception.

Method DELETE_SIMU_FLOW_RATE_DET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FLOWRATE_H	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_FLRT_H		Simulation Flow Rate header table type	20110103

Method DELETE_SIMU_FLOW_RATE_DET on class CL_GHO_SIMU_DB has no exception.

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EO_CL_GHO_SIMU_DB	Call by reference	☐	Object reference (TYPE REF TO)	CL_GHO_SIMU_DB		DB Layer	20101109

Method GET_INSTANCE on class CL_GHO_SIMU_DB has no exception.

Method GET_SD_ALLOC_FOR_NETOBJ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ALLOC_STD_UOM	Call by reference	☐	Type reference (TYPE)	MSEHI		Unit of Measurement	20110106
2	Importing	MEDIUM	Call by reference	☐	Type reference (TYPE)	GHO_PRODUCT		Product on which Allocation is Performed (Oil, Gas, Water)	20101229
3	Importing	NETID	Call by reference	☐	Type reference (TYPE)	GHO_NETOBJ_ID		Network Object ID	20101229
4	Importing	NODE_ID	Call by reference	☐	Type reference (TYPE)	GHO_NODE_ID		ID of the Node in the Network	20101229
5	Importing	SIMU_DATE_RANGE_FROM	Call by reference	☐	Type reference (TYPE)	GHO_START_DATE_ALLOC		Production Start Date	20101229
6	Importing	SIMU_DATE_RANGE_TO	Call by reference	☐	Type reference (TYPE)	GHO_END_DATE_ALLOC		End of Test Date	20101229
7	Exporting	STANDARD_DEVIATION	Call by reference	☐	Type reference (TYPE)	GHO_QUANTITY		Quantity Measured/Planned against the Node:Vol,Mass,Energy	20101229

#	Exception	Resumable	Description	Created on
1	NO_RECORDS_FOUND	☐		20101229

Method GET_SD_WELLTEST_FOR_NETOBJ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ALLOC_STD_UOM	Call by reference	☐	Type reference (TYPE)	MSEHI		Unit of Measurement	20110105
2	Importing	MEDIUM	Call by reference	☐	Type reference (TYPE)	GHO_PRODUCT		Product on which Allocation is Performed (Oil, Gas, Water)	20110105
3	Importing	NETOBJ_ID	Call by reference	☐	Type reference (TYPE)	TPLNR		ID of the Node in the Network	20110105
4	Importing	NETOBJ_TYPE	Call by reference	☐	Type reference (TYPE)	GHO_NETOBJ_TYPE		Network Object ID	20110105
5	Importing	SIMU_DATE_RANGE_FROM	Call by reference	☐	Type reference (TYPE)	GHO_START_DATE_ALLOC		Production Start Date	20110105
6	Importing	SIMU_DATE_RANGE_TO	Call by reference	☐	Type reference (TYPE)	GHO_END_DATE_ALLOC		End of Test Date	20110105
7	Exporting	STANDARD_DEVIATION	Call by reference	☐	Type reference (TYPE)	GHO_QUANTITY		Quantity Measured/Planned against the Node:Vol,Mass,Energy	20110105

#	Exception	Resumable	Description	Created on
1	NO_RECORDS_FOUND	☐		20110105

Method INSERT_SIMU_CAPACITIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SIMU_CAP	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_CAP		Table type for Simulation capacities	20101215

Method INSERT_SIMU_CAPACITIES on class CL_GHO_SIMU_DB has no exception.

Method INSERT_SIMU_DOWNTIMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SIMU_DOWN	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_DOWNTIM		Table type for simulation downtime	20101203

Method INSERT_SIMU_DOWNTIMES on class CL_GHO_SIMU_DB has no exception.

Method INSERT_SIMU_FLOWRATE_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FLOWRATE_H	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_FLRT_H		Simulation Flow Rate header table type	20101228
2	Importing	IT_FLOWRATE_I	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_FLRT_I		Simulation Flow Rate item table type	20101228

Method INSERT_SIMU_FLOWRATE_DETAILS on class CL_GHO_SIMU_DB has no exception.

Method INSERT_SIMU_HDR_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_GHO_T_SIMU_H	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_H		Simulation Header Table	20101109
2	Importing	IT_GHO_T_SIMU_H_T	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_H_T		text table for simulation	20101109

Method INSERT_SIMU_HDR_DETAILS on class CL_GHO_SIMU_DB has no exception.

Method RETRIEVE_SIMU_CAPACITIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_SIMU_CAP	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_CAP		Table type for Simulation capacities	20101216
2	Importing	IV_MEDIUM	Call by reference	☐	Type reference (TYPE)	GHO_PRODUCT		Product on which Allocation is Performed (Oil, Gas, Water)	20101216
3	Importing	IV_NETID	Call by reference	☐	Type reference (TYPE)	GHO_NETOBJ_ID		Network Object ID	20101216
4	Importing	IV_NODE_ID	Call by reference	☑	Type reference (TYPE)	GHO_NODE_ID		ID of the Node in the Network	20101216
5	Importing	IV_SIMU_ID	Call by reference	☐	Type reference (TYPE)	GHO_SIMU_ID		Simulation ID	20101216

Method RETRIEVE_SIMU_CAPACITIES on class CL_GHO_SIMU_DB has no exception.

Method RETRIEVE_SIMU_DOWNTIMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_SIMU_DOWN	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_DOWNTIM		Table type for simulation downtime	20101206
2	Importing	IV_BUS_KEY	Call by reference	☑	Type reference (TYPE)	GHO_DOWN_GUID		GUID for Downtime	20101227
3	Importing	IV_NET_ID	Call by reference	☐	Type reference (TYPE)	GHO_NETOBJ_ID		Network Object ID	20101206
4	Importing	IV_OBJ_ID	Call by reference	☑	Type reference (TYPE)	GHO_NODE_ID		Network Object ID	20101206
5	Importing	IV_SIMU_ID	Call by reference	☐	Type reference (TYPE)	GHO_SIMU_ID		Simulation ID	20101206
6	Importing	IV_VALID_FROM	Call by reference	☑	Type reference (TYPE)	GHO_DOWNTIME_START_TS		Valid from Timestamp	20101206
7	Importing	IV_VALID_TO	Call by reference	☑	Type reference (TYPE)	GHO_DOWNTIME_END_TS		Valid to Timestamp	20101206

Method RETRIEVE_SIMU_DOWNTIMES on class CL_GHO_SIMU_DB has no exception.

Method RETRIEVE_SIMU_FLOWRATE_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_SIMU_FLOW_RATE_H	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_FLRT_H		Simulation Flow Rate header table type	20101229
2	Exporting	ET_SIMU_FLOW_RATE_I	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_FLRT_I		Simulation Flow Rate item table type	20101229
3	Importing	IV_FLOW_RATE_ID	Call by reference	☑	Type reference (TYPE)	GHO_FLOW_RATE_ID		Allocation Flow Rate ID	20101229
4	Importing	IV_MEDIUM	Call by reference	☑	Type reference (TYPE)	GHO_PRODUCT		Product on which Allocation is Performed (Oil, Gas, Water)	20101229
5	Importing	IV_NET_ID	Call by reference	☐	Type reference (TYPE)	GHO_NETOBJ_ID		Network Object ID	20101229
6	Importing	IV_SIMU_ID	Call by reference	☐	Type reference (TYPE)	GHO_SIMU_ID		Simulation ID	20101229
7	Importing	IV_VALID_FROM	Call by reference	☑	Type reference (TYPE)	DATS		Valid from Timestamp	20101229
8	Importing	IV_VALID_TO	Call by reference	☑	Type reference (TYPE)	DATS		Valid to Timestamp	20101229
9	Importing	IV_WC_ID	Call by reference	☑	Type reference (TYPE)	GHO_WC_ID		Well Completion ID	20101229

Method RETRIEVE_SIMU_FLOWRATE_DETAILS on class CL_GHO_SIMU_DB has no exception.

Method RETRIVE_NETID_INET Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	EV_NETID_INET	Call by reference	☐	Type reference (TYPE)	NETID		Network identification	20101215
2	Importing	IV_NETID	Call by reference	☐	Type reference (TYPE)	GHO_NETOBJ_ID		Network Object ID	20101215

Method RETRIVE_NETID_INET on class CL_GHO_SIMU_DB has no exception.

Method RETRIVE_PN_TEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_PN_HDR_TXT	Call by reference	☐	Type reference (TYPE)	GHO_T_PN_HDR_TXT		Production Header Text	20101208
2	Importing	IT_PN_HDR	Call by reference	☐	Type reference (TYPE)	GHO_T_PN_HDR		Production Header data	20101208

#	Exception	Resumable	Description	Created on
1	NO_DATA	☐	No data in database tables	20101208

Method RETRIVE_SIMU_HDR_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_GHO_T_SIMU_H	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_H		Simulation Header Table	20101110
2	Exporting	ET_GHO_T_SIMU_H_T	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_H_T		text table for simulation	20101110
3	Importing	IV_NETID	Call by reference	☐	Type reference (TYPE)	GHO_NETOBJ_ID		Network Object ID	20101110
4	Importing	IV_SIMU_ID	Call by reference	☑	Type reference (TYPE)	GHO_SIMU_ID		Simulation ID	20101110

Method RETRIVE_SIMU_HDR_DETAILS on class CL_GHO_SIMU_DB has no exception.

Method UPDATE_SIMU_CAPACITIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SIMU_CAP_UPD	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_CAP		Table type for Simulation capacities	20101215

Method UPDATE_SIMU_CAPACITIES on class CL_GHO_SIMU_DB has no exception.

Method UPDATE_SIMU_DOWNTIMES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SIMU_DOWN_UPD	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_DOWNTIM		Table type for simulation downtime	20101203

Method UPDATE_SIMU_DOWNTIMES on class CL_GHO_SIMU_DB has no exception.

Method UPDATE_SIMU_FLOW_RATE_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_FLOWRATE_H	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_FLRT_H		Simulation Flow Rate header table type	20101229
2	Importing	IT_FLOWRATE_I	Call by reference	☑	Type reference (TYPE)	GHO_T_SIMU_FLRT_I		Simulation Flow Rate item table type	20101229

Method UPDATE_SIMU_FLOW_RATE_DETAILS on class CL_GHO_SIMU_DB has no exception.

Method UPDATE_SIMU_HDR_DETAILS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_GHO_T_SIMU_H	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_H		Simulation Header Table	20101217
2	Importing	IT_GHO_T_SIMU_H_T	Call by reference	☐	Type reference (TYPE)	GHO_T_SIMU_H_T		Text table for simulation	20101217

Method UPDATE_SIMU_HDR_DETAILS on class CL_GHO_SIMU_DB has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	606