SAP ABAP Class CL_SMI_DB_HANDLER (DB Buffer for SMI related DB activities)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ SD-BF-SMI (Application Component) Supplier Managed Inventory
     ⤷ VSMI (Package) Supplier-Managed Inventory (SNC-ERP)

Properties

Class	CL_SMI_DB_HANDLER
Short Description	DB Buffer for SMI related DB activities
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	VSMI	Supplier-Managed Inventory (SNC-ERP)
Created	20080118	SAP
Last change	20100310	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)

Interfaces

Class CL_SMI_DB_HANDLER has no interface implemented.

Friends

Class CL_SMI_DB_HANDLER has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GO_SINGLETON_INST	Static Attribute	Private	☐	Object reference (TYPE REF TO)	CL_SMI_DB_HANDLER		DB Buffer for SMI related DB activities	20080328
2	GV_SMI_DEBUG	Static Attribute	Protected	☐	Type reference (TYPE)	CHAR10		Character Field Length = 10	20080328
3	MO_BADI_PROFILE	Instance attribute	Private	☐	Object reference (TYPE REF TO)	SMI_PROFILE_DETERMINATION			20080415
4	MO_C	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_SMI_CONSTANTS		SMI Constants	20080327
5	MT_BORDER_HIST	Instance attribute	Private	☐	Type reference (TYPE)	SMI_T_BORDER_HIST		Table type for SMI_BORDER_HIST	20080327
6	MT_BORDER_HIST_KEYS	Instance attribute	Private	☐	Type reference (TYPE)	SMI_T_BORDER_HIST_KEY		Table of client independant border history keys	20080421
7	MT_BORDER_HIST_UPD	Instance attribute	Private	☐	Type reference (TYPE)	SMI_T_BORDER_HIST_UPD		Border History update table	20080422
8	MT_HEADER_UPD	Instance attribute	Private	☐	Type reference (TYPE)	SMI_T_HEADER_UPD		Table type for SMI_S_HEADER_UPD	20080327
9	MT_ITEMS	Instance attribute	Private	☐	Type reference (TYPE)	LTTY_ITEM			20080327
10	MT_ITEM_UPD	Instance attribute	Private	☐	Type reference (TYPE)	SMI_T_ITEM_UPD		Table type for SMI_S_ITEM_UPD	20080327
11	MT_KNA1	Instance attribute	Private	☐	Type reference (TYPE)	KNA1_TAB		Business partners	20080327
12	MT_KNMT	Instance attribute	Private	☐	Type reference (TYPE)	KNMT_TAB			20080327
13	MT_KNVV	Instance attribute	Private	☐	Type reference (TYPE)	KNVV_TAB		Customer Master Sales Data	20080327
14	MT_MAKT	Instance attribute	Private	☐	Type reference (TYPE)	MAKT_TAB		MAKT Table	20080327
15	MT_RECORD	Instance attribute	Private	☐	Type reference (TYPE)	LTTY_RECORDS			20080327
16	MT_SMI_AGREEMENTS	Instance attribute	Private	☐	Type reference (TYPE)	SMI_T_AGREEMENTS		Table type for SMI_AGREEMENTS	20080327
17	MT_T006A	Instance attribute	Private	☐	Type reference (TYPE)	T006A_TAB			20080327
18	MT_TIMESERIES_UPD	Instance attribute	Private	☐	Type reference (TYPE)	SMI_T_TIMESERIES_UPD		Table type for SMI_S_TIMESERIES_UPD	20080327
19	MT_VBAP	Instance attribute	Private	☐	Type reference (TYPE)	VBAP_TAB		Table Type for Structure VBAP	20080327
20	MT_VBKD	Instance attribute	Private	☐	Type reference (TYPE)	VBKD_TAB		Table type sales document: Forecast delivery schedule data	20080327
21	MT_VBPA	Instance attribute	Private	☐	Type reference (TYPE)	VBPA_TAB		TABLE VBPA	20080327

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	CHECK_BORDER_HIST_CHANGE	Instance method	Public	Method	Save changed border history of item	20080520
2	CLASS_CONSTRUCTOR	Static method	Public	Constructor		20080303
3	CLEAR_INSTANCE	Static method	Public	Method	Clearing of the singleton instance	20080606
4	CONSTRUCTOR	Instance method	Public	Constructor		20080201
5	DELETE_SMI_DATA	Instance method	Public	Method	Deletion of SMI data from database	20080320
6	DEQUEUE_SMI	Instance method	Public	Method	DB Lock release for SMI Objects (entire message)	20080124
7	DEQUEUE_SMI_HEADER	Instance method	Public	Method	DB Lock release for SMI Header	20080124
8	DEQUEUE_SMI_ITEM	Instance method	Public	Method	DB Lock release for SMI Item	20080124
9	DEQUEUE_SMI_TIMESERIES	Instance method	Public	Method	DB Lock release for SMI Timeseries	20080125
10	ENQUEUE_SMI	Instance method	Public	Method	DB Lock for SMI Objects (entire message)	20080124
11	ENQUEUE_SMI_BORDER_HIST	Instance method	Public	Method	Save changed border history of item	20080520
12	ENQUEUE_SMI_HEADER	Instance method	Public	Method	DB Lock for SMI Header	20080124
13	ENQUEUE_SMI_ITEM	Instance method	Public	Method	DB Lock for SMI Item	20080124
14	ENQUEUE_SMI_TIMESERIES	Instance method	Public	Method	DB Lock for SMI Timeseries	20080125
15	GET_INSTANCE	Static method	Public	Method		20080303
16	GET_KNA1	Instance method	Public	Method	Read table KNA1	20080118
17	GET_KNMT	Instance method	Public	Method	Read table KNMT	20080118
18	GET_KNVV	Instance method	Public	Method	Read table KNVV	20080118
19	GET_MAKT	Instance method	Public	Method	Read table MAKT	20080118
20	GET_MESSAGE	Instance method	Public	Method	Read table SMI_MESSAGES to get info about customiz. messages	20080312
21	GET_PROFILE_BY_ID	Instance method	Public	Method	Read table SMI_PROFILE using PROFILE ID	20080118
22	GET_PROFILE_CASCADE	Instance method	Public	Method	Read table SMI_PROFILE	20080118
23	GET_PROFILE_SPECIFIC	Instance method	Public	Method	Read table SMI_PROFILE	20080423
24	GET_SMI_AGREEMENT	Instance method	Public	Method	Read table SMI_AGREEMENTS	20080118
25	GET_SMI_DATA2	Instance method	Public	Method	Returns complete datamodel objects	20080402
26	GET_SMI_HISTORY	Instance method	Public	Method	Get border history table for an item	20080421
27	GET_SMI_ITEM	Instance method	Public	Method	Returns an item object	20080403
28	GET_SMI_ITEM_LAST	Instance method	Public	Method	Returns the most recent item object	20080403
29	GET_SMI_RECORD	Instance method	Public	Method	Returns a record object	20080403
30	GET_SMI_TIMESERIES	Instance method	Public	Method	Returns a timeseries object	20080403
31	GET_T006A	Instance method	Public	Method	Read table T006A	20080312
32	GET_VBAK	Instance method	Public	Method	Read table VBAK	20080429
33	GET_VBAP	Instance method	Public	Method	Read table VBAP	20080118
34	GET_VBKD	Instance method	Public	Method	Read table VBKD	20080118
35	GET_VBPA	Instance method	Public	Method	Read table VBPA	20080118
36	PUSH_UPDATE_BORDER_HIST	Instance method	Public	Method	Save changed border history of item	20080520
37	PUSH_UPDATE_HEADER	Instance method	Public	Method	Update DB Update tables header	20080204
38	PUSH_UPDATE_ITEM	Instance method	Public	Method	Update DB Update tables item	20080201
39	PUSH_UPDATE_TIMESERIES	Instance method	Public	Method	Update DB Update tables Timeseries	20080204
40	READ_KNA1	Instance method	Private	Method	Add table KNA1 to buffer GT_KNA1	20080402
41	READ_KNMT	Instance method	Private	Method	Add table KNMT to buffer GT_KNMT	20080402
42	READ_KNVV	Instance method	Private	Method	Add table KNVV to buffer GT_KNVV	20080402
43	READ_MAKT	Instance method	Private	Method	Add table MAKT to buffer GT_MAKT	20080402
44	READ_PROFILE_CASCADE	Instance method	Private	Method	Add table SMI_PROFILE to buffer GT_SMI_PROFILE	20080402
45	READ_SMI_AGREEMENT	Instance method	Private	Method	Add table SMI_AGREEMENTS to buffer GT_SMI_AGREEMENTS	20080402
46	READ_T006A	Instance method	Private	Method		20080402
47	READ_VBAP	Instance method	Private	Method	Add table VBAP to buffer GT_VBAP	20080402
48	READ_VBKD	Instance method	Private	Method	Add table VBKD to buffer GT_VBKD	20080402
49	READ_VBPA	Instance method	Private	Method	Add table VBPA to buffer GT_VBPA	20080402
50	SMI_DB_UPDATE	Instance method	Public	Method	DB Update method	20080125
51	SPLIT_RANGETABLE	Instance method	Private	Method	Populate Selection Tables of the Individual Fields for SMI	20080402

