Created structure table in R3, should be visible in BW system

[Former Member]

Hi Experts,

Greetings, need help in BW system, I am ABAPer but i have a requirement in BW hope i post in correct thread. The main requirement is i need to append some fields in structure table that already used in BW, now i created this in R3 using SE11, when i am done when checking in BW the field i created does not reflect.

Now the question is it right to create in R3?

If yes Is there any process to be done to be able to reflect in BW?.

According to our BW consultant, there is some thing should i create a abap code, wherein i have no idea.

Thanks in advance

[Former Member · Accepted solution]

i expect this kind of things for business content datasource to be done in RSA6; there you can change the extract structure. if it is a generic datasource then use RSO2.

There are two function user exits to be used for additional coding;

EXIT_SAPLRSAP_001 for generic and

EXIT_SAPLRSAP_002 for the rest.

you should find it by using CMOD and look for RSAP0001.

After having done this is R3 you must replicate to BW, etc. etc.

[syed_er1]

Hi,

As posted in the reply, please replicate the datasource from bw system, rsa1=> click on datasources, select the datasource and replicate. Your BW team guy can also do this for you. Dont forget to unhide the field, by defualt it is hidden, To unhide a field go to RSA6 then navigate to your datasource, select that and press change, then it will allow you to unhide. hope this helps

thanks

syed

[Former Member]

Hi,

If the structure in R/3 is used in BW data source??

Your are checking the structure in BW in SE11??

Do you know which data source in R/3 that structure is used??

Generally for BW.... structures in R/3 are used in the data source which you can see in t-code RSO2.

If you enhance the structure in R/3 then you will have to unhide the fields in the data source as well.

This you can do in RSO2 t-code

give your data source name and

go inside the extract structure

unhide the fields

save the data source

replicate the data source in BW.This you can do by going to RSA1 t-code->Data source->find your data source-> just right click on the data source->replicate metadata.

Now those added fields should show up in BW.

If this a structuer used specifically in BW then you will have to make the changes in BW system and not in the R/3 system.

Thanks

Ajeet

Thanks

Ajeet

[Former Member]

Hi,

Thanks to all, all replies are correct and solve my problem, i use rsa6 in r3 then rsa1 in BW system.