I_InspectionSubsetTP
Inspection Point of Inspection Operation
I_InspectionSubsetTP is a Transactional 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 60 fields with key fields InspectionLot, InspPlanOperationInternalID, InspectionSubsetInternalID. It has 3 associations to related views. Part of development package VDM_QM_INSPECTION.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InspectionSubset | InspectionSubset | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | I_InspSubsetCharcResultTP | _InspSubsetCharcResult | $projection.InspectionLot = _InspSubsetCharcResult.InspectionLot and $projection.InspPlanOperationInternalID = _InspSubsetCharcResult.InspPlanOperationInternalID and $projection.InspectionSubsetInternalID = _InspSubsetCharcResult.InspectionSubsetInternalID |
| [1..1] | I_UserContactCard | _CreatedByUser | $projection.UserID = _CreatedByUser.ContactCardID |
| [1..1] | I_UserContactCard | _LastChangedByUser | $projection.ContactCardID = _LastChangedByUser.ContactCardID |
Annotations (18)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | Inspection Point of Inspection Operation | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.transactionalProcessingEnabled | true | view | |
| ObjectModel.draftEnabled | true | view | |
| ObjectModel.writeDraftPersistence | QINSPSUBSETRR_D | view | |
| ObjectModel.entityChangeStateId | ChangedDateTime | view | |
| ObjectModel.lifecycle.enqueue.expiryBehavior | #RELATIVE_TO_LAST_CHANGE | view | |
| ObjectModel.lifecycle.enqueue.expiryInterval | PT15M | view | |
| ObjectModel.lifecycle.processing.expiryBehavior | #RELATIVE_TO_LAST_CHANGE | view | |
| ObjectModel.lifecycle.processing.expiryInterval | PT30M | view |
Fields (60)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InspectionLot | I_InspectionSubset | InspectionLot | |
| KEY | InspPlanOperationInternalID | I_InspectionSubset | InspPlanOperationInternalID | |
| KEY | InspectionSubsetInternalID | I_InspectionSubset | InspectionSubsetInternalID | |
| InspectionLotForEdit | ||||
| InspectionOperationForEdit | ||||
| InspectionOperation | ||||
| InspSubsetStatus | ||||
| InspectionSubsetSortKey | I_InspectionSubset | InspectionSubsetSortKey | ||
| InspectionOperations | ||||
| ChangedDateTime | I_InspectionSubset | ChangedDateTime | ||
| InspSubsetTimeInterval | ||||
| InspSubsetTimeIntervalUnit | ||||
| SelectedCodeSetPlant | SelectedCodeSet | SelectedCodeSetPlant | ||
| SelectedCodeSet | SelectedCodeSet | SelectedCodeSet | ||
| InspSubsetUsageDcsnCodeGroup | I_InspectionSubset | InspSubsetUsageDcsnCodeGroup | ||
| InspSubsetUsageDcsnCode | I_InspectionSubset | InspSubsetUsageDcsnCode | ||
| InspSubsetUsageDcsnValuation | I_InspectionSubset | InspSubsetUsageDcsnValuation | ||
| InspectionSubsetTime | I_InspectionSubset | InspectionSubsetTime | ||
| InspSbstTimeFldProperty | SelectedCodeSet | InspSbstTimeFldProperty | ||
| InspectionSubsetDate | I_InspectionSubset | InspectionSubsetDate | ||
| InspSbstDateFldProperty | SelectedCodeSet | InspSbstDateFldProperty | ||
| InspectionSubsetTimeZone | I_InspectionSubset | InspectionSubsetTimeZone | ||
| InspSubsetLongNumericKey | I_InspectionSubset | InspSubsetLongNumericKey | ||
| InspSbstLongNmbrFldProperty | I_InspectionSubset | InspSbstLongNmbrFldProperty | ||
| InspSubsetShortNumericKey | I_InspectionSubset | InspSubsetShortNumericKey | ||
| InspSbstShrtNmbrFldProperty | I_InspectionSubset | InspSbstShrtNmbrFldProperty | ||
| InspectionSubsetLongCharKey | I_InspectionSubset | InspectionSubsetLongCharKey | ||
| InspSbstLongTxtFldProperty | I_InspectionSubset | InspSbstLongTxtFldProperty | ||
| InspectionSubsetShortCharKey | I_InspectionSubset | InspectionSubsetShortCharKey | ||
| InspSbstShrtTxtFldProperty | I_InspectionSubset | InspSbstShrtTxtFldProperty | ||
| InspSubsetTimeFieldName | SelectedCodeSet | InspSubsetTimeFieldName | ||
| InspSubsetDateFieldName | SelectedCodeSet | InspSubsetDateFieldName | ||
| InspSubsetLongTxtFieldName | SelectedCodeSet | InspSubsetLongTxtFieldName | ||
| InspSubsetShortTxtFieldName | SelectedCodeSet | InspSubsetShortTxtFieldName | ||
| InspSubsetLongNmbrFieldName | SelectedCodeSet | InspSubsetLongNmbrFieldName | ||
| InspSubsetShortNmbrFieldName | SelectedCodeSet | InspSubsetShortNmbrFieldName | ||
| InspectionSubsetYieldQty | I_InspectionSubset | InspectionSubsetYieldQty | ||
| InspectionSubsetScrapQty | I_InspectionSubset | InspectionSubsetScrapQty | ||
| InspectionSubsetReworkQty | I_InspectionSubset | InspectionSubsetReworkQty | ||
| InspectionSubsetQtyUnit | I_InspectionSubset | InspectionSubsetQtyUnit | ||
| Inspector | I_InspectionSubset | Inspector | ||
| UserID | I_InspectionSubset | CreatedByUser | ||
| ContactCardID | I_InspectionSubset | LastChangedByUser | ||
| CreatedByUser | _CreatedByUser | FullName | ||
| CreationDate | I_InspectionSubset | CreationDate | ||
| CreationTime | I_InspectionSubset | CreationTime | ||
| LastChangedByUser | _LastChangedByUser | FullName | ||
| LastChangeDate | I_InspectionSubset | LastChangeDate | ||
| LastChangeTime | I_InspectionSubset | LastChangeTime | ||
| _InspSubsetCharcResult | _InspSubsetCharcResult | |||
| _InspectionLot | I_InspectionSubset | _InspectionLot | ||
| _InspectionOperation | I_InspectionSubset | _InspectionOperation | ||
| _InspectionSubsetInternalID | I_InspectionSubset | _InspectionSubsetInternalID | ||
| _CreatedByUser | _CreatedByUser | |||
| _LastChangedByUser | _LastChangedByUser | |||
| _UsageDecisionCodeGroup | I_InspectionSubset | _UsageDecisionCodeGroup | ||
| _UsageDecisionCode | I_InspectionSubset | _UsageDecisionCode | ||
| _InspSubsetUsageDcsnValn | I_InspectionSubset | _InspSubsetUsageDcsnValn | ||
| _InspSubsetUsageDcsnValnTxt | I_InspectionSubset | _InspSubsetUsageDcsnValnTxt | ||
| _Unit | I_InspectionSubset | _Unit |
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inspection Point of Inspection Operation'
@VDM.viewType: #TRANSACTIONAL
@AccessControl.privilegedAssociations: [ '_CreatedByUser' ]
//@ObjectModel.representativeKey: 'InspectionSubsetInternalID'
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #L, dataClass: #TRANSACTIONAL }
/* Draft 2.0 */
//@ObjectModel.modelCategory: #BUSINESS_OBJECT
@ObjectModel.semanticKey: [ 'InspectionLot' , 'InspectionSubsetInternalID' , 'InspPlanOperationInternalID' ]
@ObjectModel:{
compositionRoot: true,
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
transactionalProcessingEnabled: true,
draftEnabled: true,
writeDraftPersistence: 'QINSPSUBSETRR_D',
entityChangeStateId: 'ChangedDateTime',
lifecycle.enqueue: {
expiryBehavior: #RELATIVE_TO_LAST_CHANGE, // Default #RELATIVE_TO_LAST_CHANGE
expiryInterval: 'PT15M' // Default 'PT15M'
// notificationBeforeExpiryInterval: 'PT1M' // Default 'PT5M'
},
lifecycle.processing: {
expiryBehavior: #RELATIVE_TO_LAST_CHANGE, // Default #RELATIVE_TO_LAST_CHANGE
expiryInterval: 'PT30M' // Default 'PT30M'
// notificationBeforeExpiryInterval: 'PT3M' // Default 'PT10M'
}
}
define view entity I_InspectionSubsetTP
as select from I_InspectionSubset as InspectionSubset
left outer to one join P_InspUsgeDcsnSelectedSetCode as SelectedCodeSet on InspectionSubset.InspectionLot = SelectedCodeSet.InspectionLot
association [0..*] to I_InspSubsetCharcResultTP as _InspSubsetCharcResult on $projection.InspectionLot = _InspSubsetCharcResult.InspectionLot
and $projection.InspPlanOperationInternalID = _InspSubsetCharcResult.InspPlanOperationInternalID
and $projection.InspectionSubsetInternalID = _InspSubsetCharcResult.InspectionSubsetInternalID
association [1..1] to I_UserContactCard as _CreatedByUser on $projection.UserID = _CreatedByUser.ContactCardID
association [1..1] to I_UserContactCard as _LastChangedByUser on $projection.ContactCardID = _LastChangedByUser.ContactCardID
{
@ObjectModel.foreignKey.association: '_InspectionLot'
key InspectionSubset.InspectionLot,
@ObjectModel.foreignKey.association: '_InspectionOperation'
key InspectionSubset.InspPlanOperationInternalID,
key InspectionSubset.InspectionSubsetInternalID,
cast(InspectionSubset.InspectionLot as qplos preserving type ) as InspectionLotForEdit,
cast(InspectionSubset.InspPlanOperationInternalID as qlfnkn preserving type ) as InspectionOperationForEdit,
InspectionSubset._InspectionOperation.InspectionOperation,
//@ObjectModel.readOnly: true
cast('' as abap.char( 2 )) as InspSubsetStatus,
InspectionSubset.InspectionSubsetSortKey,
//@ObjectModel.readOnly: true
cast ('' as abap.char(1333)) as InspectionOperations,
// Field for E-tag
@ObjectModel.readOnly: true
InspectionSubset.ChangedDateTime,
cast(00000 as qrastzfak) as InspSubsetTimeInterval,
cast('' as qrastzeht) as InspSubsetTimeIntervalUnit,
SelectedCodeSet.SelectedCodeSetPlant,
// @ObjectModel.foreignKey.association: '_SelectedCodeSet'
SelectedCodeSet.SelectedCodeSet,
@ObjectModel.foreignKey.association: '_UsageDecisionCodeGroup'
InspectionSubset.InspSubsetUsageDcsnCodeGroup,
InspectionSubset.InspSubsetUsageDcsnCode,
@ObjectModel.foreignKey.association: '_InspSubsetUsageDcsnValn'
InspectionSubset.InspSubsetUsageDcsnValuation,
InspectionSubset.InspectionSubsetTime,
SelectedCodeSet.InspSbstTimeFldProperty,
InspectionSubset.InspectionSubsetDate,
SelectedCodeSet.InspSbstDateFldProperty,
InspectionSubset.InspectionSubsetTimeZone,
InspectionSubset.InspSubsetLongNumericKey,
InspectionSubset.InspSbstLongNmbrFldProperty,
InspectionSubset.InspSubsetShortNumericKey,
InspectionSubset.InspSbstShrtNmbrFldProperty,
InspectionSubset.InspectionSubsetLongCharKey,
InspectionSubset.InspSbstLongTxtFldProperty,
InspectionSubset.InspectionSubsetShortCharKey,
InspectionSubset.InspSbstShrtTxtFldProperty,
SelectedCodeSet.InspSubsetTimeFieldName,
SelectedCodeSet.InspSubsetDateFieldName,
@Feature: 'QM_IPRR_USER_FIELDS'
SelectedCodeSet.InspSubsetLongTxtFieldName,
@Feature: 'QM_IPRR_USER_FIELDS'
SelectedCodeSet.InspSubsetShortTxtFieldName,
@Feature: 'QM_IPRR_USER_FIELDS'
SelectedCodeSet.InspSubsetLongNmbrFieldName,
@Feature: 'QM_IPRR_USER_FIELDS'
SelectedCodeSet.InspSubsetShortNmbrFieldName,
// @DefaultAggregation:#NONE
@Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
InspectionSubset.InspectionSubsetYieldQty,
// @DefaultAggregation:#NONE
@Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
InspectionSubset.InspectionSubsetScrapQty,
// @DefaultAggregation:#NONE
@Semantics.quantity.unitOfMeasure: 'InspectionSubsetQtyUnit'
InspectionSubset.InspectionSubsetReworkQty,
@ObjectModel.foreignKey.association: '_Unit'
InspectionSubset.InspectionSubsetQtyUnit,
// vetext as InspectionSubset, QALT.vetext
InspectionSubset.Inspector,
// cast( InspectionSubsetDate as abap.char(8) ) as InspSubsetDateTime,
@ObjectModel.readOnly: true
InspectionSubset.CreatedByUser as UserID,
@ObjectModel.readOnly: true
InspectionSubset.LastChangedByUser as ContactCardID,
@ObjectModel.readOnly: true
_CreatedByUser.FullName as CreatedByUser,
// @Semantics.businessDate.createdAt: true
@ObjectModel.readOnly: true
InspectionSubset.CreationDate,
@Semantics.time: true
@ObjectModel.readOnly: true
InspectionSubset.CreationTime,
@ObjectModel.readOnly: true
_LastChangedByUser.FullName as LastChangedByUser,
// @Semantics.businessDate.lastChangedAt: true
@ObjectModel.readOnly: true
InspectionSubset.LastChangeDate,
@Semantics.time: true
@ObjectModel.readOnly: true
InspectionSubset.LastChangeTime,
// Draft Associations
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_InspSubsetCharcResult,
// Associations
InspectionSubset._InspectionLot,
InspectionSubset._InspectionOperation,
InspectionSubset._InspectionSubsetInternalID,
_CreatedByUser,
_LastChangedByUser,
InspectionSubset._UsageDecisionCodeGroup,
InspectionSubset._UsageDecisionCode,
// _SelectedCodeSet,
InspectionSubset._InspSubsetUsageDcsnValn,
InspectionSubset._InspSubsetUsageDcsnValnTxt,
// _MaterialSample,
// _FunctionalLocation,
// _ShopFloorItem,
// _Equipment,
InspectionSubset._Unit
}
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