I_UtilsProdCrtnMethCharcName

DDL: I_UTILSPRODCRTNMETHCHARCNAME SQL: IUILPRODCRTNMETH Type: view COMPOSITE
5 Fields 3 Data Sources

Utilities Product Creation Method for Utilities Product

I_UtilsProdCrtnMethCharcName is a Composite CDS View that provides data about "Utilities Product Creation Method for Utilities Product" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharacteristic, I_UtilsCommonFields, I_Product) and exposes 5 fields with key fields CharcInternalID, UtilitiesProduct.

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharacteristic _C inner
I_UtilsCommonFields _Comm inner
I_Product _P inner

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRODCRTNMETH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Utilities Product Creation Method for Utilities Product view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CharcInternalID CharacteristicsValue CharcInternalID Characteristic Internal ID
KEY UtilitiesProduct CharacteristicsValue ClfnObjectID
Characteristic I_ClfnCharacteristic Characteristic Field Name
UtilsProdCreationMethod CharacteristicsValue CharcValue Char. Value
ProductGroup I_Product ProductGroup Product Sold Group

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_UtilsProdCrtnMethCharcName.
-- 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: IUILPRODCRTNMETH

CREATE VIEW I_UtilsProdCrtnMethCharcName AS
SELECT
  CharacteristicsValue.CharcInternalID AS CharcInternalID,
  CharacteristicsValue.ClfnObjectID AS UtilitiesProduct,
  _C.Characteristic AS Characteristic,
  CharacteristicsValue.CharcValue AS UtilsProdCreationMethod,
  _P.ProductGroup AS ProductGroup
INNER JOIN I_ClfnCharacteristic AS _C ON /* join condition not captured in parsed metadata */
INNER JOIN I_Product AS _P ON /* join condition not captured in parsed metadata */
INNER JOIN I_UtilsCommonFields AS _Comm ON /* join condition not captured in parsed metadata */
;

Learn More