Error in ABAP code

[Former Member]

Hi experts..

There is one one routine in BI which is written in ABAP..

When I try to compile that code.. it gives me following error :

E:Field "/BI0/APP_O0100" is unknown. It is neither in one of the specified tables nor defined by a "DATA" statement. "DATA" statement.

Can you please tell me what is the reason of this error.

Regards

Swati Phadtare

[Former Member]

Try this just after the report statement mention :

tables /BI0/APP_O0100.

regards,

Advait

[Former Member]

Thanks to all..

Advait, Kiran : I wrote

tables : /bi0/app_o0100.

but now it is giving me error : E:The Dictionary structure or table "/BI0/APP_O0100" is either not active or does not exist.

vishwa sri hari : DATA: l_pp_o0100 LIKE /bi0/app_o0100,

this is the line which is giving error.. what data type should I write here??

Regards

Swati

Edited by: Swati on Oct 6, 2008 10:43 AM

[Former Member]

Hi

The field is not declared using the data statement.

DATA: /BI0/APP_O0100" type xxxx " here you have to give an data type.
if that does not work, then

tables: /BI0/APP_O0100.

Regards,

Vishwa.

Edited by: vishwa sri hari on Oct 6, 2008 2:03 PM

[Former Member]

Hi Swathi,

Declare this line in your routine.

TABLES: /BI0/APP_O0100.

this shall remove the error.

Regards,

Kiran

[Former Member]

Hi,

What type of object is /BI0/APP_O0100. To me it looks like a transparent table. But can you please let us know what it is and how have you used it in your code ?

regards,

Advait

[Former Member]

Hi

I have not written this code..

I am working in BI.. I have no idea about this code..

Thats why I am not able to find that what kind of error it is..

How to check that it is transperent table or not?

I have checked it in se11.. but its saying that this is not a table..

Regards

Swati

[Former Member]

hi

try giving it like this:

DATA: l_pp_o0100 TYPE /bi0/app_o0100.

Regards,

Vishwa.

[Former Member]

Hey

I tried that..

still it is throwing me same error : E:The Dictionary structure or table "/BI0/APP_O0100" is either not active or does not exists..

Regards

Swati

[Former Member]

Hi,

Please tell what is the name of your ODS you are referring to.

If it is a 0* ODS... meaning standard ODS then it has to be

/BI0/A followed by the ODS name without a 0.

So in your code please declare the statement as

Data : w_tab like /BI0/A<ODSNAME>.

Also please make sure that it is BI0 (zero) and no BIO (Oh)

Regards,

Pramod

Edited by: Pramod Manjunath on Oct 6, 2008 3:07 PM

[Former Member]

Thanks for ur reply

My ODS is system defined..

So in this statement

Data : w_tab like /BI0/A<ODSNAME>.

should I include 0 or not??

Regards

Swati

[Former Member]

Do not include 0 please...

only for custom objects you need to include Z.

Please let me know the result.

Regards,

Pramod

[Former Member]

Hi

Name of my ODS is 0PP_C02

Should write this

DATA: l_pp_o0100 like /bi0/app_o0100<PP_C02>,

Please correct me if I am wrong..

Regards

Swati

[Former Member]

No No..

you are getting confused

Your cube name is 0PP_C02

Your ODS name is 0PP_O01.

Try this :

Data : l_pp_o0100 like /bi0/app_o0100.

If this does not work try

Data : l_pp_o0100 type/bi0/app_o0100.

Please revert in case of clarifications.

Regards,

Pramod

[Former Member]

Hi

I tried both statements..

Its giving me this error :

E:The Dictionary structure or table "/BI0/APP_O0100" is either not active or does not exist..

Regards

Swati

[Former Member]

Hi,

This i think is because you have not activated the DSO 0PP_O01..... Please check in your AWB whether this object exits. If it exists then please activate this DSO again.

If it does not exist then please install it from your BI content.

If it exists and you need to find the related DB tables

Go to SE12

Give * PP_O01 * and press F4, If the DSO has been created you will get some search results.

From there please select the active table.

Regards,

Pramod

Edited by: Pramod Manjunath on Oct 6, 2008 3:39 PM

[Former Member]

Thanks Pramod..

But This ABAP routine has writted for infocube 0PP_C02.

And 0PP_C02 is already active..

Then why I need to install 0PP_O01 from business content??

Regards

Swati

[Former Member]

Hi,

You need to activate 0PP_O01 because you are using this ODS as reference. When you say /BI0/APP_O0100 it refers to the ODS 0PP_O01's Active table. By doing this you are taking some data from this ODS. This is called Lookup.

Tell me one thing. Are you using someother system as a reference and doing it in a new system. If so please check in that system this ODS will be active.

Regards,

Pramod

[Former Member]

Hi

First of all i didnt get what do u mean by this

> Tell me one thing. Are you using someother system as a reference and doing it in a new system. If so please check in that system this ODS will be active.

What do you mean by some other system. please explain it in detail..

Secondly.. My code has these many stmts..

DATA: l_pp_o0100 LIKE /bi0/app_o0100,

l_pp_ds0300 LIKE /bi0/app_ds0300,

So i also need to install 2nd ODS from Business content right??

Regards

Swati

[Former Member]

Yes you got it right

You need to install 2nd ODS as a Business Content too.

Regards,

Pramod

[Former Member]

Thanks a lot..

But last question Pramod..

can u pls tell me what do u said before about new system..

I am doing all stuff in BW Production..

And data in my cube is coming from R/3..

Update rule for that infocube was inactive which i want to activate..

But when I try to activate that rule.. it was giving me error.. So i found error in its routing which I have told u earlier..

So if i install that two ODS from business content.. then Will i be able to activate my update rules

Regards

Swati

[Former Member]

Hi,

Sometimes what happens is we refer to a second system ( a diff customer ) to do developement for a new system.

Thats what i meant....

Yes you have to activate both the business contents.

Regards,

Pramod

[Former Member]

Hey

Thanks a lot

Points are assigned..

Regards

Swati

[Former Member]

Hi

If I install that infoproviders from business content then as u said it will get activated..

But do I need to get data in that new ODS??

Regards

Swati

[Former Member]

You need to check the code....

If it is filling any important characteristic using this ODS then you need to fill the data. It all depends on what the code you are writing does.

Regards,

Pramod

[Former Member]

Ok

I will try to install it first n then see if rules are getting activated or not..

then i will decide whether to load data or not..

till that time I am keeping this thread as unanswered..

I will revert back..

Regards

Swati

Edited by: Swati on Oct 7, 2008 8:08 AM

[Former Member]

Yea sure,

Please let me know the result

Regards,

Pramod

[Former Member]

Hey

Rules are activated now..

No need to pull data..

Issue is solved.

Thank you very very much..

Swati

Edited by: Swati on Oct 7, 2008 8:54 AM

[naveen_kumar116]

Hi Swati,

In BI we have SID,Master ,View,Text tables...classified into P Table Q table F table....what u mentioned is not a table.

for user exits we will write code...whether u may done any enhancement to the particular DSO structure...check whether its a DSO or any field names..but for table it will comtain letters F Q P in it....