09-02-2020 2:38 PM
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