P_MPEInspectionSubset
Inspection Point of Inspection Operation
P_MPEInspectionSubset is a Composite CDS View that provides data about "Inspection Point of Inspection Operation" in SAP S/4HANA. It reads from 1 data source (I_InspectionSubset) and exposes 8 fields with key fields InspectionLot, InspectionSubsetInternalID, InspPlanOperationInternalID.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InspectionSubset | inspSubset | from |
Annotations (8)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| EndUserText.label | Inspection Point of Inspection Operation | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.representativeKey | InspectionSubsetInternalID | view |
Fields (8)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InspectionLot | I_InspectionSubset | InspectionLot | |
| KEY | InspectionSubsetInternalID | I_InspectionSubset | InspectionSubsetInternalID | |
| KEY | InspPlanOperationInternalID | I_InspectionSubset | InspPlanOperationInternalID | |
| InspSubsetUsageDcsnValuation | I_InspectionSubset | InspSubsetUsageDcsnValuation | ||
| OrderInternalBillOfOperations | inspOp | OrderInternalBillOfOperations | ||
| OrderOperationInternalID | inspOp | OrderOperationInternalID | ||
| _InspectionLot | I_InspectionSubset | _InspectionLot | ||
| _InspectionOperation | I_InspectionSubset | _InspectionOperation |
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Inspection Point of Inspection Operation'
@VDM: {
viewType: #COMPOSITE,
private: true
}
@ObjectModel: {
usageType: { serviceQuality: #B, sizeCategory: #L, dataClass: #TRANSACTIONAL },
representativeKey: 'InspectionSubsetInternalID'
}
define view entity P_MPEInspectionSubset
as select from I_InspectionSubset as inspSubset
left outer to one join I_InspectionOperation as inspOp on inspSubset.InspectionLot = inspOp.InspectionLot
and inspSubset.InspPlanOperationInternalID = inspOp.InspPlanOperationInternalID
{
@ObjectModel.foreignKey.association: '_InspectionLot'
key inspSubset.InspectionLot,
key inspSubset.InspectionSubsetInternalID,
@ObjectModel.foreignKey.association: '_InspectionOperation'
key inspSubset.InspPlanOperationInternalID,
inspSubset.InspSubsetUsageDcsnValuation,
inspOp.OrderInternalBillOfOperations,
inspOp.OrderOperationInternalID,
// Associations
inspSubset._InspectionLot,
inspSubset._InspectionOperation
}
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