R_MaintenanceItemReasonTP

DDL: R_MAINTENANCEITEMREASONTP Type: view_entity TRANSACTIONAL Package: VDM_EAM_MAINTENANCEITEM
25 Fields 1 Data Sources 2 Associations

Maintenance Item Reason

R_MaintenanceItemReasonTP is a Transactional CDS View that provides data about "Maintenance Item Reason" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceCompliance) and exposes 25 fields with key fields MaintenanceItem, NmbrOfMaintComplianceItems. It has 2 associations to related views. Part of development package VDM_EAM_MAINTENANCEITEM.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceCompliance I_MaintenanceCompliance from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaintenancePackage _MaintenancePackage $projection.maintenancestrategy = _MaintenancePackage.MaintenanceStrategy and $projection.MaintenancePackage = _MaintenancePackage.MaintenancePackage
[0..*] R_MaintenanceItemReasonTextTP _MaintenanceItemReasonText

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Maintenance Item Reason view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY MaintenanceItem MaintenanceItem MaintItem
KEY NmbrOfMaintComplianceItems NmbrOfMaintComplianceItems Seq Num Compliance
MaintenanceComplianceGroupCode MaintenanceComplianceGroupCode Code Group
MaintenanceComplianceCode MaintenanceComplianceCode Compliance Code
MaintenanceComplianceTypeCode MaintenanceComplianceTypeCode Compliance Type
MaintComplianceCatalogCode MaintComplianceCatalogCode Compliance Catalog
MaintComplianceDescription MaintComplianceDescription Comp Descr.
MaintenanceStrategy _MaintenanceItemBasic MaintenanceStrategy
MaintenancePackage MaintenancePackage Sort pos.
MaintCmplRqIsLegallyBinding MaintCmplRqIsLegallyBinding Legal Requirement
MaintCmplRqOriginCode MaintCmplRqOriginCode Task Origin
MaintComplianceHasLongText MaintComplianceHasLongText Long text
MaintComplianceSortNumber MaintComplianceSortNumber Sort Number
MaintenanceComplianceIsDeleted MaintenanceComplianceIsDeleted Delete
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
LastChangeDateTime LastChangeDateTime Timestamp
_MaintenanceItem _MaintenanceItem
_MaintCmplRqOrigin _MaintCmplRqOrigin
_MaintComplianceCodeGroupText _MaintComplianceCodeGroupText
_MaintenancePackage _MaintenancePackage
_MaintenanceComplianceCodeText _MaintenanceComplianceCodeText
_MaintenanceItemReasonText _MaintenanceItemReasonText

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 R_MaintenanceItemReasonTP.
-- 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.

CREATE VIEW R_MaintenanceItemReasonTP AS
SELECT
  MaintenanceItem,
  NmbrOfMaintComplianceItems,
  MaintenanceComplianceGroupCode,
  MaintenanceComplianceCode,
  MaintenanceComplianceTypeCode,
  MaintComplianceCatalogCode,
  MaintComplianceDescription,
  _MaintenanceItemBasic.MaintenanceStrategy AS MaintenanceStrategy,
  MaintenancePackage,
  MaintCmplRqIsLegallyBinding,
  MaintCmplRqOriginCode,
  MaintComplianceHasLongText,
  MaintComplianceSortNumber,
  MaintenanceComplianceIsDeleted,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  LastChangeDateTime
FROM I_MaintenanceCompliance
LEFT OUTER JOIN I_MaintenancePackage AS _MaintenancePackage ON maintenancestrategy = _MaintenancePackage.MaintenanceStrategy AND MaintenancePackage = _MaintenancePackage.MaintenancePackage  -- association [0..1]
LEFT OUTER JOIN R_MaintenanceItemReasonTextTP AS _MaintenanceItemReasonText ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More