cancel
Showing results for 
Search instead for 
Did you mean: 

How to pass Pindicator as parameter in query manager in sap b1

sathishsoft001
Discoverer
0 Kudos
SELECT *
FROM (SELECT b.ItemCode,c.ItemName,c.U_Size, c.U_Mode,d.ItmsGrpNam,c.U_SubGrp7,
       DATENAME(MONTH, a.DocDate) [Month], 
       SUM(isnull(b.Quantity,0))[sales count]
      FROM oinv a
      left join INV1 b on a.DocEntry=b.DocEntry
      left join OITM c on b.ItemCode=c.ItemCode
      left join OITB d on c.ItmsGrpCod=d.ItmsGrpCod
      LEFT JOIN NNM1 E ON A.Series=E.Series
      where E.SeriesName LIKE 'MR%' AND A.CANCELED='N' AND B.WhsCode='SG' AND  B.TreeType<>'I' AND A.PIndicator='FY1819' ---- Here how to pass runtime parameter in query manager

Accepted Solutions (0)

Answers (1)

Answers (1)

Johan_H
Active Contributor
0 Kudos

Hi,

You can use the syntax for parameters in complicated queries:

/* select * from OITM x */
DECLARE @Pindicator AS NVARCHAR(10)
SET @Pindicator = /* x.PIndicator */ '[%0]'
SELECT *
FROM (SELECT b.ItemCode,c.ItemName,c.U_Size, c.U_Mode,d.ItmsGrpNam,c.U_SubGrp7,
       DATENAME(MONTH, a.DocDate) [Month], 
       SUM(isnull(b.Quantity,0))[sales count]
      FROM oinv a
      left join INV1 b on a.DocEntry=b.DocEntry
      left join OITM c on b.ItemCode=c.ItemCode
      left join OITB d on c.ItmsGrpCod=d.ItmsGrpCod
      LEFT JOIN NNM1 E ON A.Series=E.Series
      where E.SeriesName LIKE 'MR%' AND A.CANCELED='N' AND B.WhsCode='SG' AND  B.TreeType<>'I' AND A.PIndicator=@Pindicator

Regards,

Johan