https://community.sap.com/t5/technology-q-a/how-pass-one-parameter-value-with-multiple-value-to-the-other-parameter-in/qaa-p/12463568#M4668668 <P>Try changing your Where clause to this:</P><P>WHERE (T0. BPLName in '@Kibuz')</P><P>-Dell</P> Wed, 09 Jun 2021 13:18:16 GMT DellSC 2021-06-09T13:18:16Z https://community.sap.com/t5/technology-q-a/how-pass-one-parameter-value-with-multiple-value-to-the-other-parameter-in/qaq-p/12463567 <P>Hello,</P> <P>this is my parameters:</P> <P>1. Kibuz@SELECT distinct BPLName FROM OBPL</P> <P>2.Projct@SELECT distinct U_Z_code,U_Z_name FROM OBPL T0 INNER JOIN [dbo].[@A1GEN_PROJ_SITE] T1 ON T0.BPLId=T1.U_Z_BusinessPlace WHERE (T0. BPLName = '@Kibuz')</P> <P>This is working if i choose in the first parameter one value, but if i choose "Allow multiple value" the second parameter is not display data.</P> <P>Any idea?</P> Wed, 09 Jun 2021 08:37:27 GMT https://community.sap.com/t5/technology-q-a/how-pass-one-parameter-value-with-multiple-value-to-the-other-parameter-in/qaq-p/12463567 former_member718258 2021-06-09T08:37:27Z https://community.sap.com/t5/technology-q-a/how-pass-one-parameter-value-with-multiple-value-to-the-other-parameter-in/qaa-p/12463568#M4668668 <P>Try changing your Where clause to this:</P><P>WHERE (T0. BPLName in '@Kibuz')</P><P>-Dell</P> Wed, 09 Jun 2021 13:18:16 GMT https://community.sap.com/t5/technology-q-a/how-pass-one-parameter-value-with-multiple-value-to-the-other-parameter-in/qaa-p/12463568#M4668668 DellSC 2021-06-09T13:18:16Z