I_RFM_MngPOItemData

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_RFM_MngPOItemData.
-- 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: IRFMMNGPOITDT

CREATE VIEW I_RFM_MngPOItemData AS
SELECT
  Item.PurchaseOrder AS PurchaseOrder,
  Item.PurchaseOrderItem AS PurchaseOrderItem,
  cast(concat(concat(Item.PurchaseOrder, '/'), Item.PurchaseOrderItem) as vdm_formattedpurchaseorditm preserving type) AS FormattedPurchaseOrderItem,
  Item.Material AS Material,
  Item.MaterialGroup AS MaterialGroup,
  Item.Plant AS Plant,
  Item.StorageLocation AS StorageLocation,
  Item.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  Item.MaterialType AS MaterialType,
  Item.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Item.PurchasingParentItem AS PurchasingParentItem,
  Item.PurchaseContractItem AS PurchaseContractItem,
  Item.PurchaseContract AS PurchaseContract,
  Item.PurchaseRequisition AS PurchaseRequisition,
  Item.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  Item.OrderQuantity AS OrderQuantity,
  Item.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  Item.StockSegment AS StockSegment,
  Item.PurchaseOrderItemText AS PurchaseOrderItemText,
  Item.ManufacturerMaterial AS ManufacturerMaterial,
  Item.DocumentCurrency AS DocumentCurrency,
  Item.NetAmount AS NetAmount,
  Item.SupplierMaterialNumber AS SupplierMaterialNumber,
  Item.TaxCode AS TaxCode,
  Item.IncotermsClassification AS IncotermsClassification,
  Item.IncotermsTransferLocation AS IncotermsTransferLocation,
  Item.IncotermsLocation1 AS IncotermsLocation1,
  Item.IncotermsLocation2 AS IncotermsLocation2,
  cast (0 as abap.quan(15,3)) AS AssignedQuantityInBaseUnit,
  Item.BaseUnit AS BaseUnit,
  cast ( 0 as abap.quan(13,3)) AS GoodsReceiptQuantity,
  cast ( 0 as abap.quan(13,3)) AS StillToBeDeliveredQuantity,
  case when _MngPOItmTrcblyAggrgn.PurchaseOrder is not null or _MngPOItmTrcblyAggrgn.PurchaseOrder <> ' ' then cast('X' as rfm_consolidated_po_item ) else cast( '' as rfm_consolidated_po_item ) end AS ConsolidatedPOItem,
  Item.ProductSeasonYear AS ProductSeasonYear,
  Item.ProductSeason AS ProductSeason,
  Item.ProductCollection AS ProductCollection,
  Item.ProductTheme AS ProductTheme,
  Item.DiversionStatus AS DiversionStatus,
  Item.ProductCharacteristic1 AS ProductCharacteristic1,
  Item.ProductCharacteristic2 AS ProductCharacteristic2,
  Item.ProductCharacteristic3 AS ProductCharacteristic3,
  Item.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  Item.IsCompletelyDelivered AS IsCompletelyDelivered,
  Item._Plant AS _Plant,
  Item._StorageLocation AS _StorageLocation,
  Item._MaterialGroup AS _MaterialGroup,
  Item._Material AS _Material,
  Item._OrderQuantityUnit AS _OrderQuantityUnit,
  Item._DocumentCurrency AS _DocumentCurrency,
  Item._ConfigurableProduct AS _ConfigurableProduct,
  Item._PurchaseRequisition AS _PurchaseRequisition,
  Item._PurchaseContract AS _PurchaseContract,
  Item._PurchaseContractItem AS _PurchaseContractItem,
  Item._PurchaseRequisitionItem AS _PurchaseRequisitionItem,
  Item._ManufacturerMaterial AS _ManufacturerMaterial,
  Item._IncotermsClassification AS _IncotermsClassification,
  Item._PurgDocumentItemCategory AS _PurgDocumentItemCategory
FROM R_PurchaseOrderItem AS Item
;