Skip to Content
0
Jun 05, 2018 at 03:10 PM

How do i count positions/items from DLN1 to ODLN

218 Views Last edit Jun 05, 2018 at 03:11 PM 2 rev

Hello together,

I hope someone can help. Im playing around with a query resulting from ODLN the delivery table. I like to inner join to dln1 and do a count of the positions and a count of the items per position regarding to DocNum in ODLN.

Like that:

DocNum / [Position Total] / [Items Total]

[123456] / [6] / [60]

Thanks in advanced for your help.

Cheers

Andreas