I_UtilitiesProduct

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_UtilitiesProduct.
-- 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: IUILPRODUCT

CREATE VIEW I_UtilitiesProduct AS
SELECT
  Product AS UtilitiesProduct,
  _Product.Division AS Division,
  _DivisionText[Language = $session.system_language ].DivisionName AS DivisionName,
  _RateCategory.UtilitiesRateCategory AS UtilitiesRateCategory,
  _CreationMethod.UtilsProdCreationMethod AS UtilsProdCreationMethod,
  cast(_ReferenceProductValue.CharcValue as productnumber) AS UtilitiesReferenceProduct,
  I_Product.ProductType AS ProductType,
  I_Product.ProductGroup AS ProductGroup,
  I_Product.AuthorizationGroup AS ProductAuthorizationGroup,
  I_Product.IndustrySector AS IndustrySector,
  _ValidFrom.UtilsProdValidFromDate AS ValidityStartDate,
  _ValidTo.UtilsProdValidToDate AS ValidityEndDate,
  _RateCategory.UtilitiesBillingClass AS UtilitiesBillingClass,
  _RateCategory._BillingClassText.UtilitiesBillingClassName AS UtilitiesBillingClassName,
  _Text[Language = $session.system_language ].ProductName AS ProductDescription,
  _RateCategory._BillingClassText AS _BillingClassText,
  _Product._Division AS _Division,
  I_Product._ProductType AS _ProductType,
  I_Product._ProductGroup AS _ProductGroup
INNER JOIN I_UtilsCommonFields AS _Comm ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Product AS _Product ON _Product.Product = UtilitiesProduct  -- association [1..1]
LEFT OUTER JOIN I_UtilsProdRateCat AS _RateCategory ON UtilitiesProduct = _RateCategory.UtilitiesProduct  -- association [1..1]
LEFT OUTER JOIN I_UtilsReferenceProduct AS _ReferenceProductValue ON UtilitiesProduct = _ReferenceProductValue.UtilitiesProduct  -- association [1..*]
LEFT OUTER JOIN I_UtilsProdValidToCharName AS _ValidTo ON UtilitiesProduct = _ValidTo.UtilitiesProduct  -- association [1..1]
LEFT OUTER JOIN I_UtilsProdValidFromCharName AS _ValidFrom ON UtilitiesProduct = _ValidFrom.UtilitiesProduct  -- association [1..1]
LEFT OUTER JOIN I_UtilsProdCrtnMethCharcName AS _CreationMethod ON UtilitiesProduct = _CreationMethod.UtilitiesProduct  -- association [1..1]
LEFT OUTER JOIN I_UtilsProdCharValue AS _Characteristics ON UtilitiesProduct = _Characteristics.ClfnObjectID  -- association [0..*]
LEFT OUTER JOIN I_UtilsProdChgOneTime AS _OneTimeCharge ON UtilitiesProduct = _OneTimeCharge.UtilitiesProduct  -- association [0..*]
LEFT OUTER JOIN I_UtilsProdChgRecurring AS _RecurringCharge ON UtilitiesProduct = _RecurringCharge.UtilitiesProduct  -- association [0..*]
LEFT OUTER JOIN I_UtilsProdChgUsage AS _UsageCharge ON UtilitiesProduct = _UsageCharge.UtilitiesProduct  -- association [0..*]
LEFT OUTER JOIN I_UtilsProdDiscount AS _Discount ON UtilitiesProduct = _Discount.UtilitiesProduct  -- association [0..*]
LEFT OUTER JOIN I_UtilsProdBillingAttribute AS _BillingAttribute ON UtilitiesProduct = _BillingAttribute.UtilitiesProduct  -- association [0..*]
LEFT OUTER JOIN I_UtilsProdSalesAttribute AS _SalesAttribute ON UtilitiesProduct = _SalesAttribute.UtilitiesProduct  -- association [0..*]
LEFT OUTER JOIN I_UtilsProdStandardAttribute AS _StandardAttribute ON UtilitiesProduct = _StandardAttribute.UtilitiesProduct  -- association [0..*]
;