Skip to Content
0
Jul 11, 2016 at 10:33 AM

Formatted Search Select More Than One Row

95 Views

Hi Sap Experts

Is it possible for a user to select more than one row in a formatted search?

I have written the below query which looks at the packing for a delivery and I need the user to be able to return the whole table in a UDF with a formatted search.

Currently when the user run's the formatted search it displays each pack per packing row, but even after holding SHIFT it will only let the user to select one.

The UDF is at document header level where the packing is line level.

The query is as per the below

SELECT concat('Pack Num',' ',T1.PackageNum,' ','Length',' ',ceiling(t2.length1),'cm',' ','Width',' ',ceiling(T2.Width1),'cm',' ','Height',' ',ceiling(T2.Height1),'cm')

FROM ODLN T0 INNER JOIN DLN7 T1 ON T0.[DocEntry] = T1.[DocEntry] inner join opkg t2 on t1.packagetyp=t2.pkgtype

WHERE T0.DOCNUM=$[ODLN.DocNum.0]

Many Thanks !!

Chris :-)