Skip to Content

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

CRM Terriroty hierarchy to BI

Hello,

The Territory hierarchy in CRM is defined in the way where the BP post code is assigned to Position(emplyoee) as territory attributes. The BP(account) is determined based on the post code when it is created.

The Hierarchy structure looks like Country -> Region -> Employee assigned to Territory.

Each employee would be responsible for a ZIP code and the Account would be automatically determined to the employee based on the zip code.

But for my reporting in BI I want to also pull the account into the hierarchy in BW. I would like to see the hierarchy in the form of Country -> Region -> Employee assigned to Territory -> Account Number.

Is there a way where I can pull the account number as well in the hierarchy or is there a table in CRM which has this information.

Could you please help me with this.

Thanks,

KK

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