topic Re: Internal Table in Application Development and Automation Discussions

Internal Table

Former Member — Fri, 04 Dec 2009 13:57:34 GMT

Hi all Pandits,

I have an internal table 'itab1' containing a field 'field'.

I want to fill another internal table 'itab2' containing same 'field' from a 'dbtable'.

Now I want to use 'For All Entries' when fetch itab2 as it dbtable has got so many entries comparing that field <> itab1-field.

Concern is, when I am doing this I am getting, Iam not getting the required records, instead all the records from dbtable are coming. Why?

Can any pandit help me out here or can provide another way?

Regards

Vaibhav

Re: Internal Table

Former Member — Fri, 04 Dec 2009 14:00:32 GMT

First check the field is value in Itab1 is it same as u r expecting.And try to use the max keys when u r fetching the data.

Regards,

Raghu.

Re: Internal Table

VXLozano — Fri, 04 Dec 2009 14:02:43 GMT

Do you check if table1 is empty? FOR ALL ENTRIES IN itab returns all rows in the FROM table when itab is empty.

Re: Internal Table

Former Member — Fri, 04 Dec 2009 14:03:22 GMT

Yes Raghu,

I have checked the field value, itab1 is sorted. I am using keys. So everything as already taken care except the right one which willhelp to resolve my bizarre issue.

Reagrds

Re: Internal Table

former_member209217 — Fri, 04 Dec 2009 14:03:22 GMT

Hi,

Before using FOR ALL ENTRIES you should check itab1 whether it is initial or not.

If you have not done this check and if no matching record is found in dbtable then all the records from Database Table are retrieved.

Regards,

lakshman.

Re: Internal Table

Former Member — Fri, 04 Dec 2009 14:04:27 GMT

YES ALL,

I have checked itab1 has got the data.

Regars

Re: Internal Table

Former Member — Fri, 04 Dec 2009 14:06:17 GMT

Please can u tell whcih tables u r refering.

Re: Internal Table

Former Member — Fri, 04 Dec 2009 14:10:38 GMT

Hi Raghav,

I am using all Z tables.

Issue is coming when I using '<>' operator with 'For All Entries'. But when I use '=', its giving the excact values which I require.

Can u pz check if even u are facing the same issue with '<>' operator?

Regards

Vaibhav

Re: Internal Table

VXLozano — Fri, 04 Dec 2009 14:12:52 GMT

Can you please copy here part of your code?

1- data declaration of your internal tables

2- SQL where you fetch data for itab1

3- SQL where you fetch data for itab2

I cannot see any operator between your ''... and I think FAE conditions must be all equal ("=")

Re: Internal Table

Former Member — Sat, 05 Dec 2009 06:36:08 GMT

before using for all entries first use if condition Eg .



ifi tab1[] is not initial.

select field from table 
INTO CORRESPONDING FIELDS OF TABLE  itba2
FOR ALL ENTRIES IN itab1
where field = itab1-field. 
endif.

hope its helps you.

thanks,

Abhilash

Re: Internal Table

Former Member — Mon, 20 Feb 2012 09:04:33 GMT

Hi,

Make sure of the following:

1. Internal table 1 has values, else the result of select query will be all the records from database table.

2.The sequence of fields in Select query and the internal table2 should be the same .

Inttab1-field1, inttab2 --field1, dbtable-field1 are of same datatype.

if not inttab1[] is initial.

Select field1

from dbtable

into table inttab2

for all entries in inttab1

where field1 = inttab1-field1.

endif.

Regards,

Ramya

Re: Internal Table

Harsh_Bansal — Mon, 20 Feb 2012 09:29:52 GMT

Hi,

Please paste your code for reference.

Regards,

Harsh Bansal

Re: Internal Table

Former Member — Mon, 20 Feb 2012 09:52:49 GMT

Try This

IF ITAB1[] IS NOT INITIAL.

SELECT FIELD FROM DBTABLE INTO CORRESPONDING FIELDS

OF TABLE ITAB2 FOR ALL ENTRIES IN ITAB1 WHERE FIELD1 = ITAB1-FIELD1.

ENDIF.