approval query

[Former Member]

Hi,

       i need a approval query for purchase order

For example:

          i create a purchase order . doc total is 51000. if  it is doc total below 50000 approval is not need. above 50000 approval is needed. sap b1 default option is there approval procedure . my problem is we are creating purchase order different numbering series like

tool po (numbering is start like 1220000,1220001,)

production PO.

so i need a approval query for purchase order depends on numbering series. is it possible

[KennedyT21 · Accepted solution]

Hi Ramesh....

Try This

SELECT distinct 'true' FROM OPOR T0 WHERE $[OPOR.DocTotal.number] >50000 and 

T0.Series In ( '    '  )

Mention the Series where you want the approval procd...

Hope Helpful

Regards

Kennedy

[Former Member · Accepted solution]

it is not working

[Former Member]

Do you still have question on this issue? If yes, please specify. Otherwise, close it.

[Former Member]

Hi,

Try:

SELECT distinct 'true' FROM OPOR T0 WHERE $[OPOR.DocTotal.number] >5000 and $[OPOR.DocNum] LIKE '122%'

Thanks,

Gordon

[kothandaraman_nagarajan]

Hi,

Run SELECT T0.[Series] FROM OPOR T0 and let me know the series number.

[Former Member]

Hi,

hi,

Try this query.

SELECT distinct 'true' FROM OPOR T0 WHERE T0.[DocTotal] >1000 and t0.series in (5)

Note : in series check with your nnm1 TABLE and put the same

Regards,

Shanmugam V.

[kothandaraman_nagarajan]

Hi Ramesh,

Try this:

SELECT distinct 'true' FROM OPOR T0 WHERE T0.[DocTotal] >51000 and t0.series in ('52')

Hope helpful.

[Former Member]

it is not working . approval is asking but it is taken all series and doctoal below and above 50000 concept also not taken

[kothandaraman_nagarajan]

Hi,

Change the series in above query as per your requirement.

[Former Member]

i changed depends on my series

[kothandaraman_nagarajan]

Please paste your series and changed query here.

[Former Member]

SELECT distinct 'true' FROM OPOR T0 WHERE T0.[DocTotal] >50000 and t0.series in ('166')

same query i put it is not working