N_PurchaseOrder

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 N_PurchaseOrder.
-- 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: NPURCHASEORDER

CREATE VIEW N_PurchaseOrder AS
SELECT
  ekko.ebeln AS PurchaseOrder,
  ekpo.ebelp AS PurchaseOrderItem,
  ekkn.zekkn AS AccountAssignmentNumber,
  ekko.bukrs AS CompanyCode,
  ekko.ernam AS CreatedByUser,
  ekko.aedat AS CreationDate,
  ekko.waers AS DocumentCurrency,
  ekko.inco1 AS IncotermsClassification,
  ekko.inco2 AS IncotermsTransferLocation,
  ekko.inco2_l AS IncotermsLocation1,
  ekko.inco3_l AS IncotermsLocation2,
  ekko.lastchangedatetime AS LastChangeDateTime,
  cast( ekko.zterm as farp_dzterm preserving type) AS PaymentTerms,
  ekko.bedat AS PurchaseOrderDate,
  ekko.loekz AS PurchaseOrderDeletionCode,
  cast ( ekko.lifnr as md_supplier preserving type) AS Supplier,
  ekko.reswk AS SupplyingPlant,
  ekko.bsart AS PurchaseOrderType,
  ekko.ekgrp AS PurchasingGroup,
  ekko.ekorg AS PurchasingOrganization,
  ekko.konnr AS PurchaseContract,
  ekpo.ematn AS ManufacturerMaterial,
  cast (ekpo.matnr as productnumber preserving type ) AS Product,
  cast (ekpo.matkl as productgroup preserving type ) AS ProductGroup,
  ekpo.netwr AS NetAmount,
  ekpo.netpr AS NetPriceAmount,
  ekpo.meins AS OrderQuantityUnit,
  ekpo.menge AS OrderQuantity,
  ekpo.bprme AS OrderPriceUnit,
  cast (ekpo.peinh as vdm_price_unit preserving type) AS NetPriceQuantity,
  ekpo.werks AS Plant,
  ekpo.txz01 AS PurchaseOrderItemText,
  ekpo.banfn AS PurchaseRequisition,
  ekpo.loekz AS IsDeleted,
  ekkn.gsber AS BusinessArea,
  ekkn.kokrs AS ControllingArea,
  ekkn.prctr AS ProfitCenter,
  ekkn.ps_psp_pnr AS WBSElementInternalID,
  $session.system_date AS CASystemDate
FROM ekko
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON SupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchaseOrderType ON _PurchaseOrderType.PurchasingDocumentCategory = 'F' AND PurchaseOrderType = _PurchaseOrderType.PurchasingDocumentType  -- association [0..1]
LEFT OUTER JOIN I_PurchasingDocumentTypeText AS _PurchaseOrderTypeName ON _PurchaseOrderTypeName.PurchasingDocumentCategory = 'F' AND PurchaseOrderType = _PurchaseOrderTypeName.PurchasingDocumentType  -- association [0..*]
LEFT OUTER JOIN I_PurchaseOrderDeletionCode AS _PurchaseOrderDeletionCode ON PurchaseOrderDeletionCode = _PurchaseOrderDeletionCode.PurchaseOrderDeletionCode  -- association [1..1]
LEFT OUTER JOIN N_PaymentTerms AS _Paymentterms ON PaymentTerms=_Paymentterms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByInternalKey AS _WBSElementByInternalKey ON WBSElementInternalID = _WBSElementByInternalKey.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ControllingArea = _ProfitCenterText.ControllingArea AND ProfitCenter = _ProfitCenterText.ProfitCenter AND CASystemDate < _ProfitCenterText.ValidityEndDate AND CASystemDate >= _ProfitCenterText.ValidityStartDate  -- association [0..*]
;