IS Retail - How can I load article hierarchy texts

[IanMacLaren]

Hi SCN

I am using the article hierarchy in ECC created with transaction WMATGRP03 and I am loading this into BW with the extractor 0MATERIAL_CDTH_HIER. 

To do this I read a blog which detailed an edit to table ROOSOURCE changing the extractor routine from the standard CMBW_HIERARCHY_TRANSFER_CDTH to the IS retail version RTCMBW_HIERARCHY_TRANSFER_CDTH but apart from this minor edit to the business content this works fine and I can see the hierarchy in reports in BW.

What I don't have is texts for the hierarchy nodes - extractor 0CM_CDT1_TEXT and 0RF_ARTHIER1_TEXT return nothing because they are pointing to views with no data - the actual data seems to be stored in table WRF_MATGRP_STRUCT.

I can create a generic extractor on this table but does anyone know if there is a SAP content extractor for these texts ?

regards

Ian

[IanMacLaren · Accepted solution]

Hi SCN

I have solved this with generic extractors on tables WRF_CMMD_CDTxT where x is 1 through 7 and added transformations to the texts for infoobjects 0CM_CDTx

The transformation needs to split the key into hierarchy Id and object key ( 1st to chars of the source key is the hierarchy ID ).

regards

Ian