C_DFS_RelocationProject

DDL: C_DFS_RELOCATIONPROJECT Type: view_entity CONSUMPTION

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.

1 data source(s) 18 fields

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
KEY StatusCode _RelProjStatus StatusCode
KEY StatusObject _RelProjStatus StatusObject
KEY Language _RelProjStatus Language
ProjectExternalID ProjectExternalID
ProjectDescription ProjectDescription
PlannedStartDate PlannedStartDate
PlannedEndDate PlannedEndDate
ProjectProfileCode I_ProjectData ProjectProfileCode
ProjectObject ProjectObject
FreeDefinedTableFieldSemantic FreeDefinedTableFieldSemantic
ControllingArea ControllingArea
ProfitCenter ProfitCenter
SystemStatusName _RelProjStatus SystemStatusName
_RelProjStatus _RelProjStatus
_RelocProjWBSElmntHierTP _RelocProjWBSElmntHierTP
_RelocProjVH _RelocProjVH
_RelocProjPro _RelocProjPro 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consumption for Relocation Project'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@Metadata.allowExtensions: true
@VDM.viewType:#CONSUMPTION
@ObjectModel.semanticKey: ['ProjectExternalID']

define view entity C_DFS_RelocationProject
  as select from I_ProjectData as RelocationProject
  association [0..1] to I_DFS_RelocationProjectStatus  as _RelProjStatus           on $projection.ProjectObject      = _RelProjStatus.StatusObject
  association [0..*] to C_DFS_RelocProjWBSElmntHierTP  as _RelocProjWBSElmntHierTP on $projection.ProjectInternalID  = _RelocProjWBSElmntHierTP.ProjectInternalID
  association [0..1] to C_DFS_RelocationProjectVH      as _RelocProjVH             on $projection.ProjectInternalID  = _RelocProjVH.ProjectInternalID
  association [0..1] to I_DFS_RelocationProjectProfile as _RelocProjPro            on $projection.ProjectProfileCode = _RelocProjPro.ProjectProfileCode
{
         @UI.hidden: true
         @Consumption.filter.hidden: true
  key    ProjectInternalID,
         @UI.hidden: true
         @Consumption.filter.hidden: true
  key    _RelProjStatus.StatusCode,
         @UI.hidden: true
         @Consumption.filter.hidden: true
  key    _RelProjStatus.StatusObject,
         @Consumption.filter.hidden: true
         @UI.hidden: true
  key    _RelProjStatus.Language,
         //@Consumption.valueHelp: '_RelocProjVH'

         @Consumption: { valueHelpDefinition: [{ entity: { element: 'ProjectExternalID' , name: 'C_DFS_RelocationProjectVH'  },
                                          additionalBinding: [{ localElement: 'ProjectDescription', element: 'ProjectDescription'} ] }]}
         ProjectExternalID,
         // @Consumption.valueHelp: '_RelocProjVH'

         @Consumption: { valueHelpDefinition: [{ entity: { element: 'ProjectDescription' , name: 'C_DFS_RelocationProjectVH'  },
          additionalBinding: [{ localElement: 'ProjectExternalID', element: 'ProjectExternalID'} ] }]}
         ProjectDescription,
         @Consumption.filter.selectionType: #INTERVAL
         //                  @UI.lineItem: [{label: 'Start Date' }]

         @UI.lineItem: [{label: 'Valid From' }]
         PlannedStartDate,
         @Consumption.filter.selectionType: #INTERVAL
         //                  @UI.lineItem: [{label: 'End Date' }]

         @UI.lineItem: [{label: 'Valid To' }]
         PlannedEndDate,

         RelocationProject.ProjectProfileCode,
         @UI.hidden: true
         @Consumption.filter.hidden: true
         ProjectObject,
         @UI.hidden: true
         @Consumption.filter.hidden: true
         FreeDefinedTableFieldSemantic,
         @UI.hidden: true
         ControllingArea, //added for DCL

         @UI.hidden: true
         ProfitCenter,    //added for DCL

         @Consumption.filter.hidden: true
         _RelProjStatus.SystemStatusName,
         _RelProjStatus,
         @ObjectModel.filter.enabled: false
         _RelocProjWBSElmntHierTP,
         _RelocProjVH,
         _RelocProjPro
}
where
  //      FreeDefinedTableFieldSemantic is not initial

      ProjectProfileCode        = _RelocProjPro.ProjectProfileCode
  and _RelProjStatus.Language   = $session.system_language
  and _RelProjStatus.StatusCode = 'I0002'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DFS_RELOCATIONPROJECTPROFILE",
"I_DFS_RELOCATIONPROJECTSTATUS",
"I_PROJECTDATA"
],
"ASSOCIATED":
[
"C_DFS_RELOCATIONPROJECTVH",
"C_DFS_RELOCPROJWBSELMNTHIERTP",
"I_DFS_RELOCATIONPROJECTPROFILE",
"I_DFS_RELOCATIONPROJECTSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More