C_Chargroupcode_Valuehelp

Q: Which tables does C_Chargroupcode_Valuehelp use?

C_Chargroupcode_Valuehelp reads from 4 data source(s): I_CharcAttribSelectedCodeSet, I_CharcAttribSelectedSetCode, I_CharcAttributeCode, I_InspectionCharacteristic.

Q: How many fields does C_Chargroupcode_Valuehelp have?

C_Chargroupcode_Valuehelp has 11 fields. Key fields: SelectedCodeSetPlant, SelectedCodeSet, CharacteristicAttributeCode, InspectionLot, InspPlanOperationInternalID.

DDL: C_CHARGROUPCODE_VALUEHELP SQL: CCHARGROUPCODEVH Type: view CONSUMPTION

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.

Data Sources (4)

Source	Alias	Join Type
I_CharcAttribSelectedCodeSet	_CharcAttribSelectedCodeSet	inner
I_CharcAttribSelectedSetCode	_CharcAttribSelectedSetCode	inner
I_CharcAttributeCode	_CharcAttributeCode	left_outer
I_InspectionCharacteristic	_InspectionCharacteristic	from

Annotations (11)

Name	Value	Level
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)

Key	Field	Source Table	Source Field
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
} 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHARCATTRIBSELECTEDCODESET",
"I_CHARCATTRIBSELECTEDSETCODE",
"I_CHARCATTRIBUTECODE",
"I_INSPECTIONCHARACTERISTIC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_Chargroupcode_Valuehelp view