01-09-2008 12:02 PM
i require some logic.
my requirement is i have to fetch debit and credit values from LFC1 table
i need to fetch only vendor from last 15 months there is no transaction.
for eg: today date is 09/01/2008
15 months back means 09/11/2006
inbetween these two dates i.e., 09/11/2006 to 09/01/2008 there is no transaction , means
debit credit
11/2006 0 0
to
01/2008 0 0
i need to get this 15 months debit and credit details , only if the values are zeros for both credit and debit.
please help how to write logic.
please urgent.
01-09-2008 12:13 PM
Hi Latha,
Get all the vendor code lifnr from rable ekko where aedat between 09/11/2006 to 09/01/2008.
Then pass all those vendor in table LFC1 to get debit credit values & store them into an internal table.
After that just code
delete itab where debit > 0
and credit > 0.
Thats all.
If it is usefull pls reward pts.
Regards
srimanta
01-09-2008 12:14 PM
Hi,
use this FM LFC1_GENERIC_READ.
copy and modify the above FM by adding two more import parameters fromdate and todate, change the code also.
I think it requires small changes like in select statements.
Thanks and Regards,
Edited by: chandra madapati on Jan 9, 2008 1:16 PM