Unhide Fields of DataSource

[Former Member]

Hello Experts,

I am working on this datasource 0MATL_GROUP_TEXT and 0material_group object. I want to display description of the Material Group.

0MATL_GROUP_TEXT has only 3 fields displayed(key1, langu, txtsh) but the ExtractStuct : ROTEXTSTR1 on which this is based shows Medium and long description too. How to make these fields appear in the Datasource as they are there in the ExtractStructure but not shown in the standard Datasource but are required for reporting.

Kindly help.

Thanks.

[Former Member · Accepted solution]

Hi Priya,

Update the Table ROOSFIELD with OLTPSOURCE = "0MATL_GROUP_TEXT" and change the SELECTION value to 'P' instead of 'A'.

Then the extraction will go through.Let me know

Thank you

Arun

[Former Member · Accepted solution]

Hi

I did have this scenario. The procedure stated above was extactly what I had used. U need to have a ABAP report to update these fields.

Regards

GPK

[Former Member · Accepted solution]

hi arun,

i tried the way u told priya but i am not getting. went to se11 > roosfield > table contents. here i specified 0matl_group_text in oltpsource, txtmd in field and p in selection. when i executed i got an error stating " no table entreis found for specified key". could u tell me where i am doing wrong.

~ rahul

[krzysztof_konitz4 · Accepted solution]

Hi,

You cannot find any rows in table ROOSFIELD for your selection because you are entering "P" in field SELECTION but in your case in this field is probably "A".

Put only 0MATL_GROUP_TEXT in field OLTPSOURCE and you will see all defined fields.

Krzys

[krzysztof_konitz4]

Hi,

Fields used in extract structure of data source are defined in table ROOSFIELD in OLTP system.

Your requested fields have value "A" in SELECTION field what means that there are not shown.

You can try to change field SELECTION to space and have this fields in extract structure but I'm not sure if they will be populated by data during extraction.

But you can always use user-exit to populate them.

Krzys

[Former Member]

Thanks a lot all your suggestions were very helpful.

Priya