topic Re: Problem with SELECT using FOR ALL ENTRIES in Application Development and Automation Discussions

Problem with SELECT using FOR ALL ENTRIES

VijayaKrishnaG — Mon, 26 May 2014 07:53:12 GMT

Hello Experts, Good Day.

I am facing problem with SELECT statement when I am using FOR ALL ENTRIES.

When I am using FOR ALL ENTRIES IN <tab> WHERE <field> = <tab-field> some entries are not getting fetched from the database. That time if I am using Select-Option like appending required conditions into Select option and using normal SELECT statement with WHERE <field> IN <s_option> then all the required entries are getting captured.

SELECT VBELN MBDAT MATNR WERKS LFIMG VRKME VGBEL FROM LIPS

INTO CORRESPONDING FIELDS OF TABLE IT_LIPS

FOR ALL ENTRIES IN IT_LIKP

WHERE VBELN = IT_LIKP-VBELN

AND WERKS EQ P_WERKS.

The above select query missing some entries from database. But if am using as below, I am getting all the entries.

LOOP AT IT_LIKP INTO WA_LIKP.

S_VBELN-SIGN = 'I'.

S_VBELN-OPTION = 'EQ'.

S_VBELN-LOW = WA_LIKP-VBELN.

APPEND S_VBELN.

CLEAR S_VBELN.

ENDLOOP.

SELECT VBELN MBDAT MATNR WERKS LFIMG VRKME VGBEL

FROM LIPS

INTO CORRESPONDING FIELDS OF TABLE IT_LIPS

* FOR ALL ENTRIES IN IT_LIKP

WHERE VBELN IN S_VBELN

* WHERE VBELN = IT_LIKP-VBELN

AND WERKS EQ WERKS.

Re: Problem with SELECT using FOR ALL ENTRIES

RaymondGiuseppi — Mon, 26 May 2014 08:05:35 GMT

The FOR ALL ENTRIES will remove duplicate results, if you do not provide the full primary key, some identical records may (and will) be removed. So add POSNR in the result of the SELECT statement.

NB: You could also get back to the LIKP select and try a JOIN with LIPS in case of performance problem : Remenber FOR ALL ENTRIES get bad performance for big set of data when IN RANGE option often get dumps in the same case...

Regards,

Raymond

Re: Problem with SELECT using FOR ALL ENTRIES

Mohamed_Mukhtar — Mon, 26 May 2014 08:10:54 GMT

Hello Vijay,

Add POSNR in your select query and check.


SELECT VBELN 
             POSNR " Add posnr
MBDAT MATNR WERKS LFIMG VRKME VGBEL FROM LIPS
     INTO CORRESPONDING FIELDS OF TABLE IT_LIPS
     FOR ALL ENTRIES IN IT_LIKP
     WHERE VBELN = IT_LIKP-VBELN
          AND WERKS EQ P_WERKS.

Thanks

Re: Problem with SELECT using FOR ALL ENTRIES

Former Member — Mon, 26 May 2014 08:21:48 GMT

Hi,

You are trying to fetch delivery items(LIPS) but you havent included item no(POSNR).

Please pass POSNR then let us know.

Regards,

Vadamalai A

Re: Problem with SELECT using FOR ALL ENTRIES

VijayaKrishnaG — Mon, 26 May 2014 08:29:11 GMT

Hi Raymond,

Thanks for the explanation and additional information provided.

Vijay