P_PurOrdMaintainHeaderActive

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_PurOrdMaintainHeaderActive.
-- 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: PPOMAINTHDRACT

CREATE VIEW P_PurOrdMaintainHeaderActive 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,
  ekko.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  _HeaderActAddr.AddressID AS AddressID,
  _HeaderActAddr.PurchaseOrderAddressNumber AS PurchaseOrderAddressNumber,
  _HeaderActAddr.AddressName AS AddressName,
  _HeaderActAddr.AddressStreetName AS AddressStreetName,
  _HeaderActAddr.AddressHouseNumber AS AddressHouseNumber,
  _HeaderActAddr.AddressPostalCode AS AddressPostalCode,
  _HeaderActAddr.AddressCityName AS AddressCityName,
  _HeaderActAddr.AddressPhoneNumber AS AddressPhoneNumber,
  _HeaderActAddr.AddressFaxNumber AS AddressFaxNumber,
  _HeaderActAddr.AddressRegion AS AddressRegion,
  _HeaderActAddr.AddressCountry AS AddressCountry,
  _HeaderActAddr.AddressCorrespondenceLanguage AS AddressCorrespondenceLanguage,
  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]
LEFT OUTER JOIN P_PurOrdMaintainHeaderActAddr AS _HeaderActAddr ON ekko.PurchaseOrder = _HeaderActAddr.PurchaseOrder  -- association [0..1]
;