Calculating Customer Overdue

[Former Member]

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

[Former Member]

Hi,

You can use table BSID and document date field to compute overdue in days.

Kath

[Former Member]

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.

[Former Member]

Hi,

Check the following reports, it may help for you:

RIBELF30

S_ALR_87012168

Regards,

Bhaskar

[Former Member]

Thanks Avinash, my work is done with the help of the link you sent