how to extract text of info object

[sreevatsa_adiraju]

how to extract text of info object ?

Example text of project defination from 0PROJECT

[nikhil_joy2]

Hi,

Refer the below links.

Link: [;

Link: [;

Hope it helps.

Regards,

Nikhil Joy

[Former Member]

hi

in r/3 goto RSA6 T-Code and find the text of 0project ( 0PROJECT_TEXT)

activate-> replicate to bi using RSDS T-code.

In bi , find the 0PROJECT_TEXT data source. make transormations to infoprovider 0project.

do infopackage -> DTP.

THEN YOU CAN FIND TEXT DATA IN 0PROJECT.

[Former Member]

hi siri,

firstly check whether text is enable for your info object in the masterdata/tex tab .

if yes.follow below or check mark and follow below.

1.find your text data source or create an DS.

2.Create an info packge and load data.

3.create transformations from DS to Info object.

4.create DTP and execute.

In fact for this question you can have many answers already availbe in Sdn.

Regards

Laxman

[sreevatsa_adiraju]

Hi Guys,

My question is how to extract text of info object from info object not from source, already loading happening from 0PROJECT_TXT to 0PROJECT

i want to load text from 0PROJECT to new ODS

i am not able to see text field to map in transfermation

[arun_kumar75]

Hi Siri,

You can create a transformation from I/O to DSO and manually have to map the fields to the DSO fields. And in DTP, some settings need to be done to handle duplicates.

Regards,

Arun S

[Former Member]

hi

right click on target ( dso) create trancformation.

under source

select object type as info object

then select subtype of object as text

give the name as 0project

and say ok. then you can find the transformations with text fields and map it.

and do dtp

[nikhil_joy2]

Hi Siri,

I think you can't display the text element if you display the data in the dso.

In the dso, you will see only the key part.

So you don't have to load the infoobject text into the DSO, you just have to load the infoobject.

In Bex you have the option to see either key,text or both.

Refet the below thread for details.

Link: [;

Hope it helps you in clearing your doubt.

Regards,

Nikhil Joy

[sreevatsa_adiraju]

Hi

I have to send these data using Open hub not in query , so what is solution ?

[nikhil_joy2]

Hi Siri,

I think you can follow the below steps.

1) Create a Open hub destination by choosing your infoprovider.

2) Under the fields tab, introduce a new field for your text.

3) In the transformation you can write code to populate the text by look up to text table.

I dont have a real time experience with open hubs. I got these points from the below link. Please refer the below link for details.

Link: [;

Hope this helps.

Regards,

Nikhil Joy

[Former Member]

hi,

if you want to load to DSO,then create trasnformation from IO to DSO and select sub type of obect as TExt and map and then load data.

I have to send these data using Open hub not in query , so what is solution ?

Once you have data in your Cube ,then you can create a open hub using cube as a source and push the data .