R_InspSubsetCharacteristicTP
Inspection Point Characteristic - TP
R_InspSubsetCharacteristicTP is a Transactional CDS View that provides data about "Inspection Point Characteristic - TP" in SAP S/4HANA. It reads from 2 data sources (I_InspectionLot, I_InspSubsetCharacteristic) and exposes 25 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID, InspectionCharacteristic. It has 2 associations to related views. Part of development package VDM_QM_INSPECTION.
Data Sources (2)
| Source | Alias | Join Type |
|---|---|---|
| I_InspectionLot | InspectionLot | inner |
| I_InspSubsetCharacteristic | InspSubsetCharacteristic | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | R_InspectionLotTP | _InspectionLot | $projection.InspectionLot = _InspectionLot.InspectionLot |
| [1..1] | R_InspectionOperationTP | _InspectionOperation | $projection.InspectionLot = _InspectionOperation.InspectionLot and $projection.InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #MANDATORY | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| EndUserText.label | Inspection Point Characteristic - 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 (25)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InspectionLot | I_InspSubsetCharacteristic | InspectionLot | |
| KEY | InspPlanOperationInternalID | I_InspSubsetCharacteristic | InspPlanOperationInternalID | |
| KEY | InspectionSubsetInternalID | I_InspSubsetCharacteristic | InspectionSubsetInternalID | |
| KEY | InspectionCharacteristic | I_InspSubsetCharacteristic | InspectionCharacteristic | |
| InspectionCharacteristicStatus | I_InspSubsetCharacteristic | InspectionCharacteristicStatus | ||
| QualityControlChart | I_InspSubsetCharacteristic | QualityControlChart | ||
| InspSampleAcceptanceNumber | I_InspSubsetCharacteristic | InspSampleAcceptanceNumber | ||
| InspSampleRejectionNumber | I_InspSubsetCharacteristic | InspSampleRejectionNumber | ||
| InspSampleHasAcceptanceFactor | I_InspSubsetCharacteristic | InspSampleHasAcceptanceFactor | ||
| InspSampleAcceptanceFactor | I_InspSubsetCharacteristic | InspSampleAcceptanceFactor | ||
| DefectFractionEstimationProced | I_InspSubsetCharacteristic | DefectFractionEstimationProced | ||
| InspSampleValuationRule | I_InspSubsetCharacteristic | InspSampleValuationRule | ||
| BOOCharcMatlToSampleUnitRate | I_InspSubsetCharacteristic | BOOCharcMatlToSampleUnitRate | ||
| BOOCharcSampleToMatlUnitRate | I_InspSubsetCharacteristic | BOOCharcSampleToMatlUnitRate | ||
| InspectionSampleSize | I_InspSubsetCharacteristic | InspectionSampleSize | ||
| InspCharacteristicSampleUnit | I_InspSubsetCharacteristic | InspCharacteristicSampleUnit | ||
| InspSpecSampleQuantityFactor | I_InspSubsetCharacteristic | InspSpecSampleQuantityFactor | ||
| InspectionSampleQuantity | I_InspSubsetCharacteristic | InspectionSampleQuantity | ||
| InspectionLotSampleUnit | I_InspSubsetCharacteristic | InspectionLotSampleUnit | ||
| InspLotDynRuleStage | I_InspSubsetCharacteristic | InspLotDynRuleStage | ||
| InspectionSeverity | I_InspSubsetCharacteristic | InspectionSeverity | ||
| InspSubsetCharcCreationDate | I_InspSubsetCharacteristic | InspSubsetCharcCreationDate | ||
| _InspectionSubset | _InspectionSubset | |||
| _InspectionLot | _InspectionLot | |||
| _InspectionOperation | _InspectionOperation |
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #TRANSACTIONAL
@EndUserText.label: 'Inspection Point Characteristic - TP'
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
serviceQuality: #B,
sizeCategory: #L,
dataClass: #TRANSACTIONAL
}
define view entity R_InspSubsetCharacteristicTP
as select from I_InspSubsetCharacteristic as InspSubsetCharacteristic
inner join I_InspectionLot as InspectionLot on InspectionLot.InspectionLot = InspSubsetCharacteristic.InspectionLot
and InspectionLot.InspLotHasSubsets = 'X'
association to parent R_InspectionSubsetTP as _InspectionSubset on $projection.InspectionLot = _InspectionSubset.InspectionLot
and $projection.InspPlanOperationInternalID = _InspectionSubset.InspPlanOperationInternalID
and $projection.InspectionSubsetInternalID = _InspectionSubset.InspectionSubsetInternalID
association [1..1] to R_InspectionLotTP as _InspectionLot on $projection.InspectionLot = _InspectionLot.InspectionLot
association [1..1] to R_InspectionOperationTP as _InspectionOperation on $projection.InspectionLot = _InspectionOperation.InspectionLot
and $projection.InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID
{
key InspSubsetCharacteristic.InspectionLot,
key InspSubsetCharacteristic.InspPlanOperationInternalID,
key InspSubsetCharacteristic.InspectionSubsetInternalID,
key InspSubsetCharacteristic.InspectionCharacteristic,
InspSubsetCharacteristic.InspectionCharacteristicStatus,
InspSubsetCharacteristic.QualityControlChart,
InspSubsetCharacteristic.InspSampleAcceptanceNumber,
InspSubsetCharacteristic.InspSampleRejectionNumber,
@Semantics.booleanIndicator
InspSubsetCharacteristic.InspSampleHasAcceptanceFactor,
InspSubsetCharacteristic.InspSampleAcceptanceFactor,
InspSubsetCharacteristic.DefectFractionEstimationProced,
InspSubsetCharacteristic.InspSampleValuationRule,
InspSubsetCharacteristic.BOOCharcMatlToSampleUnitRate,
InspSubsetCharacteristic.BOOCharcSampleToMatlUnitRate,
InspSubsetCharacteristic.InspectionSampleSize,
InspSubsetCharacteristic.InspCharacteristicSampleUnit,
InspSubsetCharacteristic.InspSpecSampleQuantityFactor,
@Semantics.quantity.unitOfMeasure: 'InspCharacteristicSampleUnit'
InspSubsetCharacteristic.InspectionSampleQuantity,
InspSubsetCharacteristic.InspectionLotSampleUnit,
InspSubsetCharacteristic.InspLotDynRuleStage,
InspSubsetCharacteristic.InspectionSeverity,
InspSubsetCharacteristic.InspSubsetCharcCreationDate,
_InspectionSubset,
_InspectionLot,
_InspectionOperation
}
where
InspSubsetCharacteristic.InspectionSubsetInternalID <> '000000'
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