How to find hardcoded selections for an Info object in BW

[former_member183290]

Hello all,

There is a requirement, where we need to get newly added company code from ECC --> BW.

As a pre-check; we have to identify, if there are any hardcoded selections for Company code in BW system including Info packages, Routines, reports etc.. So that, we can add the newly added one into BW & load the data there after.

I have checked various forums, but the only table that I got is for Info packages. I.E., "RSLDPSEL".

Excuse me, if I have missed out any important links related to this issue.

Could you please let me know, on how can we check the BW system or how to proceed with checking this impact.

Thanks,

Vikranth.

[mohd_abdullah · Accepted solution]

Madhav Vikranth wrote:


I have checked various forums, but the only table that I got is for Info packages. I.E., "RSLDPSEL".

Bro !! Dont you think you are making simple things complex here ?

For InfoPackage just go to first tab of Infopackage i.e "data selction" tab and check if there is any selection maintained for company code.....

Then check the same in the  DTP filter(at every level i.e DSO cube etc).

If there are any start or end routine just go through the code once and if you find any line like "where company code = 1000 or 2000 etc" then just add the new company code there.

now do the final check for query in the filter tab (beside rows/coloums tab) and check if there is any characterstic restriction for company code infobject.

Regards.

[former_member183290 · Accepted solution]

Hi Mohammed,

Yes, in a way what you said helps me. I can get the Info packages through the table given & there by manually check each and every flow at DTP, Routines etc. which are related to that Info package.

However, here there is lot of manual effort.

Is this the only way to find the hardcoded ones by checking the routines, DTPs step by step? Or do we have tables in a similar way to that of Info packages. Or any alternative.

Thanks,

Vikranth.

[former_member185132 · Accepted solution]

I don't think you can find this info for DTPs. So this time you'll probably have to do it the hard way.

To avoid this problem in the future though, maintain the Company code list in a table (use a Z-table or TVARVC) and in each DTP/IPAK get the selection from the table.

[RamanKorrapati]

Hi Madhav,,

Lets try to check thru where used list option.

Go to X - RSD1, enter your info object 0comp_code and display it.

from tool bar click on where used list and explore it.

Take abap expert help.

Thanks

[Former Member]

Hi,

These details can be check in the following tables with selection for Company Code:

RSLDPSEL - Hardcoded selections in InfoPackages

RSLDPRULE - ABAP source code for InfoPackages

RSBKSELECT   - Selections for DTP Request (Summary)

RSAABAP - ABAP source code per object routine

RSZRANGE - Selection specification for an element(BEx Query)

Regards,

Anupama

[KodandaPani_KV]

Hi,

we can check the hardcoded values in info package,DTP's and query designer level for specific query, check the CMOD code with I_SETP 1 - hardcoded values.

ex-  movement type - 301,101,102,103 like.

-Phani.

[former_member183290]

Hi Phani,

Did you meant that, CMOD code with I_SETP1 is the one which helps us to know; if the Info object has any hardcoded values in the BW flows.

Thanks,

Vikranth.