topic Re: Movement types in Application Development and Automation Discussions

Movement types

Former Member — Wed, 27 May 2009 11:02:06 GMT

Hi,

I need to extract from SAP all 551/552 movement types from jan 09 to date that have not been done through the upload process i.e MB10 and MB11 are not on the document.

Please assist with the code to so?

Re: Movement types

Former Member — Wed, 27 May 2009 11:08:26 GMT

I need to extract from SAP all 551/552 movement types from jan 09 to date that have not been done through the upload process i.e MB10 and MB11 are not on the document.

Use table join between MKPF and MSEG. Provide date as input and movement type as input to the select query.

E.g.

Select matnr bwart budat ..

from mseg as a inner join mkpf on a_{MBLNR = b}MBLNR

where ( bwart = 551 or bwart = 552 )

and budat in s_budat

Hope this will help to solve your problem.

Regards,

Vijay

Re: Movement types

Former Member — Wed, 27 May 2009 11:46:42 GMT

Hello Mpangib,

Try this code.


SELECT *
    FROM mbew
    INTO CORRESPONDING FIELDS OF TABLE i_mbew
   WHERE bwkey = <variable>
*       AND bwtar = ' '.   "Valuation Type.

  IF sy-subrc = 0.

    SELECT *
      FROM mseg
      INTO CORRESPONDING FIELDS OF TABLE i_mseg
       FOR ALL ENTRIES IN i_mbew
     WHERE MJAHR = '2009'
*         AND shkzg = 'S'.   "Only Debit Account Will be Picked with 'S'.
          AND bwart BETWEEN '551' and '552'.
*         AND BWTAR = ' '.   "Valuation Type.

Hope this helps.

Cheers,

Suvendu

Re: Movement types

Former Member — Wed, 03 Jun 2009 13:53:12 GMT

Hi,

I still need assistance with this question, anyone to assist?