Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

how to fetch the data from VK13 transaction

0 Kudos

Hello Guys,

do you have any idea about how to fetch the data from the transaction VK13 for the Key combination Material.

in above screenshot i have highlighted the field i want to fetch that field and using the combination is Material.

Could you please help me out in this.

1 ACCEPTED SOLUTION

michael_piesche
Active Contributor
0 Kudos

If you are wanting to find out the database tables, do the following:

If you already know the condition table (e.g. A004, go to 6., if you only know the condition type and the key, start with 1.

  1. Open transaction VK13
  2. Enter your condition type and key
  3. On the next selection screen, press the F1-help for one of the options
  4. In the opened "Performance Assistant", click the "Technical Information" button (hammer and pliers / toolbox symbol)
  5. In the opened "Technical Information" you will find a Table name like "Axxx" (e.g. A004), whereas Axxx (e.g. A004) is the database table for the condition key (not the value yet).
  6. Select your key based on the Axxx table and note the Condition record number KNUMH
  7. Based on KNUMH, you will find the following data in the following condition tables
    KONP - Conditions (Item) => contains the value in KBETR
    and the currency/percantage in KONWA
    percentage needs to be divided by 10

    KONH - Conditions (Header)
    KONM - Conditions (1-Dimensional Quantity Scale)
    KONW - Conditions (1-Dimensional Value Scale)
5 REPLIES 5

michael_piesche
Active Contributor
0 Kudos

What do you mean with 'fetch'?

Do you mean, that you want to read a condition value for a material and condition type from the database? (But this wouldnt have anything to do with VK13, you would just be helping to point out what you are looking for)

Or do you want to 'enhance' VK13 and do something with the displayed data, either in dialog or in background processing.

0 Kudos

Hello Michael,

Yes i want to read a condition value for a material and condition type from the database

michael_piesche
Active Contributor
0 Kudos

If you are wanting to find out the database tables, do the following:

If you already know the condition table (e.g. A004, go to 6., if you only know the condition type and the key, start with 1.

  1. Open transaction VK13
  2. Enter your condition type and key
  3. On the next selection screen, press the F1-help for one of the options
  4. In the opened "Performance Assistant", click the "Technical Information" button (hammer and pliers / toolbox symbol)
  5. In the opened "Technical Information" you will find a Table name like "Axxx" (e.g. A004), whereas Axxx (e.g. A004) is the database table for the condition key (not the value yet).
  6. Select your key based on the Axxx table and note the Condition record number KNUMH
  7. Based on KNUMH, you will find the following data in the following condition tables
    KONP - Conditions (Item) => contains the value in KBETR
    and the currency/percantage in KONWA
    percentage needs to be divided by 10

    KONH - Conditions (Header)
    KONM - Conditions (1-Dimensional Quantity Scale)
    KONW - Conditions (1-Dimensional Value Scale)

0 Kudos

Hello Maichael,

it worked !!!!! thanks a lot for your answer.

0 Kudos

Please use the COMMENT button for comments, questions, adding details, etc., ANSWER is only to propose a solution, dixit SAP text at the right of the answer area.

If you do a comment under a question/answer and you want to target someone else than the question/answer' author, the only solution is to copy/paste their hyperlinked name so that the person receives a warning (NB: @ doesn't work)