on 04-18-2005 10:21 AM
What is the diffrence between KONV and KONP ?
Hi,
KONV and KONP tables are both conditions tables. These tables are used when you want to find e.g : the Basic price value or excise duty values (just to name some ) .
These tales store the values based on the document condition number.
The Document Consition number(KONV-KNUMV) is number that gets generated whenever a PO or a sales order gets created. So this KNUMV is the link between the PO or the sales order. The KNUMV gets stored in KONV as well as the header tables of Sales order and Purchase order.
Let me give you an example: Incase you have a sales order number say 1206 now for this you want to create to know what is the Basic price: - so you would go to VBAK get the KNUMV of 1206 , for the KNUMV fetched go to KONV and give this KNUMV you will get all the conditions for this sales order. Same is the case with PO's also.
Now KONP also stores the conditions can be used with access sequences eg a003 or a055 etc. you cantake the KNUMH value from these tables and get the rate from KONP.This table only stores the rates and not the values. i.e KBETR value and not KWERT value.
I hope this answers your question.
Regards,
Narayani
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
KONV - Will have sales order related conditions..
KONP - Will have the values for the condition records..Not related to any transaction..But a global record that is used to propose the values for the transactions..
Thanks
Naren
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
KONV: Table stores condition values from a document along with condition type, document item no. and document condition number, etc.
KONP: Table stores the condition records for all condition types. i.e. condition master record. along with condition record number.
A5* : access sequence table for the condition types. If you konw the access sequence table from condition information, you can find the condition record number from A5* table.
From condition record number you can find the condition record value from KONP.
Similarly if you find the document condition number from say VBRK table, then you can find out the condition values for all condition types in the document from KONV table.
Regards,
Pranjal
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.