cancel
Showing results for 
Search instead for 
Did you mean: 

UserID to territory mapping

0 Kudos

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!

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Function module CRM_TERRMAN_TERR_BY_EMP_OBJ gives you the territories for one business partner (employee) or even one user id.

Best regards,

Thomas Wagner

0 Kudos

Thanks for the hint. However, I'm not familiar with function modules. How can I use this in an ETL process? I assume this is rather basic ABAP knowledge, maybe you can point me in the right direction?

Former Member
0 Kudos

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 Kudos

Hi Thomas,

just want to let you know that this approach finally works.

Thanks for your help!

Answers (0)