A_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 A_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: APURCHASEORDER

CREATE VIEW A_PurchaseOrder AS
SELECT
  PurchaseOrder,
  CompanyCode,
  PurchaseOrderType,
  PurchaseOrderDeletionCode AS PurchasingDocumentDeletionCode,
  PurchasingProcessingStatus,
  CreatedByUser,
  CreationDate,
  LastChangeDateTime,
  Supplier,
  PurchaseOrderSubtype,
  Language,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchasingOrganization,
  PurchasingDocumentOrigin,
  PurchasingGroup,
  PurchaseOrderDate,
  DocumentCurrency,
  cast(ExchangeRate as abap.char(12)) AS ExchangeRate,
  ExchangeRateIsFixed,
  ValidityStartDate,
  ValidityEndDate,
  SupplierQuotationExternalID,
  PurchasingCollectiveNumber,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  SupplyingPlant,
  IncotermsClassification,
  CorrespncExternalReference,
  CorrespncInternalReference,
  InvoicingParty,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  ManualSupplierAddressID,
  IsEndOfPurposeBlocked,
  _SupplierAddress._Address_2.CityName AS AddressCityName,
  _SupplierAddress._Address_2._CurrentDfltFaxNumber.InternationalFaxNumber AS AddressFaxNumber,
  _SupplierAddress._Address_2.HouseNumber AS AddressHouseNumber,
  _SupplierAddress._Address_2.OrganizationName1 AS AddressName,
  _SupplierAddress._Address_2.PostalCode AS AddressPostalCode,
  _SupplierAddress._Address_2.StreetName AS AddressStreetName,
  _SupplierAddress._Address_2._CurrentDfltLandlinePhoneNmbr.InternationalPhoneNumber AS AddressPhoneNumber,
  _SupplierAddress._Address_2.Region AS AddressRegion,
  _SupplierAddress._Address_2.Country AS AddressCountry,
  _SupplierAddress._Address_2.CorrespondenceLanguage AS AddressCorrespondenceLanguage,
  PurgAggrgdProdCmplncSuplrSts,
  PurgAggrgdProdMarketabilitySts,
  PurgAggrgdSftyDataSheetStatus,
  PurgProdCmplncTotDngrsGoodsSts
FROM R_PurchaseOrder AS Root
LEFT OUTER JOIN I_PurchaseOrderSupplierAddress AS _SupplierAddress ON PurchaseOrder = _SupplierAddress.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurchaseOrderExtension ON PurchaseOrder = _PurchaseOrderExtension.PurchasingDocument  -- association [1..1]
LEFT OUTER JOIN A_PurchaseOrderItem AS _PurchaseOrderItem ON /* condition not available in parsed metadata */  -- association [1..*]
LEFT OUTER JOIN A_PurchaseOrderNote AS _PurchaseOrderNote ON /* condition not available in parsed metadata */  -- association [0..*]
;