Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Resource not found for segment 'Yfs1ficds0245_Tran_ErrorResult' after upgrade from 1809 to 1909

0 Kudos

Hi,

We have created Odata service from CDS view with navigation feature.

so far up to S41809 it was working properly. after upgrade to 1909 we are facing issue to navigate from one view to another view by selecting one of the set value.

Below error while calling another view

@AbapCatalog.sqlViewName: 'YFS1FIC_TRAN_DSB'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Transaction Error Dashboard'
//@VDM.viewType: #COMPOSITE
@Analytics.dataCategory: #CUBE
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.representativeKey: 'Status_Final'
@ObjectModel: {compositionRoot}
@OData.publish: true


define view Yfs1ficds0245_Tran_Error
  with parameters
    @EndUserText:{ label:'From Date', quickInfo:'From Date' }
    p_ldate : datum,
    @EndUserText:{ label:'To Date', quickInfo:'To Date' }
    p_hdate : datum
  as select distinct from Yfs1ficds0245_Tran_Summary
                          (  p_ldate : :p_ldate,
                          p_hdate : :p_hdate ) as header
  association [0..1] to Yfs1ficds0245_Log_Sys_Val as _log_sys_v on $projection.lpd_logsys = _log_sys_v.lidd
  //  association [0..1] to Yfs1ficds0245_Tran_Count  as _status_count on $projection.Status_Final = _status_count.Status_Final


{
         @EndUserText:{ label:'Company Code_1', quickInfo:'Company Code_1' }
  key    header.BKPF_BUKRS            as Company_Code,
         @EndUserText:{ label:'S/4 HANA Document Number', quickInfo:'S/4 HANA Document Number' }
  key    header.BKPF_BELNR,
         @EndUserText:{ label:'S/4 HANA Fiscal Year', quickInfo:'S/4 HANA Fiscal Year' }
  key    header.BKPF_GJAHR,
         @EndUserText:{ label:'Logical System', quickInfo:'Logical System' }
         @Consumption.valueHelp: '_log_sys_v'
         @ObjectModel: { foreignKey.association: '_log_sys_v', mandatory: true }
  key    header.lpd_logsys,
         @EndUserText:{ label:'Source Document Number', quickInfo:'Source Document Number' }
  key    header.lpd_belnr,
         @EndUserText:{ label:'Source Fiscal Year', quickInfo:'Source Fiscal Year' }
  key    header.lpd_gjahr,
         @EndUserText:{ label:'Company Code', quickInfo:'Company Code' }
  key    header.bukrs_sender,
         @EndUserText:{ label:'MsgGUID', quickInfo:'MsgGUID' }
  key    header.msgguid,
  key    header.counter,
         @EndUserText:{ label:'Status', quickInfo:'Status' }
  key    header.Status_Final,         
         @EndUserText:{ label:'Count', quickInfo:'Count' }
         @DefaultAggregation: #SUM
  key    cast(1 as abap.int8)         as error_count,
         @EndUserText:{ label:'Posting Date', quickInfo:'Posting Date' }
         header.BKPF_BUDAT            as Posting_Date,
         @EndUserText:{ label:'S/4 HANA Doc Type', quickInfo:'S/4 HANA Doc Type' }
         header.BKPF_blart            as Doc_Type,
         @EndUserText:{ label:'S/4 HANA Land Date', quickInfo:'S/4 HANA Land Date' }
         @UI.selectionField: [ { position: 10 } ]
         header.rdate                 as S4_Land_Date,
         @EndUserText:{ label:'S/4 HANA Land Time', quickInfo:'S/4 HANA Land Time' }
         header.rtime                 as S4_Land_Time,
         @EndUserText:{ label:'Sender Document Number', quickInfo:'Sender Document Number' }
         header.cfin_awref            as SourceDocID,
         header.cfin_awrog,
         --@EndUserText:{ label:'Source System', quickInfo:'Source System' }
         header.cfin_awsys            as Source_System,
         @EndUserText:{ label:'S/4 HANA Entry Date', quickInfo:'S/4 HANA Entry Date' }
         header.S4_date,
         @EndUserText:{ label:'S/4 HANA Entry Time', quickInfo:'S/4 HANA Entry Time' }
         header.S4_time,
         @EndUserText:{ label:'AIF Error Date', quickInfo:'AIF Error Date' }
         header.Error_date,
         @EndUserText:{ label:'AIF Error Time', quickInfo:'AIF Error Time' }
         header.Error_time,
         @EndUserText:{ label:'ECC Document Number', quickInfo:'ECC Document Number' }
         header.ECC_DocNum,
         @EndUserText:{ label:'ECC Entry Date', quickInfo:'ECC Entry Date' }
         header.Success_Date_Stamp,
         @EndUserText:{ label:'ECC Entry Time', quickInfo:'ECC Entry Time' }
         header.Success_Time_Stamp,
         @EndUserText:{ label:'ECC IDOC Number', quickInfo:'ECC IDOC Number' }
         header.IDOC_Number,
         @EndUserText:{ label:'ECC IDOC Date', quickInfo:'ECC IDOC Date' }
         header.IDOC_date,
         @EndUserText:{ label:'ECC IDOC Time', quickInfo:'ECC IDOC Time' }
         header.IDOC_time,
         @EndUserText:{ label:'MsgID', quickInfo:'MsgID' }
         header.msgid,
         @EndUserText:{ label:'MsgNo', quickInfo:'MsgNo' }
         header.msgno,
         @EndUserText:{ label:'Error Message', quickInfo:'Error Message' } 
         header.msgtxt,      
         @EndUserText:{ label:'Hostname', quickInfo:'Hostname' }
         header.hostname,
         header.msgv1,
         header.msgv2,
         header.msgv3,
         header.msgv4,
         //         $parameters.p_ldate as ldate,
         //         $parameters.p_hdate as hdate,
         @EndUserText:{ label:'Row Count', quickInfo:'Row Count' }
         @ObjectModel.association.type: #TO_COMPOSITION_CHILD
         header.item,
         //         header.ldate,
         //         header.hdate,
         _log_sys_v
}
where
  (
        header.rdate >= $parameters.p_ldate
    and header.rdate <= $parameters.p_hdate
  ); 
Regards,
Shaishav Shah
  • SAP Managed Tags:
0 REPLIES 0