I_UtilsProdCharValue

DDL: I_UTILSPRODCHARVALUE SQL: IUILPRDCHARVAL Type: view COMPOSITE

Utilities Product Characteristics Value

I_UtilsProdCharValue is a Composite CDS View that provides data about "Utilities Product Characteristics Value" in SAP S/4HANA. It reads from 2 data sources (I_Product, I_ClfnObjectCharcValForKeyDate) and exposes 30 fields with key fields ClfnObjectID, ClfnObjectTable, CharcInternalID, CharcValuePositionNumber, ClfnObjectType. It has 2 associations to related views.

2 data source(s) 30 fields

Data Sources (2)

SourceAliasJoin Type
I_Product _P inner
I_ClfnObjectCharcValForKeyDate I_ClfnObjectCharcValForKeyDate from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_ClfnObjectCharcValue _CharacteristicValue _CharacteristicValue.CharcInternalID = $projection.CharcInternalID and _CharacteristicValue.CharcValue = $projection.CharcValue
[1..1] I_ClfnCharacteristic _Characteristic $projection.CharcInternalID = _Characteristic.CharcInternalID and $projection.ValidityStartDate <= _Characteristic.ValidityEndDate and $projection.ValidityEndDate >= _Characteristic.ValidityStartDate

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IUILPRDCHARVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Utilities Product Characteristics Value view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID ClfnObjectID
KEY ClfnObjectTable ClfnObjectTable
KEY CharcInternalID CharcInternalID
KEY CharcValuePositionNumber CharcValuePositionNumber
KEY ClfnObjectType ClfnObjectType
KEY ClassType ClassType
ProductType I_Product ProductType
ProductGroup I_Product ProductGroup
ProductAuthorizationGroup I_Product AuthorizationGroup
ValidityStartDate _V ValidityStartDate
ValidityEndDate _V ValidityEndDate
Characteristic _Characteristic Characteristic
CharcDataType _Characteristic CharcDataType
CharcValue CharcValue
CharcFromAmount _V CharcFromAmount
CharcToAmount _V CharcToAmount
Currency _V Currency
CharcFromDecimalValue _V CharcFromDecimalValue
CharcToDecimalValue _V CharcToDecimalValue
CharcFromDate _V CharcFromDate
CharcToDate _V CharcToDate
CharcValueUnit _Characteristic CharcValueUnit
CharcDecimals _Characteristic CharcDecimals
CharcLength _Characteristic CharcLength
CharcCheckTable _Characteristic CharcCheckTable
CharcReferenceTable _Characteristic CharcReferenceTable
CharcReferenceTableField _Characteristic CharcReferenceTableField
CharcConversionRoutine _Characteristic CharcConversionRoutine
_ProductType I_Product _ProductType
_ProductGroup I_Product _ProductGroup 
@AbapCatalog.sqlViewName: 'IUILPRDCHARVAL'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Utilities Product Characteristics Value'
define view I_UtilsProdCharValue
  as select from I_ClfnObjectCharcValForKeyDate(P_KeyDate: $session.system_date) as _V
    inner join   I_Product                                                       as _P on _P.Product = _V.ClfnObjectID
  association [0..*] to I_ClfnObjectCharcValue as _CharacteristicValue on  _CharacteristicValue.CharcInternalID = $projection.CharcInternalID
                                                                       and _CharacteristicValue.CharcValue      = $projection.CharcValue
  association [1..1] to I_ClfnCharacteristic   as _Characteristic
  // Usage of validity start and end date replaces key field TimeIntervalNumber of characteristic in the condition

                                                                       on  $projection.CharcInternalID   =  _Characteristic.CharcInternalID
                                                                       and $projection.ValidityStartDate <= _Characteristic.ValidityEndDate
                                                                       and $projection.ValidityEndDate   >= _Characteristic.ValidityStartDate
{
  key ClfnObjectID,
  key ClfnObjectTable,
  key CharcInternalID,
  key CharcValuePositionNumber,
  key ClfnObjectType,
  key ClassType,
      @Consumption.hidden
      _P.ProductType,
      _P.ProductGroup,
      @Consumption.hidden
      _P.AuthorizationGroup as ProductAuthorizationGroup,
      _V.ValidityStartDate,
      _V.ValidityEndDate,
      _Characteristic.Characteristic,
      _Characteristic.CharcDataType,
      CharcValue,
      _V.CharcFromAmount,
      _V.CharcToAmount,
      _V.Currency,
      _V.CharcFromDecimalValue,
      _V.CharcToDecimalValue,
      _V.CharcFromDate,
      _V.CharcToDate,
      _Characteristic.CharcValueUnit,
      _Characteristic.CharcDecimals,
      _Characteristic.CharcLength,
      _Characteristic.CharcCheckTable,
      _Characteristic.CharcReferenceTable,
      _Characteristic.CharcReferenceTableField,
      _Characteristic.CharcConversionRoutine,
      _P._ProductType,
      _P._ProductGroup
}
where
  ClfnObjectTable = 'MARA'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARACTERISTIC",
"I_CLFNOBJECTCHARCVALFORKEYDATE",
"I_PRODUCT"
],
"ASSOCIATED":
[
"I_CLFNCHARACTERISTIC",
"I_CLFNOBJECTCHARCVALUE",
"I_PRODUCTGROUP",
"I_PRODUCTTYPE"
],
"BASE":
[
"I_PRODUCT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More