Events

Class CL_SMI_DB_HANDLER has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	KNA1_TAB	Public	See coding			20080118	KNA1_TAB TYPE STANDARD TABLE OF KNA1
2	KNMT_TAB	Public	See coding			20080118	KNMT_TAB TYPE STANDARD TABLE OF KNMT
3	KNVV_TAB	Public	See coding			20080118	KNVV_TAB TYPE STANDARD TABLE OF KNVV
4	LTTY_ITEM	Private	See coding			20080306	LTTY_ITEM TYPE STANDARD TABLE OF LTY_ITEM
5	LTTY_RECORDS	Private	See coding			20080306	LTTY_RECORDS TYPE STANDARD TABLE OF LTY_RECORD
6	LTY_ITEM	Private	See coding			20080306	BEGIN OF LTY_ITEM, XMLGUID TYPE SMI_XMLGUID, MATNR TYPE MATNR, VBELN TYPE VBELN_VA, POSNR TYPE POSNR_VA, ITEM_REF TYPE REF TO CL_SMI_ITEM, END OF LTY_ITEM
7	LTY_RECORD	Private	See coding			20080306	BEGIN OF LTY_RECORD, XMLGUID TYPE SMI_XMLGUID, RECORD_REF TYPE REF TO CL_SMI_RECORD, END OF LTY_RECORD
8	MAKT_TAB	Public	See coding			20080118	MAKT_TAB TYPE STANDARD TABLE OF MAKT
9	T006A_TAB	Public	See coding			20080312	T006A_TAB TYPE STANDARD TABLE OF T006A
10	VBAK_TAB	Public	See coding			20080118	VBAK_TAB TYPE STANDARD TABLE OF VBAK
11	VBAP_TAB	Public	See coding			20080118	VBAP_TAB TYPE STANDARD TABLE OF VBAP
12	VBKD_TAB	Public	See coding			20080118	VBKD_TAB TYPE STANDARD TABLE OF VBKD
13	VBPA_TAB	Public	See coding			20080118	VBPA_TAB TYPE STANDARD TABLE OF VBPA

