on 01-31-2011 1:14 PM
Hi
Please can someone tell me the table to see pricing conditions against a sales order item. I was sure there was a table to give me this info, but I cannot seem to find it. I need the table because we have some orders where a specific pricing condtion has been used and it has not billed correctly because of this pricing condition.
PLease advise
thanks
Kylie Jordaqn
hi,
take the list of tables where the condition types will be stored.
KONH Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order)
KOND
hope this clears your issue.
balajia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Kylie,
The table is KONV: Conditions (Transaction Data). Two of the key fields are
1. KNUMV (Number of the document condition) --> which you can obtain from VBAK as sap2000k previously said
2. KPOSN (Condition item number) --> you can match this to your sales order line item (e.g. item 10)
One non-key Field is also
3. KSCHL (Condition type) --> here you may key in the desired condition type to see the line items where it occurs given a KNUMV:document condition number related to a VBELN:Sales Document (number)
Please let us know should you need more info.
Kind regards,
Eva
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Kylie
pick sales order no pass it in vbak-vbeln then pick the value Number of the document condition VBAK-KNUMV Then pass
this value in KONV-KNUMV .
here you may get conditions.
Regards,
Nar
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
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.