C_SrcPrjByPlntProcmtPrj

DDL: C_SRCPRJBYPLNTPROCMTPRJ SQL: CMMSRCPRJ Type: view CONSUMPTION
21 Fields 1 Data Sources 3 Associations 1 OData Services

Sourcing Project by Plant and Proc Proj

C_SrcPrjByPlntProcmtPrj is a Consumption CDS View that provides data about "Sourcing Project by Plant and Proc Proj" in SAP S/4HANA. It reads from 1 data source (P_SRCPROJBYPROCANDPLANT2) and exposes 21 fields with key fields ProcurementProjectUUID, SrcgProjPubdSuplrListUUID. It has 3 associations to related views. It is exposed through 1 OData service (UI_PRODUCT_SOURCING_OVWP).

Data Sources (1)

SourceAliasJoin Type
P_SRCPROJBYPROCANDPLANT2 P_SRCPROJBYPROCANDPLANT2 from

Parameters (3)

NameTypeDefault
P_StartDate vdm_srcgprojcreationdate
P_EndDate vdm_srcgprojcreationdate
P_DateFunction datefunctionid

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_Plant _Plant $projection.Plant = _Plant.Plant
[1..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1..1] I_ProductGroup_2 _MaterialGroup $projection.MaterialGroup = _MaterialGroup.ProductGroup

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName CMMSRCPRJ view
EndUserText.label Sourcing Project by Plant and Proc Proj view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view

OData Services (1)

ServiceBindingVersionContractRelease
UI_PRODUCT_SOURCING_OVWP UI_PRODUCT_SOURCING V2 C1 NOT_RELEASED

Fields (21)

KeyFieldSource TableSource FieldDescription
resultElementDateFunctionStartDateTime
resultElementDateFunctionEndDateTime
P_StartDate
SourcingProjectUUIDasSourcingProjectUUID
KEY ProcurementProjectUUID ProcurementProjectUUID Procurement Project UUID
KEY SrcgProjPubdSuplrListUUID SrcgProjPubdSuplrListUUID Published Supplier List UUID
SourcingProject SourcingProject SourcingProject Sourcing Project
SourcingProjectName SourcingProject SourcingProjectName Name
ProcurementProject ProcurementProject Project
ProcurementProjectName ProcurementProjectName Name
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
CompanyCode CompanyCode Receiver Company Code
PurchasingGroup PurchasingGroup Purchasing Group
PurchasingOrganization PurchasingOrganization Purchasing Organization
MaterialGroup MaterialGroup Product Group
Bidder Supplier Supplier
NumberOfSourcingProjects
_Plant _Plant
_CompanyCode _CompanyCode
_MaterialGroup _MaterialGroup

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_SrcPrjByPlntProcmtPrj.
-- 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.
-- SQL view name: CMMSRCPRJ
-- Parameters: P_StartDate : vdm_srcgprojcreationdate, P_EndDate : vdm_srcgprojcreationdate, P_DateFunction : datefunctionid

CREATE VIEW C_SrcPrjByPlntProcmtPrj AS
SELECT
  resultElement: 'DateFunctionStartDateTime' AS resultElementDateFunctionStartDateTime,
  resultElement: 'DateFunctionEndDateTime' AS resultElementDateFunctionEndDateTime,
  binding: [ { targetParameter: 'P_DateFunction', type: #PARAMETER, value : 'P_DateFunction' AS P_StartDate,
  ProcurementProjectUUID,
  SrcgProjPubdSuplrListUUID,
  SourcingProject.SourcingProject AS SourcingProject,
  SourcingProject.SourcingProjectName AS SourcingProjectName,
  ProcurementProject,
  ProcurementProjectName,
  Plant,
  _Plant.PlantName AS PlantName,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  MaterialGroup,
  Supplier AS Bidder,
  cast( 1 as mm_pur_ana_numbrofsrcgproj ) AS NumberOfSourcingProjects
FROM P_SRCPROJBYPROCANDPLANT2
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _MaterialGroup ON MaterialGroup = _MaterialGroup.ProductGroup  -- association [1..1]
;

Learn More