Method Signatures

Method CHECK_BORDER_HIST_CHANGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_ITEM	Call by reference	☐	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080520
2	Returning	RV_CHANGED	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20080520

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080520

Method CLASS_CONSTRUCTOR Signature

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

Method CLEAR_INSTANCE Signature

Method CLEAR_INSTANCE on class CL_SMI_DB_HANDLER has no parameter.
Method CLEAR_INSTANCE on class CL_SMI_DB_HANDLER has no exception.

Method CONSTRUCTOR Signature

Method CONSTRUCTOR on class CL_SMI_DB_HANDLER has no parameter.
Method CONSTRUCTOR on class CL_SMI_DB_HANDLER has no exception.

Method DELETE_SMI_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_KUNNR	Call by reference	☐	Type reference (TYPE)	RSPARAMS_TT		rsparams Table	20080516
2	Importing	IV_CREATED	Call by reference	☐	Type reference (TYPE)	SMI_DM_DATETIME		Table type for SMI_S_SMIDATA	20080416
3	Importing	IV_LOG_HANDLE	Call by reference	☑	Type reference (TYPE)	BALLOGHNDL		Application Log: Log Handle	20080527

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080320

Method DEQUEUE_SMI Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_RECORD_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SMI_RECORD		Header-Data of an SMI Inbound Record	20080328
2	Importing	IS_SMI_KEY	Call by reference	☑	Type reference (TYPE)	SMI_S_HEADER_KEY		SMI_HEADER Key Table type	20080312

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080312

