topic Re: Code help in Application Development and Automation Discussions

Code help

Former Member — Wed, 02 Jul 2008 15:32:43 GMT

I have written the following logic but get the error:

E:Field "OBJVERS" unknown.

Code

DATA: lt_tab1 LIKE /BI0/Ptable OCCURS 0,

ls_tab1 LIKE LINE OF lt_tab1.

REFRESH lt_tab1.

SELECT field1

FROM /BI0/Ptable

INTO CORRESPONDING FIELDS OF TABLE lt_tab1

FOR ALL ENTRIES IN lt_another_table

WHERE field1 EQ lt_another_table-field1

AND OBJVERS EQ 'A'.

SORT lt_tab1 BY field1 ASCENDING.

OBJVER is a field in the table which stores the version of the record i.e. modified, active

Can someone advise on what I have done wrong? Thanks

Re: Code help

Former Member — Wed, 02 Jul 2008 15:34:14 GMT

Check this:

SELECT field1

FROM /BI0/Ptable

INTO CORRESPONDING FIELDS OF TABLE lt_tab1

FOR ALL ENTRIES IN lt_another_table

WHERE field1 EQ lt_another_table-field1

AND /BI0/Ptable-OBJVER EQ 'A'

SORT lt_tab1 BY field1 ASCENDING.

Or, simply check the table /BI0/Ptable whether the field exists/misspelled?

Assign points, if this helps.

rgds,

Raghu.

Edited by: Raghuram Saripalli on Jul 2, 2008 9:07 PM

Re: Code help

Former Member — Wed, 02 Jul 2008 15:36:00 GMT

is it OBJVER or OBJVERS

Re: Code help

Former Member — Wed, 02 Jul 2008 15:59:48 GMT

Thanks for this. I thought changing to /BI0/Ptable-OBJVERS EQ 'A' may have done the trick but still the same error.

You were write it was OBJVERS but I still get the error.

Is there anything wrong with the way I have defined:

DATA: lt_tab1 LIKE /BI0/Ptable OCCURS 0,

ls_tab1 LIKE LINE OF lt_tab1.

Re: Code help

Former Member — Wed, 02 Jul 2008 16:04:47 GMT

can U try declaring with occcurs 0 OR

types: xxx type /BI0/Ptable.

data: yyy type standard table of xxx..

Rgds,

Raghu.

Re: Code help

Former Member — Wed, 02 Jul 2008 16:54:57 GMT

Thanks I changed the logic and still get the same error. The changes that I made are

DATA: BEGIN OF ls_tab1,

field1 TYPE /BI0/Fireld1,

objvers TYPE RSOBJVERS,

END OF ls_tab1,

lt_tab1 LIKE TABLE OF ls_tab1.

Re: Code help

Former Member — Wed, 02 Jul 2008 17:04:39 GMT

Check out this code:



DATA: lt_tab1 type standard table of /BI0/Ptable initial size 0,
ls_tab1 type /BI0/Ptable.

REFRESH lt_tab1.

SELECT *
FROM /BI0/Ptable
INTO TABLE lt_tab1
FOR ALL ENTRIES IN lt_another_table
WHERE field1 EQ lt_another_table-field1
AND OBJVERS = 'A'.
  if sy-subrc = 0.
   SORT lt_tab1 BY field1 ASCENDING.
 endif.

Re: Code help

Former Member — Wed, 02 Jul 2008 17:54:52 GMT

Thanks very much for this the code worked I made a slight modification in the SELECT to get the specific field that I was looking for.

In general:

1. What was I doing wrong?

2. When I declare the variable:

DATA: lt_tab1 type standard table of /BI0/Ptable initial size 0,

ls_tab1 type /BI0/Ptable.

Is there a way that I can reduce it so that it is only the one or two fields that I am interested in?

Re: Code help

Former Member — Wed, 02 Jul 2008 18:41:21 GMT

Hi Niten,

Please check this code...

DATA: BEGIN OF ls_tab1,
       <fieldname1>  LIKE  /bi0/ptable-<fieldname>,
       <fieldname2>  LIKE  /bi0/ptable-<fieldname>,
       <fieldname3>  LIKE  /bi0/ptable-<fieldname>,
     END OF ls_tab1,
     lt_tab1 TYPE TABLE OF ls_tab1.

SELECT <fieldname1>
       <fieldname2>
       <fieldname3>
  FROM /BI0/ptable
  INTO TABLE lt_tab1
   FOR ALL ENTRIES IN lt_another_table
 WHERE field1 EQ lt_another_table-field1
   AND objvers = 'A'.

reward if helpful...

Best regards,

raam

Re: Code help

Former Member — Wed, 02 Jul 2008 19:01:50 GMT

Thanks for this. Is the advantage of this approach that I am only getting my 3 specific fields whereas with the original data declaration I am getting all the columns of each row of data?

Re: Code help

Former Member — Wed, 02 Jul 2008 19:08:37 GMT

Hi Niten,

Generally it is always advantageous to fetch the data which we require.

As you require only three fields so declare the table with only three fields as i declaired and also select the fields which are required.

By doing this u are decreasing the database access. As the database access decreases the performance of the program increases.

DATA: lt_tab1 type standard table of /BI0/Ptable initial size 0,
ls_tab1 type /BI0/Ptable.

In the above table declaration all the fields of the table /BI0/Ptable are considered.

DATA: BEGIN OF ls_tab1,
       <fieldname1>  LIKE  /bi0/ptable-<fieldname>,
       <fieldname2>  LIKE  /bi0/ptable-<fieldname>,
       <fieldname3>  LIKE  /bi0/ptable-<fieldname>,
     END OF ls_tab1,
     lt_tab1 TYPE TABLE OF ls_tab1.

where as in this table declaration u are only considering the fields which you require.

Best regards,

raam