I_SourcingProjectItem

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_SourcingProjectItem.
-- 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_SourcingProjectItem AS
SELECT
  SourcingProjectItemUUID,
  SourcingProjectItem,
  SourcingProjectUUID,
  SourcingProjectItemType,
  SrcgProjItemClassification,
  SourcingProjectItemStableUUID,
  SrcgProjItemDescription,
  Material,
  ProductType,
  MaterialGroup,
  SrcgProjItemTargetAmount,
  SrcgProjItemTotalTargetAmount,
  RequestedQuantity,
  MaximumRequestedQuantity,
  RequestedQuantityUnit,
  RequestedDeliveryDate,
  PerformancePeriodStartDate,
  PerformancePeriodEndDate,
  OrderItemQtyToBaseQtyNmrtr,
  OrderItemQtyToBaseQtyDnmntr,
  Plant,
  CompanyCode,
  PurchasingGroup,
  PurchasingOrganization,
  ProcurementHubSourceSystem,
  StorageLocation,
  SourcingProjectItemParent,
  HierarchyNodeLevel,
  AlternativeItemID,
  FormattedItemID,
  HierarchyNodeSubTreeSize,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  SourcingOrigin,
  SourcingScenario,
  SrcgProjItemDemandConfCode,
  SrcgProjItemUnconfdDemandRsn,
  SrcgProjFollowOnDocumentCat,
  SrcgProjFollowOnDocumentType,
  _SourcingProject.DocumentCurrency AS DocumentCurrency
FROM R_SourcingProjectItem
LEFT OUTER JOIN I_SourcingProject AS _SourcingProject ON SourcingProjectUUID = _SourcingProject.SourcingProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_SrcgProjItmDemandDistr AS _SrcgProjDemandDistribution ON SourcingProjectItemUUID = _SrcgProjDemandDistribution.SourcingProjectItemUUID  -- association [1..*]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_ProductTypeCode AS _ProductType ON ProductType = _ProductType.ProductTypeCode  -- association [0..1]
LEFT OUTER JOIN I_SourcingProjectItemType AS _SourcingProjectItemType ON SourcingProjectItemType = _SourcingProjectItemType.SourcingProjectItemType  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjItemClassification AS _SrcgProjItemClassification ON SourcingProjectItemType = _SrcgProjItemClassification.SourcingProjectItemType AND SrcgProjItemClassification = _SrcgProjItemClassification.SrcgProjItemClassification  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _RequestedQuantityUnit ON RequestedQuantityUnit = _RequestedQuantityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchasingDocumentType ON SrcgProjFollowOnDocumentCat = _PurchasingDocumentType.PurchasingDocumentCategory AND SrcgProjFollowOnDocumentType = _PurchasingDocumentType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentCategory AS _PurchasingDocumentCategory ON SrcgProjFollowOnDocumentCat = _PurchasingDocumentCategory.PurchasingDocumentCategory  -- association [0..1]
LEFT OUTER JOIN I_SrcgProjItemDemandConfCode AS _SrcgProjItemDemandConfCode ON SrcgProjItemDemandConfCode = _SrcgProjItemDemandConfCode.SrcgProjItemDemandConfCode  -- association [0..1]
LEFT OUTER JOIN I_ProductSourcingReason AS _SourcingProjectReason ON SrcgProjItemUnconfdDemandRsn = _SourcingProjectReason.ProductSourcingReason  -- association [0..1]
LEFT OUTER JOIN E_SourcingProjectItem AS _Extension ON SourcingProjectItemUUID = _Extension.SourcingProjectItemUUID  -- association [1..1]
;