Skip to Content
author's profile photo Former Member
Former Member

logic

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.