I_MaintenanceCompliance

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_MaintenanceCompliance.
-- 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: IMAINTCMPLNC

CREATE VIEW I_MaintenanceCompliance AS
SELECT
  wapos AS MaintenanceItem,
  cpnum AS NmbrOfMaintComplianceItems,
  cpgrp AS MaintenanceComplianceGroupCode,
  cmpcod AS MaintenanceComplianceCode,
  cptyp AS MaintenanceComplianceTypeCode,
  cpkat AS MaintComplianceCatalogCode,
  cptxt AS MaintComplianceDescription,
  zaehl AS MaintenancePackage,
  legal AS MaintCmplRqIsLegallyBinding,
  indltx AS MaintComplianceHasLongText,
  qcpnum AS MaintComplianceSortNumber,
  kzloesch AS MaintenanceComplianceIsDeleted,
  origin AS MaintCmplRqOriginCode,
  erdat AS CreationDate,
  aenam AS LastChangedByUser,
  aedat AS LastChangeDate,
  changeddatetime AS LastChangeDateTime
FROM mpcr
LEFT OUTER JOIN I_MaintenanceItemBasic AS _MaintenanceItemBasic ON MaintenanceItem = _MaintenanceItemBasic.MaintenanceItem  -- association [1..1]
LEFT OUTER JOIN I_MaintCmplRqOrigin AS _MaintCmplRqOrigin ON MaintCmplRqOriginCode = _MaintCmplRqOrigin.MaintCmplRqOriginCode  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncodegrouptext AS _MaintComplianceCodeGroupText ON MaintComplianceCatalogCode = _MaintComplianceCodeGroupText.InspectionCatalog AND MaintenanceComplianceGroupCode = _MaintComplianceCodeGroupText.InspectionCodeGroup  -- association [0..*]
LEFT OUTER JOIN I_InspectionCodeText AS _MaintenanceComplianceCodeText ON MaintComplianceCatalogCode = _MaintenanceComplianceCodeText.InspectionCatalog AND MaintenanceComplianceGroupCode = _MaintenanceComplianceCodeText.InspectionCodeGroup AND MaintenanceComplianceCode = _MaintenanceComplianceCodeText.InspectionCode  -- association [0..*]
;