C_DefectMngCharacteristicsSbst

DDL: C_DEFECTMNGCHARACTERISTICSSBST SQL: CDEFECTMNGSBST Type: view CONSUMPTION
41 Fields 2 Data Sources

Defect: Characteristics with Insp. Point

C_DefectMngCharacteristicsSbst is a Consumption CDS View that provides data about "Defect: Characteristics with Insp. Point" in SAP S/4HANA. It reads from 2 data sources (I_InspectionSubset, I_InspSubsetCharacteristic) and exposes 41 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID, MaterialSample, InspectionCharacteristic.

Data Sources (2)

SourceAliasJoin Type
I_InspectionSubset _InspSubset inner
I_InspSubsetCharacteristic _InspSubsetChar from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CDEFECTMNGSBST 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 #D view
EndUserText.label Defect: Characteristics with Insp. Point view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot I_InspectionSubset InspectionLot Inspection Lot
KEY InspPlanOperationInternalID I_InspectionSubset InspPlanOperationInternalID Node Number
KEY InspectionSubsetInternalID I_InspectionSubset InspectionSubsetInternalID Sample Number
KEY MaterialSample I_InspectionSubset MaterialSample Sample
KEY InspectionCharacteristic I_InspSubsetCharacteristic InspectionCharacteristic Characteristic
InspectionSubset
InspectionOperation
OperationText
InspSubsetFieldCombination
InspectionSubsetDate _InspectionSubset InspectionSubsetDate
InspectionSubsetLongCharKey _InspectionSubset InspectionSubsetLongCharKey
InspectionSubsetShortCharKey _InspectionSubset InspectionSubsetShortCharKey
InspSubsetLongNumericKey _InspectionSubset InspSubsetLongNumericKey
InspSubsetShortNumericKey _InspectionSubset InspSubsetShortNumericKey
Equipment _InspectionSubset Equipment Equipment check
FunctionalLocation _InspectionSubset FunctionalLocation Object ID
InspectionSpecificationText
InspSpecIsQuantitative
InspectionSpecificationUnit
InspSpecRecordingType
InspSpecUpperLimit
InspSpecHasUpperLimit
InspSpecLowerLimit
InspSpecHasLowerLimit
InspSpecDecimalPlaces
InspCharacteristicSampleSize
InspCharacteristicSampleUnit
InspSpecSampleQuantityFactor
SelectedCodeSetText
InspectionValuationResult
InspectionResultMeanValue
InspectionResultMeanValueText
InspSpecToleranceLimitsText
InspectionResultHasMeanValue
CharacteristicAttributeCode
CharacteristicAttributeCodeGrp
CharacteristicAttributeCodeTxt
InspResultValidValuesNumber
InspRsltNonconformingValsNmbr
_InspectionLot I_InspectionSubset _InspectionLot
_InspectionOperation I_InspectionSubset _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_DefectMngCharacteristicsSbst.
-- 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: CDEFECTMNGSBST

CREATE VIEW C_DefectMngCharacteristicsSbst AS
SELECT
  _InspSubset.InspectionLot AS InspectionLot,
  _InspSubset.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspSubset.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _InspSubset.MaterialSample AS MaterialSample,
  _InspSubsetChar.InspectionCharacteristic AS InspectionCharacteristic,
  cast('' as qpruefpkt) AS InspectionSubset,
  cast( _InspSubset._InspectionOperation.InspectionOperation as vdm_vornr preserving type ) AS InspectionOperation,
  _InspSubset._InspectionOperation.OperationText AS OperationText,
  _InspSubsetChar._InspectionLot.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  _InspectionSubset.InspectionSubsetDate AS InspectionSubsetDate,
  _InspectionSubset.InspectionSubsetLongCharKey AS InspectionSubsetLongCharKey,
  _InspectionSubset.InspectionSubsetShortCharKey AS InspectionSubsetShortCharKey,
  _InspectionSubset.InspSubsetLongNumericKey AS InspSubsetLongNumericKey,
  _InspectionSubset.InspSubsetShortNumericKey AS InspSubsetShortNumericKey,
  _InspectionSubset.Equipment AS Equipment,
  _InspectionSubset.FunctionalLocation AS FunctionalLocation,
  _InspSubsetChar._InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspSubsetChar._InspectionCharacteristic.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecRecordingType AS InspSpecRecordingType,
  _InspSubsetChar._InspectionCharacteristic.InspSpecUpperLimit AS InspSpecUpperLimit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecLowerLimit AS InspSpecLowerLimit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _InspSubsetChar._InspectionCharacteristic.InspCharacteristicSampleSize AS InspCharacteristicSampleSize,
  _InspSubsetChar._InspectionCharacteristic.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _InspSubsetChar._InspectionCharacteristic.InspSpecSampleQuantityFactor AS InspSpecSampleQuantityFactor,
  _InspSubsetChar._InspectionCharacteristic._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  _InspSubsetChar._InspSubsetResult.InspectionValuationResult AS InspectionValuationResult,
  _InspSubsetChar._InspSubsetResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  cast( '' as vdm_qinspsummerizedresults ) AS InspectionResultMeanValueText,
  cast( '' as vdm_qinspspecification ) AS InspSpecToleranceLimitsText,
  _InspSubsetChar._InspSubsetResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  cast(_InspSubsetChar._InspSubsetResult.CharacteristicAttributeCode as vdm_qinspsummerizedresults ) AS CharacteristicAttributeCode,
  _InspSubsetChar._InspSubsetResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _InspSubsetChar._InspSubsetResult._CharcAttributeCode.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  _InspSubsetChar._InspSubsetResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  _InspSubsetChar._InspSubsetResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  _InspSubset._InspectionLot AS _InspectionLot,
  _InspSubset._InspectionOperation AS _InspectionOperation
FROM I_InspSubsetCharacteristic AS _InspSubsetChar
INNER JOIN I_InspectionSubset AS _InspSubset ON /* join condition not captured in parsed metadata */
;

Learn More