Skip to Content
avatar image
Former Member

SELECT SINGLE ISSUE ON MCHB

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers