P_PurOrdMaintainHeaderDraft

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_PurOrdMaintainHeaderDraft.
-- 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: PPOMAINTHDRDRAFT

CREATE VIEW P_PurOrdMaintainHeaderDraft AS
SELECT
  guid AS PurchaseOrderHeaderDraftUUID,
  ekkod.ebeln AS PurchaseOrder,
  cast('F' as abap.char(1)) AS PurchasingDocumentCategory,
  ekkod.bsart AS PurchasingDocumentType,
  ekkod.bukrs AS CompanyCode,
  ekkod.ekorg AS PurchasingOrganization,
  ekkod.ekgrp AS PurchasingGroup,
  ekkod.lifnr AS Supplier,
  ekkod.waers AS Currency,
  ekkod.zterm AS PaymentTerms,
  ekkod.zbd1t AS CashDiscount1Days,
  ekkod.zbd2t AS CashDiscount2Days,
  ekkod.zbd3t AS NetPaymentDays,
  ekkod.zbd1p AS CashDiscount1Percent,
  ekkod.zbd2p AS CashDiscount2Percent,
  cast(ekkod.wkurs as abap.dec(19,5)) AS ExchangeRate,
  ekkod.inco1 AS IncotermsClassification,
  ekkod.inco2 AS IncotermsTransferLocation,
  ekkod.incov AS IncotermsVersion,
  ekkod.inco2_l AS IncotermsLocation1,
  ekkod.inco3_l AS IncotermsLocation2,
  ekkod.crea_uname AS CreatedByUser,
  ekkod.bedat AS PurchaseOrderDate,
  ekkod.lchg_date_time AS LastChangeDateTime,
  ekkod.lchg_uname AS LastChangeUser,
  ekkod.lifre AS InvoicingParty,
  cast('' as abap.char(1)) AS ReleaseIsNotCompleted,
  ekkod.memory AS IsHeld,
  ekkod.knumv AS PurchasingDocumentCondition,
  ekkod.kalsm AS PricingProcedure,
  ekkod.adrnr AS AddressID,
  ekkod.ad_name1 AS AddressName,
  ekkod.ad_street AS AddressStreetName,
  ekkod.ad_hsnm1 AS AddressHouseNumber,
  ekkod.ad_pstcd1 AS AddressPostalCode,
  ekkod.ad_city1 AS AddressCityName,
  ekkod.ad_tlnmbr1 AS AddressPhoneNumber,
  ekkod.ad_fxnmbr1 AS AddressFaxNumber,
  ekkod.regio AS AddressRegion,
  ekkod.land1 AS AddressCountry,
  ekkod.langu AS AddressCorrespondenceLanguage
FROM ekko_po_d AS ekkod
LEFT OUTER JOIN P_PurOrdMaintDraftAdminData AS _DraftAdministrativeData ON ekkod.db_key = _DraftAdministrativeData.DraftID AND _DraftAdministrativeData.EntityName = 'MM_PO_DRAFT'  -- association [0..1]
;