Activity Next Date

[msantaana]

Hi Experts,

When a user clicks the Activity Number Choose from List (see attached screenshot), SAP gives the list of next Activity Dates based on the Recurrence, Interval and Day that has been set. Is there a way to extract these next activity dates into a query? Thanks in advance

Maria

[azizelmir]

Hi Maria Santa Ana,

You can check the below query.

SELECT T1.CardCode as 'BP Code', (select Cardname from OCRD where CardCode=T1.CardCode) as 'BP Name' , T1.Notes,T1.CntctDate,T1.CntctTime,T1.Recontact,T1.BeginTime,T1.endDate,T1.ENDTime FROM oclg T1

Thank you,

Aziz El Mir