topic Re: FOR ALL ENTRIES PROBLEM in Application Development and Automation Discussions

FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 07:03:44 GMT

Moderator message: do not use ALL CAPITALS in the subject line

Hi Experts,

I have one query in ALL ENTRIES KEYWORD.

Actually I am putting one select query as

SELECT LIFNR LAND1 FROM LFA1 INTO TABLE ITAB FOR ALL ENTRIES IN JTAB WHERE NAME2 = JTAB-NAME2.

Here my JTAB having one entry but the value in field JTAB-NAME2 is blank.

My problem is that i am getting here SY-SUBRC = 4 after the above mentioned query.

Whereas in table LFA1 we have entries where NAME2 equal to blank.

Any idea how I can get here sy-subrc = 0 as we have entry in table LFA1.

Please suggest.

Regards,

Neha

Edited by: Matt on Dec 22, 2008 9:16 AM

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 07:17:56 GMT

Hi,

u write your code below this manner

SELECT LIFNR LAND1 FROM LFA1 INTO TABLE ITAB

FOR ALL ENTRIES IN JTAB

WHERE

NAME2 = JTAB-NAME2

AND

NAME2 = ' '.

I think your problem will be solve.

Regards

Tarapada D.

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 07:24:24 GMT

Hi Neha,

Try like this:

SELECT LIFNR LAND1 FROM LFA1 INTO TABLE ITAB FOR ALL ENTRIES IN JTAB WHERE NAME2 = JTAB-NAME2 and NAME2 = ' '.it will take the blank values.Thn i think u will get sy-subrc =0.

Hope it helps.

Regards,

Rahul

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 07:24:54 GMT

Hello,

When u r writing FOR ALL ENTIERS statement u need check table Is Initail or not...

thank u,

Santhosh

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 07:25:29 GMT

hi,you can write

SELECT LIFNR LAND1 FROM LFA1 INTO TABLE ITAB

FOR ALL ENTRIES IN JTAB WHERE

NAME2 = JTAB-NAME2 or

NAME2 = space.

thanks

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 07:52:38 GMT

SELECT LIFNR LAND1 FROM LFA1 INTO TABLE ITAB

FOR ALL ENTRIES IN JTAB WHERE

NAME2 = JTAB-NAME2 and

NAME2 = space.

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 07:54:51 GMT

Hi Neha,

If u have that Name2 in selection screen , then make it as mandatory .

Or write your query as told by other's before this.

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 08:04:10 GMT

Please check all the entries in table JTAB .

If in internal table JTAB you find other fields (a part from NAME2 ) desimilar to the entries of LFA1 the query is going to fail.

I am sure this is the reason for Sy-SUBRC = 0.

EX.

As you say NAME2 = ' ' in JTAB the other field of jtab let it be jtab-LIFNR = '10020' .

then in table LFA1 no such entry with field LIFNR = 10020 would be there .even if

its there then its NAME2 field must be having some data.

Re: FOR ALL ENTRIES PROBLEM

matt — Mon, 22 Dec 2008 08:17:38 GMT

Please do not use ALL CAPITALS in the subject line

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 08:43:40 GMT

Hi neha,

Remember while using FOR ALL ENTERIES statement the referencing table or field declared with where clause should not be empty. it should have atleast one record. Otherwise System take it as there is no WHERE clause and selects the all records of that client.

Regards,

Vikas

Re: FOR ALL ENTRIES PROBLEM

Former Member — Mon, 22 Dec 2008 11:56:45 GMT

Hi Neha,

As far as my knowledge goes FOR ALL ENTRIES is a dangerous SQL query since any harm if happens will be for all the entries in the database table.Please be careful and ensure that you mention the where clause.

Now coming to your query

name2 can either be blank or should hold data,

hence its advisable to use the following code

SELECT LIFNR LAND1

FROM LFA1

INTO TABLE ITAB

FOR ALL ENTRIES IN JTAB

WHERE NAME2 = JTAB-NAME2 or NAME2 = ' '.

hope this gives sy-surc = 0,the solution

thanks

srikanth.p

Re: FOR ALL ENTRIES PROBLEM

Former Member — Thu, 25 Dec 2008 13:12:26 GMT

SELECT matnr werks

FROM marc INTO TABLE i1_marc where matnr IN s_matnr

AND werks in s_werks AND mmsta = '10'.

if not i1_marc is inintial.

SELECT matnr werks

FROM mast INTO TABLE i_mast

for all entries in i1_marc

where matnr = i1_marc-matnr

AND werks = i1_marc-werks.

Re: FOR ALL ENTRIES PROBLEM

Former Member — Fri, 26 Dec 2008 05:12:03 GMT

data: i1_marc type table of marc with header line.

SELECT matnr werks

FROM marc INTO TABLE i1_marc where matnr IN s_matnr

AND werks in s_werks AND mmsta = '10'.

if not i1_marc[] is inintial.

SELECT matnr werks

FROM mast INTO TABLE i_mast

for all entries in i1_marc

where matnr = i1_marc-matnr

AND werks = i1_marc-werks

thanks and regards.

SWATI GUPTA

Edited by: swati gupta on Dec 26, 2008 6:12 AM