P_DDOrderDetails

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_DDOrderDetails.
-- 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: PDDORDDETS

CREATE VIEW P_DDOrderDetails AS
SELECT
  _eban.Material AS Material,
  _eban.Plant AS Plant,
  cast(PurchaseRequisition as abap.char(12)) AS OrderID,
  lpad(PurchaseRequisitionItem, 6, '0') AS OrderItem,
  cast('0000' as delet) AS OrderScheduleLine,
  'BA' AS MRPElementCategory,
  PurchasingDocumentItemCategory AS ItemCategory,
  _eban.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  MaterialGoodsReceiptDuration,
  cast('0000-00-00' as abap.dats) AS OpeningDate,
  PurchaseRequisitionReleaseDate AS ReleaseDate,
  DeliveryDate,
  RequestedQuantity AS TotalQuantity,
  cast(0 as mng01) AS DeliveredQuantity,
  BaseUnit,
  _eban.PurchasingOrganization AS PurchasingOrganization,
  _eban.PurchasingGroup AS PurchasingGroup,
  _eban._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  _eban._PurchasingGroup.EmailAddress AS PurchasingGroupEmailID,
  _marc.MRPController AS MRPController,
  _eban.FixedSupplier AS Supplier,
  _eban._Supplier.BPSupplierFullName AS SupplierName,
  _eban._Supplier.PhoneNumber1 AS SupplierPhoneNumber,
  _eban.Subcontractor AS Subcontractor,
  StorageLocation,
  cast( '' as verid) AS ProductionVersion,
  SupplyingPlant,
  PurchasingInfoRecord,
  PurchaseContract AS PurchaseOutlineAgreement,
  PurchaseContractItem AS PurchaseOutlineAgreementItem,
  _eban.IsEndOfPurposeBlocked AS MaterialasMaterial,
  case when _PurchasingDocument.PurchasingDocumentType = 'LP' or _PurchasingDocument.PurchasingDocumentType = 'LPA' then _eket.ScheduleLineOrderQuantity else _ekpo.OrderQuantity end as TotalQuantity AS OrderQuantityendasTotalQuantity,
  '' AS PurchasingGroupPhoneNumber,
  '' AS IsEndOfPurposeBlocked
FROM I_Purchaserequisitionitem AS _eban
INNER JOIN I_MaterialPlant AS _marc ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_DemandDrivenPurDocHeader AS _Header ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurgDocScheduleLine AS _eket ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_PurchasingDocumentItem, I_PlannedOrder, I_OrderItem
;