Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Hot to put conditions in the query.(Very very urgent )

Hi BW Gurus,

Pls give me a solution for this one i have to give it today only the report pls consider this as urgent.

new BW report, following is an explanation of the report requirement what the report would look like.

The logic of the report is to retrieve all chargebacks based on certain Selection Criteria entered by the user.

Selection Criteria are as follows:

Company Code

Posting Key - this should not be a value entered by the user

Customer

Reason Code

There should also be a selection parameter available to the user to specify the report type. The selection list should be as follows:

Top 3

Top 5

Top 10

Top 15

Top 20

Top 25

Each of the above may be viewed as a report variant. This selection parameter basically specifies the number of customers to be displayed, e.g. Top 3 means that the top 3 customers from a chargeback total perspective should be displayed.

The report should display by Customer by Reason Code the value of the Chargeback. A total for Chargebacks should be calculated per reason code, per customer and a total for the report

The report should also provide drill down capability in that the user should be given the ability to drill down by customer by reason code to display all chargeback line items that make up the total for that reason code for that customer.

Thanks in advance.

Not what you were looking for? View more on this topic or Ask a question