Hi,

I want to customize report from session tfgld1101m100 and table tfgld101.
I also required data from session tfcmg2100s000 and the table tfcmg204.

How to get / retrieve the data?

Herewith I attached the session.

Thanks,
Sobiratul

Hi,

You can join tfgld101 and tfcmg204 based on the Year, Batch and Transaction Type to get the report output.

Can you give example of code / coding how to join these tables?

Thanks,
sobiratul

Here you go -

select tfcmg204.*,tfgld101
from tfcmg204,tfgld101
where tfcmg204._index1 refers to tfgld101
selectdo
|*Write your print statements here...
endselect