C_Chargroupcode_Valuehelp

DDL: C_CHARGROUPCODE_VALUEHELP SQL: CCHARGROUPCODEVH Type: view CONSUMPTION Package: ODATA_QM_RR

Selection for group and code

C_Chargroupcode_Valuehelp is a Consumption CDS View that provides data about "Selection for group and code" in SAP S/4HANA. It reads from 4 data sources (I_CharcAttribSelectedCodeSet, I_CharcAttribSelectedSetCode, I_CharcAttributeCode, I_InspectionCharacteristic) and exposes 11 fields with key fields SelectedCodeSetPlant, SelectedCodeSet, CharacteristicAttributeCode, InspectionLot, InspPlanOperationInternalID. Part of development package ODATA_QM_RR.

4 data source(s) 11 fields

Data Sources (4)

SourceAliasJoin Type
I_CharcAttribSelectedCodeSet _CharcAttribSelectedCodeSet inner
I_CharcAttribSelectedSetCode _CharcAttribSelectedSetCode inner
I_CharcAttributeCode _CharcAttributeCode left_outer
I_InspectionCharacteristic _InspectionCharacteristic from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CCHARGROUPCODEVH view
ClientDependent true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Selection for group and code view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
Search.searchable true view
Consumption.ranked true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY SelectedCodeSetPlant I_InspectionCharacteristic SelectedCodeSetPlant
KEY SelectedCodeSet I_InspectionCharacteristic SelectedCodeSet
KEY CharacteristicAttributeCode I_CharcAttribSelectedSetCode CharacteristicAttributeCode
KEY InspectionLot I_InspectionCharacteristic InspectionLot
KEY InspPlanOperationInternalID I_InspectionCharacteristic InspPlanOperationInternalID
KEY InspectionCharacteristic I_InspectionCharacteristic InspectionCharacteristic
SelectedCodeSetText I_CharcAttribSelectedCodeSet SelectedCodeSetText
CharacteristicAttributeCodeGrp I_CharcAttribSelectedSetCode CharacteristicAttributeCodeGrp
CharcAttributeValuation I_CharcAttribSelectedSetCode CharcAttributeValuation
CharacteristicAttributeCodeTxt CharacteristicAttributeCodeTxt
InspectionSelectedSetStatus I_CharcAttribSelectedCodeSet InspectionSelectedSetStatus 
@AbapCatalog.sqlViewName: 'CCHARGROUPCODEVH'
@ClientDependent: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Selection for group and code'
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #M,
    serviceQuality: #C
}

@Search.searchable: true
@Consumption.ranked: true

define view C_Chargroupcode_Valuehelp
  as select from    I_InspectionCharacteristic   as _InspectionCharacteristic
    inner join      I_CharcAttribSelectedCodeSet as _CharcAttribSelectedCodeSet on  _InspectionCharacteristic.SelectedCodeSetPlant = _CharcAttribSelectedCodeSet.SelectedCodeSetPlant
                                                                                and _InspectionCharacteristic.SelectedCodeSet      = _CharcAttribSelectedCodeSet.SelectedCodeSet
    inner join      I_CharcAttribSelectedSetCode as _CharcAttribSelectedSetCode on  _CharcAttribSelectedCodeSet.SelectedCodeSetPlant = _CharcAttribSelectedSetCode.SelectedCodeSetPlant
                                                                                and _CharcAttribSelectedCodeSet.SelectedCodeSet      = _CharcAttribSelectedSetCode.SelectedCodeSet
    left outer join I_CharcAttributeCode         as _CharcAttributeCode         on  _CharcAttributeCode.CharacteristicAttributeCodeGrp = _CharcAttribSelectedSetCode.CharacteristicAttributeCodeGrp
                                                                                and _CharcAttributeCode.CharacteristicAttributeCode    = _CharcAttribSelectedSetCode.CharacteristicAttributeCode
{
  @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW}
  key _InspectionCharacteristic.SelectedCodeSetPlant,
  key _InspectionCharacteristic.SelectedCodeSet,
  @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
  key _CharcAttribSelectedSetCode.CharacteristicAttributeCode,
  key _InspectionCharacteristic.InspectionLot,
  key _InspectionCharacteristic.InspPlanOperationInternalID,
  key _InspectionCharacteristic.InspectionCharacteristic,
      _CharcAttribSelectedCodeSet.SelectedCodeSetText,
      _CharcAttribSelectedSetCode.CharacteristicAttributeCodeGrp,
      _CharcAttribSelectedSetCode.CharcAttributeValuation,
      //@Consumption.valueHelp: '_WBSElement'

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #LOW }
      CharacteristicAttributeCodeTxt,
      @Consumption.hidden: true
      _CharcAttribSelectedCodeSet.InspectionSelectedSetStatus
}

Learn More