Skip to Content
0
Former Member
Dec 07, 2009 at 12:18 PM

Selecting data form TCURR and TCURF

2032 Views

HI,

I am making report which select all field form tcurr table. If ukurs field is negative in selected data then it should select corresponding FFACT filed form TCURR table and result should be in filnal table like FINAL UKURS = FFACT/UKURS(remove negative).

problem is that both table does not contain same data.in first table(tcurr) field 'Gdatu' is like 31.01.2003(last date of month) and second table(tcurf) Gdatu field 01.10.2003. (first date of month).

SO how can i select same data form tcurf filed.