SQVI : JoinTable ::::::

[Former Member]

Hello Experts ,

I want to create a report with MBLNR as input BUDAT

Using tables MKPF & MSEG i want to out put

1.MKPF-MBLNR

2.USNAM-MBLNR

3.BWART-MSEG

4LGORT-MSEG

The key to lik the two tables would be MBLNR

Can u pls tell me step by step procedure to do this ??

Regards

Anis

[Former Member]

Hello Experts ,

I want to create a report with MBLNR as input BUDAT

Using tables MKPF & MSEG i want to out put

1.MKPF-MBLNR

2.USNAM-MBLNR

3.BWART-MSEG

4LGORT-MSEG

The key to lik the two tables would be MBLNR

Can u pls tell me step by step procedure to do this ??

Regards

Anis

[SuhaSaha]

Hello Anis,

Type INNER JOIN in your SE38 editor & do an F1, you will get an SAP help documentation for INNER JOIN.

There is an example. Easy, isnt it !!

BR,

Suhas

[Former Member]

Hello,

In SQVI->Click 'Create Query' button with Query Name. Input data source as 'Table Join'. In the Data source editor, add tables MKPF and MSEG. The links for MBLNR and MJAHR will be created automatically. Press Back arrow and go to 'List field selection' and 'Selection Fields' tabs and pick the fields. Then save the Query and now you are ready to execute Query.

Thanks,

Venu

[Former Member]

Hi Anis,

Try it this way:

select mblnr usnam                  
    from mkpf
    into table t_mkpf
   where budat in s_date.               " Compare Posting Date with Date

  if t_mkpf is not initial.

    select mblnr                  " Number of Material Document
             bwart
             lgort
      into table t_mseg
       for all entries in t_mkpf       " For all Material Document
     where mblnr eq t_mkpf-mblnr.

    if sy-subrc ne 0.
      message: i007.
    endif.                           
  endif.