current week report

[Former Member]

Hi All,

There is a requiremnet to create a report that will contain the total amount due to and from of vendor ,the amount due in the

current week. i am using BSEG table.

Couid you please guid me to how to get the current week report when ever runs. from monday on words.

[Pramanan]

Hi Raju,

It is possible by getting input as from date and end date from the user.

For that u can use Selection screen to get From and To date.

With that write a Query to fetch neccessary details from table .

I write an example

select * from lfa1 where date in weekdate.

The week date should be declared as

Selection-screen: weekdate in type <datefield type in table>

The query will fetch the datas in between the dates given

[Former Member]

The first thing to do is to use BSIK and BSAK instead of BSEG. they are secondary index tables for BSEG indexed on company code (BUKRS) and vendor (LIFNR).

Rob