I_InspPlanPRTOpTP
Inspection Plan Op Prod Res Tool TP View
I_InspPlanPRTOpTP is a Transactional CDS View that provides data about "Inspection Plan Op Prod Res Tool TP View" in SAP S/4HANA. It has 2 associations to related views. Part of development package VDM_QM_PLANNING.
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_InspPlanOperationTP | _InspPlanOp | $projection.InspectionPlanGroup = _InspPlanOp.InspectionPlanGroup and $projection.InspectionPlan = _InspPlanOp.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlanOp.InspectionPlanInternalVersion and $projection.BOOOperationInternalID = _InspPlanOp.BOOOperationInternalID and $projection.BOOOpInternalVersionCounter = _InspPlanOp.BOOOpInternalVersionCounter and $projection.BillOfOperationsType = _InspPlanOp.BillOfOperationsType |
| [1..1] | I_InspectionPlanTP | _InspPlan | $projection.InspectionPlanGroup = _InspPlan.InspectionPlanGroup and $projection.InspectionPlan = _InspPlan.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion and $projection.BillOfOperationsType = _InspPlan.BillOfOperationsType |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Inspection Plan Op Prod Res Tool TP View | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #M | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | true | view | |
| ObjectModel.deleteEnabled | true | view | |
| ObjectModel.writeDraftPersistence | QIPPRT_D | view |
Fields (65)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InspectionPlanGroup | InspectionPlanGroup | ||
| KEY | InspectionPlan | InspectionPlan | ||
| KEY | InspectionPlanInternalVersion | InspectionPlanInternalVersion | ||
| KEY | BOOOperationInternalID | BOOOperationInternalID | ||
| KEY | BOOOpInternalVersionCounter | BOOOpInternalVersionCounter | ||
| KEY | BOOOperationPRTInternalID | BOOOperationPRTInternalID | ||
| KEY | BillOfOperationsType | BillOfOperationsType | ||
| BillOfOperationsSequence | BillOfOperationsSequence | |||
| OperationText | _InspPlanOp | OperationText | ||
| BillOfOperationsDesc | _InspPlan | BillOfOperationsDesc | ||
| ProductionResourceType | ProductionResourceType | |||
| ProductionResourceInternalID | ProductionResourceInternalID | |||
| ProdnRsceToolCategoryName | ProdnRsceToolCategoryName | |||
| ProductionResourceTool | ProductionResourceTool | |||
| ProductionResourceToolDesc | ProductionResourceToolDesc | |||
| ValidityStartDate | ValidityStartDate | |||
| ValidityEndDate | ValidityEndDate | |||
| ChangeNumber | ChangeNumber | |||
| ProdnRsceToolItemNumber | ProdnRsceToolItemNumber | |||
| ProdnRsceToolControlProfile | ProdnRsceToolControlProfile | |||
| ProdnRsceToolStandardTextCode | ProdnRsceToolStandardTextCode | |||
| ProdnRsceToolText | ProdnRsceToolText | |||
| CreationDate | CreationDate | |||
| CreatedByUser | CreatedByUser | |||
| LastChangeDate | LastChangeDate | |||
| LastChangedByUser | LastChangedByUser | |||
| IsDeleted | IsDeleted | |||
| IsImplicitlyDeleted | IsImplicitlyDeleted | |||
| ProdnRsceToolStdWorkQtyUnit | ProdnRsceToolStdWorkQtyUnit | |||
| ProdnRsceToolStandardWorkQty | ProdnRsceToolStandardWorkQty | |||
| ProdnRsceToolTotQtyCalcFormula | ProdnRsceToolTotQtyCalcFormula | |||
| ProdnRsceToolUsageQuantityUnit | ProdnRsceToolUsageQuantityUnit | |||
| ProdnRsceToolUsageQuantity | ProdnRsceToolUsageQuantity | |||
| ProdnRsceToolUsageQtyCalcFmla | ProdnRsceToolUsageQtyCalcFmla | |||
| StartDateOffsetReferenceCode | StartDateOffsetReferenceCode | |||
| StartDateOffsetDurationUnit | StartDateOffsetDurationUnit | |||
| StartDateOffsetDuration | StartDateOffsetDuration | |||
| EndDateOffsetReferenceCode | EndDateOffsetReferenceCode | |||
| EndDateOffsetDurationUnit | EndDateOffsetDurationUnit | |||
| EndDateOffsetDuration | EndDateOffsetDuration | |||
| BillOfOperationsVersion | BillOfOperationsVersion | |||
| _BillOfOperations | _BillOfOperations | |||
| _BillOfOperationsGroup | _BillOfOperationsGroup | |||
| _BillOfOperationsOperation | _BillOfOperationsOperation | |||
| _BillOfOperationsSequence | _BillOfOperationsSequence | |||
| _BillOfOperationsType | _BillOfOperationsType | |||
| _BOOOperationInternalID | _BOOOperationInternalID | |||
| _BOOOperationPRTInternalID | _BOOOperationPRTInternalID | |||
| _ChangeMaster | _ChangeMaster | |||
| _CreatedByUser | _CreatedByUser | |||
| _EndDateOffsetDurationUnit | _EndDateOffsetDurationUnit | |||
| _EndDateOffsetReferenceCode | _EndDateOffsetReferenceCode | |||
| _LastChangedByUser | _LastChangedByUser | |||
| _ProdnResourceToolUsageUnit | _ProdnResourceToolUsageUnit | |||
| _ProdnRsceToolControlProfile | _ProdnRsceToolControlProfile | |||
| _ProdnRsceToolMasterData | _ProdnRsceToolMasterData | |||
| _ProdnRsceToolStandardText | _ProdnRsceToolStandardText | |||
| _ProdnRsceToolTotQtyCalcFmla | _ProdnRsceToolTotQtyCalcFmla | |||
| _ProdnRsceToolUsageQtyCalcFmla | _ProdnRsceToolUsageQtyCalcFmla | |||
| _ProductionResourceToolUnit | _ProductionResourceToolUnit | |||
| _StartDateOffsetDurationUnit | _StartDateOffsetDurationUnit | |||
| _StartDateOffsetReferenceCode | _StartDateOffsetReferenceCode | |||
| _ProductionResourceType | _ProductionResourceType | |||
| _InspPlanOp | _InspPlanOp | |||
| _InspPlan | _InspPlan |
@EndUserText.label: 'Inspection Plan Op Prod Res Tool TP View'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: { serviceQuality: #C, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel:{
// draftEnabled : true,
createEnabled: true,
updateEnabled: true,
deleteEnabled: true,
writeDraftPersistence: 'QIPPRT_D'
}
define view entity I_InspPlanPRTOpTP
as select distinct from I_InspPlanOpPRT as _InspPlanOpPRT
association [1..1] to I_InspPlanOperationTP as _InspPlanOp on $projection.InspectionPlanGroup = _InspPlanOp.InspectionPlanGroup
and $projection.InspectionPlan = _InspPlanOp.InspectionPlan
and $projection.InspectionPlanInternalVersion = _InspPlanOp.InspectionPlanInternalVersion
and $projection.BOOOperationInternalID = _InspPlanOp.BOOOperationInternalID
and $projection.BOOOpInternalVersionCounter = _InspPlanOp.BOOOpInternalVersionCounter
and $projection.BillOfOperationsType = _InspPlanOp.BillOfOperationsType
association [1..1] to I_InspectionPlanTP as _InspPlan on $projection.InspectionPlanGroup = _InspPlan.InspectionPlanGroup
and $projection.InspectionPlan = _InspPlan.InspectionPlan
and $projection.InspectionPlanInternalVersion = _InspPlan.InspectionPlanInternalVersion
and $projection.BillOfOperationsType = _InspPlan.BillOfOperationsType
{
//_InspPlanOpPRTAssgmt
key InspectionPlanGroup,
key InspectionPlan,
key InspectionPlanInternalVersion,
key BOOOperationInternalID,
key BOOOpInternalVersionCounter,
key BOOOperationPRTInternalID,
key BillOfOperationsType,
BillOfOperationsSequence,
_InspPlanOp.OperationText,
_InspPlan.BillOfOperationsDesc,
// Billofoperationdesc,
// BOOOperationPRTIntVersCounter,
ProductionResourceType,
ProductionResourceInternalID,
// ProdnRsceToolCategory,
ProdnRsceToolCategoryName,
ProductionResourceTool,
ProductionResourceToolDesc,
ValidityStartDate,
ValidityEndDate,
ChangeNumber,
ProdnRsceToolItemNumber,
ProdnRsceToolControlProfile,
ProdnRsceToolStandardTextCode,
ProdnRsceToolText,
CreationDate,
CreatedByUser,
LastChangeDate,
LastChangedByUser,
IsDeleted,
IsImplicitlyDeleted,
ProdnRsceToolStdWorkQtyUnit,
@Semantics.quantity.unitOfMeasure: 'PRODNRSCETOOLSTDWORKQTYUNIT'
ProdnRsceToolStandardWorkQty,
ProdnRsceToolTotQtyCalcFormula,
ProdnRsceToolUsageQuantityUnit,
@Semantics.quantity.unitOfMeasure: 'PRODNRSCETOOLUSAGEQUANTITYUNIT'
ProdnRsceToolUsageQuantity,
ProdnRsceToolUsageQtyCalcFmla,
StartDateOffsetReferenceCode,
StartDateOffsetDurationUnit,
@Semantics.quantity.unitOfMeasure: 'STARTDATEOFFSETDURATIONUNIT'
StartDateOffsetDuration,
EndDateOffsetReferenceCode,
EndDateOffsetDurationUnit,
@Semantics.quantity.unitOfMeasure: 'ENDDATEOFFSETDURATIONUNIT'
EndDateOffsetDuration,
BillOfOperationsVersion,
/* Associations */
//_InspPlanOpPRTAssgmt
_BillOfOperations,
_BillOfOperationsGroup,
_BillOfOperationsOperation,
_BillOfOperationsSequence,
_BillOfOperationsType,
_BOOOperationInternalID,
_BOOOperationPRTInternalID,
_ChangeMaster,
_CreatedByUser,
_EndDateOffsetDurationUnit,
_EndDateOffsetReferenceCode,
// _InspectionPlan,
// _InspectionPlanVersion,
_LastChangedByUser,
_ProdnResourceToolUsageUnit,
_ProdnRsceToolControlProfile,
_ProdnRsceToolMasterData,
_ProdnRsceToolStandardText,
_ProdnRsceToolTotQtyCalcFmla,
_ProdnRsceToolUsageQtyCalcFmla,
_ProductionResourceToolUnit,
// _ProductionResourceType,
_StartDateOffsetDurationUnit,
_StartDateOffsetReferenceCode,
// _ProdnRsceToolCategory,
_ProductionResourceType,
@ObjectModel.association.type: [#TO_COMPOSITION_PARENT]
_InspPlanOp,
@ObjectModel.association.type: [#TO_COMPOSITION_ROOT]
_InspPlan
}
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