Skip to Content
0
Former Member
May 29, 2008 at 01:33 PM

Logic required to for Report

20 Views

Hi BWers,

We are looking for valuable suggestions for generating a query with actuals and target values for Distributors.

We are getting Resale Quantity (Daily) from CRM for at for Every BP (Distributor) level. And targets for those BP are maintained in CRM table for every quarter.

Now we have derive all the following infoobjects from BP, Invoice date and Resale quantity.

1. Actual sales quanity (either repot level or Infoprovider level) - Sum of Resale quant for Current month.

2. CA Ist Month (Actual sale quantity for Previous month)

3. CA 2nd Month (Actual sale qunat for previous to Previous).

4. Target for curent quarter is provided in CRM table, from there I am dividing into Target for 1st, 2nd and 3rd monts.

The report out put format :-

CA(Current Actals) 1st Month CA 2nd Month CA 3rd Month CA Current Month TA(target 1st Month)

TA2nd Month TA3rd Month Target Current Quarter Target Previous Quarter.

My questions are:

1. How to achieve Current actual for previous 3 months (can we achieve in report level, with out Creating new infoobjects)

2. How to get previous Quarter target can we achieve in report level, with out Creating new infoobjects)

Pls povide the logic to derive all these things..

All suggestions / solutions will be awareded with points..