I_UtilsProdChar

DDL: I_UTILSPRODCHAR SQL: IUILPRDCHAR Type: view BASIC

Utilities Product Characteristics Table

I_UtilsProdChar is a Basic CDS View that provides data about "Utilities Product Characteristics Table" in SAP S/4HANA. It reads from 1 data source (isuc_uil_prdchar) and exposes 11 fields with key fields UtilitiesReferenceProduct, Characteristic. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
isuc_uil_prdchar isuc_uil_prdchar from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_UtilsOperand _UtilsOperand $projection.UtilsBillingOperand = _UtilsOperand.UtilsBillingOperand

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRDCHAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Utilities Product Characteristics Table view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesReferenceProduct isuc_uil_prdchar reference_product Ref. Prod. Matl No.
KEY Characteristic isuc_uil_prdchar characteristic Field Name
UtilsOperandMappingID mappingid Mapping ID
UtilsBillingOperand operand Operand
UtilsSemanticsType semanticstype Semantics Type
UtilsSemanticsName1 semantics1 Semantics Name 1
UtilsSemanticsName2 semantics2 Semantics Name 2
UtilsSemanticsDescription isuc_uil_prdchrt description Well Code Des.
UtilsSemanticsTypeDescription dd07t ddtext Short text
UtilsTimeSliceCharacteristicID timeslicecharacteristic Time Sl. Charc. Name
_UtilsOperand _UtilsOperand

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_UtilsProdChar.
-- 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: IUILPRDCHAR

CREATE VIEW I_UtilsProdChar AS
SELECT
  isuc_uil_prdchar.reference_product AS UtilitiesReferenceProduct,
  isuc_uil_prdchar.characteristic AS Characteristic,
  mappingid AS UtilsOperandMappingID,
  operand AS UtilsBillingOperand,
  semanticstype AS UtilsSemanticsType,
  semantics1 AS UtilsSemanticsName1,
  semantics2 AS UtilsSemanticsName2,
  isuc_uil_prdchrt.description AS UtilsSemanticsDescription,
  dd07t.ddtext AS UtilsSemanticsTypeDescription,
  timeslicecharacteristic AS UtilsTimeSliceCharacteristicID
FROM isuc_uil_prdchar
LEFT OUTER JOIN I_UtilsOperand AS _UtilsOperand ON UtilsBillingOperand = _UtilsOperand.UtilsBillingOperand  -- association [0..1]
;