C_MngProjectDemandServiceTP

DDL: C_MNGPROJECTDEMANDSERVICETP Type: view_entity CONSUMPTION
63 Fields 1 Data Sources 4 Associations

Manage Proj Dmnd Srvc Root view for UI

C_MngProjectDemandServiceTP is a Consumption CDS View that provides data about "Manage Proj Dmnd Srvc Root view for UI" in SAP S/4HANA. It reads from 1 data source (I_ProjectDemandTP) and exposes 63 fields with key field ProjectDemandUUID. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectDemandTP I_ProjectDemandTP projection

Associations (4)

CardinalityTargetAliasCondition
[1] I_ProjectDemandStatus _ProjectDemandStatusFilter $projection.ProjectDemandStatusForFilter = _ProjectDemandStatusFilter.ProjectDemandStatus
[1] I_ProjDmndSrvcDateMaint _ProjDmndSrvcDateMaint $projection.ProjectDemandCategory = _ProjDmndSrvcDateMaint.ProjectDemandCategory and $projection.ProjectDemandDateMaintenance = _ProjDmndSrvcDateMaint.ProjectDemandDateMaintenance and $projection.ProjectDemandType = _ProjDmndSrvcDateMaint.ProjectDemandType
[0..1] C_ProjDmndWorkPackageDisplay _ProjectElementPopOverData $projection.ReferencedObjectUUID = _ProjectElementPopOverData.ProjectElementUUID
[0..1] C_ProjDmndProjectDisplay _ProjectPopOverData $projection.ProjectDescription = _ProjectPopOverData.ProjectDescription and $projection.ProjectUUID = _ProjectPopOverData.ProjectUUID

Annotations (14)

NameValueLevelField
Metadata.ignorePropagatedAnnotations true view
UI.headerInfo.description.value ProjectDemand view
UI.headerInfo.title.value ProjectDemandName view
UI.headerInfo.typeNamePlural Services view
UI.headerInfo.typeName Service view
Metadata.allowExtensions true view
Search.searchable true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Manage Proj Dmnd Srvc Root view for UI view
AccessControl.authorizationCheck #CHECK view

Fields (63)