Method DEQUEUE_SMI_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_RECORD_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SMI_RECORD		Header-Data of an SMI Inbound Record	20080328
2	Importing	IS_SMI_HEADER_KEY	Call by reference	☑	Type reference (TYPE)	SMI_S_HEADER_KEY		SMI_HEADER Key Table type	20080312

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080312

Method DEQUEUE_SMI_ITEM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_ITEM_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080328
2	Importing	IS_SMI_ITEM_KEY	Call by reference	☑	Type reference (TYPE)	SMI_S_SMI_ITEM_KEY		Table type for SMI_ITEM Keys	20080312

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080312

Method DEQUEUE_SMI_TIMESERIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_TIMESERIES_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SMI_TIMESERIES		Class to encapsulate timeseries data	20080328
2	Importing	IT_SMI_TIMESERIES_KEY	Call by reference	☑	Type reference (TYPE)	SMI_T_SMI_TIMESERIES_KEY		Table type for SMI_ITEM Keys	20080125

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080312

Method ENQUEUE_SMI Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_RECORD_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SMI_RECORD		Header-Data of an SMI Inbound Record	20080328
2	Importing	IS_SMI_KEY	Call by reference	☑	Type reference (TYPE)	SMI_S_HEADER_KEY		SMI_HEADER Key Table type	20080312

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080312

Method ENQUEUE_SMI_BORDER_HIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_ITEM	Call by reference	☐	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080520
2	Returning	RV_CHANGED	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20080520

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080520

Method ENQUEUE_SMI_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_RECORD_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SMI_RECORD		Header-Data of an SMI Inbound Record	20080328
2	Importing	IS_SMI_HEADER_KEY	Call by reference	☑	Type reference (TYPE)	SMI_S_HEADER_KEY		SMI_HEADER Key Table type	20080312

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080312

Method ENQUEUE_SMI_ITEM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_ITEM_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080416
2	Importing	IS_SMI_ITEM_KEY	Call by reference	☑	Type reference (TYPE)	SMI_S_SMI_ITEM_KEY		SMI_HEADER Key Table type	20080312

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080312

Method ENQUEUE_SMI_TIMESERIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_TIMESERIES_REF	Call by reference	☑	Object reference (TYPE REF TO)	CL_SMI_TIMESERIES		Class to encapsulate timeseries data	20080416
2	Importing	IT_SMI_TIMESERIES_KEY	Call by reference	☑	Type reference (TYPE)	SMI_T_SMI_TIMESERIES_KEY		SMI_HEADER Key Table type	20080125

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080312

Method GET_INSTANCE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	RO_SINGLETON	Value transfer	☐	Object reference (TYPE REF TO)	CL_SMI_DB_HANDLER		DB Buffer for SMI related DB activities	20080328

Method GET_INSTANCE on class CL_SMI_DB_HANDLER has no exception.

Method GET_KNA1 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_KNA1	Call by reference	☐	Type reference (TYPE)	KNA1		General Data in Customer Master	20080415
2	Importing	IV_CUSTOMER_ID	Value transfer	☐	Type reference (TYPE)	KUNNR		Customer Number 1	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080313

Method GET_KNMT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_KNMT	Call by reference	☐	Type reference (TYPE)	KNMT		Customer-Material Info Record Data Table	20080415
2	Importing	IV_CUSTOMER_ID	Value transfer	☐	Type reference (TYPE)	KUNNR		Customer Number 1	20080415
3	Importing	IV_KDMAT	Call by reference	☐	Type reference (TYPE)	KDMAT		Material belonging to the customer	20080415
4	Importing	IV_VKORG	Call by reference	☑	Type reference (TYPE)	VKORG		Sales Organization	20080415
5	Importing	IV_VTWEG	Call by reference	☑	Type reference (TYPE)	VTWEG		Distribution Channel	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080313

