Manager in database

[Former Member]

Does anyone know where the manger is stored in the backend database? I'm trying to find the virsa_ae table it is in..

[Former Member · Accepted solution]

I feel your pain at not having an ABAP debugger in Java systems...

Take a look in the Visual Admin (and as of 7.10 in the NWA) for the tracing possibilities to see which tables are hit.

You will also find some data model information and hints in OSS.

Cheers,

Julius

[Former Member · Accepted solution]

CUP just stores the manager information from the request field so it won't understand the org structure. Try APPROVER field in VT_AE_REQD_HDR1 table.

Regards,

Alpesh

[Former Member · Accepted solution]

> CUP just stores the manager information from the request field so it won't understand the org structure.

Ahh, now I see what matt g wants to do... thanks Alpesh.

It would be nice if there were a standard functionality to pull the line manager. One of my customers use a batch file procedure... but that is only as good as the users for whom it is maintained accurately.

A switch to activate the pull would be more appropriate to retro-fit this.

Cheers,

Julius

[koehntopp · Accepted solution]

There is.

In SAP HR and LDAP connectors you can define a path to managers, which will then be pulled from the user data source when creating a request.

It's not that bad

Frank.

[Former Member · Accepted solution]

Cool! Thanks for the infos Frank!

I will try this out when I find a customer with reliable and complete HR org hierarchy data..

Julius

[Former Member · Accepted solution]

Is there any guide or how-to for pulling the manager information from the user data source? I can't really imagine how to implement it. Do you have to name a field in LDAP like "manager" and it will be automatically pulled?

Thanks

Manuel

[koehntopp · Accepted solution]

The manager determination depends on the connector type.

- for the SAP HR connector you can select the manager path in the connector

- for the LDAP connector you need to map the manager field in LDAP field mapping

If managers are maintained you will then see the manager pre-populated in the request.

Frank.