C_ChangeRecordObjPgInspPlan

@AbapCatalog.sqlViewName: 'CCHGRECREFINP'
@EndUserText.label: 'Change Record Object Page Inspection Plan'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@ObjectModel.usageType: {serviceQuality: #C,
                         dataClass: #MIXED,
                         sizeCategory: #L}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ObjectModel: {
   semanticKey: ['BillOfOperationsType','BillOfOperationsGroup','BillOfOperationsVariant'],
   createEnabled: true,
   deleteEnabled: 'EXTERNAL_CALCULATION',
   updateEnabled,
   transactionalProcessingDelegated: true
}

@UI.headerInfo:{
  typeName: 'Inspection Plan',
  imageUrl: 'ChangeRecordRefObjIcon',
  typeNamePlural: 'Inspection Plans',
  title:{value:'BillOfOperationsDesc'}
  }

@UI.presentationVariant: [{
    requestAtLeast: ['ChangeRecordType', 'ChangeRecordLifecycleStatus', 'ChangeRecordReferenceType' ]
}]

define view C_ChangeRecordObjPgInspPlan
  as select from I_ChgRecdRefInspectionPlanTP as ChangeRecordReferenceINPTP

  association [1..1] to C_ChangeRecordItemRelInspPlnVH as _ChangeRecordItemRelVH   on  $projection.ChangeRecordItemRelevance = _ChangeRecordItemRelVH.ChangeRecordItemRelevance
                                                                                   and $projection.ChangeRecordType          = _ChangeRecordItemRelVH.ChangeRecordType

  //                                                                                   and (

  //                                                                                      $projection.ChangeRecordReferenceType               = _ChangeRecordItemRelVH.ChangeRecordReferenceType

  //                                                                                      or _ChangeRecordItemRelVH.ChangeRecordReferenceType = ' '

  //                                                                                    )


  association [1..1] to C_ChangeRecordObjPg            as _ChangeRecordObjPg       on  $projection.ChangeRecordUUID = _ChangeRecordObjPg.ChangeRecordUUID

  association [1..1] to C_ChangeRecordInspectionPlanVH as _InspectionPlanVH        on  $projection.BillOfOperationsType    = _InspectionPlanVH.BillOfOperationsType
                                                                                   and $projection.BillOfOperationsGroup   = _InspectionPlanVH.BillOfOperationsGroup
                                                                                   and $projection.BillOfOperationsVariant = _InspectionPlanVH.BillOfOperationsVariant
  association [1..1] to C_ChgRecordItemProcgStatusVH   as _ProcessingStatusVH      on  $projection.ChangeRecordItemProcgStatus   = _ProcessingStatusVH.ChgRecdNextItemProcgStatus
                                                                                   and $projection.ChgRecdCurrentItemProcgStatus = _ProcessingStatusVH.ChgRecdCurrentItemProcgStatus
                                                                                   and $projection.ChangeRecordLifecycleStatus   = _ProcessingStatusVH.ChangeRecordLifecycleStatus
  association [0..*] to I_ChgRecdItemProcgStatusText   as _ProcessingStatusTxt     on  $projection.ChangeRecordItemProcgStatus = _ProcessingStatusTxt.ChangeRecordItemProcgStatus

  association [1..1] to I_BillOfOperations             as _BillOfOperations        on  $projection.BillOfOperationsType    = _BillOfOperations.BillOfOperationsType
                                                                                   and $projection.BillOfOperationsGroup   = _BillOfOperations.BillOfOperationsGroup
                                                                                   and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant

  association [1..*] to C_ChangeRecordInspPlanMatVH    as _InspectionPlanMatVH     on  $projection.BillOfOperationsType    = _InspectionPlanMatVH.BillOfOperationsType
                                                                                   and $projection.BillOfOperationsGroup   = _InspectionPlanMatVH.BillOfOperationsGroup
                                                                                   and $projection.BillOfOperationsVariant = _InspectionPlanMatVH.BillOfOperationsVariant

  association [0..*] to I_ChangeRecordRefObjIcons      as _ChangeRecordRefObjIcons on  $projection.ChangeRecordUUID          = _ChangeRecordRefObjIcons.ChangeRecordUUID
                                                                                   and $projection.ChangeRecordReferenceType = _ChangeRecordRefObjIcons.ChangeRecordReferenceType

  association [0..*] to C_ChangeRecdDigSignStatusVH    as _DigSignStatusText       on  $projection.ChgRecdItmDSgntr = _DigSignStatusText.ChgRecdDigitalSignatureStatus



