I_InspectionPlanTP

@AbapCatalog.sqlViewName:  'IINSPPLTP'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Inspection Plan'
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #MASTER }
@ObjectModel:{
 draftEnabled: true ,
    compositionRoot: true,
    createEnabled: true,
    updateEnabled: true,
    deleteEnabled: true,
    transactionalProcessingEnabled: true,
    writeDraftPersistence: 'QINSPPL_D',
    entityChangeStateId: 'ChangedDateTime',
     lifecycle.enqueue: {
        expiryBehavior: #RELATIVE_TO_LAST_CHANGE,  // Default #RELATIVE_TO_LAST_CHANGE

        expiryInterval: 'PT15M'                    // Default 'PT15M'

    },
    lifecycle.processing: {
        expiryBehavior: #RELATIVE_TO_LAST_CHANGE,  // Default #RELATIVE_TO_LAST_CHANGE

        expiryInterval: 'PT30M'                    // Default 'PT30M'

    }
}

define view I_InspectionPlanTP
  as select from I_InspectionPlanVersion as _InspPlan

  association [0..*] to I_InspPlanMaterialAssgmtTP as _InspPlanMaterialAssgmtTP on  $projection.InspectionPlanGroup           = _InspPlanMaterialAssgmtTP.InspectionPlanGroup
                                                                                and $projection.InspectionPlan                = _InspPlanMaterialAssgmtTP.InspectionPlan
                                                                                and $projection.InspectionPlanInternalVersion = _InspPlanMaterialAssgmtTP.InspectionPlanInternalVersion
                                                                                and $projection.BillOfOperationsType          = _InspPlanMaterialAssgmtTP.BillOfOperationsType

  association [0..*] to I_InspPlanOperationTP      as _InspPlanOp               on  $projection.InspectionPlanGroup           = _InspPlanOp.InspectionPlanGroup
                                                                                and $projection.InspectionPlan                = _InspPlanOp.InspectionPlan
                                                                                and $projection.InspectionPlanInternalVersion = _InspPlanOp.InspectionPlanInternalVersion
                                                                                and $projection.BillOfOperationsType          = _InspPlanOp.BillOfOperationsType

{ //I_InspectionPlanVersion

      //*-------- General Data --------------*//

     
  key InspectionPlanGroup,
   // adding annotation here as they are ignored

   @Consumption.valueHelpDefinition: [ { entity: { name: 'I_BillOfOperationsStdVH', element: 'BillOfOperationsVariant' } } ]
  key InspectionPlan,
  key InspectionPlanInternalVersion,
  key BillOfOperationsType,
  /* Adding below field as a part of POC for Revision Level Filter - Poornima*/
 // concat('Q',_InspPlan.InspectionPlanGroup) as ObjMgmtRecdObjectInternalID,

  /*end of addition - Poornima */
      InspectionPlanGroup                       as InspectionPlanGroupForEdit,
      InspectionPlan                            as InspectionPlanForEdit,
//      cast(ValidityStartDate as vdm_v_key_date) as KeyDate,

      /* Changed the type of KeyDate to Char8 */
      //cast(ValidityStartDate as abap.char( 8 )) as KeyDate,

      cast('' as qmip_keydate) as TaskListKeyDateText,
      // cast('' as abap.char( 8 )) as KeyDate,

      IsDeleted,
      //IsImplicitlyDeleted,

      BillOfOperationsDesc,
      Plant,
      BillOfOperationsUsage,
      BillOfOperationsStatus,
      ResponsiblePlannerGroup,

      MinimumLotSizeQuantity,
      MaximumLotSizeQuantity,
      BillOfOperationsUnit,
      //ReplacedBillOfOperations,

      //IsMarkedForDeletion,


      //*-------- QM Data --------------*//

      InspSubsetFieldCombination,
      // adding annotations for below fields here as they are ignored

      @ObjectModel.foreignKey.association: '_InspPartialLotAssignment'
      InspectionPartialLotAssignment,
        @ObjectModel.foreignKey.association: '_SampleDrawingProcedure'
      SmplDrawingProcedure,
      @ObjectModel.foreignKey.association: '_SmplDrwgProcedureVersion'
      SmplDrawingProcedureVersion,
        @ObjectModel.foreignKey.association: '_InspectionLotDynamicLevel'
      InspectionLotDynamicLevel,
       @Consumption.valueHelpDefinition: [ { entity: { name: 'I_InspLotDynamicRuleStdVH', element: 'InspLotDynamicRule' } } ]
      @ObjectModel.foreignKey.association: '_InspLotDynamicRule'
      InspLotDynamicRule,
      @ObjectModel.foreignKey.association: '_InspExtNumbering'
      InspExternalNumberingOfValues,
      InspLotDynamicCriteria,
      MatlIsConsideredForDynModif,
      SuplrIsConsideredForDynModif,
      MfrIsConsideredForDynModif,
      CustIsConsideredForDynModif,



      //*-------- Admin Data --------------*//

      CreationDate,
      CreatedByUser,
      LastChangeDate,
      LastChangedByUser,
      ChangeNumber,
      ValidityStartDate,
      ValidityEndDate,
      ChangedDateTime,
      //      _InspPlanMaterialAssgmtTP.Material as Material,

    


      //*-------- Associations --------------*//

      //I_InspectionPlanVersion

      _BillOfOperationsStatus,
      _BillOfOperationsUnit,
      _BillOfOperationsUsage,
      _ChangeMaster,
      _InspectionLotDynamicLevel,
      _InspectionPlan,
      _InspExtNumbering,
      _InspLotDynamicRule,
      _InspSubsetFieldCombination,
      _Plant,
      _ResponsiblePlannerGroup,
      _SampleDrawingProcedure,
      _SmplDrwgProcedureVersion,
      // adding below association for foreign key association of InspectionPartialLotAssignment

      _InspPartialLotAssignment,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _InspPlanOp,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _InspPlanMaterialAssgmtTP

}
where
  IsDeleted <> 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSPECTIONPLANVERSION"
],
"ASSOCIATED":
[
"I_BILLOFOPERATIONSSTATUS",
"I_BILLOFOPERATIONSUSAGE",
"I_CHANGEMASTER",
"I_INSPECTIONLOTDYNAMICLEVEL",
"I_INSPECTIONPLAN",
"I_INSPEXTNUMBERINGOFVALUES",
"I_INSPLOTDYNAMICRULE",
"I_INSPPARTIALLOTASSIGNMENT",
"I_INSPPLANMATERIALASSGMTTP",
"I_INSPPLANOPERATIONTP",
"I_INSPSUBSETFIELDCOMBINATION",
"I_PLANT",
"I_RESPONSIBLEPLANNERGROUP",
"I_SAMPLEDRAWINGPROCEDURE",
"I_SMPLDRWGPROCEDUREVERSION",
"I_UNITOFMEASURE"
],
"BASE":
[
"I_INSPECTIONPLANVERSION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/