Help me with A sql query for Approval Procedure

[pvinod_kumar]

Hi experts

I need the users to go through Approval Procedure if the user create the Delivery Note using the Tax code 'X0'

Regards

Vinod

[kothandaraman_nagarajan · Accepted solution]

Try this query,

SELECT distinct 'True' FROM ODLN T0 INNER JOIN DLN1 T1 ON T0.[DocEntry] = T1.[DocEntry] WHERE $[$38.18.11] = 'X0'

[kothandaraman_nagarajan]

Do you need approval query for only one line item?

[pvinod_kumar]

Only for single line is not usefull one for me .

Because users may use multiple lines...if it's not possible for multiple lines as per u said pls provide me with transaction processes query.

Let me ask a doubt

If am having 3 lines and in 2 lines there is vat and in the 3rd line there is no vat then will it go for approval..if it works then it's good for my client

Regards

Vinod

[kothandaraman_nagarajan]

This is standard system design from SAP for approval. If delivery order contains only one line item, then approval process will work for that line only.

If multiple lines, the you have to create add-on for approval process.

[pvinod_kumar]

Ok understand

Can u provide me the query for the procedures

Regards

Vinod

[kothandaraman_nagarajan]

We can't make approval through transaction notification.

[pvinod_kumar]

Can u give me a solution for approval procedures through approval procedures

Bec it's will only help me in my client business scenario

Regards

Vinod

[kothandaraman_nagarajan]

Hi,

The approval process will work only on header level not on row level.You can user transaction notification instead of approval process.

Regards,

Nagarajan

[pvinod_kumar]

But through transction process can we make approval.

If so can u pls share the query for that

Regards

Vinod