I_ProcurementProjectPlant

DDL: I_PROCUREMENTPROJECTPLANT Type: view_entity BASIC Package: VDM_MM_PUR_PROCMTPROJ
8 Fields 1 Data Sources 2 Associations

Plant in Procurement Project

I_ProcurementProjectPlant is a Basic CDS View that provides data about "Plant in Procurement Project" in SAP S/4HANA. It reads from 1 data source (R_ProcurementProjectPlant) and exposes 8 fields with key field ProcmtProjectPlantUUID. It has 2 associations to related views. Part of development package VDM_MM_PUR_PROCMTPROJ.

Data Sources (1)

SourceAliasJoin Type
R_ProcurementProjectPlant R_ProcurementProjectPlant from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProcurementProject _ProcurementProject $projection.ProcurementProjectUUID = _ProcurementProject.ProcurementProjectUUID
[1..1] E_ProcurementProjectPlant _Extension $projection.ProcmtProjectPlantUUID = _Extension.ProcmtProjectPlantUUID

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.representativeKey ProcmtProjectPlantUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #BASIC view
EndUserText.label Plant in Procurement Project view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProcmtProjectPlantUUID ProcmtProjectPlantUUID Plant UUID
ProcurementProjectPlant ProcurementProjectPlant Plant
ProductionStartDate ProductionStartDate Start of Production
ProductionEndDate ProductionEndDate Production End Date
ProcurementProjectUUID ProcurementProjectUUID Procurement Project UUID
CompanyCode CompanyCode Receiver Company Code
ProcurementHubSourceSystem ProcurementHubSourceSystem Connected System ID
_ProcurementProject _ProcurementProject

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 I_ProcurementProjectPlant.
-- 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 I_ProcurementProjectPlant AS
SELECT
  ProcmtProjectPlantUUID,
  ProcurementProjectPlant,
  ProductionStartDate,
  ProductionEndDate,
  ProcurementProjectUUID,
  CompanyCode,
  ProcurementHubSourceSystem
FROM R_ProcurementProjectPlant
LEFT OUTER JOIN I_ProcurementProject AS _ProcurementProject ON ProcurementProjectUUID = _ProcurementProject.ProcurementProjectUUID  -- association [1..1]
LEFT OUTER JOIN E_ProcurementProjectPlant AS _Extension ON ProcmtProjectPlantUUID = _Extension.ProcmtProjectPlantUUID  -- association [1..1]
;

Learn More