I_UtilsProdStandardAttribute

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_UtilsProdStandardAttribute.
-- 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: IUILPRDSTDVAL

CREATE VIEW I_UtilsProdStandardAttribute AS
SELECT
  _P.ClfnObjectID AS UtilitiesProduct,
  _P.Characteristic AS Characteristic,
  _S.UtilsAttributeName AS UtilsAttributeName,
  _S.UtilsAddOnIsTrue AS UtilsAddOnIsTrue,
  _S.UtilsAttributeDescription AS UtilsAttributeDescription,
  _P.CharcValuePositionNumber AS CharcValuePositionNumber,
  cast(_ReferenceProductValue.CharcValue as productnumber) AS UtilitiesReferenceProduct,
  _ReferenceProduct.ProductGroup AS UtilsReferenceProductGroup,
  _P.CharcDataType AS CharcDataType,
  _P.Currency AS Currency,
  _P.CharcValueUnit AS CharcValueUnit,
  _P.CharcDecimals AS CharcDecimals,
  _P.CharcLength AS CharcLength,
  _P.CharcCheckTable AS CharcCheckTable,
  _P.CharcReferenceTable AS CharcReferenceTable,
  _P.CharcReferenceTableField AS CharcReferenceTableField,
  _P.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _P.ProductType AS ProductType,
  _P.ProductGroup AS ProductGroup,
  _P._ProductType AS _ProductType,
  _P._ProductGroup AS _ProductGroup
INNER JOIN I_UtilsReferenceProduct AS _ReferenceProductValue ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilsReferenceProducts AS _ReferenceProduct ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilsStandardCharacteristics AS _S ON /* join condition not captured in parsed metadata */
;