cancel
Showing results for 
Search instead for 
Did you mean: 

How to join LQUA with MLGT

Former Member
0 Kudos

I want to set up a query based on LQUA and MLGT.

When I only use LQUA as infoset all is fine. Now I need to extend and join it with  MLGT. Then  I only get a few records as output.

So I guess it is up to the selection. Is it doable?

Thx. for input

bR

Thomas

Accepted Solutions (1)

Accepted Solutions (1)

former_member220529
Active Participant
0 Kudos

Hi Thomas,

I guess you want to link LQUA with MLGT by material number...of course you can. But can you please check that the materials have the WM view open at storage type level (MLGT) and not only at warehouse number level (MLGN)?

Let me/us know

Regards

Claudio

Former Member
0 Kudos

Hi Claudio,

the purpose was: I wanted to report stock in certain storage types (LQUA) and then:

Do these materials have an MLGT-entry, the have their "own" imaginations. But when I joined additionally MLGT (after LQUA + MLGN) I got scratch as output.

In the meantime I solved it (hopefully) like this:

Download of all tables: LQUA, MLGN, MLGT into Excel, from there into Access and then a query.

I guess it is satisfaying for the requester.

Thx.

Thomas

Answers (2)

Answers (2)

former_member201275
Active Contributor
0 Kudos

after some googling i would say not, unless you involve other tables.

former_member392866
Active Participant
0 Kudos

Hi Thomas,

Yes... after completion of query once check with single record by go through tables manually..

Thank you.

Regards,

Balaji.