What is I_SourcingProjectMilestone in SAP S/4HANA?

I_SourcingProjectMilestone is a basic CDS view in SAP S/4HANA. Milestone for Sourcing Project It contains 10 fields.

Which tables does I_SourcingProjectMilestone read from?

I_SourcingProjectMilestone reads data from: mmsrcgpmlstn.

What VDM layer is I_SourcingProjectMilestone?

I_SourcingProjectMilestone is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_SourcingProjectMilestone

DDL: I_SOURCINGPROJECTMILESTONE Type: view_entity BASIC

10 Fields 1 Data Sources 3 Associations

Milestone for Sourcing Project

I_SourcingProjectMilestone is a Basic CDS View that provides data about "Milestone for Sourcing Project" in SAP S/4HANA. It reads from 1 data source (mmsrcgpmlstn) and exposes 10 fields with key field SourcingProjectMilestoneUUID. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
mmsrcgpmlstn	mmsrcgpmlstn	from

Associations (3)

Cardinality	Target	Alias	Condition
[1..1]	I_SourcingProject	_SourcingProject	`$projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID`
[0..1]	I_SrcgProjMilestoneType	_SrcgProjMilestoneType	`$projection.SourcingProjectMilestone = _SrcgProjMilestoneType.SourcingProjectMilestoneType`
[0..1]	I_SrcgProjMilestoneStatus	_SrcgProjMilestoneStatus	`$projection.SourcingProjectMilestoneStatus = _SrcgProjMilestoneStatus.SourcingProjectMilestoneStatus`

Annotations (7)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
ObjectModel.representativeKey	SourcingProjectMilestoneUUID	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
VDM.viewType	#BASIC	view
EndUserText.label	Milestone for Sourcing Project	view

Fields (10)

Key	Field	Source Field	Description
KEY	SourcingProjectMilestoneUUID	sourcingprojectmilestoneuuid	Sourcing Project Milestone UUID
	SourcingProjectUUID	sourcingprojectuuid	Sourcing Project UUID
	SourcingProjectMilestone	sourcingprojectmilestone	Milestone Type
	SrcgProjMilestoneDateTime	srcgprojmilestonedatetime	Milestone Date
	SourcingProjectMilestoneStatus	sourcingprojectmilestonestatus	Milestone Status
	SourcingOrigin	sourcingorigin	Sourcing Origin
	SourcingScenario	sourcingscenario	Integration Scenario
	_SourcingProject	_SourcingProject
	_SrcgProjMilestoneType	_SrcgProjMilestoneType
	_SrcgProjMilestoneStatus	_SrcgProjMilestoneStatus

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_SourcingProjectMilestone.
-- 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 I_SourcingProjectMilestone AS
SELECT
  SourcingProjectMilestoneUUID,
  SourcingProjectUUID,
  SourcingProjectMilestone,
  SrcgProjMilestoneDateTime,
  SourcingProjectMilestoneStatus,
  SourcingOrigin,
  SourcingScenario
FROM mmsrcgpmlstn
LEFT OUTER JOIN I_SourcingProject AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_SrcgProjMilestoneType AS _SrcgProjMilestoneType ON SourcingProjectMilestone = _SrcgProjMilestoneType.SourcingProjectMilestoneType  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjMilestoneStatus AS _SrcgProjMilestoneStatus ON SourcingProjectMilestoneStatus = _SrcgProjMilestoneStatus.SourcingProjectMilestoneStatus  -- association [0..1]
;

Depth:

I_SourcingProjectMilestone view_entity

mmsrcgpmlstn