0TCTROLE is not found from RSA6 or RSA5
I am trying to load master data and text for this IO, but I can't seem to find it in R3 to activate it for use to replicate on the BW side for creating an InfoSource. It is activated and active from the BW side.
0tctrole is business technical content object,
i think ...
if you don't want r/3 role values mix with bw's, i do suggest you to create another infoobject with
similar properties 0tctrole (use 'template' when create infoobjects), then create a multiprovider to join these 2 infoobjects and report from it.
to populate role's data from r/3 to bw, yes you can create a custom/generic datasource (RSO2) e.g ZROLE_TEXT choose option 'Texts' (master data text) and use method 'table/view', role's table is AGR_TEXTS (for code and description, other role table can check AGR_*), you want filter by language, so in datasource screen mark 'selection' for SPRAS and save. replicate this datasource to bw and assign to that infoobject's infosource and schedule infopackage to upload. if any error occured, set infopackage option 'ignore duplicate..' (since there is LINE field in that datasource).
hope this helps.