C_DFS_RelocationProject

DDL: C_DFS_RELOCATIONPROJECT Type: view_entity CONSUMPTION
18 Fields 1 Data Sources 4 Associations

Consumption for Relocation Project

C_DFS_RelocationProject is a Consumption CDS View that provides data about "Consumption for Relocation Project" in SAP S/4HANA. It reads from 1 data source (I_ProjectData) and exposes 18 fields with key fields ProjectInternalID, StatusCode, StatusObject, Language. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectData RelocationProject from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_DFS_RelocationProjectStatus _RelProjStatus $projection.ProjectObject = _RelProjStatus.StatusObject
[0..*] C_DFS_RelocProjWBSElmntHierTP _RelocProjWBSElmntHierTP $projection.ProjectInternalID = _RelocProjWBSElmntHierTP.ProjectInternalID
[0..1] C_DFS_RelocationProjectVH _RelocProjVH $projection.ProjectInternalID = _RelocProjVH.ProjectInternalID
[0..1] I_DFS_RelocationProjectProfile _RelocProjPro $projection.ProjectProfileCode = _RelocProjPro.ProjectProfileCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Consumption for Relocation Project view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY ProjectInternalID ProjectInternalID Project Def.
KEY StatusCode _RelProjStatus StatusCode Statuscode
KEY StatusObject _RelProjStatus StatusObject Status Object
KEY Language _RelProjStatus Language Report Text Language
ProjectExternalID ProjectExternalID Project def.
ProjectDescription ProjectDescription Project Name
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ProjectProfileCode I_ProjectData ProjectProfileCode Project Profile
ProjectObject ProjectObject Object number
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic Field key PS
ControllingArea ControllingArea Controlling Area
ProfitCenter ProfitCenter Profit Center
SystemStatusName _RelProjStatus SystemStatusName
_RelProjStatus _RelProjStatus
_RelocProjWBSElmntHierTP _RelocProjWBSElmntHierTP
_RelocProjVH _RelocProjVH
_RelocProjPro _RelocProjPro

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_DFS_RelocationProject.
-- 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_DFS_RelocationProject AS
SELECT
  ProjectInternalID,
  _RelProjStatus.StatusCode AS StatusCode,
  _RelProjStatus.StatusObject AS StatusObject,
  _RelProjStatus.Language AS Language,
  ProjectExternalID,
  ProjectDescription,
  PlannedStartDate,
  PlannedEndDate,
  RelocationProject.ProjectProfileCode AS ProjectProfileCode,
  ProjectObject,
  FreeDefinedTableFieldSemantic,
  ControllingArea,
  ProfitCenter,
  _RelProjStatus.SystemStatusName AS SystemStatusName
FROM I_ProjectData AS RelocationProject
LEFT OUTER JOIN I_DFS_RelocationProjectStatus AS _RelProjStatus ON ProjectObject = _RelProjStatus.StatusObject  -- association [0..1]
LEFT OUTER JOIN C_DFS_RelocProjWBSElmntHierTP AS _RelocProjWBSElmntHierTP ON ProjectInternalID = _RelocProjWBSElmntHierTP.ProjectInternalID  -- association [0..*]
LEFT OUTER JOIN C_DFS_RelocationProjectVH AS _RelocProjVH ON ProjectInternalID = _RelocProjVH.ProjectInternalID  -- association [0..1]
LEFT OUTER JOIN I_DFS_RelocationProjectProfile AS _RelocProjPro ON ProjectProfileCode = _RelocProjPro.ProjectProfileCode  -- association [0..1]
;

Learn More