Skip to Content

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

UserID to territory mapping

Hello all,

I want to automate the authorization for some BW reports related to CRM. The authorization is based on territory nodes (a copy of the CRM hierarchy is in the BW). Therefore, I'm looking for a mapping between CRM userids and territory and then load it into an ODS.

Any ideas? Thanks in advance!

Tags:
Former Member replied

What about a generic data source based on a function module. There you select all users, loop over them and call my function module to get the territory. You have have a closer look at my function module, check which table is storing the information about the user-territory-link and create a generic datasource about this table.

Best regards,

Thomas Wagner

0 View this answer in context

Helpful Answer

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