topic logic in Application Development and Automation Discussions

logic

Former Member — Wed, 09 Jan 2008 12:02:28 GMT

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

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.

Former Member — Wed, 09 Jan 2008 12:13:12 GMT

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

Former Member — Wed, 09 Jan 2008 12:14:40 GMT

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