Texts for an InfoObject from another InfoObject

[thecardinal]

I want to get the texts for an InfoObject from the text table of another InfoObject.

Is that possible?

If so, can anybody point me in the right direction as to how it could be done.

Stuart

[thecardinal]

I wonder if I have explained this very well.

I have 3 characteristics in an ODS, which extracts complaints from CRM. These three characteristics are compounded to each other and are effectively a catalog, a code group and a code. I cannot reference the InfoObjects 0CAT_TYPE, 0CAT_GROUP or 0CAT_CODE as I would not then be able to change the compounding.

When SAP created equivalent characteristics, such as the reason code (0CRM_RSN_TY, 0CRM_RSN_GR, and 0CRM_RSN_CO), they were able to change the compounding even though they used a reference characteristic. I don't know how they did this and I have an OSS message outstanding.

My problem now is that when I extract the data into the ODS I do not have any text for my catalog, code group or code.

I want to be able to display the texts for these characteristics in my queries, and I want the texts to come from the 0CAT_TYPE, 0CAT_GROUP and 0CAT_CODE text tables.

I would prefer not to store redundant data for these characteristics, but perhaps I have to?

Any other ideas?

[thecardinal]

It will be ongoing, but always a full load I think.

Basically, I have three new characteristics in an ODS which can all contain the same value (reason code).

There is also a BC characteristic for reason code which has the texts as a datasource.

I would like to get the texts for my three new characteristics from the BC characteristic rather than create duplicate datasources.

[Former Member]

Hi,

If the Attributes also same for both custom objects and standard object, Then you can use reference concept at the time of creating Custom info objects.

If not, use generic extractor , which will take the texts from Business content info object's text table and feeds the text table of custom Info objects.

With rgds,

Anil Kumar Sharma .P

[thecardinal]

I can't create the attributes with reference because I need different compound characteristics.

I don't want to create generic extractors because that defeats the point. I would then have multiple extractors all getting the same texts.

That is why I would like to get the text from an existing infoobject text table.

[thecardinal]

How do i use a generic extractor to do this?

The text I want is in a different InfoObject's text table within BW.

[Former Member]

Hi,

From the T-table of the other info object , you will create the generic DS(rso2).here BW system it self used as the source system. So, replicate the DS from BWsystem itself after creating the Generic DS. Then create the transfer rules(text) for your info object from this DS.

With rgds,

Anil Kumar Sharma .P

[thecardinal]

How do you create the generic DS. When I go into RSO2 I presume I want to specify the text datasource? What would it be, the table name?

[Former Member]

When I go into RSO2 I presume I want to specify the text datasource?

yes.

/BI0/TPLANT is the text table for 0PLANT.

Similarly use text table of your info object from which you want to update text of other infoobject.

With rgds,

Anil Kumar Sharma .P

[thecardinal]

Anil,

Sorry. I'm having a blonde moment.

In RSO2, I call the datasource whatever I like, on the create datasource for texts screen I enter the text table as the view table?

I then create the datasource and assign it to my InfoSource?

Stuart

[Former Member]

Hi,

Perfectly correct, Go ahead .

With rgds,

Anil Kumar Sharma .P

[thecardinal]

I created the generic datasource, replicated it in RSA1 and assigned it to my InfoObject. No problem.

However, when I schedule the InfoPackage I received an error saying that there were errors in the data selection during extraction.

Any ideas what this problem might be?

[former_member188975]

Hi Stuart,

Does the monitor give you any further details?

[Former Member]

Hi,

May the error is ome what relevent to the restriction on Language. So as Bhanu said ,Let us know the error details further more.

With rgds,

Anil Kumar Sharma .P

Kindly assign points to the help ful answers.

[Former Member]

Hi Stuart ,

Check this option.

Write a Info object routine in the update rule which will read from the reason code Text table and feeds these characteristics.

Basically you need a select statement in the routine.

Hope this helps,

<i>Sudh</i>

[thecardinal]

I think that the problem is that I don't have any data in the InfoObject!

[thecardinal]

If I get the text in the update rule, where would I put it?

[Former Member]

Hi ,

What ever we have done till now is perfectly suitable for youe scenario. SO first of all populate the text values for base characterstics and then execute our in fopackage to populate the texts from first characterstc to second one.

With rgds,

Anil Kumar Sharma .P

[thecardinal]

Anil,

I really appreciate your help with this problem.

Wouldn't this mean that I have to store redundant data?

I would have to hold master data and texts for all of these characteristics and create 19 generic datasources.

[Former Member]

Hi,

I do not under stand that why you have specified the number 19.

With rgds,

Anil Kumar Sharma .P

[thecardinal]

I meant 18!

There are 9 characteristics, so I would nead 1 datasource for master data and 1 for texts for each characteristic.

[Former Member]

Hi,

If there are 9 characteristics, SO obviously you would nead morethan 18 DS.1 datasource for master data and 1 for texts for each characteristic. An others are for hierarchies.

By the by have you populated the data .If not, are you still getting problem.

With rgds,

Anil Kumar Sharma .P

[thecardinal]

Anil,

Is this the only way to do it?

Doing it this way means that I will have the same data and texts 4 times.

[Former Member]

Hi,

For example IO1 and IO2 are 2 objetcs:

So 2 tables will hold same data for attributes of the above 2 characterstics.

And 2 tables will hold same data for text of the above 2 characterstics.

With rgds,

Anil Kumar Sharma .P

Kindly assign points, So it will help to give answers further .

[Former Member]

Hi Stuart,

Do you want to get texts from a delivered IO to a custom IO?

Thanks.

[former_member188975]

Hi Stuart,

Is this a one time affair or something that will be on going (with Delta)?