Skip to Content

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

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
error.jpg (146.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

0 Answers

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.