Question:
Hi,
How can we findout the possible company codes for a given User in BW.
I am writing one bespoke report program, which contains Company code in the selectioin screen.
When the user press the F4 button on company code field, popup screen comes up with the company codes those available to current user.
How can we do it in the BW.
I tried to use /BI0/TCOMP_CODE or /BI0/MCOMP_CODE and /BI0/SUSERNAME. But there is no relation between two tables.
Could any body suggest me to solve this issue?
thanks,
Sri
Answer:
Ever heard about authorization concept, profiles and objects ?
Typically, what u need is contained in that purpose... Allowed Company codes are set up into profiles, that are assigned to users. Your job is to get the profiles the users is assigned to, then the company codes contained into the profile(s).
Best regards,
_________________
Laurent THIBERT
Business Connection Amerique
Answer:
Hi Laurent THIBERT,
Thanks for the mail.
i heard about the profiles and authorizations. But never used it.
Could you tell me what are the tables i will have to use to get profiles and company codes?
thanks.