C_Chargroupcode_Valuehelp

DDL: C_CHARGROUPCODE_VALUEHELP SQL: CCHARGROUPCODEVH Type: view CONSUMPTION
11 Fields 4 Data Sources

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)

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 Receiving Plant
KEY SelectedCodeSet I_InspectionCharacteristic SelectedCodeSet CodeGrp/SelSet
KEY CharacteristicAttributeCode I_CharcAttribSelectedSetCode CharacteristicAttributeCode Water Hazard Cl.
KEY InspectionLot I_InspectionCharacteristic InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspectionCharacteristic InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic I_InspectionCharacteristic InspectionCharacteristic Characteristic
SelectedCodeSetText I_CharcAttribSelectedCodeSet SelectedCodeSetText
CharacteristicAttributeCodeGrp I_CharcAttribSelectedSetCode CharacteristicAttributeCodeGrp Code Group
CharcAttributeValuation I_CharcAttribSelectedSetCode CharcAttributeValuation Code Valuation
CharacteristicAttributeCodeTxt CharacteristicAttributeCodeTxt
InspectionSelectedSetStatus I_CharcAttribSelectedCodeSet InspectionSelectedSetStatus Workflow Status

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 C_Chargroupcode_Valuehelp.
-- 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: CCHARGROUPCODEVH

CREATE VIEW C_Chargroupcode_Valuehelp AS
SELECT
  _InspectionCharacteristic.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  _InspectionCharacteristic.SelectedCodeSet AS SelectedCodeSet,
  _CharcAttribSelectedSetCode.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  _InspectionCharacteristic.InspectionLot AS InspectionLot,
  _InspectionCharacteristic.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspectionCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  _CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  _CharcAttribSelectedSetCode.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _CharcAttribSelectedSetCode.CharcAttributeValuation AS CharcAttributeValuation,
  CharacteristicAttributeCodeTxt,
  _CharcAttribSelectedCodeSet.InspectionSelectedSetStatus AS InspectionSelectedSetStatus
FROM I_InspectionCharacteristic AS _InspectionCharacteristic
INNER JOIN I_CharcAttribSelectedCodeSet AS _CharcAttribSelectedCodeSet ON /* join condition not captured in parsed metadata */
INNER JOIN I_CharcAttribSelectedSetCode AS _CharcAttribSelectedSetCode ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CharcAttributeCode AS _CharcAttributeCode ON /* join condition not captured in parsed metadata */
;

Learn More