Pricing Table

[Former Member]

Hi All

what are the tables and fields used for pricing ?

Thanks

Ashwath Reddy

[Former Member]

Hi,

Following are the tables used for storing pricing related data

KONV Conditions for Transaction Data

KONP Conditions for Items

KOND Conditions (Data)

KONH Conditions (Header)

KONM Conditions

A000 Condition Table for Pricing $

T684 Condition Exclusion Groups

T684G Condition Exclusion Groups: Condition Types

T684S Condition Exclusion: Procedure Assignment

T689 Download Profile for the Conditions

T689K Reference: Download Profile - Pricing Procedures

Reward points pls.

Regards,

Govind.

[Former Member]

hi,

There are two things about pricing tables

1. Condition tables

2. Prices tables

Condition tables

These tables stores the values which will be maintned in condition records ie., VK11

Example PR00--> will have access sequence PR02 which inturn has condiotion tables

305 Customer/material with release status

306 Price list category/currency/material with release status

304 Material with release status

The tables corresponding will be A304,A306 & A305 the condition table will have "A" series

Price tables

KONP Conditions (Item)

KONV Conditions (Transaction Data)

KOMP Conditions (Transaction Data)--> this is structure tables

• Fields*

KNUMH Conditions (Transaction Data)

KSCHL Condition type

hope this helps u

regards,

Arun prasad C R

[Former Member]

HI,

First of all there are 2 things:

a) Master Price (maintainted thro VK11)

b) Transaction Data Price (sale order / Invoice)

For point a) you can go to KONH ( Pricing Header table)

KONP ( Pricing Item Table)

Also most important point is you need to know the condition tables for getting the price from KONP. These tables start with conventions as A582, a555 etc.

For point b) if the document is an invoice, put the invoice in VBRK table and retrieve the condition record no (VBRK-KNUMV) mandatory & unique for each doc.

Pass this KNUMV into KONV table, you can get the transaction price details for all the condition types.

Hope this helps.

Regards,

JLN

[Former Member]

hi,

KONH Conditions header

KONP Conditions items

KONV Procedure ( billing doc or sales order)

regards

sadhu kishore

[Former Member]

Hi,

You can see Pricing Field Catalog with trcode:OV24

[Former Member]

Hello,

in wiev V_T681F you can see all permitted fields for condition technique.

Sarhan.