ES Report Extractor for Maintenance Status

DataSource Attributes: E2E_ESREP_EXT_MS

This DataSource provides access to data from the SAP Solution Manager system landscape about the operating maintenance level of productive systems and software components.

Technical Data

Application Component	SAP Solution Manager
Available as of Release	SAP Enhancement Package 1 for SAP Solution Manager 7.0 SP21
Shipment	BI_CONT 704 SP05
Content Versions	No different content versions available
RemoteCube-Capable	No
Delta-Capable	Yes
Extraction from Archives	No
Verifiable	No

Data Modeling

Fields of Origin for the Extract Structure
Fields in the Extract Structure	Description of the Field in the Extract Structure	Table of Origin	Field in the Table of Origin
wa_system-systemname	Landscape System ID	SMSY_SYSTEM	SYSTEMNAME
wa_system_sap-inst_number	Landscape Installation Number	SMSY_SYSTEM_SAP	INST_NUMBER
wa_system_info-DESCR	System Description	SMSY_SYSTEM	DESCR
wa_provers-PRODUCTVERSION	Product Version PPMS ID	SMSY_PROD_VERS	PRODUCTVERSION
l_prodvrsstxt	Product Version	SMSY_PROD_VERS	PRODVERSTXT
wa_pv_maintend-MFINISH_E	End of Mainstream Maintenance	SMSY_PV_MAINTEND	MFINISH_E <`STD`>
wa_pv_maintendex-MFINISH_E	End of Extended Maintenance	SMSY_PV_MAINTEND	MFINISH_E <`EXT`>
l_tihm	Time (yyyymmddhhmm)	-	-

Extractor Logic

The extraction is performed by using function modules:

Function Module	Description
SMSY_GET_ALL_SYSTEMS_INFO	Retrieves all system information; returns collection of all system IDs from your system landscape
SMSY_GET_SYSTEM_INFO	Retrieves the landscape installation number
SMSY_GET_PRODUCTS_TO_SYSTEM	Retrieves the product version PPMS ID
SMSY_GET_STEXT_TO_PRODVERS	Retrieves the product version
SMSY_GET_PRODVERS_MAINT_ENDS	Retrieves the end date of mainstream and extended maintenance