P_PurOrdMaintainHeaderAll

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_PurOrdMaintainHeaderAll.
-- 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: PPOMAINTHDRALL

CREATE VIEW P_PurOrdMaintainHeaderAll AS
SELECT
  cast(CONCAT(':',REPLACE(REPLACE(active.PurchaseOrder,'~','~~'),':','~:')) as abap.char(32)) AS ID,
  active.PurchaseOrder AS PurchaseOrder,
  cast('' as abap.char(32)) AS PurchaseOrderHeaderDraftUUID,
  hextobin('00000000000000000000000000000000') AS DraftUUID,
  active.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  active.PurchasingDocumentType AS PurchasingDocumentType,
  active.CompanyCode AS CompanyCode,
  active_t001.CompanyCodeName AS CompanyCodeName,
  active.PurchasingOrganization AS PurchasingOrganization,
  active_ekorg.PurchasingOrganizationName AS PurchasingOrganizationName,
  active.PurchasingGroup AS PurchasingGroup,
  active_ekgrp.PurchasingGroupName AS PurchasingGroupName,
  active.Supplier AS Supplier,
  active_supplier.SupplierName AS SupplierName,
  active.Currency AS Currency,
  active.PaymentTerms AS PaymentTerms,
  active.CashDiscount1Days AS CashDiscount1Days,
  active.CashDiscount2Days AS CashDiscount2Days,
  active.NetPaymentDays AS NetPaymentDays,
  active.CashDiscount1Percent AS CashDiscount1Percent,
  active.CashDiscount2Percent AS CashDiscount2Percent,
  active.ExchangeRate AS ExchangeRate,
  active.IncotermsClassification AS IncotermsClassification,
  active.IncotermsTransferLocation AS IncotermsTransferLocation,
  active.IncotermsVersion AS IncotermsVersion,
  active.IncotermsLocation1 AS IncotermsLocation1,
  active.IncotermsLocation2 AS IncotermsLocation2,
  active.CreatedByUser AS CreatedByUser,
  active.PurchaseOrderDate AS PurchaseOrderDate,
  active.LastChangeDateTime AS LastChangeDateTime,
  active.LastChangeUser AS LastChangeUser,
  active.InvoicingParty AS InvoicingParty,
  active_invparty.SupplierName AS InvoicingPartyName,
  active.ReleaseIsNotCompleted AS ReleaseIsNotCompleted,
  active.IsHeld AS IsHeld,
  active_POHeaderCalFields.NumberOfItems AS NumberOfItems,
  active_POHeaderCalFields.NetValue AS PurchaseOrderNetAmount,
  active_POHeaderCalFields.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  active.EditState AS EditState,
  cast('' as abap.char(1)) AS IsDraft,
  active.HasTwin AS HasTwin,
  draft_header.PurchaseOrderHeaderDraftUUID AS TwinPurchaseOrderHdrDraftUUID,
  hextobin(draft_header.PurchaseOrderHeaderDraftUUID) AS TwinUUID,
  active.PurchasingDocumentCondition AS PurchasingDocumentCondition,
  active.PricingProcedure AS PricingProcedure,
  active.AddressID AS AddressID,
  active.AddressName AS AddressName,
  active.AddressStreetName AS AddressStreetName,
  active.AddressHouseNumber AS AddressHouseNumber,
  active.AddressPostalCode AS AddressPostalCode,
  active.AddressCityName AS AddressCityName,
  active.AddressPhoneNumber AS AddressPhoneNumber,
  active.AddressFaxNumber AS AddressFaxNumber,
  active.AddressRegion AS AddressRegion,
  active.AddressCountry AS AddressCountry,
  active.AddressCorrespondenceLanguage AS AddressCorrespondenceLanguage,
  cast('X' as abap.char(1)) AS IsActiveEntity,
  IsEndOfPurposeBlocked as IsEndOfPurposeBlocked AS char32asID,
  case draft.PurchaseOrder when '' then cast('1' as abap.char(1)) else cast('3' as abap.char(1)) end as EditState AS char1endasEditState,
  case draft.PurchaseOrder when '' then cast('' as abap.char(1)) else cast('X' as abap.char(1)) end as HasTwin AS char1endasHasTwin,
  cast(' ' as abap.char(1)) AS IsEndOfPurposeBlocked
FROM P_PurOrdMaintainHeaderActive AS active
LEFT OUTER JOIN I_Supplier AS active_supplier ON Supplier = active_supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS active_invparty ON InvoicingParty = active_invparty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS active_ekorg ON PurchasingOrganization = active_ekorg.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS active_ekgrp ON PurchasingGroup = active_ekgrp.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS active_t001 ON CompanyCode = active_t001.CompanyCode  -- association [1..1]
LEFT OUTER JOIN P_PurOrdMaintainHeaderActCalFs AS active_POHeaderCalFields ON PurchaseOrder = active_POHeaderCalFields.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN P_PurOrdMaintainHeaderDraft AS draft_header ON PurchaseOrder = draft_header.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS draft_supplier ON Supplier = draft_supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS draft_invparty ON InvoicingParty = draft_invparty.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS draft_ekorg ON PurchasingOrganization = draft_ekorg.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS draft_ekgrp ON PurchasingGroup = draft_ekgrp.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS draft_t001 ON CompanyCode = draft_t001.CompanyCode  -- association [1..1]
LEFT OUTER JOIN P_PurOrdMaintainHeaderDrfCalFs AS draft_POHeaderCalFields ON PurchaseOrderHeaderDraftUUID = draft_POHeaderCalFields.PurchaseOrderHeaderDraftUUID  -- association [1..1]
-- UNION ALL with additional select branch(es): P_PurOrdMaintainHeaderDraft
;