I_MaintenanceChecklist

DDL: I_MAINTENANCECHECKLIST SQL: IMAINTCHECKLIST Type: view BASIC
12 Fields 1 Data Sources

Maintenance Checklist

I_MaintenanceChecklist is a Basic CDS View that provides data about "Maintenance Checklist" in SAP S/4HANA. It reads from 1 data source (eam_clobj) and exposes 12 fields with key fields MaintenanceChecklistType, MaintenanceChecklist.

Data Sources (1)

SourceAliasJoin Type
eam_clobj eam_clobj from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMAINTCHECKLIST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Maintenance Checklist view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #A view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceChecklistType cl_objtype Checklist Type
KEY MaintenanceChecklist cl_objkey Checklist ID
MaintenanceBusinessObjectType objtype Translation OType
MaintenanceBusinessObject objkey Push Object Key
MaintBusinessSubobjectType so_objtype SubObject Type
MaintenanceBusinessSubobject so_objkey SubObject ID
MaintChecklistTemplateType cl_t_objtype Checklist Templ Type
MaintenanceChecklistTemplate cl_t_objkey Checklist TemplateID
Equipment equnr Equipment
FunctionalLocation tplnr Functional loc.
MaintChklstAddlInformationText cl_status Checklist Status
MainChecklistIsDeactivated deact Inactive

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 I_MaintenanceChecklist.
-- 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: IMAINTCHECKLIST

CREATE VIEW I_MaintenanceChecklist AS
SELECT
  cl_objtype AS MaintenanceChecklistType,
  cl_objkey AS MaintenanceChecklist,
  objtype AS MaintenanceBusinessObjectType,
  objkey AS MaintenanceBusinessObject,
  so_objtype AS MaintBusinessSubobjectType,
  so_objkey AS MaintenanceBusinessSubobject,
  cl_t_objtype AS MaintChecklistTemplateType,
  cl_t_objkey AS MaintenanceChecklistTemplate,
  equnr AS Equipment,
  tplnr AS FunctionalLocation,
  cl_status AS MaintChklstAddlInformationText,
  deact AS MainChecklistIsDeactivated
FROM eam_clobj
;

Learn More