R_InspectionResultValueTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_InspectionResultValue | I_InspectionResultValue | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA