C_InspSubsetChar

DDL: C_INSPSUBSETCHAR SQL: CINSPSUBSETCHAR Type: view CONSUMPTION
40 Fields 2 Data Sources 1 Associations

Inspection Characteristic for Inspection Points

C_InspSubsetChar is a Consumption CDS View that provides data about "Inspection Characteristic for Inspection Points" in SAP S/4HANA. It reads from 2 data sources (I_InspectionSubset, I_InspSubsetCharacteristic) and exposes 40 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID, MaterialSample, InspectionCharacteristic. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_InspectionSubset _InspSubset inner
I_InspSubsetCharacteristic _InspSubsetChar from

Associations (1)

CardinalityTargetAliasCondition
[1..*] C_InspSubsetCharSingleRslt _InspSubsetCharSingleRslt $projection.InspectionLot = _InspSubsetCharSingleRslt.InspectionLot and $projection.InspectionCharacteristic = _InspSubsetCharSingleRslt.InspectionCharacteristic and $projection.InspPlanOperationInternalID = _InspSubsetCharSingleRslt.InspPlanOperationInternalID and $projection.InspectionSubsetInternalID = _InspSubsetCharSingleRslt.InspectionSubsetInternalID

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName CINSPSUBSETCHAR view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION view
EndUserText.label Inspection Characteristic for Inspection Points view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (40)

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
InspectionOperation
InspectionMethod
InspectionMethodText
InspSpecImportanceCodeText
InspectionSpecification
InspectionSpecificationText
InspectionSpecificationPlant
InspectionSpecificationVersion
InspSpecIsQuantitative
InspectionSpecificationUnit
InspSpecRecordingType
InspSpecUpperLimit
InspSpecHasUpperLimit
InspSpecLowerLimit
InspSpecHasLowerLimit
InspSpecDecimalPlaces
InspCharacteristicSampleSize
InspCharacteristicSampleUnit
InspSpecSampleQuantityFactor
InspSpecIsMeasuredValueRqd
SelectedCodeSetText
InspectionMethodPlant
InspectionMethodVersion
InspectionValuationResult
InspResultValidValuesNumber
InspRsltNonconformingValsNmbr
InspRsltInspNonConformanceCt Inspected / Nonconforming
InspectionResultMeanValue
CharacteristicAttributeCodeTxt
CharacteristicAttributeCode
InspectionResultHasMeanValue
CharacteristicAttributeCodeGrp
_InspectionLot I_InspectionSubset _InspectionLot
_InspectionOperation I_InspectionSubset _InspectionOperation
_InspSubsetCharSingleRslt _InspSubsetCharSingleRslt

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_InspSubsetChar.
-- 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: CINSPSUBSETCHAR

CREATE VIEW C_InspSubsetChar AS
SELECT
  _InspSubset.InspectionLot AS InspectionLot,
  _InspSubset.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _InspSubset.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _InspSubset.MaterialSample AS MaterialSample,
  _InspSubsetChar.InspectionCharacteristic AS InspectionCharacteristic,
  _InspSubsetChar._InspectionCharacteristic._InspectionOperation.InspectionOperation AS InspectionOperation,
  _InspSubsetChar._InspectionCharacteristic.InspectionMethod AS InspectionMethod,
  _InspSubsetChar._InspectionCharacteristic._InspectionMethodVersion._InspectionMethodText[1:Language=$session.system_language].InspectionMethodText AS InspectionMethodText,
  _InspSubsetChar._InspectionCharacteristic._InspSpecImportanceCode.InspSpecImportanceCodeText AS InspSpecImportanceCodeText,
  _InspSubsetChar._InspectionCharacteristic.InspectionSpecification AS InspectionSpecification,
  _InspSubsetChar._InspectionCharacteristic.InspectionSpecificationText AS InspectionSpecificationText,
  _InspSubsetChar._InspectionCharacteristic.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _InspSubsetChar._InspectionCharacteristic.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _InspSubsetChar._InspectionCharacteristic.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _InspSubsetChar._InspectionCharacteristic._InspectionSpecificationUnit._Text[1:Language=$session.system_language].UnitOfMeasureTechnicalName 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.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  _InspSubsetChar._InspectionCharacteristic._CharcAttribSelectedCodeSet.SelectedCodeSetText AS SelectedCodeSetText,
  _InspSubsetChar._InspectionCharacteristic.InspectionMethodPlant AS InspectionMethodPlant,
  _InspSubsetChar._InspectionCharacteristic.InspectionMethodVersion AS InspectionMethodVersion,
  _InspSubsetChar._InspSubsetResult.InspectionValuationResult AS InspectionValuationResult,
  _InspSubsetChar._InspSubsetResult.InspResultValidValuesNumber AS InspResultValidValuesNumber,
  _InspSubsetChar._InspSubsetResult.InspRsltNonconformingValsNmbr AS InspRsltNonconformingValsNmbr,
  concat (concat (cast (_InspSubsetChar._InspSubsetResult.InspResultValidValuesNumber as abap.char( 20 )),' / '), concat(' ',cast (_InspSubsetChar._InspSubsetResult.InspRsltNonconformingValsNmbr as abap.char( 20 )))) AS InspRsltInspNonConformanceCt,
  _InspSubsetChar._InspSubsetResult.InspectionResultMeanValue AS InspectionResultMeanValue,
  _InspSubsetChar._InspSubsetResult._CharcAttributeCode.CharacteristicAttributeCodeTxt AS CharacteristicAttributeCodeTxt,
  _InspSubsetChar._InspSubsetResult.CharacteristicAttributeCode AS CharacteristicAttributeCode,
  _InspSubsetChar._InspSubsetResult.InspectionResultHasMeanValue AS InspectionResultHasMeanValue,
  _InspSubsetChar._InspSubsetResult.CharacteristicAttributeCodeGrp AS CharacteristicAttributeCodeGrp,
  _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 */
LEFT OUTER JOIN C_InspSubsetCharSingleRslt AS _InspSubsetCharSingleRslt ON InspectionLot = _InspSubsetCharSingleRslt.InspectionLot AND InspectionCharacteristic = _InspSubsetCharSingleRslt.InspectionCharacteristic AND InspPlanOperationInternalID = _InspSubsetCharSingleRslt.InspPlanOperationInternalID AND InspectionSubsetInternalID = _InspSubsetCharSingleRslt.InspectionSubsetInternalID  -- association [1..*]
;

Learn More