Select statement

Former Member — Fri, 25 Aug 2006 12:38:23 GMT

I have to update an uinternal table like below..

loop at T_Shipto.

SELECT

E_{KUNDE E}EQUNR E1_{EQKTX E}MATNR E_{SERNR E}INVNR I_{EQFNR I}ANLNR

INTO table T_Equip

FROM EQUI as E inner join EQUZ as Z

On E_{EQUNR = Z}EQUNR

Inner join ILOA as I

On I_{ILOAN = Z}ILOAN

Inner Join EQKT as E1

On E1_{EQUNR = E}EQUNR

For All Entries in T_SHipto

WHERE KUNDE = T_Shipto-KUNN2.

If SY-SUBRC <> 0.

T_output-KUNNR = T_Shipto-KUNNR.

T_Output-KUNN2 = T_Shipto-KUNN2.

T_Output-Status = 'N'.

Append T_Output.

Clear T_Output.

Else.

T_output-KUNNR = T_Shipto-KUNNR.

T_Output-KUNN2 = T_Shipto-KUNN2.

Append T_Output.

Clear T_Output.

Endif.

clear T_EQUIP.

Endloop.

If I give this.. For first shipto customer its uopdating values in internal table...for 2nd its not adding as new line..its modifying the previous value...

Re: Select statement

Former Member — Fri, 25 Aug 2006 12:45:44 GMT

Hi,

Use

<b>refresh: T_EQUIP. clear: T_EQUIP.</b>

Regards,

Raj

Re: Select statement

Former Member — Fri, 25 Aug 2006 12:46:45 GMT

in Select statement instead of inton table T_Equip

I gave appending Table T_Equip..

Now its working fine

topic Re: Select statement in Application Development and Automation Discussions

Select statement

Re: Select statement

Re: Select statement