I_PurchaseOrderEnhanced

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 I_PurchaseOrderEnhanced.
-- 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: IMMPURORDENH

CREATE VIEW I_PurchaseOrderEnhanced AS
SELECT
  PurchaseOrder,
  PurchaseOrderType,
  PurchaseOrderSubtype,
  PurchasingDocumentIsAged,
  PurchasingDocumentOrigin,
  CreatedByUser,
  CreationDate,
  PurchaseOrderDate,
  ValidityStartDate,
  ValidityEndDate,
  Language,
  PurchaseOrderDeletionCode AS PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  ManualSupplierAddressID,
  _lfa1.name1 AS SupplierName,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  CorrespncExternalReference,
  CorrespncInternalReference,
  IsIntrastatReportingRelevant,
  IsIntrastatReportingExcluded,
  PricingDocument AS PurchasingDocumentCondition,
  PricingProcedure,
  DocumentCurrency,
  ExchangeRate,
  IsEndOfPurposeBlocked,
  VATRegistration,
  VATRegistrationCountry,
  PurgDocDefaultShippingType,
  MsgOnGoodsReceiptIsRequested,
  coalesce(_PurchaseOrderNetAmount.PurchaseOrderNetAmount, cast(0 as bwert)) AS PurchaseOrderNetAmount,
  _OvrdPurOrdItemsCount.NumberOfOverduePurOrdItm AS NumberOfOverduePurOrdItm,
  _PurOrdHasItemHierarchy.PurchasingHasItemHierarchy AS PurchasingHasItemHierarchy,
  R_PurchaseOrder._SupplierAddress AS _SupplierAddress_2
FROM R_PurchaseOrder
LEFT OUTER JOIN I_Address AS _SupplierAddress ON SupplierAddressID = _SupplierAddress.AddressID  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderNetAmount AS _PurchaseOrderNetAmount ON PurchaseOrder = _PurchaseOrderNetAmount.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderStatus AS _PurchaseOrderStatus ON PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_PurchaseorderItemEnhanced AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PurchaseorderItemEnhanced AS _PurchaseOrderLimitItem ON PurchaseOrder = _PurchaseOrderLimitItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PurchasingDocumentStatus AS _Status ON purchasingdocumentstatus = _Status.PurchasingDocumentStatus  -- association [0..1]
LEFT OUTER JOIN lfa1 AS _lfa1 ON _lfa1.lifnr = Supplier  -- association [0..1]
LEFT OUTER JOIN I_OvrdPurOrdItemsCount AS _OvrdPurOrdItemsCount ON PurchaseOrder = _OvrdPurOrdItemsCount.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _HeaderExtension ON PurchaseOrder = _HeaderExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN R_PurOrdHasItemHierarchy AS _PurOrdHasItemHierarchy ON PurchaseOrder = _PurOrdHasItemHierarchy.PurchaseOrder  -- association [0..1]
;