Skip to Content
0
May 14, 2020 at 07:38 AM

SAP CPI using a date logic from SFSF

844 Views Last edit May 14, 2020 at 08:47 AM 2 rev

Dear,

Need to Configure the Customized integration flow with below logic.

Logic-1

•Fetch data from SFSF(cust_clockin_clockout) with start date as 01-05-2019, this date can be externalize parameter which can be changed in Integration. •The end date will be todays’s date – 60 days. •For example, for today’s run on integration start date will be 01-05-2019 and end date is 14-03-2020 (today’s date – 60 days). •For tomorrow integration run, it will be : •Start date- 01-05-2019 •End date- 15-03-2020 •The end date will be dynamic for fetching data from portlet-1 •

Logic-2

Fetch data from SFSF (cust_clockin_clockout_d) with date selection as:

select all record, as this will be having only last 60 days of record/

Can anyone let me know how to achieve in CPI integration.

Thanks in advance

Thanks & Regards

Rohit