C_DefectMngCharcRslts

DDL: C_DEFECTMNGCHARCRSLTS SQL: CDEFECTCHARCRSLT Type: view CONSUMPTION
17 Fields 2 Data Sources

Defect: Charcteristics Single Results

C_DefectMngCharcRslts is a Consumption CDS View that provides data about "Defect: Charcteristics Single Results" in SAP S/4HANA. It reads from 2 data sources (I_InspectionResultValue, I_InspSubsetCharacteristic) and exposes 17 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic, InspectionSubsetInternalID, InspectionOperation.

Data Sources (2)

SourceAliasJoin Type
I_InspectionResultValue _InspectionResultValue left_outer
I_InspSubsetCharacteristic _InspSubsetChar from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CDEFECTCHARCRSLT view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #C view
EndUserText.label Defect: Charcteristics Single Results view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspSubsetCharacteristic InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspSubsetCharacteristic InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic Characteristic
KEY InspectionSubsetInternalID I_InspSubsetCharacteristic InspectionSubsetInternalID Sample Number
KEY InspectionOperation
KEY InspResultValueInternalID I_InspectionResultValue InspResultValueInternalID Indiv. result
InspSpecIsQuantitative
InspSpecRecordingType
InspSpecIsMeasuredValueRqd
InspectionSpecificationUnit
InspSpecDecimalPlaces
InspResultHasMeasuredValue I_InspectionResultValue InspResultHasMeasuredValue
CharacteristicAttributeCodeGrp I_InspectionResultValue CharacteristicAttributeCodeGrp Code Group
fltpendasInspectionResultMeasuredValue
clientNULLendasChangedDateTime
_InspectionLot I_InspSubsetCharacteristic _InspectionLot
_InspectionOperation I_InspSubsetCharacteristic _InspectionOperation

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_DefectMngCharcRslts.
-- 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: CDEFECTCHARCRSLT

CREATE VIEW C_DefectMngCharcRslts AS
SELECT
  _InspSubsetChar.InspectionLot AS InspectionLot,
  _InspSubsetChar.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspSubsetChar.InspectionCharacteristic AS InspectionCharacteristic,
  _InspSubsetChar.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _InspSubsetChar._InspectionCharacteristic._InspectionOperation.InspectionOperation AS InspectionOperation,
  _InspectionResultValue.InspResultValueInternalID AS InspResultValueInternalID,
  _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType AS InspSpecRecordingType,
  _InspSubsetChar._InspectionCharacteristic.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  _InspSubsetChar._InspectionCharacteristic._InspectionSpecificationUnit._Text[1:Language=$session.system_language].UnitOfMeasureTechnicalName AS InspectionSpecificationUnit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspectionResultValue.InspResultHasMeasuredValue AS InspResultHasMeasuredValue,
  _InspectionResultValue.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  case _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative when 'X' then case _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType when '+' then _InspectionResultValue.InspectionResultMeasuredValue else cast(0 as abap.fltp) end else cast(0 as abap.fltp) end as InspectionResultMeasuredValue AS fltpendasInspectionResultMeasuredValue,
  case when (LastChangeDate is not null and LastChangeDate <> '00000000') then dats_tims_to_tstmp(LastChangeDate, ChangedTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') else dats_tims_to_tstmp(CreationDate, CreationTime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL') end as ChangedDateTime AS clientNULLendasChangedDateTime,
  _InspSubsetChar._InspectionLot AS _InspectionLot,
  _InspSubsetChar._InspectionOperation AS _InspectionOperation
FROM I_InspSubsetCharacteristic AS _InspSubsetChar
LEFT OUTER JOIN I_InspectionResultValue AS _InspectionResultValue ON /* join condition not captured in parsed metadata */
;

Learn More