P_PurReqnItm

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 P_PurReqnItm.
-- 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: PPURGDOCITEMSPR

CREATE VIEW P_PurReqnItm AS
SELECT
  ebkn.PurchaseRequisition AS PurchaseRequisition,
  ebkn.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  ebkn.PurchaseReqnAcctAssgmtNumber AS PurchaseReqnAcctAssgmtNumber,
  eban.PurchaseReqnItemUniqueID AS PurchaseReqnItemUniqueID,
  eban.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  concat(concat(ebkn.PurchaseRequisition, '/'), ebkn.PurchaseRequisitionItem) AS FormattedPurRequisitionItem,
  eban.PurchaseRequisitionType AS PurchaseRequisitionType,
  eban.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  eban.MaterialGroup AS MaterialGroup,
  eban.Material AS Material,
  eban.Batch AS Batch,
  eban.PurchasingOrganization AS PurchasingOrganization,
  eban.PurchasingGroup AS PurchasingGroup,
  eban.CompanyCode AS CompanyCode,
  eban.Plant AS Plant,
  eban.StorageLocation AS StorageLocation,
  eban.AccountAssignmentCategory AS AccountAssignmentCategory,
  cast( case eban.PurReqnPriceQuantity when 0 then eban.PurchaseRequisitionPrice * eban.RequestedQuantity else division(eban.PurchaseRequisitionPrice * eban.RequestedQuantity, eban.PurReqnPriceQuantity, 2) end as abap.curr( 25, 2 )) as PurReqnItemTotalAmount AS curr252asPurReqnItemTotalAmount,
  case when PurchaseReqnAcctAssgmtNumber = '00' then cast(0 as abap.quan(13,3)) else ebkn.Quantity end as Quantity AS QuantityendasQuantity,
  eban.RequestedQuantity AS RequestedQuantity,
  eban.OrderedQuantity AS OrderedQuantity,
  cast (eban.RequestedQuantity - eban.OrderedQuantity as obmng) AS OpenQuantity,
  eban.FixedSupplier AS Supplier,
  eban.Supplier AS ExtDesiredSupplierForPurg,
  eban.RequirementTracking AS RequirementTracking,
  eban.RequisitionerName AS RequisitionerName,
  eban.DeliveryDate AS DeliveryDate,
  eban.CreatedByUser AS CreatedByUser,
  eban.PurchaseRequisitionReleaseDate AS PurchaseRequisitionReleaseDate,
  eban.PurReqCreationDate AS PurReqCreationDate,
  eban.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  eban.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  eban.BaseUnit AS BaseUnit,
  eban.PurReqnItemCurrency AS PurReqnItemCurrency,
  eban.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  eban.ProcessingStatus AS Status,
  cast('0' as numc1) AS ObjectType,
  eban.ServicePerformer AS ServicePerformer,
  ebkn.CostCenter AS CostCenter,
  ebkn.SalesOrder AS SalesOrder,
  eban._Supplier AS _Supplier,
  eban._AccAssgnmtCategory AS _AccAssgnmtCategory,
  eban._Plant AS _Plant,
  eban._PurchasingDocumentType AS _PurchasingDocumentType,
  eban._MaterialGroup AS _MaterialGroup,
  eban._Material AS _Material,
  eban._PurchasingOrganization AS _PurchasingOrganization,
  eban._PurchasingGroup AS _PurchasingGroup,
  eban._StorageLocation AS _StorageLocation,
  eban.SupplyingPlant AS SupplyingPlant,
  eban.PurchasingDocument AS PurchaseOrder,
  eban._SupplyingPlant AS _SupplyingPlant,
  ebkn.WBSElementExternalID AS WBSElementExternalID,
  WBSElementObject,
  cast(0 as abap.dec(3)) AS MultipleAcctAssgmtDistrPercent,
  cast(0 as mm_a_target_amount) AS PurgDocNetAmount,
  cast(0 as abap.quan(13,3)) AS Quantity,
  '' AS WorkItem
FROM P_PurReqnItmAccountAssignment AS ebkn
LEFT OUTER JOIN I_Purchaserequisitionitem AS eban ON ebkn.PurchaseRequisition = eban.PurchaseRequisition AND ebkn.PurchaseRequisitionItem = eban.PurchaseRequisitionItem  -- association [1..1]
-- UNION ALL with additional select branch(es): I_Purchaserequisitionitem
;