append on 0MATERIAL_ATTR

[Former Member]

Hello,

I earlier on created an append structure on data source 0MATERIAL_ATTR, added some Z-fields + transported it to test system.

Now I can see the new fields in the extract structure (RSA6) in the test system, but not in development... (?) This is strange to me. I have earlier been able to see this also in development (otherwise the transport wouldn't have been possible)...

Could someone please guide me on how to find the missing fields in the extract structure (RSA6). They are visible in the "dictionary: display structure" (SE11) and looks exactly the same as in test...

Why can't I see the new fields in RSA6?

Best regards,

Fredrik

[Former Member · Accepted solution]

Hi Fredrik,

Goto R/3 -> se38 -> create a program -> Copy the code that I posted and make the changes in the places like your datasource and field. Save, activate and execute.

Bye

Dinesh

[Former Member · Accepted solution]

Hello,

I don't know ABAP so I'm very thankful for your help...

Now the program looks exactly like this:

REPORT ZROOSFIELD.

tables ROOSFIELD.

update ROOSFIELD set SELECTION = 'X' where

Datasource = '0MATERIAL_ATTR'

and field = 'ZZUTGI'.

I get an error message:

"Field "DATASOURCE" unknown."

What's wrong?

BR,

Fredrik

[edwin_harpino · Accepted solution]

hi Fredrik,

try

update ROOSFIELD set SELECTION = 'X' where

<b>OLTPSOURCE</b> = '0MATERIAL_ATTR'

and field = 'ZZUTGI'.

[Former Member · Accepted solution]

That did it!

Thanks a lot the two of you!!!

Best regards,

Fredrik

[Former Member]

Hi Fredrik,

Did you try running the program that I posted. This way uour fields would be available in RSA6 in DEV. You can then save the datasource and transport to TEST.

Bye

Dinesh

[Former Member]

Hello,

No I didn't run it... How do I run this program?

BR,

Fredrik

[Former Member]

Please note also that this has worked before in DEV (without this program)...

/BR Fredrik

[edwin_harpino]

hi Fredrik,

do you see the 0material_attr like back to business content ? somebody accidently transfer again from business content datasource ?

check if helps rsa6 menu->datasource->version comparison.

[Former Member]

The "version comparison" in RSA6 looks very different in DEV from TEST. In TEST all the append field are included...

In table ROOSFIELD, the Z-fields do exist (in DEV + TEST)...

So in RSA6 the Z-fields are missing in DEV (but existing in TEST). However, in SE11, the Z-filds are available in DEV...

BR,

Fredrik

[Former Member]

Hi Fredrik,

Goto RSA6 -> edit the datasource -> save -> check whether the newly added fields are there with the "hide" and "field know only in customer exit" option unchecked.

In case you dont find the fields in RSA6. Then goto se11 and find whether teh fields exist in the table ROOSFIELD for your datasource. If it exists then create/execute this simple program:

tables ROOSFIELD.
 
update ROOSFIELD set SELECTION = 'X' where 
Datasource = ' <Data source>'
and field = '<your field>'.

This would make the field appear in RSO2/RSA6.

Bye

Dinesh

[Former Member]

Any ideas, gentlemen?

Best regards,

Fredrik

[edwin_harpino]

hi Fredrik,

when rsa6 and choose 0material_attr, and double click the extract structure, can you see these z fields ?

and if click 'append structure', is there za.. structure ?

try to activate from this extract structure again.

then back to datasource, see if z fields displayed.

hope this helps.

[Former Member]

Hello,

Yes, I see the Z fields in the extract structure.. Yes, there is a za.. structure.. I have tried to re-activate, but still nothing pops up in RSA6 (data source)..

It's strange that this has worked before... I'll go ahead and try to create the program mentioned..

BR,

Fredrik