{

          @UI.hidden: true
          @ObjectModel.readOnly: true
  key     ChangeRecordReferenceUUID,
          @UI.hidden: true
          @UI.lineItem:[
          { position:5,
            importance:#HIGH }
          ]
          @UI.identification: {position: 5, importance: #HIGH}
          @Semantics.imageUrl: true
          @ObjectModel.readOnly: true
          @EndUserText.label: 'Icon'
          _ChangeRecordRefObjIcons[ChangeRecordType = ChangeRecordType].ChangeRecordRefObjIcon as ChangeRecordRefObjIcon,
          @UI.lineItem:[{
                position:10,
                importance:#HIGH }
              ]
          @UI.identification: {position: 10, importance: #HIGH}
          //@ObjectModel.foreignKey.association: '_InspectionPlanVH'

          //@Consumption.valueHelp: '_InspectionPlanVH'

          @Consumption.valueHelpDefinition: [
                                             { entity: {name: 'C_ChangeRecordInspectionPlanVH',
                                                        element: 'BillOfOperationsGroup'},
                                               additionalBinding: [{ localElement: 'BillOfOperationsVariant', element: 'BillOfOperationsVariant' }],
                                               label: 'Inspection Plan'
                                               },
                                             { entity: {name: 'C_ChangeRecordInspPlanMatVH',
                                                        element: 'BillOfOperationsGroup'},
                                               additionalBinding: [{ localElement: 'BillOfOperationsVariant', element: 'BillOfOperationsVariant' }],
                                               label: 'Inspection Plan by Material',
                                               qualifier: 'SecondaryValueHelp'
                                             }
                                             ]

          @ObjectModel.mandatory: true
          @ObjectModel.text.element:  [ 'BillOfOperationsDesc' ]
          ChangeRecordReferenceINPTP.BillOfOperationsGroup                                     as BillOfOperationsGroup,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].BillOfOperationsDesc,

          @UI.hidden: true
          ChangeRecordReferenceINPTP.BillOfOperationsType                                      as BillOfOperationsType,
          @UI.lineItem:[{
               position:25,
               label: 'Group Counter ',
               importance:#HIGH }
             ]
          @UI.identification: {position: 30, importance: #HIGH }
          // label: 'Bill of Operation Variant'}

          ChangeRecordReferenceINPTP.BillOfOperationsVariant,

          @UI.hidden: true
          InspectionPlanInternalVersion,

          @UI.hidden: true
          @ObjectModel.readOnly: true
          // @ObjectModel.foreignKey.association: '_ChangeRecordItemRelVH'

          _ChangeRecordObjPg.ChangeRecordType                                                  as ChangeRecordType,
          @ObjectModel.readOnly:true
          @UI.hidden: true
          _ChangeRecordObjPg.ChgRecdItemProcgStatusIsEnbld,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordLifecycleStatus                                       as ChangeRecordLifecycleStatus,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordStatus,
          @UI.hidden: true
          ChangeRecordUUID,
          @UI.hidden: true
          ChangeRecordReferenceType,
          @UI.hidden: true
          ParentChangeRecordRefUUID,
          @UI.lineItem:[{
                      position:35,
                      importance:#MEDIUM }
                    ]
          @UI.identification: {position:50, importance: #MEDIUM}
          @ObjectModel.foreignKey.association: '_ChangeRecordItemRelVH'
          @Consumption.valueHelp: '_ChangeRecordItemRelVH'
          @ObjectModel.mandatory: true
          @UI.textArrangement: #TEXT_ONLY
          ChangeRecordItemRelevance,

          @UI.lineItem:[ {position: 45, importance:#MEDIUM } ]
          @UI.identification: [{position: 70, importance: #MEDIUM }]
          @EndUserText.label: 'Processing Status'
          @Consumption.valueHelpDefinition: [{association: '_ProcessingStatusVH'}]
          @ObjectModel.foreignKey.association: '_ProcessingStatusVH'
          @UI.textArrangement: #TEXT_FIRST
          ChangeRecordItemProcgStatus,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          ChgRecdCurrentItemProcgStatus,
          @UI.lineItem:[{position:80,importance:#MEDIUM }]
          @UI.identification: {position: 80, importance: #MEDIUM}
          @ObjectModel.readOnly: true
          @Consumption.semanticObject: 'ChangeMaster'
          ChangeNumber,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordItemIsNotEditable,
          @UI.hidden: true
          @ObjectModel.readOnly: true
          _ChangeRecordObjPg.ChangeRecordItmIsAddDelEnabled,
          @UI.hidden: true
          ChangeRecordReference,

          @Semantics.user.createdBy: true
          @UI.identification: {position: 95, importance: #MEDIUM}
          CreatedByUser,
          @UI.hidden: true
          CreationDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CREATIONDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: {position: 100, importance: #MEDIUM}
          cast( '00000000' as /plmb/created_on )                                               as CreationDate,
          @Semantics.user.lastChangedBy: true
          @UI.identification: {position: 105, importance: #MEDIUM}
          LastChangedByUser,

          @UI.hidden: true
          LastChangeDateTime,
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_CHANGEDATE_CONVERT'
          @ObjectModel.readOnly: true
          @UI.identification: {position: 110, importance: #MEDIUM}
          cast( '00000000' as /plmb/changed_on )                                               as LastChangeDate,

          @UI.hidden: true
          @UI.lineItem:[{importance:#MEDIUM, hidden: true }   ]
          @EndUserText.label: 'Digital Signature Status'
          @ObjectModel.foreignKey.association: '_DigSignStatusText'
          @Consumption: { valueHelp: '_DigSignStatusText' }
          ChgRecdItmDSgntr,

          @UI.lineItem:[{
              hidden: true,
              importance:#LOW }
            ]
          @UI.hidden: true
          @ObjectModel.readOnly: true
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_I_DSGNTR_ENABLE'
          cast( '' as boolean)                                                                 as DigitalSignUserIsAuthorized,

          @ObjectModel.readOnly: true
          @UI.identification: [{importance: #LOW, position: 90 }]
          @EndUserText.label: 'Digital Signature Status'
          _DigSignStatusText.ChgRecdDigSignStatusTxt                                           as ChgRecdDigSignStatusTxt,


          @UI.lineItem:[{
          hidden: true,
          importance:#LOW }
          ]
          @UI.hidden: true
          @ObjectModel.readOnly: true
          @ObjectModel.virtualElement : true
          @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_CR_I_DSGNTR_ENABLE'
          cast( '' as boolean)                                                                 as ChgRecdObjDgtlSgntrEnable,

          @UI.identification: {position: 115, importance: #MEDIUM}
          ChgRecdReasonForChange,

          @UI.identification: {position: 120, importance: #MEDIUM}
          ExpdCompltnDte,

          @UI.identification: {position: 125, importance: #MEDIUM}
          @Consumption.valueHelpDefinition: [{ entity : { name : 'C_ChangeRecdAuthznGrpVH' , element: 'ChgRecdNmbrAuthznGrp'}}]
          ChgRecdAuthznGrpText,

          @UI.identification: {position: 130, importance: #MEDIUM}
          @Consumption.valueHelpDefinition: [{ entity : { name : 'C_ChgRecdChgNmbrStatusVH' , element: 'ChgRecdNmbrChgSts'}}]
          ChgRecdNmbrChgSts,



          @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT,#TO_COMPOSITION_PARENT ]
          _ChangeRecordObjPg,
          _ChangeRecordItemRelVH,
          _ProcessingStatusVH,
          _InspectionPlanVH,
          _InspectionPlanMatVH,
          _ProcessingStatusTxt,
          _DigSignStatusText,
          _BillOfOperations
}