Which query replaces 0IC_C01_Q0002?

[Former Member]

Hello Gurus,

I want to generate a standard report 0IC_C01_Q0002, which is extraction data from 0IC_C01.  But, i have read that this is the old cube and we are using 0IC_C03 instead of this.  So, which report will serve the purpose of 0IC_C01_Q0002?  I have already loaded data to 0IC_C03, is this enough or do i need to do anything more? Kindly suggest, points will be assigned.

Thanks and expecting a quick response.

Rakesh

[former_member183012 · Accepted solution]

Hi Rakesh,

Can you please check this report once 0IC_C03_Q0018 also check on google you will find the replacement of queries.

hope it will help.

Regards,

Ganesh Bothe

[Former Member · Accepted solution]

Hello Ganesh,

Yes, i think this query will serve my purpose.. Thanks a lot.  Points assigned.

Rakesh

[Former Member · Accepted solution]

But, one more doubt is that, can we simply take this query or do we need to do any modifications at the back end in order to use this query?

Thanks

Rakesh

[former_member183012 · Accepted solution]

Hi Rakesh,

If you are loading data properly to inventory cube then I do not think you should to anything ..just execute query and validate with R/3 system.

Regards,

Ganesh Bothe

[Former Member]

Hi Rakesh,

Please find the below query, it may satisfy

Stock Overview ( Technical name: 0IC_C03_Q0013 )

Stock Overview (as of SAP BW 3.1 Content) - Inventory Management - SAP Library

Regards,

Baskaran.

[RamanKorrapati]

Hi BR,

please better to avoid posting simple links. Rather than posting links,  guide him how to get the required information.

http://scn.sap.com/community/support/blog/2013/11/08/posting-links-and-the-jungle-you-end-up-in

Thanks

[Former Member]

Hello Baskaran,

Appreciate you for taking time to give reply,

But, i think this query replaces objects 0IC_C01_Q0010 and 0IC_C01_Q0011, not Q0002.  I believe Q0018 will serve the purpose. Thanks for your reply..

Rakesh

[RamanKorrapati]

Hi,

When your query technical represents 0IC_C01_Q0002(it pulls data from 0IC_C01 only). so you can't do report on 0IC_C03 cube.

You need find the the report which was replaced to 0IC_C01_Q0002 to 0IC_C03_QXXXX.

Find the relevant reprot form business content and use. it may works.

Thanks