Skip to Content

How to link PDN1 and IPF1 tables of SAP B1 in query?.

Hi all,

How can I match IPF1 and PDN1 tables of SAP B1?

I tried to do this simple query

SELECT * FROM PDN1 T0 INNER JOIN IPF1 T1 ON T0.[DocEntry] = T1.[BaseEntry]

But here each record will be repeated many because of same DocEntry

SELECT * FROM PDN1 T0 INNER JOIN IPF1 T1 ON T0.[DocEntry] = T1.[BaseEntry]  AND T0.[BaseLine] = T1.[LineNum]

Here it brings only one record per each document, and I want to get all data of each row.

But I do know how I can link these tables in order to display records in details.

Please anyone can help me.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 06, 2017 at 06:20 AM

    Hi

    try this

    SELECT T0.[ItemCode] FROM PDN1 T0 INNER JOIN IPF1 T1 ON T0.[DocEntry] = T1.[BaseEntry] AND T0.[BaseLine] = T1.[LineNum] and T0.[ItemCode] =T1.[ItemCode]

    Add comment
    10|10000 characters needed characters exceeded