P_Contractmaintain_Trans

@AbapCatalog.sqlViewName: 'PCTRMAINTTRANS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_Contractmaintain_Trans
  as select from I_PurchaseContractVersion as _PurchaseContract 
  
    left outer join I_PurchaseContractRelevance as _ContractRelevance    on _ContractRelevance.PurchaseContract = _PurchaseContract.PurchaseContract 
    left outer join P_QtyContractPrediction     as QtyContractPrediction on _ContractRelevance.PurchaseContract = QtyContractPrediction.PurchaseContract
    left outer join I_CalendarDate              as CalendarDate          on CalendarDate.CalendarDate = $session.system_date

  association to I_PurContractClassification as _PurContractClassification on $projection.PurchaseContractType = _PurContractClassification.PurchasingDocumentType

{
  key _PurchaseContract.PurchaseContract,

      _PurchaseContract.PurchaseContractType,

      _PurContractClassification.PurchaseContractClassification                          as PurchaseContractClassification,

      ContractExpiryPredictedDate,

      PurchaseContractConsumedAmount,

      cast( case when _PurchaseContract.ValidityEndDate > $session.system_date
            then dats_days_between(  cast( $session.system_date as abap.dats ), _PurchaseContract.ValidityEndDate )
           else 0 end  as numberofdays )                                                 as NumberOfDays,

      cast(
      case
        when _PurchaseContract.ValidityEndDate >= $session.system_date
          then ''
        else 'X'
      end as mm_oa_iscontractexpired )                                                   as IsExpired,

      cast (0 as mm_a_supplier_opl_score)                                                as SupplierOperationalScore,

      cast (0 as mm_pur_ana_suplreval_opl_score)                                         as SuplrEvalOplScrInDcmlVal, // dummy lines


      cast ('' as mm_oa_oc_type )                                                        as PurContrOutputCtrlType,

      cast ('' as mm_oa_oc_status )                                                      as PurContrOutputCtrlStatus,

      cast ('' as mm_oa_oc_status_txt )                                                  as PurContrOutputCtrlStatusTxt,

      cast (0 as mm_oa_oc_time )                                                         as PurContrOutputCtrlDateTime,

      cast ('' as mm_oa_approver_id)                                                     as AccWorkflowApprover,

      cast ('' as mm_oa_approver_name)                                                   as AccWorkflowApproverFirstName,

      cast( '' as val_text )                                                             as ApprovalStatusName,

      cast( '' as sww_aagent )                                                           as ApproverUser,
      //Added for performance improvement concatenate approver names in object page

      cast( '' as mmpur_approver_name)                                                   as WorkflowApproverNote,

      WeightedRelevance,

      cast ('' as boole_d )                                                              as IsContrRefOfPurReqn,

      cast ( ContractConsumptionInPct as abap.char( 34 ) )                               as ContractConsumptionInPct,

      cast (0 as mm_oa_validity_criticality )                                            as PurContrCnsmpnCriticality,

      cast ( '' as mm_oa_iscontracttemplate )                                            as IsPurContrTemplate,

      cast ( hextobin('00000000000000000000000000000000') as sysuuid_x preserving type ) as ChangeRecordReferenceUUID,

      cast('' as boolean)                                                                as PurgContractIsInPreparation,

      cast ('' as val_text)                                                              as PurchasingDocumentStatus,

      cast ('' as boolean)                                                               as PurContrHasAdvncdUsrInterface
      //cast( '1' as mm_pur_ctr_consumption_pct )                                           as PurContractConsumptionInPct2

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE",
"I_PURCHASECONTRACTRELEVANCE",
"I_PURCHASECONTRACTVERSION",
"I_PURCONTRACTCLASSIFICATION",
"P_QTYCONTRACTPREDICTION"
],
"ASSOCIATED":
[
"I_PURCONTRACTCLASSIFICATION"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/