How can the amount be subtracted based on condition types?

[atif_bhatti]

Hi wisers,

I am working on a report where I have used invoice table VBRP and VBRK.

The customer has asked to exclude some of the condition types from the total invoice value (such as expenses).

I am using the following

1) get Document condition VBRK-KNUMV

2) check all the condition type KONV-KSCHL (Condition type)

3) subtract the amount KONV-KWERT (Condition value)

Can the above assumption is correct?

When I have analysed it looks that it will work but I need to confirm it.

thanks

Regards

Atif

[Lakshmipathi · Accepted solution]

asked to exclude some of the condition types from the total invoice value

Most probably, these values would flow in VBRP table itself.  So first check whether they are flowing and if so, straightaway, you can excluse those values in the report being developed by you.  If it is not there, then you can go for the logic what you had mentioned.

G. Lakshmipathi

[atif_bhatti · Accepted solution]

Can you kindly state which fields have this info in VBRP table? I tried to search for Doc condition but I can not find it. I notice one thing that one can find the condition from sales order table but invoice is the best option among sales order and invoice table.

[Lakshmipathi · Accepted solution]

Based on your pricing procedure configuration, you can post different values to Subtotal-1 to 6 which you can see in VBRP.  Check that whether you were able to see those values which can be excluded.

G. Lakshmipathi

[atif_bhatti · Accepted solution]

Hi again,

For some reason the subtotal 1-6 in VBRP is not set.

But I have managed to compute the inovice excluding the conditions which are not required.

using the following approach

1) get Document condition VBRK-KNUMV

2) check all the condition type KONV-KSCHL (Condition type)

3) subtract the amount KONV-KWERT (Condition value)

thanks for you help.

Atif