topic problem in code in Application Development and Automation Discussions

problem in code

Former Member — Thu, 12 Feb 2009 04:52:26 GMT

Hi,

I am working on a code in which i am using inner join and for all entries in the same select query but it giving the error:-

The where condition does not refer to the FOR ALL ENTRIES table

SELECT D_{AUFNR D}BWART D_{MENGE D}MEINS D_{BLDAT D}WERKS D_{MATNR E}NTGEW

FROM AUFM AS D

INNER JOIN MARA AS E ON E_{MATNR = D}MATNR

INTO TABLE T_ITPO4

FOR ALL ENTRIES IN T_ITPO1

WHERE D_{AUFNR = W_ITPO1-AUFNR AND E}MTART IN ('ROH','ZSCR','HALB','FERT')

AND D~BWART IN ('101','261','531').

But when i am using the Like method and types declarations it does not give the error .

I want to know that the method of using types in program is latest method used today or by using OOPS concept.

Re: problem in code

Former Member — Thu, 12 Feb 2009 04:56:08 GMT

Hello,

while u r using the FOR ALL ENTRIES u need check 1st the internal table is INITIAL or not.

its the pre condition for that...

Thank u,

santhosh

Re: problem in code

Former Member — Thu, 12 Feb 2009 04:56:32 GMT

Hi please refer this

u should compare t_itpo1 or w_itpo1.

SELECT D_{AUFNR D}BWART D_{MENGE D}MEINS D_{BLDAT D}WERKS D_{MATNR E}NTGEW

FROM AUFM AS D

INNER JOIN MARA AS E ON E_{MATNR = D}MATNR

INTO TABLE T_ITPO4

FOR ALL ENTRIES IN T_ITPO1

WHERE D_{AUFNR = T_ITPO1-AUFNR AND E}MTART IN ('ROH','ZSCR','HALB','FERT')

AND D~BWART IN ('101','261','531').

Regards

ABAPEr

Re: problem in code

Former Member — Thu, 12 Feb 2009 04:57:11 GMT

Hi,

FOR ALL ENTRIES IN T_ITPO1

WHERE D~AUFNR = W_ITPO1-AUFN

here for all entries refers to a different table and where condition refers to a different table .

Both should be same . Chande it and should work

Re: problem in code

Former Member — Thu, 12 Feb 2009 04:58:42 GMT

Hi ,

You need to add AND AUFNR = T_ITPO1-AUFNR in where clause -

SELECT D~AUFNR D~BWART D~MENGE D~MEINS D~BLDAT D~WERKS D~MATNR E~NTGEW
FROM AUFM AS D
INNER JOIN MARA AS E ON E~MATNR = D~MATNR
INTO TABLE T_ITPO4
FOR ALL ENTRIES IN T_ITPO1
WHERE D~AUFNR = W_ITPO1-AUFNR AND E~MTART IN ('ROH','ZSCR','HALB','FERT')
AND D~BWART IN ('101','261','531')
AND  AUFNR  =  T_ITPO1-AUFNR.

Regards

Pinaki

Re: problem in code

Former Member — Thu, 12 Feb 2009 05:02:09 GMT

Hi,

Give table name( T_ITPO1) in where condition instead of work area( W_ITPO1).

SELECT D_{AUFNR D}BWART D_{MENGE D}MEINS D_{BLDAT D}WERKS D_{MATNR E}NTGEW

FROM AUFM AS D

INNER JOIN MARA AS E ON E_{MATNR = D}MATNR

INTO TABLE T_ITPO4

FOR ALL ENTRIES IN T_ITPO1

WHERE D_{AUFNR = T_ITPO1-AUFNR AND E}MTART IN ('ROH','ZSCR','HALB','FERT')

AND D~BWART IN ('101','261','531').

Re: problem in code

former_member222860 — Thu, 12 Feb 2009 05:04:43 GMT

Hi,

Check ur itab name in where

W_ITPO1-AUFNR

Re: problem in code

Former Member — Thu, 12 Feb 2009 05:06:45 GMT

Hi Ricx,

In the code by mistake you have given the work area in the where condition instead of table due to which its giving you problem....

please make the following changes..

SELECT D_{AUFNR D}BWART D_{MENGE D}MEINS D_{BLDAT D}WERKS D_{MATNR E}NTGEW

FROM AUFM AS D

INNER JOIN MARA AS E ON E_{MATNR = D}MATNR

INTO TABLE T_ITPO4

FOR ALL ENTRIES IN T_ITPO1

WHERE D_{AUFNR = T_ITPO1-AUFNR AND E}MTART IN ('ROH','ZSCR','HALB','FERT')

AND D~BWART IN ('101','261','531').

because the select query gets executed at the database interface and there it does not recognize w_itpo1 as it is not used in the query.... it only takes the variables used in the query and also the fields which are there in the database table..

Regards,

Siddarth

Re: problem in code

Former Member — Thu, 12 Feb 2009 05:41:48 GMT

Hi,

I think the solution given by experts will solve your problem,

In the select for all entries the system will not recognize work area as you are reffering internal table.

Once resolved please close the thread.

Regards,

Edited by: jyoti sahu on Feb 12, 2009 6:41 AM