I_InspectionResultValueTP_2

DDL: I_INSPECTIONRESULTVALUETP_2 Type: view_entity TRANSACTIONAL
50 Fields 1 Data Sources

Single Inspection Result - TP

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

Data Sources (1)

SourceAliasJoin Type
R_InspectionResultValueTP R_InspectionResultValueTP projection

Annotations (8)

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

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID
KEY InspectionCharacteristic InspectionCharacteristic
KEY InspResultValueInternalID InspResultValueInternalID
InspectionResultAttribute InspectionResultAttribute
InspResultItemInternalID InspResultItemInternalID
InspectionSubsetInternalID InspectionSubsetInternalID
InspectionResultMeasuredValue InspectionResultMeasuredValue
InspResultHasMeasuredValue InspResultHasMeasuredValue
InspectionResultOriginalValue InspectionResultOriginalValue
InspectionResultText InspectionResultText
InspectionResultHasLongText InspectionResultHasLongText
InspectionResultItem InspectionResultItem
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip
InspectionValuationResult InspectionValuationResult
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp
InspectionResultCodeGroup2 InspectionResultCodeGroup2
InspectionResultCodeGroup3 InspectionResultCodeGroup3
InspectionResultCodeGroup4 InspectionResultCodeGroup4
InspectionResultCodeGroup5 InspectionResultCodeGroup5
CharacteristicAttributeCode CharacteristicAttributeCode
InspectionResultCode2 InspectionResultCode2
InspectionResultCode3 InspectionResultCode3
InspectionResultCode4 InspectionResultCode4
InspectionResultCode5 InspectionResultCode5
CharcAttributeCodeVers CharcAttributeCodeVers
InspectionResultCode2Vers InspectionResultCode2Vers
InspectionResultCode3Vers InspectionResultCode3Vers
InspectionResultCode4Vers InspectionResultCode4Vers
InspectionResultCode5Vers InspectionResultCode5Vers
CharacteristicAttributeCatalog CharacteristicAttributeCatalog
InspectionResultCatalog2 InspectionResultCatalog2
InspectionResultCatalog3 InspectionResultCatalog3
InspectionResultCatalog4 InspectionResultCatalog4
InspectionResultCatalog5 InspectionResultCatalog5
Inspector Inspector Inspector
InspectionStartDate InspectionStartDate
InspectionStartTime InspectionStartTime
InspectionEndDate InspectionEndDate
InspectionEndTime InspectionEndTime
InspectionNumberOfDefects InspectionNumberOfDefects
DefectClass DefectClass Defect Class
InspResultNrOfAddlDcmlsPlaces InspResultNrOfAddlDcmlsPlaces
CreatedByUser CreatedByUser User Name
CreationDate CreationDate Time Stamp
LastChangedByUser LastChangedByUser User Name
LastChangeDate LastChangeDate 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_InspectionResultValueTP_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_InspectionResultValueTP_2 AS
SELECT
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspResultValueInternalID,
  InspectionResultAttribute,
  InspResultItemInternalID,
  InspectionSubsetInternalID,
  InspectionResultMeasuredValue,
  InspResultHasMeasuredValue,
  InspectionResultOriginalValue,
  InspectionResultText,
  InspectionResultHasLongText,
  InspectionResultItem,
  InspRsltFreeDefinedTestEquip,
  InspectionValuationResult,
  CharacteristicAttributeCodeGrp,
  InspectionResultCodeGroup2,
  InspectionResultCodeGroup3,
  InspectionResultCodeGroup4,
  InspectionResultCodeGroup5,
  CharacteristicAttributeCode,
  InspectionResultCode2,
  InspectionResultCode3,
  InspectionResultCode4,
  InspectionResultCode5,
  CharcAttributeCodeVers,
  InspectionResultCode2Vers,
  InspectionResultCode3Vers,
  InspectionResultCode4Vers,
  InspectionResultCode5Vers,
  CharacteristicAttributeCatalog,
  InspectionResultCatalog2,
  InspectionResultCatalog3,
  InspectionResultCatalog4,
  InspectionResultCatalog5,
  Inspector,
  InspectionStartDate,
  InspectionStartTime,
  InspectionEndDate,
  InspectionEndTime,
  InspectionNumberOfDefects,
  DefectClass,
  InspResultNrOfAddlDcmlsPlaces,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  ChangedTime,
  CreationTime
FROM R_InspectionResultValueTP
;

Learn More