Skip to Content
-1

Vendor Report

Hi Experts ,

I have a requirement to get the vendors due in next 20 days .

I created a SQ01 and created a extra fields .

I have got the day in arrear . If I look at FBL1N in I find that any item any which is days in arrear between 01 to -10 should be in report . if item not due in next 10 days then it should be in not due ,

I have created a field "Amount due in next 20 days " and coded as below

Clear AMOUNTDUEIN20DAYS.
IF DAYSINARREARS < 20 and DAYSINARREARS > 0.
move BSEG-DMBTR to AMOUNTDUEIN10DAYS.
endif.

And also defined the Days in Arrear

Clear DAYSINARREARS.
DAYSINARREARS = KEYDAT - DUEDAT.

Any help will be appreciated .

many Thanks

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 13, 2017 at 06:49 AM

    If you want to get data similar to the detail FI reports FM, use same tool like FM ITEM_DERIVE_FIELDS or FM executed by this FM like DETERMINE_DUE_DATE.

    Add comment
    10|10000 characters needed characters exceeded