Which tables does I_InspPlanOperationTP use?

I_InspPlanOperationTP reads from 1 data source(s): I_InspPlanOpAssgmtVersion.

I_InspPlanOperationTP

Q: How many fields does I_InspPlanOperationTP have?

I_InspPlanOperationTP has 45 fields. Key fields: InspectionPlanGroup, InspectionPlan, InspectionPlanInternalVersion, BOOOperationInternalID, BOOOpInternalVersionCounter.

DDL: I_INSPPLANOPERATIONTP SQL: IINSPPLOPTP Type: view TRANSACTIONAL Package: VDM_QM_PLANNING

Inspection Plan Operation Version

I_InspPlanOperationTP is a Transactional CDS View that provides data about "Inspection Plan Operation Version" in SAP S/4HANA. It reads from 1 data source (I_InspPlanOpAssgmtVersion) and exposes 45 fields with key fields InspectionPlanGroup, InspectionPlan, InspectionPlanInternalVersion, BOOOperationInternalID, BOOOpInternalVersionCounter. It has 4 associations to related views. Part of development package VDM_QM_PLANNING.

Data Sources (1)

Source	Alias	Join Type
I_InspPlanOpAssgmtVersion	_InspPlanOpVersion	inner

Associations (4)

Cardinality	Target	Alias	Condition
[0..*]	I_InspPlanPRTOpTP	_InspPlanOpPRT	`$projection.InspectionPlanGroup = _InspPlanOpPRT.InspectionPlanGroup and $projection.InspectionPlan = _InspPlanOpPRT.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlanOpPRT.InspectionPlanInternalVersion and $projection.BOOOperationInternalID = _InspPlanOpPRT.BOOOperationInternalID and $projection.BOOOpInternalVersionCounter = _InspPlanOpPRT.BOOOpInternalVersionCounter and $projection.BillOfOperationsType = _InspPlanOpPRT.BillOfOperationsType`
[0..*]	I_InspPlanOpCharcTP	_InspPlanCharc	`$projection.InspectionPlanGroup = _InspPlanCharc.InspectionPlanGroup and $projection.InspectionPlan = _InspPlanCharc.InspectionPlan and $projection.InspectionPlanInternalVersion = _InspPlanCharc.InspectionPlanInternalVersion and $projection.BOOOperationInternalID = _InspPlanCharc.BOOOperationInternalID and $projection.BOOOpInternalVersionCounter = _InspPlanCharc.BOOOpInternalVersionCounter and $projection.BillOfOperationsType = _InspPlanCharc.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`
[0..1]	I_WorkCenter	_WorkCenter	`$projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID and $projection.WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	IINSPPLOPTP	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Inspection Plan Operation Version	view
VDM.viewType	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#B	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	QINSPPLOP_D	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (45)

Key	Field	Source Table	Source Field
KEY	InspectionPlanGroup	_InspPlanOp	InspectionPlanGroup
KEY	InspectionPlan	_InspPlanOp	InspectionPlan
KEY	InspectionPlanInternalVersion
KEY	BOOOperationInternalID	_InspPlanOp	BOOOperationInternalID
KEY	BOOOpInternalVersionCounter		BOOOpInternalVersionCounter
KEY	BillOfOperationsType	_InspPlanOp	BillOfOperationsType
	BOOSqncOpAssgmtIntVersionCntr		BOOSqncOpAssgmtIntVersionCntr
	WorkCenterInternalID		WorkCenterInternalID
	WorkCenterTypeCode		WorkCenterTypeCode
	WorkCenter	_WorkCenter	WorkCenter
	IsDeleted	_InspPlanOp	IsDeleted
	IsImplicitlyDeleted	_InspPlanOp	IsImplicitlyDeleted
	OperationExternalID		OperationExternalID
	Operation		Operation
	OperationText		OperationText
	Plant		Plant
	OperationControlProfile		OperationControlProfile
	OperationStandardTextCode		OperationStandardTextCode
	BillOfOperationsRefType		BillOfOperationsRefType
	BillOfOperationsRefGroup		BillOfOperationsRefGroup
	BillOfOperationsRefVariant		BillOfOperationsRefVariant
	BOORefOperationIncrementValue		BOORefOperationIncrementValue
	InspResultRecordingView		InspResultRecordingView
	InspSbstCompletionConfirmation		InspSbstCompletionConfirmation
	InspSbstHasNoTimeOrQuantity		InspSbstHasNoTimeOrQuantity
	OperationReferenceQuantity		OperationReferenceQuantity
	OperationUnit		OperationUnit
	OpQtyToBaseQtyDnmntr		OpQtyToBaseQtyDnmntr
	OpQtyToBaseQtyNmrtr		OpQtyToBaseQtyNmrtr
	CreationDate	_InspPlanOp	CreationDate
	CreatedByUser	_InspPlanOp	CreatedByUser
	LastChangeDate	_InspPlanOp	LastChangeDate
	LastChangedByUser	_InspPlanOp	LastChangedByUser
	ChangeNumber	_InspPlanOp	ChangeNumber
	ValidityStartDate	_InspPlanOp	ValidityStartDate
	ValidityEndDate	_InspPlanOp	ValidityEndDate
	IsValid
	_WorkCenter		_WorkCenter
	BillOfOperationsStatus
	BillOfOperationsUsage
	_InspectionPlanVersion	_InspPlanOp	_InspectionPlanVersion
	_InspPlanCharc		_InspPlanCharc
	_InspPlanOpPRT		_InspPlanOpPRT
	_InspPlan		_InspPlan
	_OperationUnit		_OperationUnit

@AbapCatalog.sqlViewName: 'IINSPPLOPTP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inspection Plan Operation Version'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel:{
 //   draftEnabled : true,

    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    writeDraftPersistence: 'QINSPPLOP_D'
}
@Metadata.ignorePropagatedAnnotations:true
define view I_InspPlanOperationTP

  as select distinct from I_InspPlanOperationVersion as _InspPlanOp

    inner join            I_InspPlanOpAssgmtVersion  as _InspPlanOpVersion on  _InspPlanOp.InspectionPlanGroup    = _InspPlanOpVersion.InspectionPlanGroup
                                                                           and _InspPlanOp.InspectionPlan         = _InspPlanOpVersion.InspectionPlan
                                                                           and _InspPlanOp.BOOOperationInternalID = _InspPlanOpVersion.BOOOperationInternalID
                                                                           and _InspPlanOp.BillOfOperationsType   = _InspPlanOpVersion.BillOfOperationsType
  //  left outer join   I_InspectionPlanVersion    as I_BillOfOperationsChangeState on  _InspPlanOp.InspectionPlanGroup =  I_BillOfOperationsChangeState.InspectionPlanGroup

  //                                                                             and _InspPlanOp.InspectionPlan      =  I_BillOfOperationsChangeState.InspectionPlan

  //                                                                           and _InspPlanOp.ValidityStartDate   >= I_BillOfOperationsChangeState.ValidityStartDate

  //                                                                       and _InspPlanOp.ValidityStartDate   <= I_BillOfOperationsChangeState.ValidityEndDate


  association [0..*] to I_InspPlanPRTOpTP   as _InspPlanOpPRT on  $projection.InspectionPlanGroup           = _InspPlanOpPRT.InspectionPlanGroup
                                                              and $projection.InspectionPlan                = _InspPlanOpPRT.InspectionPlan
                                                              and $projection.InspectionPlanInternalVersion = _InspPlanOpPRT.InspectionPlanInternalVersion
                                                              and $projection.BOOOperationInternalID        = _InspPlanOpPRT.BOOOperationInternalID
                                                              and $projection.BOOOpInternalVersionCounter   = _InspPlanOpPRT.BOOOpInternalVersionCounter
                                                              and $projection.BillOfOperationsType          = _InspPlanOpPRT.BillOfOperationsType

  association [0..*] to I_InspPlanOpCharcTP as _InspPlanCharc on  $projection.InspectionPlanGroup           = _InspPlanCharc.InspectionPlanGroup
                                                              and $projection.InspectionPlan                = _InspPlanCharc.InspectionPlan
                                                              and $projection.InspectionPlanInternalVersion = _InspPlanCharc.InspectionPlanInternalVersion
                                                              and $projection.BOOOperationInternalID        = _InspPlanCharc.BOOOperationInternalID
                                                              and $projection.BOOOpInternalVersionCounter   = _InspPlanCharc.BOOOpInternalVersionCounter
                                                              and $projection.BillOfOperationsType          = _InspPlanCharc.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

  //  association[0..*] to I_ReferenceOpSetOperationTP as _RefOpSetOp on $projection.BillOfOperationsRefGroup = _RefOpSetOp.InspectionPlanGroup

  //                                                              and $projection.BillOfOperationsRefVariant = _RefOpSetOp.InspectionPlan

  //                                                              and $projection.InspectionPlanInternalVersion = _RefOpSetOp.InspectionPlanInternalVersion


  association [0..1] to I_WorkCenter        as _WorkCenter    on  $projection.WorkCenterInternalID = _WorkCenter.WorkCenterInternalID
                                                              and $projection.WorkCenterTypeCode   = _WorkCenter.WorkCenterTypeCode

{ //_InspPlanOp

  key      _InspPlanOp.InspectionPlanGroup,
  key      _InspPlanOp.InspectionPlan,
  key      _InspPlanOp._InspectionPlanVersion.InspectionPlanInternalVersion as InspectionPlanInternalVersion,
  key      _InspPlanOp.BOOOperationInternalID,
  key      BOOOpInternalVersionCounter                                      as BOOOpInternalVersionCounter,
  key      _InspPlanOp.BillOfOperationsType,
           BOOSqncOpAssgmtIntVersionCntr,
           WorkCenterInternalID,
           WorkCenterTypeCode,
//           _InspPlanOp.ValidityStartDate                                                as KeyDate1,

           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           _WorkCenter.WorkCenter,
           _InspPlanOp.IsDeleted,
           _InspPlanOp.IsImplicitlyDeleted,
           OperationExternalID,
           @ObjectModel.readOnly: true
           Operation,
           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           OperationText,
           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           Plant,
           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           OperationControlProfile,
           OperationStandardTextCode,
           @UI.hidden: true
           BillOfOperationsRefType,
           @ObjectModel.readOnly: true
           BillOfOperationsRefGroup,
           @ObjectModel.readOnly: true
           BillOfOperationsRefVariant,
           BOORefOperationIncrementValue,
           InspResultRecordingView,
           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           InspSbstCompletionConfirmation,
           InspSbstHasNoTimeOrQuantity,
           @Semantics.quantity.unitOfMeasure: 'OperationUnit'
           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           OperationReferenceQuantity,
           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           OperationUnit,
           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           OpQtyToBaseQtyDnmntr,
           @ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
           OpQtyToBaseQtyNmrtr,
           _InspPlanOp.CreationDate,
           _InspPlanOp.CreatedByUser,
           _InspPlanOp.LastChangeDate,
           _InspPlanOp.LastChangedByUser,
           @ObjectModel.readOnly: true
           _InspPlanOp.ChangeNumber,
           @ObjectModel.readOnly: true
           _InspPlanOp.ValidityStartDate,
           @ObjectModel.readOnly: true
           _InspPlanOp.ValidityEndDate,
           cast('X' as abap.char( 1 ))                                      as IsValid,
           _WorkCenter,
           _InspPlanOp._InspectionPlanVersion.BillOfOperationsStatus,
           _InspPlanOp._InspectionPlanVersion.BillOfOperationsUsage,
           _InspPlanOp._InspectionPlanVersion,
           @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
           _InspPlanCharc,
           @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
           _InspPlanOpPRT,
           @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT , #TO_COMPOSITION_PARENT]
           _InspPlan,
           _OperationUnit
           //           _RefOpSetOp



}
where
  _InspPlanOpVersion.IsDeleted <> 'X'

Depth:

I_InspPlanOperationTP view

I_InspPlanOpAssgmtVersion view_entity

C_InspPlanOperation view