I_InspectionResultTP_2

DDL: I_INSPECTIONRESULTTP_2 Type: view_entity TRANSACTIONAL

Summarized Inspection Result - TP

I_InspectionResultTP_2 is a Transactional CDS View that provides data about "Summarized Inspection Result - TP" in SAP S/4HANA. It reads from 1 data source (R_InspectionResultTP) and exposes 64 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic.

Data Sources (1)

SourceAliasJoin Type
R_InspectionResultTP R_InspectionResultTP projection

Annotations (8)

NameValueLevelField
EndUserText.label Summarized Inspection Result - TP view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #TRANSACTIONAL_INTERFACE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (64)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
Inspector Inspector Inspector
InspectionResultStatus InspectionResultStatus
InspResultIsCompletionForced InspResultIsCompletionForced
InspectionResultAttribute InspectionResultAttribute
InspectionResultOrigin InspectionResultOrigin
InspectionValuationResult InspectionValuationResult
InspResultDynModifValuation InspResultDynModifValuation
InspectionResultMeanValue InspectionResultMeanValue
InspectionResultHasMeanValue InspectionResultHasMeanValue
InspectionResultMaximumValue InspectionResultMaximumValue
InspResultHasMaximumValue InspResultHasMaximumValue
InspectionResultMinimumValue InspectionResultMinimumValue
InspResultHasMinimumValue InspResultHasMinimumValue
InspectionResultOriginalValue InspectionResultOriginalValue
InspResultValidValuesNumber InspResultValidValuesNumber
InspResultNmbrOfRecordedRslts InspResultNmbrOfRecordedRslts
InspectionResultText InspectionResultText
InspectionResultHasLongText InspectionResultHasLongText
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp
CharacteristicAttributeCode CharacteristicAttributeCode
CharcAttributeCodeVers CharcAttributeCodeVers
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip
InspRsltBelowToleranceValsNmbr InspRsltBelowToleranceValsNmbr
InspRsltAboveToleranceValsNmbr InspRsltAboveToleranceValsNmbr
InspRsltNonconformingValsNmbr InspRsltNonconformingValsNmbr
InspectionNumberOfDefects InspectionNumberOfDefects
InspRsltAboveToleranceFraction InspRsltAboveToleranceFraction
InspRsltBelowToleranceFraction InspRsltBelowToleranceFraction
InspResultVariance InspResultVariance
InspResultHasVariance InspResultHasVariance
CharacteristicAttributeCatalog CharacteristicAttributeCatalog
InspectionResultCatalog2 InspectionResultCatalog2
InspectionResultCatalog3 InspectionResultCatalog3
InspectionResultCatalog4 InspectionResultCatalog4
InspectionResultCatalog5 InspectionResultCatalog5
InspectionResultCode2 InspectionResultCode2
InspectionResultCode3 InspectionResultCode3
InspectionResultCode4 InspectionResultCode4
InspectionResultCode5 InspectionResultCode5
InspectionResultCode2Vers InspectionResultCode2Vers
InspectionResultCode3Vers InspectionResultCode3Vers
InspectionResultCode4Vers InspectionResultCode4Vers
InspectionResultCode5Vers InspectionResultCode5Vers
InspectionResultCodeGroup2 InspectionResultCodeGroup2
InspectionResultCodeGroup3 InspectionResultCodeGroup3
InspectionResultCodeGroup4 InspectionResultCodeGroup4
InspectionResultCodeGroup5 InspectionResultCodeGroup5
DefectClass DefectClass Defect Class
InspectionPartialSampleSize InspectionPartialSampleSize
InspectionStartDate InspectionStartDate
InspectionStartTime InspectionStartTime
InspectionEndDate InspectionEndDate
InspectionEndTime InspectionEndTime
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate Time Stamp
ChangedDateTime ChangedDateTime Time Stamp
ChangedTime ChangedTime Changed at
CreationTime CreationTime Time of Change
_InspectionOperation _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 I_InspectionResultTP_2.
-- 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 I_InspectionResultTP_2 AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  Inspector,
  InspectionResultStatus,
  InspResultIsCompletionForced,
  InspectionResultAttribute,
  InspectionResultOrigin,
  InspectionValuationResult,
  InspResultDynModifValuation,
  InspectionResultMeanValue,
  InspectionResultHasMeanValue,
  InspectionResultMaximumValue,
  InspResultHasMaximumValue,
  InspectionResultMinimumValue,
  InspResultHasMinimumValue,
  InspectionResultOriginalValue,
  InspResultValidValuesNumber,
  InspResultNmbrOfRecordedRslts,
  InspectionResultText,
  InspectionResultHasLongText,
  CharacteristicAttributeCodeGrp,
  CharacteristicAttributeCode,
  CharcAttributeCodeVers,
  InspRsltFreeDefinedTestEquip,
  InspRsltBelowToleranceValsNmbr,
  InspRsltAboveToleranceValsNmbr,
  InspRsltNonconformingValsNmbr,
  InspectionNumberOfDefects,
  InspRsltAboveToleranceFraction,
  InspRsltBelowToleranceFraction,
  InspResultVariance,
  InspResultHasVariance,
  CharacteristicAttributeCatalog,
  InspectionResultCatalog2,
  InspectionResultCatalog3,
  InspectionResultCatalog4,
  InspectionResultCatalog5,
  InspectionResultCode2,
  InspectionResultCode3,
  InspectionResultCode4,
  InspectionResultCode5,
  InspectionResultCode2Vers,
  InspectionResultCode3Vers,
  InspectionResultCode4Vers,
  InspectionResultCode5Vers,
  InspectionResultCodeGroup2,
  InspectionResultCodeGroup3,
  InspectionResultCodeGroup4,
  InspectionResultCodeGroup5,
  DefectClass,
  InspectionPartialSampleSize,
  InspectionStartDate,
  InspectionStartTime,
  InspectionEndDate,
  InspectionEndTime,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  ChangedDateTime,
  ChangedTime,
  CreationTime
FROM R_InspectionResultTP
;