Skip to Content
0

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

Jul 05, 2017 at 03:49 PM

78

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Balaji Selvaraj Jul 06, 2017 at 06:20 AM
0

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]

Share
10 |10000 characters needed characters left characters exceeded