Relationship needed for table KONV

[Former Member]

Hi,

I have to pick up data from table KONV ( Conditions (Transaction Data) ).

i am picking KNUMV ( Number of the document condition ) from VBRK-KNUMV.

From which table can i get the details of other key fields of KONV

1. KPOSN

2. STUNR

3. ZAEHK

also give the name of SD tables related to KONV

regards

[Lakshmipathi]

Dear rajvansh

The field STUNR flows in the following table also

EKBZ:::::::::::: History per Purchasing Document: Delivery Costs

EKBZH::::::::::: History per Purchasing Document: Delivery Costs

JKONV::::::::::: IS-M/SD: Conditions (Transaction Data)

J_1IKONV:::::::Excise recalculated conditions

OIAF7:::::::::::::Formula Condition Txn Data-Header

WCOCOF:::::::Condition Contract: Document Flow Data

MLWERE:::::: Conversion Table between Purchasing and Material Ledger

TTE2C_TAX_MAP::::Mapping between Tax Type and Procedure

VFKONV::::::::::(Freight) Conditions

T683T::::::::::::::Pricing Procedures: Texts

S008:::::::::::::::Communications Table SD -> CO/Projects

COER:::::::::::::Sales Order Value Revenue

RSEG:::::::::::::Document Item: Incoming Invoice

Similarly, field ZAEHK flows in some of the following tables

T6B2F:::::::::: Rebate : Permitted Condition Types/Tables per Group

EKBZ::::::::::: History per Purchasing Document: Delivery Costs

J_1IKONV:::::::: Excise recalculated conditions

OIAF7:::::::::::: Formula Condition Txn Data-Header

OIUQ9::::::::::: Formula Condition Data - Formula group items

T682Z:::::::::::: Conditions: Access Sequences (Fields)

MLWERE:::::: Conversion Table between Purchasing and Material Ledger

T683T::::::::::: Pricing Procedures: Texts

PRCD_COND:::::Price Condition - Item - Condition (KONV)

COER:::::::::::::: Sales Order Value Revenue

RSEG::::::::::::: Document Item: Incoming Invoice

thanks

G. Lakshmipathi

[former_member183879]

KPOSN of KONV equals to VBAP-POSNR or VBRP-POSNR

STUNR and ZAEHK are related to T683S which is pricing procedure

[Former Member]

Hi krishnan,

I have to pick up KAPPL ( Application ) from KONV which is one of the key fields of T683S . Any other tables to pick STUNR and ZAEHK ??

[former_member183879]

I dont think there is some other table

For KAPPL, you can use T681A also.

But for STUNR and ZAEHK, only KONV and T683S are the related tables.

Hope this helps ou

[Former Member]

Hi krishnan,

I also face similar problem, I want to know the actual transparent table (SQL level) and the relationships for these fields:

KONV-KSCHL (Condition type)

KONV-WAERS, (Currency)

KONV-KWERT, (Condition value)

KONV-KBETR (Amount)

Thanks a lot.