I_UtilsSalesAttributesVH

DDL: I_UTILSSALESATTRIBUTESVH SQL: IUILSLSATTRVH Type: view COMPOSITE
11 Fields 1 Data Sources 2 Associations

Sales Attributes for Reference Utilities Product

I_UtilsSalesAttributesVH is a Composite CDS View that provides data about "Sales Attributes for Reference Utilities Product" in SAP S/4HANA. It reads from 1 data source (I_UtilsProdChar) and exposes 11 fields with key fields UtilitiesReferenceProduct, Characteristic. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_UtilsProdChar I_UtilsProdChar from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ClfnCharacteristic _Characteristic $projection.Characteristic = _Characteristic.Characteristic
[1..*] I_UtilsAttributeValueVH _ValueVH $projection.Characteristic = _ValueVH.Characteristic and $projection.UtilitiesReferenceProduct = _ValueVH.UtilitiesReferenceProduct

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IUILSLSATTRVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Attributes for Reference Utilities Product view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesReferenceProduct UtilitiesReferenceProduct Ref. Prod. Matl No.
KEY Characteristic Characteristic Field Name
UtilsOperandMappingID UtilsOperandMappingID Mapping ID
UtilsSemanticsName1 UtilsSemanticsName1 Semantics Name 1
UtilsSemanticsName2 UtilsSemanticsName2 Semantics Name 2
UtilsSemanticsDescription UtilsSemanticsDescription Well Code Des.
UtilsSemanticsTypeDescription UtilsSemanticsTypeDescription Short text
CharcValueUnit _Characteristic CharcValueUnit Internal UoM
Currency _Characteristic Currency Valuation Crcy
EntryIsRequired _Characteristic EntryIsRequired
_ValueVH _ValueVH

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_UtilsSalesAttributesVH.
-- 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: IUILSLSATTRVH

CREATE VIEW I_UtilsSalesAttributesVH AS
SELECT
  UtilitiesReferenceProduct,
  Characteristic,
  UtilsOperandMappingID,
  UtilsSemanticsName1,
  UtilsSemanticsName2,
  UtilsSemanticsDescription,
  UtilsSemanticsTypeDescription,
  _Characteristic.CharcValueUnit AS CharcValueUnit,
  _Characteristic.Currency AS Currency,
  _Characteristic.EntryIsRequired AS EntryIsRequired
FROM I_UtilsProdChar
LEFT OUTER JOIN I_ClfnCharacteristic AS _Characteristic ON Characteristic = _Characteristic.Characteristic  -- association [1..1]
LEFT OUTER JOIN I_UtilsAttributeValueVH AS _ValueVH ON Characteristic = _ValueVH.Characteristic AND UtilitiesReferenceProduct = _ValueVH.UtilitiesReferenceProduct  -- association [1..*]
;

Learn More