Skip to Content
0
Former Member
Jan 07, 2011 at 03:37 PM

CRM Territory Levels extraction in BW

40 Views

Hello,

There is a standard Territory infoobject 0CRM_TR in BW which stores Hier, Attr and Text. Now in Reporting, when I use 0CRM_TR object, it shows the Terr node maintained in transactional data. When I display 0CRM_TR as a HIER in report, I can see all the upper level that node rolling up to, but as a HIER and not as a seperate column.

EX: As per below territory hier, if I have created records in source system and TERR mainatined as WASHINGTON, then in reporting I would see TERR = Washington and Roll up as hier will show upper level. However this would be in the same column. I would like to have all associated upper levels in seperate column.

AMERICA

--> NA

--> CALIFORNIA

--> WASHINGTON

--> CANEDA

ASIA

--> INDIA

--> SINGAPORE

Now I want to have all the upper nodes as a seperate column and I found there are standard objects delivered by SAP (0CRM_TR_A01, 0CRM_TR_A02, 0CRM_TR_A03, 0CRM_TR_A04, 0CRM_TR_A05 ... and so on). As per the description of these infoobjects, I was expecting that those would hold the respective node levels. but this is not correct and I am not able to understand how to use these objects.

Do I have to write a logic at extractor level or Update/Transfer rule to derive individual territory levels? I can do that, but curious to knowif there is any other standard way to get Terr nodes as a seperate column?

Regards

Pankaj