R_InspectionResultTP

DDL: R_INSPECTIONRESULTTP Type: view_entity TRANSACTIONAL
75 Fields 1 Data Sources 3 Associations

Inspection Result TP

R_InspectionResultTP is a Transactional CDS View that provides data about "Inspection Result TP" in SAP S/4HANA. It reads from 1 data source (I_InspectionResult) and exposes 75 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionCharacteristic. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InspectionResult I_InspectionResult from

Associations (3)

CardinalityTargetAliasCondition
[1..1] R_InspectionOperationTP _InspectionOperation $projection.InspectionLot = _InspectionOperation.InspectionLot and $projection.InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID
[1..1] R_InspectionLotTP _InspectionLot $projection.InspectionLot = _InspectionLot.InspectionLot
[0..*] R_InspectionResultValueTP _InspectionResultValue

Annotations (8)

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

Fields (75)

KeyFieldSource TableSource FieldDescription
KEY InspectionLot InspectionLot Inspection Lot
KEY InspPlanOperationInternalID InspPlanOperationInternalID Node Number
KEY InspectionCharacteristic InspectionCharacteristic Characteristic
Inspector Inspector Inspector
InspectionResultStatus InspectionResultStatus Status
InspResultIsCompletionForced InspResultIsCompletionForced
InspectionResultAttribute InspectionResultAttribute Name of attribute
InspectionResultOrigin InspectionResultOrigin Data Origin
InspectionValuationResult InspectionValuationResult Valuation
InspResultDynModifValuation InspResultDynModifValuation Dyn. Valuation
InspectionResultMeanValue InspectionResultMeanValue Mean Value
InspectionResultHasMeanValue InspectionResultHasMeanValue
InspectionResultMaximumValue InspectionResultMaximumValue Max Valid Value
InspResultHasMaximumValue InspResultHasMaximumValue
InspectionResultMinimumValue InspectionResultMinimumValue Min Valid Value
InspResultHasMinimumValue InspResultHasMinimumValue
InspectionResultOriginalValue InspectionResultOriginalValue Original Value
InspResultValidValuesNumber InspResultValidValuesNumber Inspected
InspResultNmbrOfRecordedRslts InspResultNmbrOfRecordedRslts Recorded
InspectionResultText InspectionResultText
InspectionResultHasLongText InspectionResultHasLongText Long text
CharacteristicAttributeCodeGrp CharacteristicAttributeCodeGrp Code Group
CharacteristicAttributeCode CharacteristicAttributeCode Code
CharcAttributeCodeVers CharcAttributeCodeVers Version
InspRsltFreeDefinedTestEquip InspRsltFreeDefinedTestEquip Information
InspRsltBelowToleranceValsNmbr InspRsltBelowToleranceValsNmbr Number Below
InspRsltAboveToleranceValsNmbr InspRsltAboveToleranceValsNmbr Number Above
InspRsltNonconformingValsNmbr InspRsltNonconformingValsNmbr Nonconforming
InspectionNumberOfDefects InspectionNumberOfDefects No. of Defects
InspRsltAboveToleranceFraction InspRsltAboveToleranceFraction Fraction Above
InspRsltBelowToleranceFraction InspRsltBelowToleranceFraction Fraction Below
InspResultVariance InspResultVariance Variance
InspResultHasVariance InspResultHasVariance
CharacteristicAttributeCatalog CharacteristicAttributeCatalog Catalog Type
InspectionResultCatalog2 InspectionResultCatalog2 Catalog Type
InspectionResultCatalog3 InspectionResultCatalog3 Catalog Type
InspectionResultCatalog4 InspectionResultCatalog4 Catalog Type
InspectionResultCatalog5 InspectionResultCatalog5 Catalog Type
InspectionResultCode2 InspectionResultCode2 Code
InspectionResultCode3 InspectionResultCode3 Code
InspectionResultCode4 InspectionResultCode4 Code
InspectionResultCode5 InspectionResultCode5 Code
InspectionResultCode2Vers InspectionResultCode2Vers Version
InspectionResultCode3Vers InspectionResultCode3Vers Version
InspectionResultCode4Vers InspectionResultCode4Vers Version
InspectionResultCode5Vers InspectionResultCode5Vers Version
InspectionResultCodeGroup2 InspectionResultCodeGroup2 Code Group
InspectionResultCodeGroup3 InspectionResultCodeGroup3 Code Group
InspectionResultCodeGroup4 InspectionResultCodeGroup4 Code Group
InspectionResultCodeGroup5 InspectionResultCodeGroup5 Code Group
DefectClass DefectClass Defect Class
InspectionPartialSampleSize InspectionPartialSampleSize Partial Samples
InspectionStartDate InspectionStartDate Insp.Start Date
InspectionStartTime InspectionStartTime Insp.Start Time
InspectionEndDate InspectionEndDate
InspectionEndTime InspectionEndTime Insp. End Time
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
_InspectionCharacteristic _InspectionCharacteristic
_InspectionResultValue _InspectionResultValue
_CharcAttributeCode _CharcAttributeCode
_CharcAttributeCodeGrp _CharcAttributeCodeGrp
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation
_InspectionResultAttribute _InspectionResultAttribute
_InspectionResultOrigin _InspectionResultOrigin
_InspectionResultStatus _InspectionResultStatus
_InspectionValuationResult _InspectionValuationResult
_InspResultDynModifValuation _InspResultDynModifValuation
_InspResultLongText _InspResultLongText

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_InspectionResultTP.
-- 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_InspectionResultTP 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 I_InspectionResult
LEFT OUTER JOIN R_InspectionOperationTP AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN R_InspectionLotTP AS _InspectionLot ON InspectionLot = _InspectionLot.InspectionLot  -- association [1..1]
LEFT OUTER JOIN R_InspectionResultValueTP AS _InspectionResultValue ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More