Skip to Content
0
Former Member
Mar 02, 2009 at 09:07 PM

Sales Rep. Modelling for Query.

19 Views

As you might know, in SD one can have 4 Sales Rep for the same document (i.e. Sales Order). All of them goes to different fields in the extractors and from there, up to the DSO/Cubes.

How can I model them if I have to write a query of Sales by Sales Rep.

- Is there a kind of "Meta Sales Rep" to mean everyone of them?

- Should I take the four of them?

- How can have a report like this:

Sales Rep - Sales Net Value, - Qty,....etc.

Anyone have reported Sales Rep on SD who can bring some light?

Regards,