Table to be used to fetch conditon value of a condition type

[Former Member]

Hi Friends

I need to do some enhancements to a report where in I have to add a new column which adds up the netvalue of the invoice ( netwr) with the condition value of a tax condition ( octori ). To fetch the condition value of this conditon which is the appropriate table to be used ? Usually KONV is used but this is leading to slow performance. Is there any alternative table ? Can KONP be used ?

Regards

Mahesh

[Former Member]

Hi

Use table KONP -- it will give the condition recd number for condition type..

after that use AXXX - Table for Condition recd -- condition value..

NOTE : XXX - your condition table

Muthu

[former_member227476]

dear mahesh

through system modification you can add this field

add the fields to the structures KOMK,KOMP

rewards if it helps

siva

[Former Member]

Hi

Pl find below tables related to pricing

KOMK,KOMV,KOMP

KONV Conditions for Transaction Data

KONP Conditions for Items

KOND Conditions (Data)

KONH Conditions (Header)

KONM Conditions

T684 Condition Exclusion Groups

T684G Condition Exclusion Groups: Condition Types

T684S Condition Exclusion: Procedure Assignment

T689 Download Profile for the Conditions

T689K Reference: Download Profile - Pricing Procedures

Axxx- condition record tabel

eg: A304- is table for condition record for material with release status

A305, a306,a074

A000 Condition Table for Pricing

I have not checked any of them. Dont know whether it will help you.

regards

[Former Member]

hi mahesh,

try to put some more condition other than knumv.

u can use item,kschl (type) etc with ur condition value.So the performance will be good.

again try to select the value fields alone from the table .

move it_vbrk-knumv to knumv.

select f1 f2 f3 f4 from konv into table it_konv for all entries in it_vbrp where knumv eq knumv and kposn eq it_vbrp-posnr and kschl eq 'PR00'.

hope it will help u.

regards,

manikandan

[Former Member]

I think if you use VBRK-KNUMV to search table KONV, the performance will be ok

and in VBRK and VBRP, there are fields for tax amount

[Former Member]

Steve,

So far we have been using VBRK-KNUMV from KONV and performance is not satisfactory.

Any other ideas ?

Regards

mahesh

[Former Member]

hi Mahesh,

I am not sure about your tax condition octori

In my system the VAT tax can be found in VBRK-MWSBK and VBRP-MWSBP

Steve