I_RFM_PrvsnlSlsContrVarItems

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_PrvsnlSlsContrVarItems.
-- 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: IRFMPRVSNLVRITMS

CREATE VIEW I_RFM_PrvsnlSlsContrVarItems AS
SELECT
  gnrc.SalesContract AS SalesContract,
  gnrc.SalesContractItem AS SalesContractItem,
  Mara.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  case when Variant.OrderQuantity > 0 then 'E' else 'O' end AS RFMVariantExstc,
  Variant.OrderQuantity AS OrderQuantity,
  cast (0 as abap.quan(15,3)) AS ProposedQuantity,
  Variant.OrderQuantityUnit AS OrderQuantityUnit,
  Variant.SalesDocumentItem AS SalesDocumentItem,
  Mara.ProductCharacteristic1 AS ProductCharacteristic1,
  Mara.ProductCharacteristic2 AS ProductCharacteristic2,
  Mara.ProductCharacteristic3 AS ProductCharacteristic3,
  _CharValTexts1.RetailCharacteristicValueDesc AS ProductCharacteristic1Desc,
  _CharValTexts2.RetailCharacteristicValueDesc AS ProductCharacteristic2Desc,
  _CharValTexts3.RetailCharacteristicValueDesc AS ProductCharacteristic3Desc,
  Variant.SalesDocumentType AS SalesDocumentType,
  Variant.OrganizationDivision AS OrganizationDivision,
  Variant.SalesOrganization AS SalesOrganization,
  Variant.DistributionChannel AS DistributionChannel,
  cast(Mara.ProdCharc1InternalNumber as atinn_no_conv preserving type ) AS ProdCharc1InternalNumber,
  cast(Mara.ProdCharc2InternalNumber as atinn_no_conv preserving type ) AS ProdCharc2InternalNumber,
  cast(Mara.ProdCharc3InternalNumber as atinn_no_conv preserving type ) AS ProdCharc3InternalNumber,
  Variant._OrderQuantityUnit AS _OrderQuantityUnit
FROM I_RFM_PrvsnlSlsContrGnrcItm AS gnrc
INNER JOIN I_Material AS Mara ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts1 ON ProductCharacteristic1 = _CharValTexts1.RetailCharacteristicValue AND ProdCharc1InternalNumber = _CharValTexts1.CharacteristicInternalID AND _CharValTexts1.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts2 ON ProductCharacteristic2 = _CharValTexts2.RetailCharacteristicValue AND ProdCharc2InternalNumber = _CharValTexts2.CharacteristicInternalID AND _CharValTexts2.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_RetailCharacteristicValueT AS _CharValTexts3 ON ProductCharacteristic3 = _CharValTexts3.RetailCharacteristicValue AND ProdCharc3InternalNumber = _CharValTexts3.CharacteristicInternalID AND _CharValTexts3.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Mara.Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [1..1]
;