FMS Query

[ramco1917]

Hi

  I have below Query and i want to add Period Indicator condition also.

If Date is 01/06/2025 then Series should be of that Period Indicator.

If Date is 01/1-/2025 then Series should be of that Period Indicator.

SELECT T1."SeriesName" from nnm1 T1
where  T1."BP"=$[OINV."BP"] 
and T1."Locked"='N' and T1."ObjectCode"=13

Thanks

[msundararaja_perumal]

Dear @ramco1917 ,

Do inner join with OPID table to link the Period Indicator, then add the necessary condition.

Thanks.