topic Need code logic in Application Development and Automation Discussions

Need code logic

Former Member — Wed, 20 Jun 2007 16:57:33 GMT

Hi all,

I want the logic for

Expense/Repairable flag (Table –MVKE – Field name - MTPOS) filter with VKORG=sales_org_param and VTWEG=dist_channel_param and SPART=divisioin_param

MTPOS conains either ZREP or ZEXP (ZREP=repairable, ZEXP=expensed)

regards,Ram

Re: Need code logic

RichHeilman — Wed, 20 Jun 2007 16:59:31 GMT

Have you tried it yourself yet? This is pretty straight foward, yes?

Regards,

Rich Heilman

Re: Need code logic

RichHeilman — Wed, 20 Jun 2007 17:07:12 GMT

Well, in any case, this should get you started.



report zrich_0001 .


data: xmvke type mvke.
data: xmara type mara.

data: begin of ima occurs 0,
      matnr type mara-matnr,
      spart type mara-spart,
      vkorg type mvke-vkorg,
      vtweg type mvke-vtweg,
      mtpos type mvke-mtpos,
      end of ima.

parameters: p_spart type mara-spart,
            p_vkorg type mvke-vkorg,
            p_vtweg type mvke-vtweg.

start-of-selection.

select * into corresponding fields of table ima
          from mara
              inner join mvke
                  on mara~matnr = mvke~matnr
                         where mara~spart = p_spart
                           and mvke~vkorg = p_vkorg
                           and mvke~vtweg = p_vtweg
                           and mvke~mtpos in ('ZREP', 'ZEXP').


loop at ima.
  write:/ ima-matnr, ima-spart, ima-vkorg, ima-vtweg, ima-mtpos.
endloop.

Regards,

Rich Heilman