E_MaintenanceItemBasic

DDL: E_MAINTENANCEITEMBASIC SQL: EMAINTITEMBASIC Type: view EXTENSION
1 Fields 1 Data Sources

Extension View of Maintenance Item

E_MaintenanceItemBasic is a Extension CDS View that provides data about "Extension View of Maintenance Item" in SAP S/4HANA. It reads from 1 data source (mpos) and exposes 1 field with key field MaintenanceItem.

Data Sources (1)

SourceAliasJoin Type
mpos Persistence from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName EMAINTITEMBASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label Extension View of Maintenance Item view
VDM.viewType #EXTENSION view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem mpos wapos MaintItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view E_MaintenanceItemBasic.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: EMAINTITEMBASIC

CREATE VIEW E_MaintenanceItemBasic AS
SELECT
  Persistence.wapos AS MaintenanceItem
FROM mpos AS Persistence
;

Learn More