C_SrcgProjDmndDistrCompare

DDL: C_SRCGPROJDMNDDISTRCOMPARE Type: view_entity CONSUMPTION
12 Fields 1 Data Sources 3 Associations

Demand Distribution

C_SrcgProjDmndDistrCompare is a Consumption CDS View that provides data about "Demand Distribution" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjItmDemandDistr) and exposes 12 fields with key field SrcgProjDmndDistributionUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjItmDemandDistr R_SrcgProjItmDemandDistr from

Associations (3)

CardinalityTargetAliasCondition
[0..*] C_SrcgProjDmndDistrDetsCompare _SrcgProjDmndDistrDetsCompare $projection.SrcgProjDmndDistributionUUID = _SrcgProjDmndDistrDetsCompare.SrcgProjDmndDistributionUUID
[0..1] I_BackendPlantForPurg _Plant $projection.ProcmtHubPlantUniqueID = _Plant.ProcmtHubPlantUniqueID
[0..1] C_ProcurementProjectVH _ProcurementProject $projection.ProcurementProject = _ProcurementProject.ProcurementProject

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey SrcgProjDmndDistributionUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
EndUserText.label Demand Distribution view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjDmndDistributionUUID SrcgProjDmndDistributionUUID Demand Distribution UUID
SourcingProjectItemUUID SourcingProjectItemUUID Item UUID
Plant Plant Valuation Area
ProcmtHubPlantUniqueID ProcmtHubPlantUniqueID Plant Unique ID
ProcurementProject ProcurementProject Project
SrcgProjItemDemandConfCode SrcgProjItemDemandConfCode Confirmation Code
RequestedCommitmentPeriod RequestedCommitmentPeriod
PlantName _Plant PlantName Plant Name
ProcurementProjectName _ProcurementProject ProcurementProjectName Name
SourcingProjectUUID SourcingProjectUUID Sourcing Project UUID
_SourcingProject _SourcingProject
_SrcgProjDmndDistrDetsCompare _SrcgProjDmndDistrDetsCompare

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_SrcgProjDmndDistrCompare.
-- 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_SrcgProjDmndDistrCompare AS
SELECT
  SrcgProjDmndDistributionUUID,
  SourcingProjectItemUUID,
  Plant,
  ProcmtHubPlantUniqueID,
  ProcurementProject,
  SrcgProjItemDemandConfCode,
  RequestedCommitmentPeriod,
  _Plant.PlantName AS PlantName,
  _ProcurementProject.ProcurementProjectName AS ProcurementProjectName,
  SourcingProjectUUID
FROM R_SrcgProjItmDemandDistr
LEFT OUTER JOIN C_SrcgProjDmndDistrDetsCompare AS _SrcgProjDmndDistrDetsCompare ON SrcgProjDmndDistributionUUID = _SrcgProjDmndDistrDetsCompare.SrcgProjDmndDistributionUUID  -- association [0..*]
LEFT OUTER JOIN I_BackendPlantForPurg AS _Plant ON ProcmtHubPlantUniqueID = _Plant.ProcmtHubPlantUniqueID  -- association [0..1]
LEFT OUTER JOIN C_ProcurementProjectVH AS _ProcurementProject ON ProcurementProject = _ProcurementProject.ProcurementProject  -- association [0..1]
;

Learn More