topic Re: where condition solution in Application Development and Automation Discussions

where condition solution

Former Member — Wed, 26 Dec 2007 10:22:56 GMT

SELECT tabname

as4local

FROM dd02l

INTO TABLE i_table_delete

FOR ALL ENTRIES IN i_fetch_data_temp

WHERE tabname = i_fetch_data_temp-obj_name.

char 30(DD02L) char 40( table TADIR)

in the above where condition the length is not matching but i need to compare the two fields is there any solution for this.

Re: where condition solution

Former Member — Wed, 26 Dec 2007 10:27:55 GMT

Hi,

You can not compare two fields with diff length,

Declare one of the field with the same length as that of the other and then compare.

Else you can use offset like :

Field1+0(30) = field2.

Just give a try....should be helpful to you.

One more thing : When ever you use for All Entries Clause Select All the Primary Key fields else you will not get complete data. As in this case if there are two values for same TABNAME, AS4LOCAL but diff AS4VERS then you will get only one.

Regards,

Lalit

Re: where condition solution

Nimesh_S_Patel — Wed, 26 Dec 2007 10:31:21 GMT

Hi Rocky

One solution.

Define one more table having the same structure exept one field obj_name, change field length to 30 char.

Before writing query transfer all data of i_table_delete into new table by MOVE-CORRESPONDING syntax and write down your query.

Regards

Nimesh S. Patel

Re: where condition solution

former_member386202 — Wed, 26 Dec 2007 10:35:59 GMT

Hi,

While declaring the structure of internal table declare both the fields as same data element.

Regards,

Prashant

Re: where condition solution

Former Member — Wed, 26 Dec 2007 11:05:56 GMT

the data is moving into the new internal table properly but it is causing dump in select statement.