C_CharcAttribCodeGroupVH

DDL: C_CHARCATTRIBCODEGROUPVH Type: view_entity CONSUMPTION
16 Fields 3 Data Sources 1 Associations

Characteristic Attribute Code Group

C_CharcAttribCodeGroupVH is a Consumption CDS View that provides data about "Characteristic Attribute Code Group" in SAP S/4HANA. It reads from 3 data sources (I_CharcAttribSelectedCodeSet, I_CharcAttribSelectedSetCode, I_InspectionCharacteristic) and exposes 16 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, CharacteristicAttributeCode, CharacteristicAttributeCodeGrp. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_CharcAttribSelectedCodeSet _CharcAttribSelectedCodeSet inner
I_CharcAttribSelectedSetCode _CharcAttribSelectedSetCode inner
I_InspectionCharacteristic _InspectionCharacteristic from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_InspectionValuationRsltText _InspectionValuationRsltText $projection.InspectionValuationResult = _InspectionValuationRsltText.InspectionValuationResult

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Characteristic Attribute Code Group view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
Search.searchable true view
Consumption.ranked true view
ObjectModel.representativeKey CharacteristicAttributeCode view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionCharacteristic InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspectionCharacteristic InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic I_InspectionCharacteristic InspectionCharacteristic Characteristic
KEY CharacteristicAttributeCode I_CharcAttribSelectedSetCode CharacteristicAttributeCode Water Hazard Cl.
KEY CharacteristicAttributeCodeGrp I_CharcAttribSelectedSetCode CharacteristicAttributeCodeGrp Code Group
CharacteristicAttributeCodeTxt _CharcAttributeCode CharacteristicAttributeCodeTxt
InspectionValuationResult I_CharcAttribSelectedSetCode CharcAttributeValuation Valuation
InspectionValuationResultText _InspectionValuationRsltText InspectionValuationResultText Valuation Text
Plant
InspectionLotType
MatlQualityAuthorizationGroup
IsBusinessPurposeCompleted
SelectedCodeSetPlant I_CharcAttribSelectedCodeSet SelectedCodeSetPlant Receiving Plant
InspectionSelectedSetStatus I_CharcAttribSelectedCodeSet InspectionSelectedSetStatus Workflow Status
SelectedCodeSet I_CharcAttribSelectedCodeSet SelectedCodeSet CodeGrp/SelSet
_InspectionValuationRsltText _InspectionValuationRsltText

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_CharcAttribCodeGroupVH.
-- 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.

CREATE VIEW C_CharcAttribCodeGroupVH AS
SELECT
  _InspectionCharacteristic.InspectionLot AS InspectionLot,
  _InspectionCharacteristic.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspectionCharacteristic.InspectionCharacteristic AS InspectionCharacteristic,
  _CharcAttribSelectedSetCode.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  _CharcAttribSelectedSetCode.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _CharcAttributeCode.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  _CharcAttribSelectedSetCode.CharcAttributeValuation AS InspectionValuationResult,
  _InspectionValuationRsltText.InspectionValuationResultText AS InspectionValuationResultText,
  _InspectionCharacteristic._InspectionLot.Plant AS Plant,
  _InspectionCharacteristic._InspectionLot.InspectionLotType AS InspectionLotType,
  _InspectionCharacteristic._InspectionLot.MatlQualityAuthorizationGroup AS MatlQualityAuthorizationGroup,
  _InspectionCharacteristic._InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _CharcAttribSelectedCodeSet.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  _CharcAttribSelectedCodeSet.InspectionSelectedSetStatus AS InspectionSelectedSetStatus,
  _CharcAttribSelectedCodeSet.SelectedCodeSet AS SelectedCodeSet
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_InspectionValuationRsltText AS _InspectionValuationRsltText ON InspectionValuationResult = _InspectionValuationRsltText.InspectionValuationResult  -- association [1..1]
;

Learn More