T-CD : SQVI - KONV table

[Former Member]

Dear all.

As you know, KONV table cannot be used in T-CD : SQVI because this is Cluster table.

Are there any other tables instead of KONV?

Best Regards.

Sejoon

[former_member217082]

Hi Sejoon

As KONV is a cluster table , so as per your requirement as you want to select and include the required fields(KAWRT,KBETR,WAERS,KKURS,KPEIN,KMEIN) from KONV table and join , so Just include the following fields in the

VBAK, ,VBRP tables

Regards

Srinath

[Lakshmipathi]

As you rightly said, KONV cannot be used in SQVI if you can let us know what is your requirement, may be some suggestions can be proposed accordingly.

thanks

G. Lakshmipathi

[Former Member]

Hi, Lakshmipathi

i'd like to join VBAK, VBAP, VBEP and KONV.

And want to select the following fields from KONV.

KAWRT Condition base value

KBETR Rate (condition amount or percentage)

WAERS Currency Key

KKURS Condition exchange rate for conversion to local currency

KPEIN Condition pricing unit

KMEIN Condition unit in the document

Best Regards.

Sejoon

[hansi_heyderich]

Just in case the question is still open: There is a logical database called VAV which seems to give the details in sales area (unfortunately not in purchase area...).

Haven't tried it but perhaps it helps someone.

BR,

Hansi