Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

logic

Former Member
0 Kudos

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.

2 REPLIES 2

Former Member
0 Kudos

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
0 Kudos

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