P_PurOrdItemCastedAmounts

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_PurOrdItemCastedAmounts.
-- 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: PPOITEMCASTDAMT

CREATE VIEW P_PurOrdItemCastedAmounts AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  _PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  _PurchaseOrder.Supplier AS Supplier,
  _PurchaseOrder.SupplyingPlant AS SupplyingPlant,
  _PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  _PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrder.CompanyCode AS CompanyCode,
  _PurchaseOrder.DocumentCurrency AS DocumentCurrency,
  _PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  _PurchaseOrder.CreationDate AS CreationDate,
  _PurchaseOrder.CreatedByUser AS CreatedByUser,
  PurchaseOrderItemText,
  Material,
  MaterialGroup,
  Plant,
  ProductType,
  PurchaseOrderItemCategory,
  AccountAssignmentCategory,
  ServicePerformer,
  IsReturnsItem,
  SupplierQuotation,
  SupplierQuotationItem,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  IsCompletelyDelivered,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  IsFinallyInvoiced,
  StorageLocation,
  PurchasingInfoRecord,
  IsInfoRecordUpdated,
  PurchaseContract,
  PurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  RequestForQuotation,
  RequestForQuotationItem,
  RequirementTracking,
  cast (ExpectedOverallLimitAmount as abap.curr(21, 5)) AS ExpectedOverallLimitAmount,
  cast (OverallLimitAmount as abap.curr(21, 5)) AS OverallLimitAmount,
  cast (NetPriceAmount as abap.curr(21, 5)) AS NetPriceAmount,
  cast (NetAmount as abap.curr(21, 5)) AS NetAmount,
  OrderQuantity,
  NetPriceQuantity,
  PurchaseOrderQuantityUnit,
  OrderPriceUnit,
  NonDeductibleInputTaxAmount
FROM I_PurgAnalyticsConfiguration AS MigrationStatus
INNER JOIN I_PurchaseOrderItem ON /* join condition not captured in parsed metadata */
;