Skip to Content
author's profile photo Former Member
Former Member

Dynamic distribution of single customer sales report to specifc customers


Could you please provdie some thoughts about the following requirement.

1. We have a single sales report (Customer orders in take) for all customers. We would like to share this report to all existing customers with restricted information to particular customers only. In other words customer should able to view his sales figures not the others. It is not possible to create individual reports per customer and bursting through IB / publishing into porta as we have more than 3000 customers in place.

2. All these customers are having EP access to place their sales orders currently, so we would like to publish their order intake values in EP with data restrictions said above.

3. As of now we are not intended to give BW system access to customer becoz of data integrity and number of customers existed. Hence ideal solution is publish reports in EP and made available to customers.

My questions:-

a. Can we use Information broadcast functionality to distribute one single sales reprort into 3000 individual customer reports and publish into EP.

b. Without EP, if we are able to burst 3000 reports to respective users are also acceptable.

c. If none of functionality works, as a stand by do we need to provide BW system access for all customers.

Thanks for your solution / suggestions.

Best Regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 06, 2009 at 06:33 PM


    you can ristrict doing for a particular customer name at the back end itself

    First you have to run the program in se38 RSUSR020 to get the profiles and the corresponding role(or define the Profile from the basis foks). After that that you have to runSE16 and the table UST10S to get PROFN and AUTH. And finally you need the entries of UST12 to reveive the FIELDs of the customer Object for authorization.

    follow the same above and run the report you will be able to restrict for a particulat customer.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.