I_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 I_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: IMMPURCHASEORDER

CREATE VIEW I_PurchaseOrder AS
SELECT
  cast (PurchasingDocument as vdm_purchaseorder preserving type) AS PurchaseOrder,
  cast (PurchasingDocumentType as mm_purchaseordertype preserving type ) AS PurchaseOrderType,
  PurchasingDocumentSubtype AS PurchaseOrderSubtype,
  PurchasingDocumentOrigin,
  PurchasingDocumentIsAged,
  CreatedByUser,
  CreationDate,
  cast (PurchasingDocumentOrderDate as bedat preserving type) AS PurchaseOrderDate,
  Language,
  PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  PurchasingProcessingStatus,
  PurgReleaseSequenceStatus,
  ReleaseCode,
  PurchasingReleaseStrategy,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  ManualSupplierAddressID,
  SupplierAddressID,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  Customer,
  CorrespncExternalReference,
  CorrespncInternalReference,
  PurchaseContract,
  RequestForQuotation,
  SupplierQuotationExternalID,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  DownPaymentDueDate,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IsIntrastatReportingRelevant,
  IsIntrastatReportingExcluded,
  PricingDocument AS PurchasingDocumentCondition,
  PricingProcedure,
  DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  ExchangeRate,
  ExchangeRateIsFixed,
  LastChangeDateTime,
  IsEndOfPurposeBlocked,
  TaxReturnCountry,
  VATRegistrationCountry,
  PurgReasonForDocCancellation,
  PurgReleaseTimeTotalAmount
FROM R_PurchasingDocument
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchaseOrderType ON _PurchaseOrderType.PurchasingDocumentCategory = 'F' AND _PurchaseOrderType.PurchasingDocumentType = PurchaseOrderType  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PurchaseOrderCalcFields AS _PurchaseOrderCalcFields ON PurchaseOrder = _PurchaseOrderCalcFields.PurchaseOrder  -- association [1..1]
;