Method GET_KNVV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_KNVV	Call by reference	☐	Type reference (TYPE)	KNVV_TAB			20080118
2	Importing	IV_CUSTOMER_ID	Call by reference	☐	Type reference (TYPE)	KUNNR		Customer Number 1	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080313

Method GET_MAKT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CS_MAKT	Call by reference	☐	Type reference (TYPE)	MAKT		Material Descriptions	20080415
2	Importing	IV_MATNR	Call by reference	☐	Type reference (TYPE)	MATNR		Material Number	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080313

Method GET_MESSAGE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_MESSAGE_CUST	Call by reference	☐	Type reference (TYPE)	SMI_MESSAGES		SMI Customizable Messages	20080415
2	Importing	IV_MSGID	Call by reference	☐	Type reference (TYPE)	SYMSGID		Message Class	20080415
3	Importing	IV_MSGNO	Call by reference	☐	Type reference (TYPE)	SYMSGNO		Message Number	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080318

Method GET_PROFILE_BY_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CS_PROFILE	Call by reference	☑	Type reference (TYPE)	SMI_PROFILE		SMI Replenishment Profile	20080328
2	Importing	IV_ACTIVE_ONLY	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL			20080328
3	Importing	IV_ID	Call by reference	☐	Type reference (TYPE)	SMI_PROFILE_ID		Supplier Managed Inventory replenishment Profile	20080328

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080318

Method GET_PROFILE_CASCADE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_PROFILE	Call by reference	☑	Type reference (TYPE)	SMI_T_PROFILE		SMI Replenishment Profile table	20080415
2	Importing	IV_ACTIVE_ONLY	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL			20080415
3	Importing	IV_BSTKD	Call by reference	☑	Type reference (TYPE)	BSTKD		Customer purchase order number	20080415
4	Importing	IV_KDMAT	Call by reference	☑	Type reference (TYPE)	KDMAT		Material belonging to the customer	20080415
5	Importing	IV_KUNNR	Call by reference	☑	Type reference (TYPE)	KUNNR		Customer Number 1	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080319

Method GET_PROFILE_SPECIFIC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_PROFILE	Call by reference	☑	Type reference (TYPE)	SMI_T_PROFILE		SMI Replenishment Profile table	20080423
2	Importing	IV_ACTIVE_ONLY	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL			20080423
3	Importing	IV_BSTKD	Call by reference	☑	Type reference (TYPE)	BSTKD		Customer purchase order number	20080423
4	Importing	IV_KDMAT	Call by reference	☑	Type reference (TYPE)	KDMAT		Material belonging to the customer	20080423
5	Importing	IV_KUNNR	Call by reference	☑	Type reference (TYPE)	KUNNR		Customer Number 1	20080423

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080423

Method GET_SMI_AGREEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_SMI_AGREEMENTS	Call by reference	☐	Type reference (TYPE)	SMI_AGREEMENTS		Table type for SMI_AGREEMENTS	20080118
2	Importing	IV_CUSTOMER_ID	Call by reference	☑	Type reference (TYPE)	KUNNR		Customer Number 1	20080415
3	Importing	IV_KDMAT	Call by reference	☑	Type reference (TYPE)	MATNR_KU		Material Number Used by Customer	20080415
4	Importing	IV_POSNR	Call by reference	☑	Type reference (TYPE)	POSNR_VA		Sales Document Item	20080415
5	Importing	IV_VBELN	Call by reference	☑	Type reference (TYPE)	VBELN_VA		Sales Document	20080415
6	Importing	IV_WERKS_EXT	Call by reference	☑	Type reference (TYPE)	KNREF		Customer description of partner (plant, storage location)	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080318

