P_PurOrdMaintainHeadersList

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_PurOrdMaintainHeadersList.
-- 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: PPOMAINHEADLIST

CREATE VIEW P_PurOrdMaintainHeadersList AS
SELECT
  ekko.PurchaseOrder AS PurchaseOrder,
  'F' AS PurchasingDocumentCategory,
  ekko.PurchaseOrderType AS PurchasingDocumentType,
  ekko.CompanyCode AS CompanyCode,
  ekko.PurchasingOrganization AS PurchasingOrganization,
  ekko.PurchasingGroup AS PurchasingGroup,
  ekko.Supplier AS Supplier,
  ekko.DocumentCurrency AS Currency,
  ekko.PaymentTerms AS PaymentTerms,
  ekko.CashDiscount1Days AS CashDiscount1Days,
  ekko.CashDiscount2Days AS CashDiscount2Days,
  ekko.NetPaymentDays AS NetPaymentDays,
  ekko.CashDiscount1Percent AS CashDiscount1Percent,
  ekko.CashDiscount2Percent AS CashDiscount2Percent,
  cast(ekko.ExchangeRate as abap.dec(19,5)) AS ExchangeRate,
  ekko.IncotermsClassification AS IncotermsClassification,
  ekko.IncotermsTransferLocation AS IncotermsTransferLocation,
  ekko.IncotermsVersion AS IncotermsVersion,
  ekko.IncotermsLocation1 AS IncotermsLocation1,
  ekko.IncotermsLocation2 AS IncotermsLocation2,
  ekko.CreatedByUser AS CreatedByUser,
  ekko.PurchaseOrderDate AS PurchaseOrderDate,
  cast('19000101120000' as abap.dec(21,7)) AS LastChangeDateTime,
  cast('' as abap.char(12)) AS LastChangeUser,
  ekko.InvoicingParty AS InvoicingParty,
  ekko.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  ekko.PurchasingCompletenessStatus AS IsHeld,
  ekko.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  ekko.PricingProcedure AS PricingProcedure,
  ekko.ValidityEndDate AS ValidityEndDate,
  case when _HeaderDraft.PurchaseOrder is null then cast('0' as abap.char(1)) else cast('2' as abap.char(1)) end as EditState AS char1endasEditState,
  case when _HeaderDraft.PurchaseOrder is null then cast('' as abap.char(1)) else cast('X' as abap.char(1)) end as HasTwin AS char1endasHasTwin
FROM I_PurchaseOrder AS ekko
LEFT OUTER JOIN P_PurOrdMaintainHeaderDraft AS _HeaderDraft ON ekko.PurchaseOrder = _HeaderDraft.PurchaseOrder AND _HeaderDraft.CreatedByUser != ''  -- association [0..1]
;