Approval Query for GRPO Document when there is no base document that is PO

[Former Member]

Hi,

I want to create a approval template in sap business one and here i want that whenever there is no base document for GRPO then it should go for approval.

Regards,

AswiniKumar

[Former Member]

Hi,

Approval query may only work for header table. Not line table. However, the link is only saved in line table.

Thanks,

Gordon

[kothandaraman_nagarajan]

Hi Aswini Rout,

Try this approval query:

SELECT distinct 'true' FROM PDN1 T0  INNER JOIN OPDN T1 ON T0.DocEntry = T1.DocEntry WHERE T0.[BaseRef] = ''

Assign the above query in approval template.

Hope helpful.

Thanks & Regards,

Nagarajan

[KennedyT21]

Hi Aswini Rout

Try With This Query

Select Distinct TRUE from pdn1 where BaseRef='-1'

Hope Helpful

Regards

Kennedy