I_INSPPLANOPASSGMTVERSION

CDS View

Version of Operation Assgmt in Insp Plan

I_INSPPLANOPASSGMTVERSION is a CDS View in S/4HANA. Version of Operation Assgmt in Insp Plan. It contains 2 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 2 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
A_InspPlanOperation view_entity inner COMPOSITE Inspection Plan Operations
I_InspPlanOperationTP view inner TRANSACTIONAL Inspection Plan Operation Version
I_InspPlanOperationVersion_2 view_entity inner COMPOSITE Version of Inspection Plan Operation
R_InspPlanOperationTP view_entity inner TRANSACTIONAL Inspection Plan Operation

Fields (2)

KeyField CDS FieldsUsed in Views
KEY InspectionPlan InspectionPlan 2
IsDeleted IsDeleted 1 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Version of Operation Assgmt in Insp Plan'
@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'BOOSqncOpAssgmtIntVersionCntr'
@Analytics.technicalName: 'IINSPPLOPASSGVRS'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #L, dataClass: #MASTER }
define view entity I_InspPlanOpAssgmtVersion
  as select from I_BOOSqncOperationAssgmtChgSt
  association [1..1] to I_InspectionPlan        as _InspectionPlan        on  $projection.InspectionPlanGroup = _InspectionPlan.InspectionPlanGroup
                                                                          and $projection.InspectionPlan      = _InspectionPlan.InspectionPlan
  association [1..1] to I_InspPlanOpAssgmt      as _InspPlanOpAssgmt      on  $projection.InspectionPlanGroup    = _InspPlanOpAssgmt.InspectionPlanGroup
                                                                          and $projection.InspectionPlan         = _InspPlanOpAssgmt.InspectionPlan
                                                                          and $projection.BOOOperationInternalID = _InspPlanOpAssgmt.BOOOperationInternalID
                                                                          and $projection.BillOfOperationsType   = _InspPlanOpAssgmt.BillOfOperationsType
  /*+[hideWarning] { "IDS" :  [ "CARDINALITY_CHECK" ] } */
  association [1..1] to I_InspectionPlanVersion as _InspectionPlanVersion on  $projection.InspectionPlanGroup =  _InspectionPlanVersion.InspectionPlanGroup
                                                                          and $projection.InspectionPlan      =  _InspectionPlanVersion.InspectionPlan
                                                                          and $projection.ValidityStartDate   >= _InspectionPlanVersion.ValidityStartDate
                                                                          and $projection.ValidityStartDate   <= _InspectionPlanVersion.ValidityEndDate

  association [1..1] to I_BillOfOperationsType  as _BillOfOperationsType  on  $projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType
  
  association [1..1] to I_BillOfOperationsGroup as _BillOfOperationsGroup on  $projection.BillOfOperationsType  = _BillOfOperationsGroup.BillOfOperationsType
                                                                          and $projection.InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup
{
         @ObjectModel.foreignKey.association: '_BillOfOperationsGroup'
  key    BillOfOperationsGroup   as InspectionPlanGroup,
         @ObjectModel.foreignKey.association: '_InspectionPlan'
  key    BillOfOperationsVariant as InspectionPlan,
         @ObjectModel.foreignKey.association: '_InspPlanOpAssgmt'
  key    BOOOperationInternalID,
  key    BOOSqncOpAssgmtIntVersionCntr,
         @ObjectModel.foreignKey.association: '_BillOfOperationsType'
  key    BillOfOperationsType,
         ValidityStartDate,
         ValidityEndDate,

         IsDeleted,
         IsImplicitlyDeleted,

         ChangeNumber,

         // Administration Data

         CreationDate,
         CreatedByUser,
         LastChangeDate,
         LastChangedByUser,

         //Associations

         _InspectionPlan,
         _InspPlanOpAssgmt,
         _InspectionPlanVersion,
         _ChangeMaster,
         _BillOfOperationsType,
         _BillOfOperationsGroup

}
where
  (
       BillOfOperationsType     = 'Q'
    or BillOfOperationsType     = 'S'
  )
  and  BillOfOperationsSequence = '000000'

Learn More