Skip to Content
0

SELECT SINGLE ISSUE ON MCHB

Jun 22, 2017 at 01:14 PM

23

avatar image
Former Member

Hi.

I have the following select single and for some materials, this selection retrieves the record with LGORT = A002 and for others retrieves the record with LGORT = A001. Of course for all case exist both records on table MCHB with A001 and A002.

* Calculate new stock balance

SELECT SINGLE * FROM mchb

WHERE matnr = itab-zzmaterial

AND werks = 'XXXX'

AND ( lgort = 'A001' OR lgort = 'A002' )

AND charg = itab-zzbatch.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers