P_PURCHASEORDERWITHSTOFILTER

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 P_PURCHASEORDERWITHSTOFILTER.
-- 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: PPURCHORDNOSTO

CREATE VIEW P_PURCHASEORDERWITHSTOFILTER AS
SELECT
  cast (PurchaseOrder.PurchasingDocument as vdm_purchaseorder preserving type) AS PurchaseOrder,
  PurchaseOrderItem,
  cast (PurchasingDocumentType as mm_purchaseordertype preserving type ) AS PurchaseOrderType,
  PurchasingDocumentSubtype AS PurchaseOrderSubtype,
  PurchasingDocumentOrigin,
  PurchasingDocumentIsAged,
  CreatedByUser,
  PurchaseOrder.CreationDate AS CreationDate,
  cast (PurchasingDocumentOrderDate as bedat preserving type) AS PurchaseOrderDate,
  Language,
  PurchaseOrder.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  ReleaseIsNotCompleted,
  PurchasingCompletenessStatus,
  PurchasingProcessingStatus,
  PurgReleaseSequenceStatus,
  ReleaseCode,
  PurchasingReleaseStrategy,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  Supplier,
  ManualSupplierAddressID,
  SupplierAddressID,
  SupplierRespSalesPersonName,
  SupplierPhoneNumber,
  SupplyingSupplier,
  SupplyingPlant,
  InvoicingParty,
  PurchaseOrder.Customer AS Customer,
  CorrespncExternalReference,
  CorrespncInternalReference,
  PurchaseOrder.PurchaseContract AS PurchaseContract,
  PurchaseOrder.RequestForQuotation AS RequestForQuotation,
  SupplierQuotationExternalID,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  PurchaseOrder.DownPaymentType AS DownPaymentType,
  PurchaseOrder.DownPaymentPercentageOfTotAmt AS DownPaymentPercentageOfTotAmt,
  PurchaseOrder.DownPaymentAmount AS DownPaymentAmount,
  PurchaseOrder.DownPaymentDueDate AS DownPaymentDueDate,
  PurchaseOrder.IncotermsClassification AS IncotermsClassification,
  PurchaseOrder.IncotermsTransferLocation AS IncotermsTransferLocation,
  IncotermsVersion,
  PurchaseOrder.IncotermsLocation1 AS IncotermsLocation1,
  PurchaseOrder.IncotermsLocation2 AS IncotermsLocation2,
  IsIntrastatReportingRelevant,
  IsIntrastatReportingExcluded,
  PurchasingDocumentCondition,
  PricingProcedure,
  PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  ValidityStartDate,
  ValidityEndDate,
  ExchangeRate,
  ExchangeRateIsFixed,
  LastChangeDateTime,
  IsEndOfPurposeBlocked,
  TaxReturnCountry,
  VATRegistrationCountry,
  PurgReasonForDocCancellation,
  PurgReleaseTimeTotalAmount,
  IsStatisticalItem,
  AccountAssignmentCategory,
  PurchaseOrderQuantityUnit,
  NetPriceAmount,
  NetAmount,
  NetPriceQuantity,
  MaterialGroup,
  Material,
  Plant,
  PurchaseOrderItemCategory,
  PurchaseOrderCategory,
  PurchaseContractItem,
  ProductType,
  ServicePerformer,
  MultipleAcctAssgmtDistribution,
  OrderQuantity,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  IsCompletelyDelivered,
  IsReturnsItem
FROM I_PurchasingDocument AS PurchaseOrder
INNER JOIN I_PurchaseOrderItem AS PurchaseOrderItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingDocumentType AS _PurchaseOrderType ON _PurchaseOrderType.PurchasingDocumentCategory = 'F' AND _PurchaseOrderType.PurchasingDocumentType = PurchaseOrderType  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderCalcFields AS _PurchaseOrderCalcFields ON PurchaseOrder = _PurchaseOrderCalcFields.PurchaseOrder  -- association [1..1]
;