I_BG_SAFTProduct

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_BG_SAFTProduct.
-- 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.
-- Parameters: P_FromPostingDate : figen_rep_date_from, P_ToPostingDate : figen_rep_date_to

CREATE VIEW I_BG_SAFTProduct AS
SELECT
  MaterialPlant.Material AS Product,
  MaterialPlant.Plant AS Plant,
  Product.ProductType AS MaterialType,
  GoodsService.BG_SAFTGoodsService AS BG_SAFTGoodsService,
  Product.ProductGroup AS ProductGroup,
  CommCode.CommodityCodeText AS CommodityCodeText,
  CommCode.BG_SAFTComCodeValidFromDate AS BG_SAFTComCodeValidFromDate,
  CommCode.BG_SAFTComCodeValidToDate AS BG_SAFTComCodeValidToDate,
  coalesce(description.ProductName, coalesce(descriptionE.ProductName, 'N.A.')) AS ProductName,
  Product.ProductStandardID AS ProductStandardID,
  Product.BaseUnit AS BaseUnit,
  ProductUom.AlternativeUnit AS AlternativeUnit,
  case when ( Product.BaseUnit = ProductUom.AlternativeUnit ) then 1 when ( ProductUom.QuantityNumerator <> 0 and ProductUom.QuantityDenominator <> 0 ) then division( cast(ProductUom.QuantityNumerator as abap.dec(23,5)), cast(ProductUom.QuantityDenominator as abap.dec(23,5)), 5 ) else 0 end as ConversionFactor AS dec2355else0endasConversionFactor,
  Product.AuthorizationGroup AS AuthorizationGroup,
  Product._ProductType AS _ProductType,
  Product._ProductGroup_2 AS _ProductGroup_2
INNER JOIN I_MaterialPlant AS MaterialPlant ON /* join condition not captured in parsed metadata */
;