Relation between EKET and LIPS

[Mad_Guitar]

Hi all,

I'd like to create a query to compare the demands to suppliers with their ASN / GR-postings. I therefore need to find a way to connect EKET (for the demands) and LIPS (for shipping notifications / Avises).

Does anyone have an idea on how to connect those tables to get get a clear realtion from the demands to the shipping notifications?

Thanks in advance.