topic Re: current week report in Application Development and Automation Discussions

current week report

Former Member — Wed, 27 Feb 2008 10:30:10 GMT

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.

Re: current week report

Pramanan — Wed, 27 Feb 2008 10:42:53 GMT

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

Re: current week report

Former Member — Wed, 27 Feb 2008 18:28:40 GMT

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