Method GET_SMI_DATA2 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_SMI_DATA	Call by reference	☐	Type reference (TYPE)	SMI_T_SMIDATA		Table type for SMI_S_SMIDATA	20080402
2	Importing	IT_SELCRIT_VALUES	Call by reference	☐	Type reference (TYPE)	RSPARAMS_TT		rsparams Table	20080415
3	Importing	IV_HEADER_ONLY	Call by reference	☑	Type reference (TYPE)	XCHAR		Batch management indicator (internal)	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402
2	CX_SMI_INPUT	☐		20080402

Method GET_SMI_HISTORY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_ITEM	Call by reference	☐	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080421
2	Returning	RT_BORDER_HISTORY	Value transfer	☐	Type reference (TYPE)	SMI_T_BORDER_HIST		SMI Border History	20080421

Method GET_SMI_HISTORY on class CL_SMI_DB_HANDLER has no exception.

Method GET_SMI_ITEM 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	20080403
2	Importing	IV_POSNR	Call by reference	☐	Type reference (TYPE)	POSNR_VA		Sales Document Item	20080611
3	Importing	IV_VBELN	Call by reference	☐	Type reference (TYPE)	VBELN_VA		Sales Document	20080611
4	Importing	IV_XMLGUID	Call by reference	☐	Type reference (TYPE)	SMI_XMLGUID		XML GUID	20080403
5	Returning	RO_ITEM	Value transfer	☐	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080403

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080416

Method GET_SMI_ITEM_LAST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IT_SELCRIT_VALUES	Call by reference	☐	Type reference (TYPE)	RSPARAMS_TT		rsparams Table	20080415
2	Returning	RO_ITEM	Value transfer	☐	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080403

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080403

Method GET_SMI_RECORD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_XMLGUID	Call by reference	☐	Type reference (TYPE)	SMI_XMLGUID		XML GUID	20080403
2	Returning	RO_RECORD	Value transfer	☐	Object reference (TYPE REF TO)	CL_SMI_RECORD		Header-Data of an SMI Inbound Record	20080403

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080416

Method GET_SMI_TIMESERIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_ITEM	Call by reference	☐	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080403
2	Importing	IV_TSTYPE	Call by reference	☐	Type reference (TYPE)	SMI_TSTYPE		Time Series Type	20080403
3	Returning	RO_TIMESERIES	Value transfer	☐	Object reference (TYPE REF TO)	CL_SMI_TIMESERIES		Class to encapsulate timeseries data	20080403

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080416

Method GET_T006A Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_T006A	Call by reference	☐	Type reference (TYPE)	T006A		Assign Internal to Language-Dependent Unit	20080312
2	Importing	IV_LANGU	Call by reference	☑	Type reference (TYPE)	SPRAS		Language	20080416
3	Importing	IV_UNIT	Call by reference	☐	Type reference (TYPE)	MSEHI		Unit	20080416

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080319

Method GET_VBAK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	CS_VBAK	Value transfer	☐	Type reference (TYPE)	VBAK		Sales Document: Header Data	20080429
2	Importing	IV_VBELN	Call by reference	☐	Type reference (TYPE)	VBELN_VL		Delivery	20080429

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080429

Method GET_VBAP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CS_VBAP	Call by reference	☑	Type reference (TYPE)	VBAP		Sales Document: Item Data	20080415
2	Changing	CT_VBAP	Call by reference	☑	Type reference (TYPE)	VBAP_TAB		Table Type for Structure VBAP	20080415
3	Importing	IV_POSNR	Call by reference	☑	Type reference (TYPE)	POSNR		Item number of the SD document	20080415
4	Importing	IV_VBELN	Call by reference	☐	Type reference (TYPE)	VBELN		Sales and Distribution Document Number	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080313

Method GET_VBKD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_VBKD	Call by reference	☑	Type reference (TYPE)	VBKD_TAB		Table type sales document: Business data	20080415
2	Importing	IV_BSTKD	Call by reference	☐	Type reference (TYPE)	BSTKD_M		Customer PO number as matchcode field	20080415
3	Importing	IV_POSNR	Call by reference	☑	Type reference (TYPE)	POSNR		Item number of the SD document	20080415
4	Importing	IV_VBELN	Call by reference	☑	Type reference (TYPE)	VBELN		Sales and Distribution Document Number	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080313

