Inner join

[Former Member]

Hi,

How to do inner join between MARD and MBEW not using matnr. Please provide me with the code also.

Thanks,

Sriram.

Message was edited by: sriram Ponna

[Former Member]

Use view V_SLGH_1 instead.

Rob

[Former Member]

What fields do you have? What fields do you need? From SAP program SAPMM07S:

SELECT * FROM V_SLGH_1 INTO TABLE YV_SLGH_1       
                       WHERE WERKS EQ XSBSE-WERKS 
                         AND LGORT EQ XSBSE-LGORT 
                         AND MTART IN RMTART      
                         AND BWKEY EQ WERKE-BWKEY.

Rob

Message was edited by: Rob Burbank

[Former Member]

Hi Sriram,

Both MARD and MBEW are related to materials. I don't se why you would want to eliminate the material number out of the join. It will give you wrong results. Here is an example.

<u>MARD</u>
MATNR    WERKS       LGORT
123      6000        STO1
456      6001        STO2

<u>MBEW</u>
MATNR     BWKEY    ...
123       6001
456       6000

Now, when you join the two tables without using MATNR, using just MARD-WERKS = MBEW-BWKEY, then you will end up selecting the second record for from MBEW for the first record from MARD. This will get complicated if you include storage location.

Why do you want to do it?

Please let us know.

Srinivas

[Former Member]

And... what was your solution? I think, posting your conclusion will help the forum.