cancel
Showing results for 
Search instead for 
Did you mean: 

B1UP Print&Delivery SQL

xhf
Explorer
0 Kudos

Hi people,

I'm working on an email automatic created by B1UP. This email will inform our customer when they receive a parcel. Now I want to show up all the information. like address, what they order and a link to the Track & Trace website. almost everything is working except the the rows what they order.

I used the following SQL code

SQL(SELECT T1.[Dscription] FROM ODLN T0  INNER JOIN DLN1 T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[DocNum] = $[$8.0.0])

Normally in SAP this will work, at this stage I only get the first record. I hope someone can help me out with this?

Thank you.

Accepted Solutions (0)

Answers (1)

Answers (1)

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please check this thread before FMS requirement:

Thanks & Regards,

Nagarajan