12-03-2010 3:35 AM
Hi Experts,
I have to develop a report which should show the longest overdue (in Days) of a Customer.
Please let me know the relevant tables and fields that I can use to get the Overdue of customer.
Thanks in advanceu2026
Venkat
12-03-2010 7:35 AM
Hi,
You can use table BSID and document date field to compute overdue in days.
Kath
12-03-2010 7:42 AM
Hi
I need to find out the Overdue of the customer while creating Sales Order I used the table & fields as follows please let me know if I am correct.
select shkzg zfbdt zbd1t zbd2t zbd3t rebzg
from bsid into table it_bsid
where bukrs eq tvko-bukrs and
kunnr eq vbak-kunnr and
budat le vbak-audat and
bstat eq space and
kkber eq vbak-kkber.
loop at it_bsid.
call function 'NET_DUE_DATE_GET'
exporting
i_zfbdt = it_bsid-zfbdt
i_zbd1t = it_bsid-zbd1t
i_zbd2t = it_bsid-zbd2t
i_zbd3t = it_bsid-zbd3t
i_shkzg = it_bsid-shkzg
i_rebzg = it_bsid-rebzg
importing
e_faedt = v_faedt.
call function 'ITEM_OVERDUE_DAYS'
exporting
key_date = vbak-audat
due_date = v_faedt
importing
overdue_days = v_verzn.
if v_verzn gt v_verzn1.
v_verzn1 = v_verzn.
endif.
endloop.
Overdue = v_verzn1.
12-03-2010 7:57 AM
Hi,
Check the following reports, it may help for you:
RIBELF30
S_ALR_87012168
Regards,
Bhaskar
01-27-2011 6:42 AM
Thanks Avinash, my work is done with the help of the link you sent