R_InspectionResultValueTP

DDL: R_INSPECTIONRESULTVALUETP Type: view_entity TRANSACTIONAL

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
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
InspectionStartDate InspectionStartDate
InspectionStartTime InspectionStartTime
InspectionEndDate InspectionEndDate
InspectionEndTime InspectionEndTime
InspectionNumberOfDefects InspectionNumberOfDefects
DefectClass DefectClass
InspResultNrOfAddlDcmlsPlaces InspResultNrOfAddlDcmlsPlaces
CreatedByUser CreatedByUser
CreationDate CreationDate
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
ChangedTime ChangedTime
CreationTime CreationTime
_CharcAttributeCode _CharcAttributeCode
_CharcAttributeCodeGrp _CharcAttributeCodeGrp
_InspectionCharacteristic _InspectionCharacteristic
_InspectionLot _InspectionLot
_InspectionOperation _InspectionOperation
_InspectionResultAttribute _InspectionResultAttribute
_InspectionResult _InspectionResult
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY 
@EndUserText.label: 'Single Inspection Result - TP'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #TRANSACTIONAL
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #B,
  sizeCategory: #XL,
  dataClass: #TRANSACTIONAL
}
define view entity R_InspectionResultValueTP
  as select from I_InspectionResultValue

  association        to parent R_InspectionResultTP  as _InspectionResult         on  $projection.InspectionLot               = _InspectionResult.InspectionLot
                                                                                  and $projection.InspPlanOperationInternalID = _InspectionResult.InspPlanOperationInternalID
                                                                                  and $projection.InspectionCharacteristic    = _InspectionResult.InspectionCharacteristic

  association [1..1] to R_InspectionCharacteristicTP as _InspectionCharacteristic on  $projection.InspectionLot               = _InspectionCharacteristic.InspectionLot
                                                                                  and $projection.InspPlanOperationInternalID = _InspectionCharacteristic.InspPlanOperationInternalID
                                                                                  and $projection.InspectionCharacteristic    = _InspectionCharacteristic.InspectionCharacteristic

  association [1..1] to R_InspectionLotTP            as _InspectionLot            on  $projection.InspectionLot = _InspectionLot.InspectionLot

{
  key InspectionLot,
  key InspPlanOperationInternalID,
  key InspectionCharacteristic,
  key InspResultValueInternalID,
      InspectionResultAttribute,
      InspResultItemInternalID,
      InspectionSubsetInternalID,
      InspectionResultMeasuredValue,
      @Semantics.booleanIndicator: true        
      InspResultHasMeasuredValue,
      InspectionResultOriginalValue,
      InspectionResultText,
      @Semantics.booleanIndicator: true        
      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,
      /* Associations */
      _CharcAttributeCode,
      _CharcAttributeCodeGrp,
      _InspectionCharacteristic,
      _InspectionLot,
      _InspectionOperation,
      _InspectionResultAttribute,
      _InspectionResult
}
where InspectionSubsetInternalID is initial
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONRESULTVALUE"
],
"ASSOCIATED":
[
"I_CHARCATTRIBUTECODE",
"I_CHARCATTRIBUTECODEGRP",
"I_INSPECTIONOPERATION",
"I_INSPECTIONRESULTATTRIBUTE",
"R_INSPECTIONCHARACTERISTICTP",
"R_INSPECTIONLOTTP",
"R_INSPECTIONRESULTTP"
],
"BASE":
[
"I_INSPECTIONRESULTVALUE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/