Method GET_VBPA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_VBPA	Call by reference	☐	Type reference (TYPE)	VBPA_TAB		TABLE VBPA	20080118
2	Importing	IV_VBELN	Call by reference	☐	Type reference (TYPE)	VBELN		Customer Number 1	20080415

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080313

Method PUSH_UPDATE_BORDER_HIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_ITEM	Call by reference	☐	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080520
2	Returning	RV_CHANGED	Value transfer	☐	Type reference (TYPE)	ABAP_BOOL			20080520

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080520

Method PUSH_UPDATE_HEADER Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_HEADER	Call by reference	☐	Object reference (TYPE REF TO)	CL_SMI_RECORD		Single Item of an SMI Record	20080416
2	Importing	IV_UPDKZ	Call by reference	☑	Type reference (TYPE)	UPDKZ_D		Update indicator	20080416

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080415

Method PUSH_UPDATE_ITEM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_ITEM_REF	Call by reference	☐	Object reference (TYPE REF TO)	CL_SMI_ITEM		Single Item of an SMI Record	20080416
2	Importing	IV_UPDKZ	Call by reference	☑	Type reference (TYPE)	UPDKZ_D		Update indicator	20080416

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080328

Method PUSH_UPDATE_TIMESERIES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IO_TIMESERIES	Call by reference	☐	Object reference (TYPE REF TO)	CL_SMI_TIMESERIES		Single Item of an SMI Record	20080416
2	Importing	IV_UPDKZ	Call by reference	☑	Type reference (TYPE)	UPDKZ_D		Update indicator	20080416

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080415

Method READ_KNA1 Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_KNA1	Call by reference	☐	Type reference (TYPE)	KNA1		General Data in Customer Master	20080402
2	Importing	IV_CUSTOMER_ID	Call by reference	☐	Type reference (TYPE)	KUNNR		Customer Number 1	20080402
3	Importing	IV_TABIX	Call by reference	☐	Type reference (TYPE)	SYTABIX		Index of Internal Tables	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_KNMT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IV_CUSTOMER_ID	Value transfer	☐	Type reference (TYPE)	KUNNR		Customer Number 1	20080402
2	Importing	IV_KDMAT	Call by reference	☐	Type reference (TYPE)	KDMAT		Material belonging to the customer	20080402
3	Importing	IV_VKORG	Call by reference	☑	Type reference (TYPE)	VKORG		Sales Organization	20080402
4	Importing	IV_VTWEG	Call by reference	☑	Type reference (TYPE)	VTWEG		Distribution Channel	20080402
5	Returning	RS_KNMT	Value transfer	☐	Type reference (TYPE)	KNMT		Customer-Material Info Record Data Table	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_KNVV Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_KNVV	Call by reference	☐	Type reference (TYPE)	KNVV_TAB			20080402
2	Importing	IV_CUSTOMER_ID	Call by reference	☐	Type reference (TYPE)	KUNNR		Customer Number 1	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_MAKT 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	20080402
2	Importing	IV_TABIX	Call by reference	☐	Type reference (TYPE)	SYTABIX		Index of Internal Tables	20080402
3	Returning	RS_MAKT	Value transfer	☐	Type reference (TYPE)	MAKT		Material Descriptions	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_PROFILE_CASCADE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_PROFILE	Call by reference	☑	Type reference (TYPE)	SMI_T_PROFILE		SMI Replenishment Profile table	20080402
2	Importing	IV_ACTIVE_ONLY	Call by reference	☑	Type reference (TYPE)	ABAP_BOOL			20080402
3	Importing	IV_BSTKD	Call by reference	☑	Type reference (TYPE)	BSTKD		Customer purchase order number	20080402
4	Importing	IV_KDMAT	Call by reference	☑	Type reference (TYPE)	KDMAT		Material belonging to the customer	20080402
5	Importing	IV_KUNNR	Call by reference	☑	Type reference (TYPE)	KUNNR		Customer Number 1	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_SMI_AGREEMENT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_SMI_AGREEMENTS	Call by reference	☐	Type reference (TYPE)	SMI_AGREEMENTS		Table type for SMI_AGREEMENTS	20080402
2	Importing	IV_CUSTOMER_ID	Call by reference	☑	Type reference (TYPE)	KUNNR		Customer Number 1	20080402
3	Importing	IV_KDMAT	Call by reference	☑	Type reference (TYPE)	MATNR_KU		Material Number Used by Customer	20080402
4	Importing	IV_POSNR	Call by reference	☑	Type reference (TYPE)	POSNR_VA		Sales Document Item	20080402
5	Importing	IV_VBELN	Call by reference	☑	Type reference (TYPE)	VBELN_VA		Sales Document	20080402
6	Importing	IV_WERKS_EXT	Call by reference	☑	Type reference (TYPE)	KNREF		Customer description of partner (plant, storage location)	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_T006A Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_T006A	Call by reference	☐	Type reference (TYPE)	T006A		Assign Internal to Language-Dependent Unit	20080402
2	Importing	IV_LANGU	Call by reference	☑	Type reference (TYPE)	SPRAS	SY-LANGU	Language Key	20080402
3	Importing	IV_TABIX	Call by reference	☐	Type reference (TYPE)	SYTABIX		Index of Internal Tables	20080402
4	Importing	IV_UNIT	Call by reference	☐	Type reference (TYPE)	MSEHI		Unit of Measurement	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_VBAP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CS_VBAP	Call by reference	☑	Type reference (TYPE)	VBAP		Sales Document: Item Data	20080402
2	Changing	CT_VBAP	Call by reference	☑	Type reference (TYPE)	VBAP_TAB		Table Type for Structure VBAP	20080402
3	Importing	IV_POSNR	Call by reference	☑	Type reference (TYPE)	POSNR		Item number of the SD document	20080402
4	Importing	IV_VBELN	Call by reference	☐	Type reference (TYPE)	VBELN		Sales and Distribution Document Number	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_VBKD Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_VBKD	Call by reference	☑	Type reference (TYPE)	VBKD_TAB		Table type sales document: Business data	20080402
2	Importing	IV_BSTKD	Call by reference	☐	Type reference (TYPE)	BSTKD_M		Customer PO number as matchcode field	20080402
3	Importing	IV_POSNR	Call by reference	☑	Type reference (TYPE)	POSNR		Item number of the SD document	20080402
4	Importing	IV_VBELN	Call by reference	☑	Type reference (TYPE)	VBELN		Sales and Distribution Document Number	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method READ_VBPA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_VBPA	Call by reference	☐	Type reference (TYPE)	VBPA_TAB		TABLE VBPA	20080402
2	Importing	IV_VBELN	Call by reference	☐	Type reference (TYPE)	VBELN		Customer Number 1	20080402

