Skip to Content
avatar image
Former Member

Relationship needed for table KONV

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jul 31, 2007 at 05:07 AM

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

    STUNR and ZAEHK are related to T683S which is pricing procedure

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Navaneetha Krishnan

      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.

  • Apr 03, 2008 at 04:18 AM

    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

    Add comment
    10|10000 characters needed characters exceeded