R_InspectionResultValueTP

DDL: R_INSPECTIONRESULTVALUETP Type: view_entity TRANSACTIONAL
56 Fields 1 Data Sources 2 Associations

Single Inspection Result - TP

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

Data Sources (1)

SourceAliasJoin Type
I_InspectionResultValue I_InspectionResultValue from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_InspectionCharacteristicTP _InspectionCharacteristic $projection.InspectionLot = _InspectionCharacteristic.InspectionLot and $projection.InspPlanOperationInternalID = _InspectionCharacteristic.InspPlanOperationInternalID and $projection.InspectionCharacteristic = _InspectionCharacteristic.InspectionCharacteristic
[1..1] R_InspectionLotTP _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Single Inspection Result - TP view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (56)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic InspectionCharacteristic Characteristic
KEY InspResultValueInternalID InspResultValueInternalID Indiv. result
InspectionResultAttribute InspectionResultAttribute Name of attribute
InspResultItemInternalID InspResultItemInternalID Insp. Unit No.
InspectionSubsetInternalID InspectionSubsetInternalID Sample Number
InspectionResultMeasuredValue InspectionResultMeasuredValue Measured Value
InspResultHasMeasuredValue InspResultHasMeasuredValue
InspectionResultOriginalValue InspectionResultOriginalValue Original Value
InspectionResultText InspectionResultText
InspectionResultHasLongText InspectionResultHasLongText Long text
InspectionResultItem InspectionResultItem Serial Number
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip Information
InspectionValuationResult InspectionValuationResult Valuation
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp Code Group
InspectionResultCodeGroup2 InspectionResultCodeGroup2 Code Group
InspectionResultCodeGroup3 InspectionResultCodeGroup3 Code Group
InspectionResultCodeGroup4 InspectionResultCodeGroup4 Code Group
InspectionResultCodeGroup5 InspectionResultCodeGroup5 Code Group
CharacteristicAttributeCode CharacteristicAttributeCode Code
InspectionResultCode2 InspectionResultCode2 Code
InspectionResultCode3 InspectionResultCode3 Code
InspectionResultCode4 InspectionResultCode4 Code
InspectionResultCode5 InspectionResultCode5 Code
CharcAttributeCodeVers CharcAttributeCodeVers Version
InspectionResultCode2Vers InspectionResultCode2Vers Version
InspectionResultCode3Vers InspectionResultCode3Vers Version
InspectionResultCode4Vers InspectionResultCode4Vers Version
InspectionResultCode5Vers InspectionResultCode5Vers Version
CharacteristicAttributeCatalog CharacteristicAttributeCatalog Catalog Type
InspectionResultCatalog2 InspectionResultCatalog2 Catalog Type
InspectionResultCatalog3 InspectionResultCatalog3 Catalog Type
InspectionResultCatalog4 InspectionResultCatalog4 Catalog Type
InspectionResultCatalog5 InspectionResultCatalog5 Catalog Type
Inspector Inspector Inspector
InspectionStartDate InspectionStartDate Insp.Start Date
InspectionStartTime InspectionStartTime Insp.Start Time
InspectionEndDate InspectionEndDate Insp. End Date
InspectionEndTime InspectionEndTime Insp. End Time
InspectionNumberOfDefects InspectionNumberOfDefects No. of Defects
DefectClass DefectClass Defect Class
InspResultNrOfAddlDcmlsPlaces InspResultNrOfAddlDcmlsPlaces Diff. Decimal Places
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
_CharcAttributeCode _CharcAttributeCode
_CharcAttributeCodeGrp _CharcAttributeCodeGrp
_InspectionCharacteristic _InspectionCharacteristic
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation
_InspectionResultAttribute _InspectionResultAttribute
_InspectionResult _InspectionResult

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 R_InspectionResultValueTP.
-- 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 R_InspectionResultValueTP 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 I_InspectionResultValue
LEFT OUTER JOIN R_InspectionCharacteristicTP AS _InspectionCharacteristic ON InspectionLot = _InspectionCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspectionCharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _InspectionCharacteristic.InspectionCharacteristic  -- association [1..1]
LEFT OUTER JOIN R_InspectionLotTP AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
;

Learn More