I_MaintProcmtMilestoneAssgmt

DDL: I_MAINTPROCMTMILESTONEASSGMT SQL: IMNTPRMLSAS Type: view BASIC Package: EAM_BACKLOG
9 Fields 1 Data Sources 2 Associations

Maintenance Procurement Milestone Assignment

I_MaintProcmtMilestoneAssgmt is a Basic CDS View that provides data about "Maintenance Procurement Milestone Assignment" in SAP S/4HANA. It reads from 1 data source (eam_procmlstasg) and exposes 9 fields with key fields MaintProcurementMilestone, MaintProcmtMilestoneAssgmt. It has 2 associations to related views. Part of development package EAM_BACKLOG.

Data Sources (1)

SourceAliasJoin Type
eam_procmlstasg eam_procmlstasg from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MaintProcurementMilestone _Milestones _Milestones.MaintProcurementMilestone = $projection.MaintProcurementMilestone
[0..1] I_MaintOrdProcmtDemandCategory _MaintOrdProcmtDemandCategory _MaintOrdProcmtDemandCategory.MaintOrdProcmtDemandCategory = $projection.MaintOrdProcmtDemandCategory

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMNTPRMLSAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Maintenance Procurement Milestone Assignment view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY MaintProcurementMilestone eam_procmlstasg maintprocurementmilestone Milestone
KEY MaintProcmtMilestoneAssgmt eam_procmlstasg maintprocmtmilestoneassgmt Number
MaintenanceOrderType eam_procmlstasg maintenanceordertype Order Type
MaintenancePlanningPlant eam_procmlstasg maintenanceplanningplant Planning Plant
MaintOrdProcmtDemandCategory eam_procmlstasg maintordprocmtdemandcategory Demand Category
MaintenancePlant eam_procmlstasg maintenanceplant Plant
MaterialGroup eam_procmlstasg materialgroup Product Group
_Milestones _Milestones
_MaintOrdProcmtDemandCategory _MaintOrdProcmtDemandCategory

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_MaintProcmtMilestoneAssgmt.
-- 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: IMNTPRMLSAS

CREATE VIEW I_MaintProcmtMilestoneAssgmt AS
SELECT
  eam_procmlstasg.maintprocurementmilestone AS MaintProcurementMilestone,
  eam_procmlstasg.maintprocmtmilestoneassgmt AS MaintProcmtMilestoneAssgmt,
  eam_procmlstasg.maintenanceordertype AS MaintenanceOrderType,
  eam_procmlstasg.maintenanceplanningplant AS MaintenancePlanningPlant,
  eam_procmlstasg.maintordprocmtdemandcategory AS MaintOrdProcmtDemandCategory,
  eam_procmlstasg.maintenanceplant AS MaintenancePlant,
  eam_procmlstasg.materialgroup AS MaterialGroup
FROM eam_procmlstasg
LEFT OUTER JOIN I_MaintProcurementMilestone AS _Milestones ON _Milestones.MaintProcurementMilestone = MaintProcurementMilestone  -- association [0..1]
LEFT OUTER JOIN I_MaintOrdProcmtDemandCategory AS _MaintOrdProcmtDemandCategory ON _MaintOrdProcmtDemandCategory.MaintOrdProcmtDemandCategory = MaintOrdProcmtDemandCategory  -- association [0..1]
;

Learn More