SAP ABAP Class CL_PPH_HANA_ACCESS (Access HANA functions for PP)

Hierarchy

☛

SAP_APPL (Software Component) Logistics and Accounting
⤷

PP-MRP (Application Component) Material Requirements Planning
⤷

PPH_ACCESS_HANA (Package) PP on HANA: Access to HANA objects

Properties

Class	CL_PPH_HANA_ACCESS
Short Description	Access HANA functions for PP
Super Class
Instantiability of a Class	0	Private
Final

General Data

Message Class
Program status
Category	0
Package	PPH_ACCESS_HANA	PP on HANA: Access to HANA objects
Created	20120806	SAP
Last change	20140121	SAP
Shared Memory-enabled
Fixed point arithmetic
Unicode checks active

Forward declarations

#	Type group / Object type	Type	Type Description
1	ABAP	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)
2	IF_SDM_KPI	Forward declaration interface (INTERFACE i DEFINITION DEF...	Forward declaration interface (INTERFACE i DEFINITION DEF...

Interfaces

Class CL_PPH_HANA_ACCESS has no interface implemented.

Friends

Class CL_PPH_HANA_ACCESS has no friend class.

Attributes

#	Attribute	Level	Visibility	Typing	Associated Type	Initial Value	Description	Created on
1	GC_BUFFER_MODE_P	Static Attribute	Public	Type reference (TYPE)	CHAR1	'P'	Single-Character Indicator	20130417
2	GC_DEFAULT_RESULT_VIEW_1_AGG	Constant	Public	Type reference (TYPE)	STRING	'_SYS_BIC.PPH_AV_FINALIZE_AGG_1'		20121017
3	GC_DEFAULT_RESULT_VIEW_1_NAGG	Constant	Public	Type reference (TYPE)	STRING	'_SYS_BIC.PPH_V_FINALIZE_NON_AGG_1'		20121017
4	GC_DEFAULT_RESULT_VIEW_AGG	Constant	Public	Type reference (TYPE)	STRING	'_SYS_BIC.PPH_MDPS_EXT'		20120806
5	GC_DEFAULT_RESULT_VIEW_NON_AGG	Constant	Public	Type reference (TYPE)	STRING	'_SYS_BIC.PPH_MDPS_EXT_NON_AGG'		20120806
6	GC_UNION_AGG	Constant	Public	Type reference (TYPE)	STRING	'PPH_UNION_AGG'		20120827
7	GC_UNION_NON_AGG	Constant	Public	Type reference (TYPE)	STRING	'PPH_UNION_NON_AGG'		20120827
8	GT_INSTANCES	Static Attribute	Private	See coding				20120806
9	GV_FORCE_MODE	Static Attribute	Public	Type reference (TYPE)	CHAR1	' '	1 w/ move-c, 2 w/o, 3 w/ proxy	20120921
10	MO_CON_REF	Instance attribute	Protected	Object reference (TYPE REF TO)	CL_SQL_CONNECTION			20120806
11	MT_MDPS_ONE_OUT	Instance attribute	Protected	Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20121017
12	MT_MDPS_OUT	Instance attribute	Protected	Type reference (TYPE)	PPH_MDPS_EXT_TAB			20120806
13	MV_RESULT_VIEW	Instance attribute	Protected	Type reference (TYPE)	STRING			20120806

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	BUILD_MDSP_INDV	Instance method	Private	Method	Build MDPS from individual tables	20130228
2	BUILD_MDSP_INDV_AFPO	Instance method	Private	Method	Build MDPS from individual tables	20130517
3	BUILD_MDSP_INDV_EBAN	Instance method	Private	Method	Build MDPS from individual tables	20130517
4	BUILD_MDSP_INDV_MARD	Instance method	Private	Method	Build MDPS from individual tables	20130517
5	BUILD_MDSP_INDV_MDBS	Instance method	Private	Method	Build MDPS from individual tables	20130517
6	BUILD_MDSP_INDV_MDLA	Instance method	Private	Method	Build MDPS from individual tables	20130517
7	BUILD_MDSP_INDV_MDPB	Instance method	Private	Method	Build MDPS from individual tables	20130517
8	BUILD_MDSP_INDV_MDQM	Instance method	Private	Method	Build MDPS from individual tables	20130517
9	BUILD_MDSP_INDV_MDRELA	Instance method	Private	Method	Build MDPS from individual tables	20130517
10	BUILD_MDSP_INDV_MDUA	Instance method	Private	Method	Build MDPS from individual tables	20130517
11	BUILD_MDSP_INDV_MDUB	Instance method	Private	Method	Build MDPS from individual tables	20130517
12	BUILD_MDSP_INDV_MDUR	Instance method	Private	Method	Build MDPS from individual tables	20130517
13	BUILD_MDSP_INDV_MRBED	Instance method	Private	Method	Build MDPS from individual tables	20130517
14	BUILD_MDSP_INDV_MSSA	Instance method	Private	Method	Build MDPS from individual tables	20130517
15	BUILD_MDSP_INDV_MSSL	Instance method	Private	Method	Build MDPS from individual tables	20130517
16	BUILD_MDSP_INDV_MSSQ	Instance method	Private	Method	Build MDPS from individual tables	20130517
17	BUILD_MDSP_INDV_PLAF	Instance method	Private	Method	Build MDPS from individual tables	20130517
18	BUILD_MDSP_INDV_PROW	Instance method	Private	Method	Build MDPS from individual tables	20130517
19	BUILD_MDSP_INDV_RESB	Instance method	Private	Method	Build MDPS from individual tables	20130517
20	BUILD_MDSP_INDV_RESB_AGG	Instance method	Private	Method	Build MDPS from individual tables	20130517
21	BUILD_MDSP_INDV_VBBE	Instance method	Private	Method	Build MDPS from individual tables	20130517
22	BUILD_MDSP_INDV_VBBE_AGG	Instance method	Private	Method	Build MDPS from individual tables	20130517
23	CONSTRUCTOR	Instance method	Private	Constructor		20120806
24	DELETE_BUFFER_BY_MATNR_WERKS	Instance method	Public	Method		20120919
25	EXECUTE_PROCEDURE	Instance method	Public	Method	Call PPH procedure, delegates to other	20120806
26	EXECUTE_PROCEDURE_1	Instance method	Private	Method	Call procedure w/ ADBC, transfer with move-corresponding	20120919
27	EXECUTE_PROCEDURE_2	Instance method	Private	Method	Call procedure w/ ADBC, no move-corresponding (faster)	20120821
28	EXECUTE_PROCEDURE_3	Instance method	Private	Method	DB proxies	20120827
29	EXECUTE_PROCEDURE_KPI	Instance method	Public	Method		20121130
30	EXECUTE_PROCEDURE_MAT_CTRL	Instance method	Public	Method		20121130
31	EXECUTE_PROCEDURE_TWO	Instance method	Public	Method	Call PPH procedure for SP2	20130225
32	GENERATE_PROCEDURES	Instance method	Public	Method		20120904
33	GET_INSTANCE	Static method	Public	Method		20120806
34	HANDLE_SQL_EXCEPTION	Instance method	Private	Method		20120904
35	PREPARE_SELECT_BY_DISPO_WERKS	Instance method	Public	Method		20120806
36	PREPARE_SELECT_BY_MATNR_BERID	Instance method	Public	Method		20120806
37	PREPARE_SELECT_BY_MATNR_WERKS	Instance method	Public	Method		20120806
38	READ_SDM_DEMANDS	Instance method	Public	Method		20131115
39	READ_SDM_KPI	Instance method	Public	Method		20131115
40	READ_SDM_LATE_SUPPLIES	Instance method	Public	Method		20131115
41	RETRIEVE_RESULT_BY_MATNR_BERID	Instance method	Public	Method	read data from local buffer and delete buffer	20120816
42	RETRIEVE_RESULT_BY_MATNR_WERKS	Instance method	Public	Method	read data from local buffer and delete buffer	20120806
43	RETRIEVE_RESULT_BY_MATNR_WRK_1	Instance method	Public	Method	read data from local buffer and delete buffer	20130225
44	TRUNCATE	Instance method	Private	Method		20120806
45	_ASSERT_NO_DUPRECS	Instance method	Private	Method		20120913
46	_CREATE	Instance method	Private	Method		20120827
47	_PREP_TABLE_ABAP	Instance method	Private	Method		20120904
48	_PREP_TABLE_SQL	Instance method	Private	Method		20120904

Events

Class CL_PPH_HANA_ACCESS has no event.

Types

#	Type	Visibility	Typing	Created on	Type Source
1	CODE_TABLE	Private	See coding	20120904	`code_table TYPE STANDARD TABLE OF char250_d`
2	INST_TYPE	Private	See coding	20120806	`BEGIN OF inst_type, view_name TYPE string, access TYPE REF TO cl_pph_hana_access, END OF inst_type`
3	KPI_AVAILABLE_QTY	Public	See coding	20131115	`kpi_available_qty TYPE STANDARD TABLE OF if_sdm_kpi=>et_sdiv_totals`
4	KPI_LATE_SUPPLY_ITEM	Public	See coding	20131115	`kpi_late_supply_item TYPE STANDARD TABLE OF if_sdm_kpi=>et_late_supply_item`
5	KPI_MATERIAL	Public	See coding	20131115	`kpi_material TYPE STANDARD TABLE OF if_sdm_kpi=>et_material`
6	KPI_PLANNING_SEGMENT	Public	See coding	20131115	`kpi_planning_segment TYPE STANDARD TABLE OF if_sdm_kpi=>et_planning_segment`
7	KPI_SHORTAGE	Public	See coding	20131115	`kpi_shortage TYPE STANDARD TABLE OF if_sdm_kpi=>et_shortage_statistics`
8	KPI_SUPPLIER	Public	See coding	20131115	`kpi_supplier TYPE STANDARD TABLE OF if_sdm_kpi=>et_supplier`
9	KPI_SUPPLY_DEMAND_ITEM	Public	See coding	20131115	`kpi_supply_demand_item TYPE STANDARD TABLE OF if_sdm_kpi=>et_supply_demand_item`
10	KPI_UNCOVERED_DEMAND	Public	See coding	20131115	`kpi_uncovered_demand TYPE STANDARD TABLE OF if_sdm_kpi=>et_uncovered_demand_item`
11	STRING_TABLE	Private	See coding	20120904	`string_table TYPE STANDARD TABLE OF string`
12	TS_SUPPLY	Public	See coding	20131115	`BEGIN OF ts_supply, werks TYPE werks_d, matnr TYPE matnr, berid TYPE berid, plaab TYPE plaab, planr TYPE planr, date TYPE dat00, dat01 TYPE dat01, dat02 TYPE dat02, fix01 TYPE fix01, oqty TYPE mng01, lqty TYPE mng01, cumqty TYPE mng01, is_late TYPE boolean, rdate TYPE dat00, "requirement date for late receipts delkz TYPE delkz, delnr TYPE del12, delps TYPE delps, delet TYPE delet, lifnr TYPE lifnr, wrk02 TYPE wrk02, END OF ts_supply`
13	TT_AFPO	Public	See coding	20130517	`tt_afpo TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_afpo_out`
14	TT_CTRL	Public	See coding	20130517	`tt_ctrl TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_ctrl_out`
15	TT_DEMAND	Public	See coding	20131115	`tt_demand type standard table of ty_demand with DEFAULT KEY`
16	TT_EBAN	Public	See coding	20130517	`tt_eban TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_eban_out`
17	TT_MARD	Public	See coding	20130517	`tt_mard TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mard_out`
18	TT_MATNR_WERKS_BERID_SEL	Public	See coding	20130417	`tt_matnr_werks_berid_sel TYPE TABLE OF if_pph_sp02_finalize_non_agg=>it_sel`
19	TT_MDBS	Public	See coding	20130517	`tt_mdbs TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mdbs_out`
20	TT_MDLA	Public	See coding	20130517	`tt_mdla TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mdla_out`
21	TT_MDPB	Public	See coding	20130517	`tt_mdpb TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mdpb_out`
22	TT_MDQM	Public	See coding	20130517	`tt_mdqm TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mdqm_out`
23	TT_MDRELA	Public	See coding	20130517	`tt_mdrela TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mdrela_out`
24	TT_MDUA	Public	See coding	20130517	`tt_mdua TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mdua_out`
25	TT_MDUB	Public	See coding	20130517	`tt_mdub TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mdub_out`
26	TT_MDUR	Public	See coding	20130517	`tt_mdur TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mdur_out`
27	TT_MRBED	Public	See coding	20130517	`tt_mrbed TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mrbed_out`
28	TT_MSSA	Public	See coding	20130517	`tt_mssa TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mssa_out`
29	TT_MSSL	Public	See coding	20130517	`tt_mssl TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mssl_out`
30	TT_MSSQ	Public	See coding	20130517	`tt_mssq TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_mssq_out`
31	TT_PLAF	Public	See coding	20130517	`tt_plaf TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_plaf_out`
32	TT_PROW	Public	See coding	20130517	`tt_prow TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_prow_out`
33	TT_RESB	Public	See coding	20130517	`tt_resb TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_resb_out`
34	TT_RESB_AGG	Public	See coding	20130517	`tt_resb_agg TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_resb_agg_out`
35	TT_SUPPLY	Public	See coding	20131115	`tt_supply TYPE SORTED TABLE OF ts_supply WITH NON-UNIQUE KEY werks matnr berid plaab planr date cumqty`
36	TT_SUPPLY_AND_DEMAND_LIST	Public	See coding	20130417	`tt_supply_and_demand_list TYPE TABLE OF if_pph_sp02_finalize_non_agg=>et_mdps_out`
37	TT_VBBE	Public	See coding	20130517	`tt_vbbe TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_vbbe_out`
38	TT_VBBE_AGG	Public	See coding	20130517	`tt_vbbe_agg TYPE TABLE OF if_pph_v02_fin_indv_narrow=>et_vbbe_agg_out`
39	TY_DEMAND	Public	See coding	20131115	`BEGIN OF ty_demand, vbeln TYPE vbeln, posnr TYPE posnr, delet TYPE delet, delkz TYPE delkz, matnr TYPE matnr, werks TYPE werks_d, berid TYPE berid, plaab TYPE plaab, planr TYPE planr, lprio TYPE lprio, erdat TYPE erdat, erzet TYPE erzet, mbdat TYPE mbdat, dat00 TYPE dat00, oqty TYPE omeng, "open demand qty uqty TYPE omeng, "uncovred qty dqty TYPE omeng, "delayed qty meins TYPE meins, maximumdelay TYPE d, END OF ty_demand`

Method Signatures

Method BUILD_MDSP_INDV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130228
2	Importing	IT_INDV_ELEMENTS	Call by reference		Type reference (TYPE)	STANDARD TABLE			20130228

Method BUILD_MDSP_INDV on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_AFPO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_AFPO	Call by reference		Type reference (TYPE)	TT_AFPO			20130517

Method BUILD_MDSP_INDV_AFPO on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_EBAN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_EBAN	Call by reference		Type reference (TYPE)	TT_EBAN			20130517

Method BUILD_MDSP_INDV_EBAN on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MARD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MARD	Call by reference		Type reference (TYPE)	TT_MARD			20130517

Method BUILD_MDSP_INDV_MARD on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MDBS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MDBS	Call by reference		Type reference (TYPE)	TT_MDBS			20130517

Method BUILD_MDSP_INDV_MDBS on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MDLA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MDLA	Call by reference		Type reference (TYPE)	TT_MDLA			20130517

Method BUILD_MDSP_INDV_MDLA on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MDPB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MDPB	Call by reference		Type reference (TYPE)	TT_MDPB			20130517

Method BUILD_MDSP_INDV_MDPB on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MDQM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MDQM	Call by reference		Type reference (TYPE)	TT_MDQM			20130517

Method BUILD_MDSP_INDV_MDQM on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MDRELA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MDRELA	Call by reference		Type reference (TYPE)	TT_MDRELA			20130517

Method BUILD_MDSP_INDV_MDRELA on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MDUA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MDUA	Call by reference		Type reference (TYPE)	TT_MDUA			20130517

Method BUILD_MDSP_INDV_MDUA on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MDUB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MDUB	Call by reference		Type reference (TYPE)	TT_MDUB			20130517

Method BUILD_MDSP_INDV_MDUB on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MDUR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MDUR	Call by reference		Type reference (TYPE)	TT_MDUR			20130517

Method BUILD_MDSP_INDV_MDUR on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MRBED Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MRBED	Call by reference		Type reference (TYPE)	TT_MRBED			20130517

Method BUILD_MDSP_INDV_MRBED on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MSSA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MSSA	Call by reference		Type reference (TYPE)	TT_MSSA			20130517

Method BUILD_MDSP_INDV_MSSA on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MSSL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MSSL	Call by reference		Type reference (TYPE)	TT_MSSL			20130517

Method BUILD_MDSP_INDV_MSSL on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_MSSQ Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_MSSQ	Call by reference		Type reference (TYPE)	TT_MSSQ			20130517

Method BUILD_MDSP_INDV_MSSQ on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_PLAF Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_PLAF	Call by reference		Type reference (TYPE)	TT_PLAF			20130517

Method BUILD_MDSP_INDV_PLAF on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_PROW Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_PROW	Call by reference		Type reference (TYPE)	TT_PROW			20130517

Method BUILD_MDSP_INDV_PROW on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_RESB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_RESB	Call by reference		Type reference (TYPE)	TT_RESB			20130517

Method BUILD_MDSP_INDV_RESB on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_RESB_AGG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_RESB_AGG	Call by reference		Type reference (TYPE)	TT_RESB_AGG			20130517

Method BUILD_MDSP_INDV_RESB_AGG on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_VBBE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_VBBE	Call by reference		Type reference (TYPE)	TT_VBBE			20130517

Method BUILD_MDSP_INDV_VBBE on class CL_PPH_HANA_ACCESS has no exception.

Method BUILD_MDSP_INDV_VBBE_AGG Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130517
2	Importing	IT_INDV_VBBE_AGG	Call by reference		Type reference (TYPE)	TT_VBBE_AGG			20130517

Method BUILD_MDSP_INDV_VBBE_AGG on class CL_PPH_HANA_ACCESS has no exception.

Method CONSTRUCTOR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_RESULT_VIEW_NAME	Call by reference		Type reference (TYPE)	STRING			20120806

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120806

Method DELETE_BUFFER_BY_MATNR_WERKS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_MATNR	Call by reference		Type reference (TYPE)	MATNR		Material Number	20120919
2	Importing	IV_WERKS	Call by reference		Type reference (TYPE)	WERKS_D		Plant	20120919

Method DELETE_BUFFER_BY_MATNR_WERKS on class CL_PPH_HANA_ACCESS has no exception.

Method EXECUTE_PROCEDURE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_TAB		enhanced MDPS table type	20120806
2	Importing	IV_BUFFER_RESULT	Call by reference		Type reference (TYPE)	CHAR1	' '	Buffer handling	20120806

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120806

Method EXECUTE_PROCEDURE_1 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_TAB		enhanced MDPS table type	20120919
2	Importing	IV_BUFFER_RESULT	Call by reference		Type reference (TYPE)	CHAR1	' '	Buffer handling	20120919

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120919

Method EXECUTE_PROCEDURE_2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_TAB		enhanced MDPS table type	20120821
2	Importing	IV_BUFFER_RESULT	Call by reference		Type reference (TYPE)	CHAR1	' '	Buffer handling	20120821

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120821

Method EXECUTE_PROCEDURE_3 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_TAB			20120827
2	Importing	IV_BUFFER_RESULT	Call by reference		Type reference (TYPE)	CHAR1	' '		20120827

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120827

Method EXECUTE_PROCEDURE_KPI Signature

#	Type	Parameter	Pass Value	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_BUCKET_OUT	Call by reference	Type reference (TYPE)	PPH_KPI_VIEW_BUCKET_TAB		Table type for PPH_KPI_VIEW_BUCKET	20121130
2	Exporting	ET_DATA_OUT	Call by reference	Type reference (TYPE)	PPH_KPI_VIEW_KEY_FIG_UI_TAB		Table type for PPH_KPI_VIEW_KEY_FIG_UI	20121130
3	Importing	IV_DISPO	Call by reference	Type reference (TYPE)	DISPO		MRP controller	20121130
4	Importing	IV_EVAL_HOR	Call by reference	Type reference (TYPE)	I	30		20121207
5	Importing	IV_MANDT	Call by reference	Type reference (TYPE)	MANDT	SY-MANDT	Client	20121130
6	Importing	IV_MATNR	Call by reference	Type reference (TYPE)	MATNR		Material Number	20121218
7	Importing	IV_WERKS	Call by reference	Type reference (TYPE)	WERKS_D		enhanced mat_ctrl_params	20121130

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20121130

Method EXECUTE_PROCEDURE_MAT_CTRL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MAT_CTRL_OUT	Call by reference		Type reference (TYPE)	PPH_MAT_CTRL_PARAMS_TAB		enhanced mat_ctrl_params	20121130
2	Importing	IV_PLSCN	Call by reference		Type reference (TYPE)	PLSCN	'000'		20121130

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20121130

Method EXECUTE_PROCEDURE_TWO Signature

#	Type	Parameter	Pass Value	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference	Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB		enhanced MDPS table type SP1	20130225
2	Importing	IT_SELECTION	Call by reference	Type reference (TYPE)	PPH_MATNR_WERKS_BERID_SEL_TAB		Global temporary table for selecting from HANA (PP)	20130225
3	Importing	IV_AGG_SELECTION	Call by reference	Type reference (TYPE)	ABAP_BOOL	' '	aggregated MDPS selection	20130228
4	Importing	IV_BUFFER_RESULT	Call by reference	Type reference (TYPE)	CHAR1	' '	how to buffer	20130225
5	Importing	IV_CUTOFF_DATE	Call by reference	Type reference (TYPE)	CHAR8	'99991231'	Cutoff Date	20130308

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION		Exception Class for SQL Error	20130225

Method GENERATE_PROCEDURES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_VERSION	Call by reference		Type reference (TYPE)	C			20121130

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120904

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_RESULT_VIEW_NAME	Call by reference		Type reference (TYPE)	STRING			20120806
2	Returning	RO_ACCESS	Value transfer		Object reference (TYPE REF TO)	CL_PPH_HANA_ACCESS			20120806

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120806

Method HANDLE_SQL_EXCEPTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_SQL_EXCEPTION	Call by reference		Object reference (TYPE REF TO)	CX_SQL_EXCEPTION		Exception Class for SQL Error	20120904
2	Importing	IV_VERSION	Call by reference		Type reference (TYPE)	C	'0'		20121130

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120904

Method PREPARE_SELECT_BY_DISPO_WERKS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_DISPO	Call by reference		Type reference (TYPE)	DISPO			20120806
2	Importing	IV_WERKS	Call by reference		Type reference (TYPE)	WERKS_D			20120806

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120806

Method PREPARE_SELECT_BY_MATNR_BERID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SELECTION	Call by reference		Type reference (TYPE)	PPH_MATNR_WERKS_BERID_SEL_TAB		Global temporary table for selecting from HANA (PP)	20120806

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120806

Method PREPARE_SELECT_BY_MATNR_WERKS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SELECTION	Call by reference		Type reference (TYPE)	PPH_MATNR_WERKS_SEL_TAB			20120806

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120806

Method READ_SDM_DEMANDS Signature

#	Type	Parameter	Pass Value	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_DEMANDS	Call by reference	Type reference (TYPE)	TT_DEMAND			20131115
2	Exporting	ET_SUPPLIES	Call by reference	Type reference (TYPE)	SDM_SUPPLIES_FOR_DEMAND_TAB		Table type for SDM_SUPPLIES_FOR_DEMAND	20131115
3	Importing	IT_SELECTION	Call by reference	Type reference (TYPE)	PPH_MATNR_WERKS_BERID_SEL_TAB		Global temporary table for selecting from HANA (PP)	20131115
4	Importing	IV_CUTOFF_DATE	Call by reference	Type reference (TYPE)	D	'99991231'	Character field, 8 characters long	20131115
5	Importing	IV_RETURN_COVERED	Call by reference	Type reference (TYPE)	BOOLEAN	ABAP_FALSE	Boolean Variable (X=True, -=False, Space=Unknown)	20131115

#	Exception	Resumable	Description	Created on
1	CX_SDM_HANA_ACCESS		HANA DB 2 ABAP Data Mapping Service Exception	20131115

Method READ_SDM_KPI Signature

#	Type	Parameter	Pass Value	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_AVAILABLE_QTY	Call by reference	Type reference (TYPE)	KPI_AVAILABLE_QTY			20131115
2	Exporting	ET_LATE_SUPPLY_ITEM	Call by reference	Type reference (TYPE)	KPI_LATE_SUPPLY_ITEM			20131115
3	Exporting	ET_MATERIAL	Call by reference	Type reference (TYPE)	KPI_MATERIAL			20131115
4	Exporting	ET_PLANNING_SEGMENT	Call by reference	Type reference (TYPE)	KPI_PLANNING_SEGMENT			20131115
5	Exporting	ET_SHORTAGE	Call by reference	Type reference (TYPE)	KPI_SHORTAGE			20131115
6	Exporting	ET_SUPPLIER	Call by reference	Type reference (TYPE)	KPI_SUPPLIER			20131115
7	Exporting	ET_SUPPLY_DEMAND_ITEM	Call by reference	Type reference (TYPE)	KPI_SUPPLY_DEMAND_ITEM			20131115
8	Exporting	ET_UNCOVERED_DEMAND	Call by reference	Type reference (TYPE)	KPI_UNCOVERED_DEMAND			20131115
9	Importing	IT_MRPCONTROLLER	Call by reference	Type reference (TYPE)	MD_RANGE_T_DISPO		Range Table for Materials Planner	20131115
10	Importing	IT_PLANT	Call by reference	Type reference (TYPE)	MD_RANGE_T_WERKS		Range Table for Plant	20131115
11	Importing	IT_SELECTION	Call by reference	Type reference (TYPE)	PPH_MATNR_WERKS_BERID_SEL_TAB		Global temporary table for selecting from HANA (PP)	20131115
12	Importing	IV_CUTOFF_DATE	Call by reference	Type reference (TYPE)	D	'99991231'	Character field, 8 characters long	20131115

#	Exception	Resumable	Description	Created on
1	CX_SDM_HANA_ACCESS		HANA DB 2 ABAP Data Mapping Service Exception	20131115

Method READ_SDM_LATE_SUPPLIES Signature

#	Type	Parameter	Pass Value	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_SUPPLIES	Call by reference	Type reference (TYPE)	TT_SUPPLY		Table type for SDM_SUPPLIES_FOR_DEMAND	20131115
2	Importing	IT_SELECTION	Call by reference	Type reference (TYPE)	PPH_MATNR_WERKS_BERID_SEL_TAB		Global temporary table for selecting from HANA (PP)	20131115
3	Importing	IV_CUTOFF_DATE	Call by reference	Type reference (TYPE)	D	'99991231'	Character field, 8 characters long	20131115

#	Exception	Resumable	Description	Created on
1	CX_SDM_HANA_ACCESS		HANA DB 2 ABAP Data Mapping Service Exception	20131115

Method RETRIEVE_RESULT_BY_MATNR_BERID Signature

#	Type	Parameter	Pass Value	Typing Method	Associated Type	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference	Type reference (TYPE)	PPH_MDPS_EXT_TAB		20120816
2	Importing	IS_SELECTION	Call by reference	Type reference (TYPE)	PPH_MATNR_WERKS_BERID_SEL	Type for Global temporary table for selecting from HANA (PP)	20120816
3	Importing	IV_KEEP_BUFFER	Call by reference	Type reference (TYPE)	XFELD	do not delete entries in buffer	20120920

Method RETRIEVE_RESULT_BY_MATNR_BERID on class CL_PPH_HANA_ACCESS has no exception.

Method RETRIEVE_RESULT_BY_MATNR_WERKS Signature

#	Type	Parameter	Pass Value	Typing Method	Associated Type	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference	Type reference (TYPE)	PPH_MDPS_EXT_TAB		20120806
2	Importing	IS_SELECTION	Call by reference	Type reference (TYPE)	PPH_MATNR_WERKS_SEL		20120806
3	Importing	IV_KEEP_BUFFER	Call by reference	Type reference (TYPE)	XFELD	do not delete entries in buffer	20120920

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120806

Method RETRIEVE_RESULT_BY_MATNR_WRK_1 Signature

#	Type	Parameter	Pass Value	Typing Method	Associated Type	Description	Created on
1	Exporting	ET_MDPS_OUT	Call by reference	Type reference (TYPE)	PPH_MDPS_EXT_ONE_TAB	enhanced MDPS table type SP1	20130225
2	Importing	IS_SELECTION	Call by reference	Type reference (TYPE)	PPH_MATNR_WERKS_SEL	Type for Global temporary table for selecting from HANA (PP)	20130225
3	Importing	IV_KEEP_BUFFER	Call by reference	Type reference (TYPE)	XFELD	Checkbox	20130225

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION		Exception Class for SQL Error	20130225

Method TRUNCATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_TABLE	Call by reference		Type reference (TYPE)	STRING			20120806

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120806

Method _ASSERT_NO_DUPRECS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_MDPS	Call by reference		Type reference (TYPE)	PPH_MDPS_EXT_TAB		enhanced MDPS table type	20120913
2	Returning	EV_RESULT	Value transfer		Type reference (TYPE)	ABAP_BOOL			20120913

Method _ASSERT_NO_DUPRECS on class CL_PPH_HANA_ACCESS has no exception.

Method _CREATE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_MESSAGE	Call by reference		Type reference (TYPE)	STRING_TABLE			20120904
2	Importing	IV_VERSION	Call by reference		Type reference (TYPE)	C			20121130

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION			20120827

Method _PREP_TABLE_ABAP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_CODE	Call by reference		Type reference (TYPE)	CODE_TABLE			20120904
2	Importing	IT_SQL	Call by reference		Type reference (TYPE)	STRING_TABLE			20120904

Method _PREP_TABLE_ABAP on class CL_PPH_HANA_ACCESS has no exception.

Method _PREP_TABLE_SQL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_SQL	Call by reference		Type reference (TYPE)	STRING_TABLE			20120904
2	Importing	IT_CODE	Call by reference		Type reference (TYPE)	CODE_TABLE			20120904

Method _PREP_TABLE_SQL on class CL_PPH_HANA_ACCESS has no exception.

History

Last changed by/on	SAP	20140121
SAP Release Created in	616

Object Hierarchy

Using

Used by

Advertise Links