C_SrcgProjItmDmndDistrDetDEX

DDL: C_SRCGPROJITMDMNDDISTRDETDEX Type: view_entity CONSUMPTION
10 Fields 1 Data Sources 3 Associations

SrcgProjItem Distribution Detail Extract

C_SrcgProjItmDmndDistrDetDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

SrcgProjItemDmndDistrDetail · Sourcing & Procurement

C_SrcgProjItmDmndDistrDetDEX is a Consumption CDS View (Fact) that provides data about "SrcgProjItem Distribution Detail Extract" in SAP S/4HANA. It reads from 1 data source (R_SrcgProjItmDmndDistrDetail) and exposes 10 fields with key field SrcgProjDmndDistrDetailsUUID. It has 3 associations to related views.

SAP API Hub

StateC1
Line of BusinessSourcing & Procurement
Application ComponentMM-PUR-SRC-SP
CapabilitiesData Source for Data Extraction
PackageSourcing & Procurement for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
R_SrcgProjItmDmndDistrDetail SrcgProjItmDmndDistrDetailDEX from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_SourcingProjectDEX _SourcingProject $projection.SourcingProjectUUID = _SourcingProject.SourcingProjectUUID
[1..1] C_SrcgProjItmDemandDistrDEX _SrcgProjDemandDistribution $projection.SrcgProjDmndDistributionUUID = _SrcgProjDemandDistribution.SrcgProjDmndDistributionUUID
[0..1] I_UnitOfMeasure _RequestedQuantityUnit $projection.requestedquantityunit = _RequestedQuantityUnit.UnitOfMeasure

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
Analytics.dataCategory #FACT view
ObjectModel.sapObjectNodeType.name SrcgProjItemDmndDistrDetail view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.modelingPattern #ANALYTICAL_FACT view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label SrcgProjItem Distribution Detail Extract view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY SrcgProjDmndDistrDetailsUUID R_SrcgProjItmDmndDistrDetail SrcgProjDmndDistrDetailsUUID Demand Distribution Details UUID
SrcgProjDmndDistributionUUID R_SrcgProjItmDmndDistrDetail SrcgProjDmndDistributionUUID Sourcing Project Demand Distribution UUID
SourcingProjectUUID R_SrcgProjItmDmndDistrDetail SourcingProjectUUID Sourcing Project UUID
FiscalYear R_SrcgProjItmDmndDistrDetail FiscalYear G/L Fiscal Year
RequestedQuantity R_SrcgProjItmDmndDistrDetail RequestedQuantity Requested Quantity
MaximumRequestedPeriodQuantity R_SrcgProjItmDmndDistrDetail MaximumRequestedPeriodQuantity Maximum Demand Per Period
RequestedQuantityUnit _SrcgProjDemandDistribution RequestedQuantityUnit Requested Quantity Unit
_SrcgProjDemandDistribution _SrcgProjDemandDistribution
_RequestedQuantityUnit _RequestedQuantityUnit
_SourcingProject _SourcingProject

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_SrcgProjItmDmndDistrDetDEX.
-- 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_SrcgProjItmDmndDistrDetDEX AS
SELECT
  SrcgProjItmDmndDistrDetailDEX.SrcgProjDmndDistrDetailsUUID AS SrcgProjDmndDistrDetailsUUID,
  SrcgProjItmDmndDistrDetailDEX.SrcgProjDmndDistributionUUID AS SrcgProjDmndDistributionUUID,
  SrcgProjItmDmndDistrDetailDEX.SourcingProjectUUID AS SourcingProjectUUID,
  SrcgProjItmDmndDistrDetailDEX.FiscalYear AS FiscalYear,
  SrcgProjItmDmndDistrDetailDEX.RequestedQuantity AS RequestedQuantity,
  SrcgProjItmDmndDistrDetailDEX.MaximumRequestedPeriodQuantity AS MaximumRequestedPeriodQuantity,
  _SrcgProjDemandDistribution.RequestedQuantityUnit AS RequestedQuantityUnit
FROM R_SrcgProjItmDmndDistrDetail AS SrcgProjItmDmndDistrDetailDEX
LEFT OUTER JOIN C_SourcingProjectDEX AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN C_SrcgProjItmDemandDistrDEX AS _SrcgProjDemandDistribution ON SrcgProjDmndDistributionUUID = _SrcgProjDemandDistribution.SrcgProjDmndDistributionUUID  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RequestedQuantityUnit ON requestedquantityunit = _RequestedQuantityUnit.UnitOfMeasure  -- association [0..1]
;

Learn More