R_MaintenanceItemCauseTP

DDL: R_MAINTENANCEITEMCAUSETP Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources 3 Associations

Maintenance Item Cause

R_MaintenanceItemCauseTP is a Transactional CDS View that provides data about "Maintenance Item Cause" in SAP S/4HANA. It reads from 1 data source (I_MaintenanceCompliance) and exposes 26 fields with key fields MaintenanceItem, NmbrOfMaintComplianceItems. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_MaintenanceCompliance I_MaintenanceCompliance from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_MaintenancePackage _MaintenancePackage $projection.maintenancestrategy = _MaintenancePackage.MaintenanceStrategy and $projection.MaintenancePackage = _MaintenancePackage.MaintenancePackage
[0..1] I_MaintenanceStrategy _MaintenanceStrategy _MaintenanceStrategy.MaintenanceStrategy = $projection.maintenancestrategy
[0..*] R_MaintenanceItemCauseTextTP _MaintenanceItemCauseText

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Maintenance Item Cause 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 (26)

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 _MaintenanceStrategy 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
_MaintenanceComplianceCodeText _MaintenanceComplianceCodeText
_MaintenancePackage _MaintenancePackage
_MaintenanceStrategy _MaintenanceStrategy
_MaintenanceItemCauseText _MaintenanceItemCauseText

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_MaintenanceItemCauseTP.
-- 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_MaintenanceItemCauseTP AS
SELECT
  MaintenanceItem,
  NmbrOfMaintComplianceItems,
  MaintenanceComplianceGroupCode,
  MaintenanceComplianceCode,
  MaintenanceComplianceTypeCode,
  MaintComplianceCatalogCode,
  MaintComplianceDescription,
  _MaintenanceStrategy.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 I_MaintenanceStrategy AS _MaintenanceStrategy ON _MaintenanceStrategy.MaintenanceStrategy = maintenancestrategy  -- association [0..1]
LEFT OUTER JOIN R_MaintenanceItemCauseTextTP AS _MaintenanceItemCauseText ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More