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