A_DevelopmentProject

DDL: A_DEVELOPMENTPROJECT Type: view_entity CONSUMPTION
34 Fields 1 Data Sources 2 Associations

Development Project

A_DevelopmentProject is a Consumption CDS View that provides data about "Development Project" in SAP S/4HANA. It reads from 1 data source (R_DevelopmentProjectTP) and exposes 34 fields with key field ProjectUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_DevelopmentProjectTP R_DevelopmentProjectTP projection

Associations (2)

CardinalityTargetAliasCondition
[1..*] A_DevelopmentProjectStatus _ProjectStatus $projection.ProjectUUID = _ProjectStatus.ProjectUUID ---Extension
[1..1] E_DevelopmentProject _Extension $projection.ProjectUUID = _Extension.ProjectUUID

Annotations (9)

NameValueLevelField
EndUserText.label Development Project view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
OData.entityType.name DevelopmentProject_Type view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID Project UUID
ProjectDescription ProjectDescription Project Name
ProjectReasonCode ProjectReasonCode
MasterLanguage MasterLanguage Primary lang.
ProjectLocation ProjectLocation
CustomerUUID CustomerUUID NodeID
SoldToPartyUUID SoldToPartyUUID
OrganizationalUnit OrganizationalUnit Org. Unit ID
ProjectTemplateUUID ProjectTemplateUUID Entity GUID
ProjectTemplateAdminBuPaUUID ProjectTemplateAdminBuPaUUID
DevProjPeriodType DevProjPeriodType
ResourceAllocationUnit ResourceAllocationUnit
ProjectLastChangedByUser ProjectLastChangedByUser Changed by
ProjectLastChangedDateTime ProjectLastChangedDateTime Time Stamp
Project Project WBS Element
DevProjElmntUUID DevProjElmntUUID
PriorityCode PriorityCode Priority
DevProjType DevProjType
StartConstraintType StartConstraintType
DevProjFinishConstraintType DevProjFinishConstraintType
DevProjCalculatedStartDate DevProjCalculatedStartDate
DevProjCalculatedFinishDate DevProjCalculatedFinishDate
StartConstraintDate StartConstraintDate
FinishConstraintDate FinishConstraintDate
FactoryCalendar FactoryCalendar Factory Calendar
DevProjGroupingText DevProjGroupingText
DevProjSearchFieldText DevProjSearchFieldText
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
DevProjActualWorkQuantity DevProjActualWorkQuantity
ActualWorkQuantityUnit ActualWorkQuantityUnit
_ProjectStatus _ProjectStatus

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 A_DevelopmentProject.
-- 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 A_DevelopmentProject AS
SELECT
  ProjectUUID,
  ProjectDescription,
  ProjectReasonCode,
  MasterLanguage,
  ProjectLocation,
  CustomerUUID,
  SoldToPartyUUID,
  OrganizationalUnit,
  ProjectTemplateUUID,
  ProjectTemplateAdminBuPaUUID,
  DevProjPeriodType,
  ResourceAllocationUnit,
  ProjectLastChangedByUser,
  ProjectLastChangedDateTime,
  Project,
  DevProjElmntUUID,
  PriorityCode,
  DevProjType,
  StartConstraintType,
  DevProjFinishConstraintType,
  DevProjCalculatedStartDate,
  DevProjCalculatedFinishDate,
  StartConstraintDate,
  FinishConstraintDate,
  FactoryCalendar,
  DevProjGroupingText,
  DevProjSearchFieldText,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  DevProjActualWorkQuantity,
  ActualWorkQuantityUnit
FROM R_DevelopmentProjectTP
LEFT OUTER JOIN A_DevelopmentProjectStatus AS _ProjectStatus ON ProjectUUID = _ProjectStatus.ProjectUUID  -- association [1..*]
LEFT OUTER JOIN E_DevelopmentProject AS _Extension ON ProjectUUID = _Extension.ProjectUUID  -- association [1..1]
;

Learn More