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
  PurchasingDocument 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,
  cast( ActivePurchasingDocument as pps_e_active_po_doc preserving type ) AS ActivePurchasingDocument,
  PurgDocChangeRequestStatus,
  PurchasingDocumentVersion,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  ManualSupplierAddressID,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  Customer,
  PurchaseContract,
  RequestForQuotation,
  QuotationSubmissionDate,
  PurchasingCollectiveNumber,
  ItemNumberIntervalForSubItems,
  SupplierQuotationExternalID,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  DownPaymentType,
  DownPaymentPercentageOfTotAmt,
  DownPaymentAmount,
  DownPaymentDueDate,
  RetentionType,
  PurgDocHdrInvcRtntnPct,
  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,
  PurchasingDocumentCategory,
  PurchasingDocumentName,
  cast( 'PurchaseOrder' as sbo_node_type ) AS PPSExtPubgSystApplObjectType
FROM I_PPS_PurchasingDocument
LEFT OUTER JOIN R_PPS_PurchaseOrderItem AS _PurchaseOrderItem ON PurchaseOrder = _PurchaseOrderItem.PurchaseOrder  -- association [0..*]
LEFT OUTER JOIN I_PurchaseOrderDeletionCode AS _PurchaseOrderDeletionCode ON PurchaseOrderDeletionCode = _PurchaseOrderDeletionCode.PurchaseOrderDeletionCode  -- association [1..1]
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierCurrency ON _SupplierCurrency.Supplier = Supplier AND _SupplierCurrency.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
;