I_DCBQualityNameForMaterial

DDL: I_DCBQUALITYNAMEFORMATERIAL SQL: IDCBQLTNAMCHRMAT Type: view COMPOSITE

Quality name parameters per material

I_DCBQualityNameForMaterial is a Composite CDS View that provides data about "Quality name parameters per material" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharcBasic, I_ClfnObjectCharc, I_DCBQualityNameConfiguration) and exposes 7 fields with key fields ClfnObjectID, CharcInternalID. It has 1 association to related views.

3 data source(s) 7 fields

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharcBasic _Characteristic inner
I_ClfnObjectCharc _ObjectCharacteristic inner
I_DCBQualityNameConfiguration _Quality inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ClfnCharcDesc _CharacteristicDescription _CharacteristicDescription.CharcInternalID = _Characteristic.CharcInternalID and _CharacteristicDescription.ValidityStartDate <= $session.system_date and _CharacteristicDescription.ValidityEndDate >= $session.system_date

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IDCBQLTNAMCHRMAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Quality name parameters per material view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ClfnObjectID _ObjectClass ClfnObjectID
KEY CharcInternalID I_ClfnCharcBasic CharcInternalID
Characteristic I_ClfnCharcBasic Characteristic
CharcDescription
ValidityStartDate I_ClfnCharcBasic ValidityStartDate
ValidityEndDate I_ClfnCharcBasic ValidityEndDate
Class 
@AbapCatalog.sqlViewName: 'IDCBQLTNAMCHRMAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Quality name parameters per material'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType: {
serviceQuality: #C,
sizeCategory: #L,
dataClass: #MIXED
}
define view I_DCBQualityNameForMaterial
  as select distinct from I_ClfnObjectClass             as _ObjectClass
    inner join            I_ClfnObjectCharc             as _ObjectCharacteristic on  _ObjectCharacteristic.ClfnObjectID       = _ObjectClass.ClfnObjectID
                                                                                 and _ObjectCharacteristic.ClfnObjectTable    = _ObjectClass.ClfnObjectTable
                                                                                 and _ObjectCharacteristic.ClassInternalID    = _ObjectClass.ClassInternalID
                                                                                 and _ObjectCharacteristic.ClassType          = _ObjectClass.ClassType
                                                                                 and _ObjectCharacteristic.TimeIntervalNumber = _ObjectClass.TimeIntervalNumber
    inner join            I_ClfnCharcBasic              as _Characteristic       on  _Characteristic.CharcInternalID    = _ObjectCharacteristic.CharcInternalID
                                                                                 and _Characteristic.TimeIntervalNumber = _ObjectClass.TimeIntervalNumber
    inner join            I_DCBQualityNameConfiguration as _Quality              on _Quality.CharcInternalID = _Characteristic.CharcInternalID
  association [0..*] to I_ClfnCharcDesc as _CharacteristicDescription on  _CharacteristicDescription.CharcInternalID   = _Characteristic.CharcInternalID
                                                                      and _CharacteristicDescription.ValidityStartDate <= $session.system_date
                                                                      and _CharacteristicDescription.ValidityEndDate   >= $session.system_date
{
  key _ObjectClass.ClfnObjectID                                                            as ClfnObjectID,
  key _Characteristic.CharcInternalID                                                      as CharcInternalID,
      @ObjectModel.text.element: 'CharcDescription'
      _Characteristic.Characteristic                                                       as Characteristic,
      _CharacteristicDescription[1: Language = $session.system_language ].CharcDescription as CharcDescription,
      _Characteristic.ValidityStartDate                                                    as ValidityStartDate,
      _Characteristic.ValidityEndDate                                                      as ValidityEndDate,
      _ObjectClass._Class.Class                                                            as Class
}
where
     _ObjectClass.ClassType = '001'
  or _ObjectClass.ClassType = '023'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCBASIC",
"I_CLFNCHARCDESC",
"I_CLFNCLASS",
"I_CLFNOBJECTCHARC",
"I_CLFNOBJECTCLASS",
"I_DCBQUALITYNAMECONFIGURATION"
],
"ASSOCIATED":
[
"I_CLFNCHARCDESC"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More