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

HI Experts,Can anybody provide model programs for Aging analysis

Appriciate your service.

Thanks and Regards,

Viswanath

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 06:42 PM

    A simplest way to do this to read BSID, and the group them into buckets (0-30, 30-60, 60-90, etc.) based on BSID-ZFBDT (if your baseline date is the true date for aging) or add bsid-zbd1t to the posting date and age based of that.

    But again, there are standard aging reports in SAP and I dont know why you want to develop one.

    Albert

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 08:49 PM

    You can look at the transaction S_ALR_87012178. But a sample code would be

    select bukrs kunnr gjahr belnr budat wrbtr WAERS XBlnR SHKZG

    zbd1t vbeln zfbdt

    into corresponding fields of table it_bsid from bsid

    where kunnr in s_kunnr

    and bukrs in s_bukrs

    and blart in s_blart

    and zfbdt le wa_budat.

    "Aging to be considered based on baseline date not postingdate if not change appropriately.

    loop at it_bsid.

    add it_bsid-zbd1t to it_bsid-budat.

    if it_bsid-shkzg = 'H'.

    it_bsid-wrbtr = -1 * it_bsid-wrbtr.

    endif.

    move corresponding it_bsid to output.

    l_days = syst-datum - it_bsid-zfbdt.

    if l_days le 30.

    move it_bsid-wrbtr to output-thirty.

    elseif l_days le 60.

    move it_bsid-wrbtr to output-sixty.

    elseif l_days le 90.

    move it_bsid-wrbtr to output-ninety.

    elseif l_days le 120.

    move it_bsid-wrbtr to output-onetwenty.

    else.

    move it_bsid-wrbtr to output-over120.

    endif.

    append output.

    endloop.

    Albert

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 19, 2007 at 09:09 PM

    check standard SAP program RFFMFG_AGINGBYFUND.

    Rob

    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.