R_PPS_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 R_PPS_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: PPSPURCHASEORDER

CREATE VIEW R_PPS_PurchaseOrder AS
SELECT
  cast (PurchasingDocument as vdm_purchaseorder preserving type) AS PurchaseOrder,
  PurchasingDocumentType AS PurchaseOrderType,
  PurchasingDocumentSubtype AS PurchaseOrderSubtype,
  PurchasingDocumentProcessCode,
  PurchasingDocumentOrigin,
  PurchasingDocumentIsAged,
  CreatedByUser,
  CreationDate,
  cast (PurchasingDocumentOrderDate as bedat preserving type) AS PurchaseOrderDate,
  Language,
  cast (PurchasingDocumentDeletionCode as mmpur_po_del_code preserving type) AS PurchaseOrderDeletionCode,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  PurchasingProcessingStatus,
  PurgReleaseSequenceStatus,
  ReleaseCode,
  PurchasingReleaseStrategy,
  ActivePurchasingDocument,
  PurgDocChangeRequestStatus,
  PurchasingDocumentVersion,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  ManualSupplierAddressID,
  SupplierAddressID,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  Customer,
  PurchaseContract,
  RequestForQuotation,
  QuotationSubmissionDate,
  PurchasingCollectiveNumber,
  ItemNumberIntervalForSubItems,
  SupplierQuotationExternalID,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  DownPaymentDueDate,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsVersion,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsSupChnLoc1AddlUUID,
  IncotermsSupChnLoc2AddlUUID,
  IncotermsSupChnDvtgLocAddlUUID,
  IsIntrastatReportingRelevant,
  IsIntrastatReportingExcluded,
  CorrespncExternalReference,
  CorrespncInternalReference,
  PricingDocument,
  PricingProcedure,
  DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  ExchangeRate,
  ExchangeRateIsFixed,
  LastChangeDateTime,
  IsEndOfPurposeBlocked,
  TaxReturnCountry,
  VATRegistrationCountry,
  PurgReasonForDocCancellation,
  PurgReleaseTimeTotalAmount,
  PurgAggrgdProdCmplncSuplrSts,
  PurgAggrgdProdMarketabilitySts,
  PurgAggrgdSftyDataSheetStatus,
  PurgProdCmplncTotDngrsGoodsSts,
  PurgDocDefaultShippingType,
  cast( '' as abap.char( 510 ) ) AS PPSFieldChangeIndicatorString
FROM R_PurchasingDocument
LEFT OUTER JOIN I_PurchaseOrderType AS _PurchaseOrderType ON _PurchaseOrderType.PurchaseOrderType = PurchaseOrderType  -- association [0..1]
LEFT OUTER JOIN R_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN R_PurchaseOrderSupplierAddress AS _SupplierAddress ON PurchaseOrder = _SupplierAddress.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PurchaseOrderCalcFields AS _PurchaseOrderCalcFields ON PurchaseOrder = _PurchaseOrderCalcFields.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_PurchaseOrderDeletionCode AS _PurchaseOrderDeletionCode ON PurchaseOrderDeletionCode = _PurchaseOrderDeletionCode.PurchaseOrderDeletionCode  -- association [1..1]
;