on 04-25-2007 8:36 AM
Hi All,
Iam confused which pricing tables are used and where.
for instance
1) which tables are used during sales order pricing before saving the sales order.
2) which tables are used after saving the sales order.
3) what are the tables used when we create condition records in VK11.
4) when we maintain condition reocrds for different access for a condition type. which tables are hit.
5) what are KOMV, KOMP,KOMG, KONV,KONP,KOMK tables etc.
what is condition record no and item condition no and how the data gets transferred from condition records to sales order.
regards
sachin
regards
sachin
Hi,
SAP uses 2 different types of table before saving the application documents. The tables used before saving the sales orders are known as structures. So the data is buffered into these structures before saving. once you saved,the structures will commit to respective SAP tables. so the saved data is stored at tables.
KOMV, KOMP,KOMG, KONV,KONP,KOMK are structures.
KOMV-Pricing Communications-Condition Record
KOMP-Pricing Communication Item
KOMG-Allowed Fields for Condition Structures
KONV-Conditions (Transaction Data)
KONP-Conditions (Item)
KOMK-Communication Header for Pricing
KONA-Rebate Agreements
The condition records will be executed based on the above structures..
The conditon record no is nothing but in a particular sales order based on the conditon types assinged in the pricing procdure.which conditon record for a particular conditon record is displayed at which line and the Iem conditon no is known for which line items in a sales order that particular conditon record is displayed.
Reward if this helps
Regards
Simu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi!! Sachin,
All your questions have to understood in the perspective of Condition technique for pricing.
1)First check the enteries in t.code OVKK , a pricing procedure is maintained for combintion of Sales AreaCust. pricing procedureSal doc pricing procedure.Note down one of the pricing procedure
2)For this pricing procedure check in t.code V/08 there exists a control data, select a pricing procedure(select the one you normally use or the one noted down earlier) & click on the control data. This will show a list of condition types used for this pricing procedure.Note down one of the condition type.
3)For this condition type check in t.code V/06, go to the detailed screen of one of the condition type(choose the one you normally use or the one noted down) you will find an access sequence attached to it. Note this access sequence no.
4)For this access seq check in t.code V/05, select the access seq. you noted down in last step, now from the left hand margin click on 'accessess' in this screen select any one line item & from the left hand margin click on 'Fields'.
5)Here on the top you can see the table no., This is the table you are searching for - a structure/table where we maintain condition records.
When you use the menu path Easy Acess>Logistics>Sales & Dist>Master Data>select using condition type>create>enter a condition type now click on key combination- this will be the access sequence what u saw in step 4. Select any one ( so basically you are selecting the table u saw in step 5. these are the tables you are searching for the KOMG, KOMP etc.)
The values mentioned in these tables are the condition records.
Hope this clarifies , pl give your feedback.
Regards,
PATHIK
Message was edited by:
Pathik Pandya
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
1) KONP table is used during sales order pricing before saving the sales order
2) VBAP table is used after saving the sales order
3) KONP table is used when we create condition records in VK11
4) KONP,KONH,T185, VBMOD, VDATA
5) These tables are used to store Pricing related data during condition record creation(VK11)
the data gets transferred to the sales order depending on the pricing procedure which is based on sales area+ customer pricing procedure+document pricing procedure.
hope it helps
cheers,
anil.
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 | |
4 | |
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.