KeyFieldSource TableSource FieldDescription
KEY ProjectDemandUUID ProjectDemandUUID Entity GUID
ProjectDemand ProjectDemand Demand ID
ProjectDemandName ProjectDemandName Demand Name
ProjectDemandCategory ProjectDemandCategory Demand Category
ProjectDemandType ProjectDemandType Demand Type
ProjectDemandTypeForFilter ProjectDemandType Demand Type
ProjectDemandDescription ProjectDemandDescription Description
ProjDmndRequestedQuantity ProjDmndRequestedQuantity Required Quantity
ProjDmndRequestedQuantityUnit ProjDmndRequestedQuantityUnit Quantity Unit
ReferencedObjectUUID ReferencedObjectUUID Referenced Object
Plant Plant Valuation Area
ProjectDemandDateMaintenance ProjectDemandDateMaintenance Date Alignment
ProjectDemandStartDate ProjectDemandStartDate Demand Start Date
ProjectDemandEndDate ProjectDemandEndDate Demand End Date
ProjectDemandStatus ProjectDemandStatus Demand Status
ProjectDemandStatusForFilter ProjectDemandStatus Demand Status
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingGroupName _PurchasingGroup PurchasingGroupName Purchasing Grp. Name
PurchasingOrganization PurchasingOrganization Purchasing Organization
PurchasingOrganizationName _PurchasingOrganisation PurchasingOrganizationName Purch. Org. Name
ProjectDemandRequestCurrency ProjectDemandRequestCurrency Demand Currency
ProjectDemandPerUnitAmount ProjectDemandPerUnitAmount Price Per Unit
PriceUnitQty PriceUnitQty Price unit
ProjectDemandRequestNetAmount ProjectDemandRequestNetAmount Net Demand Value
ProjectDemandExpectedAmount Net Value
ProjDmndReqNetAmountCurrency ProjDmndReqNetAmountCurrency Demand Currency
ProjectDemandOverallAmount ProjectDemandOverallAmount Overall Limit
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
ProjectDemandLastChangedByUser ProjectDemandLastChangedByUser Demand Changed By
ProjDemandLastChangeDateTime ProjDemandLastChangeDateTime Demand Changed On
FormattedPurRequisitionItem _MngProjDmndSrvcPurReqnOrd FormattedPurRequisitionItem
Project _ProjectElementData Project WBS Element
ProjectDescription _ProjectElementData ProjectDescription Project Name
ProjectUUID _ProjectElementData ProjectUUID Project UUID
ProjectElement _ProjectElementData ProjectElement Proj Element ID
ProjectElementDescription _ProjectElementData ProjectElementDescription Name
Material Material
MaterialGroup Material Group
Supplier Supplier
PurchasingInfoRecord Info Record
PurchaseContract Purchase Contract
_ProjDmndQuantityUnit _ProjDmndQuantityUnit
_WorkPackage _WorkPackage
_Plant _Plant
_ProjectElementData _ProjectElementData
_ProjectDemandStatus _ProjectDemandStatus
_ProjectDemandStatusFilter _ProjectDemandStatusFilter
_PurchasingGroup _PurchasingGroup
_ProjectDemandCurrency _ProjectDemandCurrency
_ProjectDemandNetCurrency _ProjectDemandNetCurrency
_ProjectDemandCategory _ProjectDemandCategory
_ProjectDemandType _ProjectDemandType
_PurchasingOrganisation _PurchasingOrganisation
_ProjectDemandVH _ProjectDemandVH
_ProjDmndSrvcDateMaint _ProjDmndSrvcDateMaint
_ProjectElementPopOverData _ProjectElementPopOverData
_ProjectPopOverData _ProjectPopOverData
_MngProjDmndSrvcPurReqnOrd _MngProjDmndSrvcPurReqnOrd
ProjectDemandFormattedName _ProjectDemandVH ProjectDemandFormattedName
SitnNumberOfInstances

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_MngProjectDemandServiceTP.
-- 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_MngProjectDemandServiceTP AS
SELECT
  ProjectDemandUUID,
  ProjectDemand,
  ProjectDemandName,
  ProjectDemandCategory,
  ProjectDemandType,
  ProjectDemandType AS ProjectDemandTypeForFilter,
  ProjectDemandDescription,
  ProjDmndRequestedQuantity,
  ProjDmndRequestedQuantityUnit,
  ReferencedObjectUUID,
  Plant,
  ProjectDemandDateMaintenance,
  ProjectDemandStartDate,
  ProjectDemandEndDate,
  ProjectDemandStatus,
  ProjectDemandStatus AS ProjectDemandStatusForFilter,
  PurchasingGroup,
  _PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  PurchasingOrganization,
  _PurchasingOrganisation.PurchasingOrganizationName AS PurchasingOrganizationName,
  ProjectDemandRequestCurrency,
  ProjectDemandPerUnitAmount,
  PriceUnitQty,
  ProjectDemandRequestNetAmount,
  cast( ProjectDemandRequestNetAmount as tv_proj_dmnd_expected_value preserving type ) AS ProjectDemandExpectedAmount,
  ProjDmndReqNetAmountCurrency,
  ProjectDemandOverallAmount,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ProjectDemandLastChangedByUser,
  ProjDemandLastChangeDateTime,
  _MngProjDmndSrvcPurReqnOrd.FormattedPurRequisitionItem AS FormattedPurRequisitionItem,
  _ProjectElementData.Project AS Project,
  _ProjectElementData.ProjectDescription AS ProjectDescription,
  _ProjectElementData.ProjectUUID AS ProjectUUID,
  _ProjectElementData.ProjectElement AS ProjectElement,
  _ProjectElementData.ProjectElementDescription AS ProjectElementDescription,
  _ProjectDemand._Service.Material AS Material,
  _ProjectDemand._Service.MaterialGroup AS MaterialGroup,
  _ProjectDemand._Service.Supplier AS Supplier,
  _ProjectDemand._Service.PurchasingInfoRecord AS PurchasingInfoRecord,
  _ProjectDemand._Service.PurchaseContract AS PurchaseContract,
  _ProjectDemandVH.ProjectDemandFormattedName AS ProjectDemandFormattedName,
  _ProjectDemandVH._SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances
FROM I_ProjectDemandTP
LEFT OUTER JOIN I_ProjectDemandStatus AS _ProjectDemandStatusFilter ON ProjectDemandStatusForFilter = _ProjectDemandStatusFilter.ProjectDemandStatus  -- association [1]
LEFT OUTER JOIN I_ProjDmndSrvcDateMaint AS _ProjDmndSrvcDateMaint ON ProjectDemandCategory = _ProjDmndSrvcDateMaint.ProjectDemandCategory AND ProjectDemandDateMaintenance = _ProjDmndSrvcDateMaint.ProjectDemandDateMaintenance AND ProjectDemandType = _ProjDmndSrvcDateMaint.ProjectDemandType  -- association [1]
LEFT OUTER JOIN C_ProjDmndWorkPackageDisplay AS _ProjectElementPopOverData ON ReferencedObjectUUID = _ProjectElementPopOverData.ProjectElementUUID  -- association [0..1]
LEFT OUTER JOIN C_ProjDmndProjectDisplay AS _ProjectPopOverData ON ProjectDescription = _ProjectPopOverData.ProjectDescription AND ProjectUUID = _ProjectPopOverData.ProjectUUID  -- association [0..1]
;

Learn More