How to write customer exit to get Latest Date in SAP BW ?

[VijayMutyala]

Hi,

I have a requirement to display the latest date data in report based on the month value which i pass in Variable.

Ex:

CustID Date Month Quantity

100 10.09.2017 09.2017 100

101 11.09.2017 09.2017 200

Now i will enter the Month in Variable 09.2017 then out put should be 11.09.2017

Kindly suggest me how to write the Variable Customer Exit with I_STEP = 2

to get this Logic.

Thanks in Advance.

AVMutyala.

[SimonKranig]

Hi Vijay,

you can use function module RSDRI_INFOPROV_READ to read the available values of the underlying infoprovider. Get them back sorted and pick the first entry.

https://wiki.scn.sap.com/wiki/display/BI/OT-DBIF-RSDRI_INFOPROV_READ

regards, Simon