#	Exception	Resumable	Description	Created on
1	CX_SMI_DB	☐	Storage & data related exceptions	20080402

Method SMI_DB_UPDATE Signature

Method SMI_DB_UPDATE on class CL_SMI_DB_HANDLER has no parameter.
Method SMI_DB_UPDATE on class CL_SMI_DB_HANDLER has no exception.

Method SPLIT_RANGETABLE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_BSTKD	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
2	Exporting	ET_CREATED	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
3	Exporting	ET_KDMAT	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
4	Exporting	ET_KNREF	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
5	Exporting	ET_KUNNR	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
6	Exporting	ET_KUNWE	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
7	Exporting	ET_MATNR	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
8	Exporting	ET_POSNR	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080610
9	Exporting	ET_PROCTRIGGER	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
10	Exporting	ET_RECEIVED	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
11	Exporting	ET_STATUS	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
12	Exporting	ET_STOPPED	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080619
13	Exporting	ET_TSQUAN	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
14	Exporting	ET_TSTYPE	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
15	Exporting	ET_VBELN	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080610
16	Exporting	ET_XMLGUID	Call by reference	☐	Type reference (TYPE)	SMI_T_RANGE		Table type for SMI_RANGE	20080416
17	Importing	IT_SELCRIT_VALUES	Call by reference	☐	Type reference (TYPE)	RSPARAMS_TT		rsparams Table	20080415

Method SPLIT_RANGETABLE on class CL_SMI_DB_HANDLER has no exception.

History

Last changed by/on	SAP	20100310
SAP Release Created in	604