topic Re: Optimization for a query for reversal checking.....! in Application Development and Automation Discussions

Optimization for a query for reversal checking.....!

anup_deshmukh4 — Mon, 06 Jul 2009 12:47:09 GMT

Hey experts I have one query...!

in MSEG field lfbnr contains the reference document no.

I want to eliminate the entries which have reversal ....!

like if one( MBLNR 123 with moment 101 has lfbnr null ) and its reversal is ( MBLNR 456 with moment 102 with lfbnr = 123 check ! )

i want to eliminate both

the query will somwhat look like below....athough its not actual....!



 SELECT MBLNR 
      FROM MSEG INTO CORRESPONDING FIELDS OF TABLE IT_MSEG 
                                         WHERE
                                         BWART  = '101'  AND
                                          mblnr not in
                                     ( SELECT lfbnr as mblnr FROM mseg WHERE bwart = '102' ).

above is just an example...just for test....

plz suggest a solution or suggest a aternative for same thing

Thanks in Advance.

Re: Optimization for a query for reversal checking.....!

Former Member — Mon, 06 Jul 2009 12:53:45 GMT

Hi Anup,

Select all material documents in one internal table.

For all entries in this table select all entries from MSEG where ref. doc number equals material doc.

Then looping through one table and reading another table insert all matching entries in final internal table.

Finally u have all entries as u required in Final table, delete those entries.

Regards,

Deepak.

Re: Optimization for a query for reversal checking.....!

ThomasZloch — Mon, 06 Jul 2009 15:59:20 GMT

You want to check for reversed material document items, right? Please tell me why you are using LFBNR and not SMBLN for this check. I'm asking because there is a secondary index for SMBLN, but not for LFBNR.

Thomas

Re: Optimization for a query for reversal checking.....!

anup_deshmukh4 — Tue, 07 Jul 2009 07:00:36 GMT

Thanks a lot for the suggestion

Re: Optimization for a query for reversal checking.....!

thelazyhangman — Tue, 06 Feb 2024 10:58:54 GMT

SMBLN is empty while LFBNR is not