FBL5n Copy

[Former Member]

Dear Gurus.

I have made a copy of fbl5n in open items. then i have called this copy from my report by this statement.

SUBMIT zsnak_pending_submit
 WITH dd_kunnr IN kunnr
 WITH dd_bukrs EQ 'TPF'
 WITH pa_stida EQ budat
AND RETURN.

  CLEAR it_pos.
  IMPORT it_pos FROM MEMORY ID  'it_pos'.
  FREE MEMORY ID 'it_pos'.

i want my report to get the open items on two dates which is

1 which is entered in budat.

2 the last date of previous month.

example if i have entered the date 30.11.2009 then the second date will be 31.10.2009.

the problem im facing is that im not getting the open items for the date on 31.10.2009.

can we use the submit query two times in the report?.

regards

Saad Nisar.

[Former Member]

Dear Saad ,

I dont understand why did you copied FBL5N ?? Just get the logic for getting open items ?

For that I dont see any need to copy the FBL5N. You can simply get the data from table BSID.

Now as far as logic for getting open items on a perticular date is concerned that you can get it from the field BUDAT of BSID.

To get the last date of previous month you can use FM RP_LAST_DAY_OF_MONTHS.

Please get back to me in case of you need more help.

regards,

Nikhil