how to fetch the data from VK13 transaction

[former_member652588]

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.

[michael_piesche]

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.

[former_member652588]

Hello Michael,

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

[michael_piesche]

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)

[former_member652588]

Hello Maichael,

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

[Sandra_Rossi]

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)