I_UtilsProdSalesAttribute

DDL: I_UTILSPRODSALESATTRIBUTE SQL: IUILPRDSLSATTR Type: view COMPOSITE
17 Fields 1 Data Sources

Sales Attributes for Utilities Product

I_UtilsProdSalesAttribute is a Composite CDS View that provides data about "Sales Attributes for Utilities Product" in SAP S/4HANA. It reads from 1 data source (I_UtilsProdAttributes) and exposes 17 fields with key fields UtilitiesProduct, Characteristic, ValuePositionNumber.

Data Sources (1)

SourceAliasJoin Type
I_UtilsProdAttributes _A from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRDSLSATTR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sales Attributes for Utilities Product view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY UtilitiesProduct I_UtilsProdAttributes UtilitiesProduct
KEY Characteristic I_UtilsProdAttributes Characteristic Field Name
KEY ValuePositionNumber I_UtilsProdAttributes CharcValuePositionNumber
UtilsSemanticsName1 I_UtilsProdAttributes UtilsSemanticsName1
UtilsSemanticsName2 I_UtilsProdAttributes UtilsSemanticsName2
Currency I_UtilsProdAttributes Currency Valuation Crcy
CharcDataType I_UtilsProdAttributes CharcDataType Format
ProductType I_UtilsProdAttributes ProductType Product Type Group
ProductGroup I_UtilsProdAttributes ProductGroup Product Sold Group
ProductAuthorizationGroup I_UtilsProdAttributes ProductAuthorizationGroup
_ProductType I_UtilsProdAttributes _ProductType
_ProductGroup I_UtilsProdAttributes _ProductGroup
CharcDecimals CharcDecimals Decimal Places
CharcLength I_UtilsProdAttributes CharcLength Number of Chars
CharcCheckTable I_UtilsProdAttributes CharcCheckTable
CharcReferenceTable I_UtilsProdAttributes CharcReferenceTable
CharcReferenceTableField I_UtilsProdAttributes CharcReferenceTableField

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_UtilsProdSalesAttribute.
-- 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: IUILPRDSLSATTR

CREATE VIEW I_UtilsProdSalesAttribute AS
SELECT
  _A.UtilitiesProduct AS UtilitiesProduct,
  _A.Characteristic AS Characteristic,
  _A.CharcValuePositionNumber AS ValuePositionNumber,
  _A.UtilsSemanticsName1 AS UtilsSemanticsName1,
  _A.UtilsSemanticsName2 AS UtilsSemanticsName2,
  _A.Currency AS Currency,
  _A.CharcDataType AS CharcDataType,
  _A.ProductType AS ProductType,
  _A.ProductGroup AS ProductGroup,
  _A.ProductAuthorizationGroup AS ProductAuthorizationGroup,
  _A._ProductType AS _ProductType,
  _A._ProductGroup AS _ProductGroup,
  CharcDecimals,
  _A.CharcLength AS CharcLength,
  _A.CharcCheckTable AS CharcCheckTable,
  _A.CharcReferenceTable AS CharcReferenceTable,
  _A.CharcReferenceTableField AS CharcReferenceTableField
FROM I_UtilsProdAttributes AS _A
;

Learn More