topic Re: select problem URGENT in Application Development and Automation Discussions

select problem URGENT

Former Member — Thu, 21 Jun 2007 10:54:36 GMT

Guys , i need some help .

Why is this select working , but not bringing both types of BWART ?

SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF IT_DATA2

WHERE VBELN = IT_DATA-VBELN AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

BWART IN S_BWARTO OR

BWART IN S_BWARTI .

ENDSELECT .

and this select is not working at all ??? brings me no data

SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF IT_DATA2

WHERE VBELN = IT_DATA-VBELN AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

BWART IN S_BWARTO .

ENDSELECT .

Re: select problem URGENT

Former Member — Thu, 21 Jun 2007 10:56:49 GMT

change the condition to bwart in (s_bwarto, s_bwarti) and it will work. Award points if it was useful.

Re: select problem URGENT

Former Member — Thu, 21 Jun 2007 10:57:40 GMT

Hello,

Make ur change like this.


SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF table IT_DATA2 
WHERE VBELN = IT_DATA-VBELN AND
MATNR IN S_MATNR AND
WERKS IN S_WERKS AND
(BWART IN S_BWARTO OR  " Check here
BWART IN S_BWARTI ).  





and this select is not working at all ??? brings me no data

SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF table IT_DATA2
WHERE VBELN = IT_DATA-VBELN AND
MATNR IN S_MATNR AND
WERKS IN S_WERKS AND
BWART IN S_BWARTO .

Regards,

Vasanth

Re: select problem URGENT

Former Member — Thu, 21 Jun 2007 10:59:01 GMT

why u r using Select Endselect loop.

fetch the dat in one fetch only as shown below -

SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF TABLE IT_DATA2

WHERE VBELN = IT_DATA-VBELN AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

(BWART IN S_BWARTO OR

BWART IN S_BWARTI ).

Re: select problem URGENT

Former Member — Thu, 21 Jun 2007 10:59:33 GMT

what's the data you are entering in S_BWARTO and S_BWARTI .

values exists for both the fields

Use for all entries in of iT-DATA

and check if it is not initial.

see the right code.

If not IT_DATA[] is initial.

SELECT * FROM LIPS INTO TABLE IT_DATA2

for all entries in it_data

WHERE VBELN = IT_DATA-VBELN AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

BWART IN S_BWARTO .

endif.

Reward points for useful Answers

Regards

Anji

Re: select problem URGENT

Former Member — Thu, 21 Jun 2007 11:25:41 GMT

SELECT * FROM LIKP

INTO CORRESPONDING FIELDS OF TABLE IT_DATA

WHERE LFDAT IN S_LFDAT .

LOOP AT IT_DATA .

SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF IT_DATA2

WHERE VBELN = IT_DATA-VBELN AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

( BWART IN S_BWARTO OR

BWART IN S_BWARTI ) .

IT_DATA3-VBELN = IT_DATA-VBELN .

IT_DATA3-KUNNR = IT_DATA-KUNNR .

IT_DATA3-LFDAT = IT_DATA-LFDAT .

IT_DATA3-MATNR = IT_DATA2-MATNR .

IT_DATA3-LFIMG = IT_DATA2-LFIMG .

IT_DATA3-BWART = IT_DATA2-BWART .

APPEND IT_DATA3 .

APPEND IT_DATA2 .

ENDSELECT .

ENDLOOP .

these are data

I |BT |20070602|20070621 - S_LFDAT

I |EQ |000000000101200000 - s_matnr

I |EQ |TCKJ| - s_werks

I |BT |622|623 - s_bwarto

I |EQ |621| - s_bwarti

data exist in the tables but i am not hetting nothing ...

Why

Re: select problem URGENT

Former Member — Thu, 21 Jun 2007 11:54:02 GMT

loop at s_bwart1.

s_bwart0-sign =s_bwart1-sign.

s_bwart0-option =s_bwart1-option.

s_bwart0-low =s_bwart1-low.

s_bwart0-high =s_bwart1-high.

append s_bwart0.

clear s_bwarto.

endloop.

If not IT_DATA[] is initial.

SELECT * FROM LIPS INTO TABLE IT_DATA2

for all entries in it_data

WHERE VBELN = IT_DATA-VBELN AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

BWART IN S_BWARTO .

endif.

Regards

Peram

Re: select problem URGENT

Former Member — Thu, 21 Jun 2007 12:02:08 GMT

Hi Neno.

please try as follows.

SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF table IT_DATA2

WHERE VBELN = IT_DATA-VBELN AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

(BWART IN S_BWARTO OR

BWART IN S_BWARTI ).

SELECT * FROM LIPS INTO CORRESPONDING FIELDS OF table IT_DATA2

WHERE VBELN = IT_DATA-VBELN AND

MATNR IN S_MATNR AND

WERKS IN S_WERKS AND

BWART IN S_BWARTO .

regadrs,

Jay