topic Re: Error in ABAP code in Application Development and Automation Discussions

Error in ABAP code

Former Member — Mon, 06 Oct 2008 08:30:46 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 08:31:54 GMT

Try this just after the report statement mention :

tables /BI0/APP_O0100.

regards,

Advait

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 08:32:45 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 08:34:24 GMT

Hi Swathi,

Declare this line in your routine.

TABLES: /BI0/APP_O0100.

this shall remove the error.

Regards,

Kiran

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 08:36:30 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 08:43:56 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 08:46:43 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 09:12:20 GMT

try giving it like this:

DATA: l_pp_o0100 TYPE /bi0/app_o0100.

Regards,

Vishwa.

Re: Error in ABAP code

naveen_kumar116 — Mon, 06 Oct 2008 09:17:07 GMT

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....

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 09:30:19 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 09:36:57 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 09:45:31 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 09:47:01 GMT

Do not include 0 please...

only for custom objects you need to include Z.

Please let me know the result.

Regards,

Pramod

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 09:50:24 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 09:57:24 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 10:05:51 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 10:08:57 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 10:14:58 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 10:17:35 GMT

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

Re: Error in ABAP code

Former Member — Mon, 06 Oct 2008 10:26:30 GMT

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