I_ProjPurDocItems

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_ProjPurDocItems.
-- 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: IPURDOCI

CREATE VIEW I_ProjPurDocItems AS
SELECT
  cast( ProjPurDocItems.PurchasingDocument as ps_s4_doc preserving type ) AS PurchasingDocument,
  cast( ProjPurDocItems.PurchasingDocumentItem as ps_s4_docitem preserving type ) AS PurchasingDocumentItem,
  ProjPurDocItems.AccountAssignmentNumber AS AccountAssignmentNumber,
  ProjPurDocItems.ProjectNetworkInternalID AS ProjectNetworkInternalID,
  ProjPurDocItems.NetworkActivityInternalID AS NetworkActivityInternalID,
  ProjPurDocItems.ProjectNetwork AS ProjectNetwork,
  ProjPurDocItems.PurchasingDocumentType AS PurchasingDocumentType,
  ProjPurDocItems.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  ProjPurDocItems.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  ProjPurDocItems.DeliveryDate AS DeliveryDate,
  ProjPurDocItems.BaseUnit AS BaseUnit,
  ProjPurDocItems.RequestedQuantity AS RequestedQuantity,
  ProjPurDocItems.Plant AS Plant,
  ProjPurDocItems.PlantName AS PlantName,
  ProjPurDocItems.Supplier AS Supplier,
  ProjPurDocItems.Material AS Material,
  ProjPurDocItems.MaterialGroup AS MaterialGroup,
  ProjPurDocItems.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _NetworkActivity.NetworkActivityObject AS NetworkActivityObject,
  _NetworkActivity.ObjBasedAuthorizationIsActive AS NtwkActyObjBsdAuthznIsActv
FROM P_ProjPurDocItems AS ProjPurDocItems
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON _UnitOfMeasure.UnitOfMeasure = BaseUnit  -- association [1..1]
LEFT OUTER JOIN I_ProjectNetwork AS _ProjectNetwork ON _ProjectNetwork.ProjectNetworkInternalID = ProjectNetworkInternalID OR _ProjectNetwork.ProjectNetwork = ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivityByInternalKey AS _NetworkActivity ON _NetworkActivity.ProjectNetworkInternalID = ProjectNetworkInternalID AND _NetworkActivity.NetworkActivityInternalID = NetworkActivityInternalID  -- association [0..1]
;