Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

query from 2 screens

Hi,

How do we get data from 2 screens like Goods receipt and landed cost in a single query.

Rgds,

Rajeev

replied

You can try something like:

Select * From PDN1 T0 Left Join IPF1 T1 ON T1.BaseEntry
= T0.DocEntry

You can choose any fields you like from two tables for the query.

If you need header table as well, it can be done through Inner Join for OPDN and Left Join for OIPF.

Thanks,

Gordon

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question