topic Re: Table For TCode MC.9 in Application Development and Automation Discussions

Table For TCode MC.9

Former Member — Tue, 04 Nov 2008 05:30:34 GMT

HI Friends,

for particular Period (i.e.03.2008) i m running report from MC.9, from which database table i can get the same data?

Re: Table For TCode MC.9

Former Member — Tue, 04 Nov 2008 05:35:02 GMT

Hi,

Try Table MSEG and BSIM...


*&---Fetching Record from MSEG
  SELECT   a~mblnr
           a~zeile
           b~budat
           a~mjahr
           a~werks
           a~bwart
           a~matnr
           a~menge
           a~meins
           a~dmbtr
           a~shkzg
           c~mtart
           c~matkl
           a~bwtar
           a~sobkz
           a~mat_pspnr
           d~maktx
           INTO CORRESPONDING FIELDS OF TABLE it_mseg
           FROM mseg AS a INNER JOIN mkpf AS b
           ON  a~mblnr = b~mblnr
           AND a~mjahr = b~mjahr
           AND b~budat LE last_date
           INNER JOIN mara AS c
           ON  a~matnr = c~matnr
           INNER JOIN makt AS d
           ON a~matnr = d~matnr
           WHERE a~matnr IN s_matnr
           AND   a~werks IN s_werks
           AND   a~bwart IN s_bwart
           AND   a~lgort NE space
           AND   a~sobkz IN s_sobkz
           AND   a~mat_pspnr IN s_wbs
           AND   c~mtart IN s_mtart
           AND   c~matkl IN s_matkl
           .
    SELECT   a~belnr AS mblnr
             a~buzei AS zeile
             a~budat
             a~gjahr AS mjahr
             a~bwkey AS werks
             a~matnr
             a~meins
             a~dmbtr
             a~shkzg
             b~mtart
             b~matkl
             a~bwtar
             c~maktx
             APPENDING CORRESPONDING FIELDS OF TABLE it_mseg
             FROM bsim AS a INNER JOIN mara AS b
             ON a~matnr = b~matnr
             INNER JOIN makt AS c
             ON a~matnr = c~matnr
             WHERE a~matnr IN s_matnr
             AND   a~bwkey IN s_werks
             AND   a~budat LE last_date
             AND   a~blart IN ('R1','R2','R3','R4','R5','R6')
             AND   b~mtart IN s_mtart
             AND   b~matkl IN s_matkl
             .

consider the values of SHKZG is S then DMBTR and MENGE is +ve and if H then DMBTR and MENGE is -ve

Edited by: Sukriti Saha on Nov 4, 2008 11:05 AM

Re: Table For TCode MC.9

Former Member — Tue, 04 Nov 2008 05:37:28 GMT

Hi Amit,

Check in this report - RMCB0300 you can find.

Click on where used-list in the application tool bar(CtrlshiftF5) and

expand the dictionary structure you can get all the tables.

Cheers!!

VEnk@

Edited by: Venkat Reddy on Nov 4, 2008 11:08 AM

Re: Table For TCode MC.9

Former Member — Tue, 04 Nov 2008 05:38:19 GMT

Hello

s031, s032, s039, s034, s035, s094, mbew

Re: Table For TCode MC.9

Former Member — Tue, 04 Nov 2008 05:47:38 GMT

Hi,

Tables might be S031/S039.

Re: Table For TCode MC.9

Former Member — Wed, 05 Nov 2008 04:37:39 GMT

i m using MARDH and MCHBH Table But Not Getting Correct Figure as like MC.9 ,but the stock is not tallying