C_SrcgProjectMilestoneTP_F7757

DDL: C_SRCGPROJECTMILESTONETP_F7757 Type: view_entity CONSUMPTION
12 Fields 1 Data Sources 1 Associations 1 OData Services

Milestone for Sourcing Project - TP

C_SrcgProjectMilestoneTP_F7757 is a Consumption CDS View that provides data about "Milestone for Sourcing Project - TP" in SAP S/4HANA. It reads from 1 data source (R_SourcingProjectMilestoneTP) and exposes 12 fields with key field SourcingProjectMilestoneUUID. It has 1 association to related views. It is exposed through 1 OData service (UI_SRCGPROJ_CONTRIBUTE).

Data Sources (1)

SourceAliasJoin Type
R_SourcingProjectMilestoneTP R_SourcingProjectMilestoneTP from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_SourcingProjectTP_F7757 _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey SourcingProjectMilestoneUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
Metadata.allowExtensions true view
EndUserText.label Milestone for Sourcing Project - TP view

OData Services (1)

ServiceBindingVersionContractRelease
UI_SRCGPROJ_CONTRIBUTE UI_SRCGPROJ_CONTRIBUTE V2 C1 NOT_RELEASED

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SourcingProjectMilestoneUUID SourcingProjectMilestoneUUID Sourcing Project Milestone UUID
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
SourcingProjectMilestone SourcingProjectMilestone Milestone Type
SrcgProjMilestoneTypeText
SrcgProjMilestoneDateTime SrcgProjMilestoneDateTime Milestone Date
SourcingProjectMilestoneStatus SourcingProjectMilestoneStatus Milestone Status
SrcgProjMilestoneStatusText
SourcingOrigin SourcingOrigin Sourcing Origin
SrcgProjSourcingOriginText
SourcingScenario SourcingScenario Integration Scenario
SrcgProjSourcingScenarioText
_SourcingProject _SourcingProject

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 C_SrcgProjectMilestoneTP_F7757.
-- 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 C_SrcgProjectMilestoneTP_F7757 AS
SELECT
  SourcingProjectMilestoneUUID,
  SourcingProjectUUID,
  SourcingProjectMilestone,
  _SrcgProjMilestoneType._SrcgProjMilestoneTypeText[1: Language = $session.system_language].SrcgProjMilestoneTypeText AS SrcgProjMilestoneTypeText,
  SrcgProjMilestoneDateTime,
  SourcingProjectMilestoneStatus,
  _SrcgProjMilestoneStatus._SrcgProjMilestoneStatusText[1: Language = $session.system_language].SrcgProjMilestoneStatusText AS SrcgProjMilestoneStatusText,
  SourcingOrigin,
  _SrcgProjSourcingOriginText[1: Language = $session.system_language].SrcgProjSourcingOriginText AS SrcgProjSourcingOriginText,
  SourcingScenario,
  _SrcgProjSourcingScenarioText[1: Language = $session.system_language].SrcgProjSourcingScenarioText AS SrcgProjSourcingScenarioText
FROM R_SourcingProjectMilestoneTP
LEFT OUTER JOIN C_SourcingProjectTP_F7757 AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
;

Learn More