Skip to Content
0
Former Member
Sep 18, 2016 at 03:53 AM

SAP B1 OPKL,PKL1,ORDR,RDR1 Table Group By

589 Views

Hi All,

how can i summary all my item that i picked in pick list. my query below is doesn't work.

can any one help me.

SELECT DISTINCT

T3.[Dscription], T3.Quantity

FROM OPKL T0

INNER JOIN PKL1 T1 ON T0.AbsEntry = T1.AbsEntry

INNER JOIN ORDR T2 ON T1.OrderEntry = T2.DocEntry

INNER JOIN RDR1 T3 ON T2.DocEntry = T3.DocEntry

WHERE T0.AbsEntry = [%0]

GROUP BY T3.[Dscription], T3.Quantity

Thanks a lot 😊

Attachments

Screenshot_5.jpg (74.2 kB)