Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on 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 a 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.

  • Posted on 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 a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.