Skip to Content
author's profile photo Former Member
Former Member


hi Gurus,

PR00 value (pricing value) will be stored in which table??

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 07:39 AM

    The table will depend upon the "key combination"

    The KONP table stores the condition number and the following tables the value (there can be customized tables also)

    A002 Domestic Taxes

    A004 Material

    A005 Customer/Material

    A006 Price List Type/Currency/Material

    A007 Division/Customer

    A011 Export Taxes

    A020 Division/Price Group

    A029 Material Pricing Group

    A030 Customer/Material Pricing Group

    A031 Price Group/Material Pricing Group

    A032 Price group/Material

    A033 Incoterms

    A034 Incoterms (Parts 1+2)

    A040 Country/State/Customer Classif.1/Material Classification 1

    A041 Country/State/County/Customer Classif.2/Material Classif.2

    A042 Country/State/City/Customer Classif.3/Material Classif.3

    A055 Sales Org./Order/Plant/Material

    A056 Sales Org./Order/Plant

    A057 Variants

    A064 Customer Hierarchy

    A065 Customer Hierarchy/Material

    A070 EAN per Plant

    A071 Material per Plant

    A072 EAN per SOrg/DstCh

    A073 Material per SOrg/DstCh

    A074 Plant/Customs Area/Material

    A078 Departure Country / Destination Country

    A079 Sales Organization/Distribution Channel/Material Group

    A089 SD Document/Material

    A090 SD Document/Item/Material

    A098 SD Document/Item/Material Pricing Group

    A099 SD Document/Item

    A100 SOrg/DstCh/Material_MainItem/Material

    A101 SOrg/DstCh/Material-Main Item/Material Pricing Group

    A102 SOrg/DstCh/Material Pricing Group-Main Item/Material

    A103 SOrg/DstCh/MaterialPricingGroup-MainItem/MatPricingGroup

    A106 Price List/Material Group

    A110 Sales Organization/Destination Country

    A114 Tax Exemption: Customer

    A116 Tax Exemption - Customer/Tax Classification 2-Material

    A117 Tax Exemption: Customer/Material

    A121 Legal regulations: Values for calculated foreign percentage

    A133 Mixed Taxes, Domestic

    A134 Vendor

    A140 Sales Area / Accounting Indicator

    A144 Sales Deal Basic Data

    A145 Sales Deal - Customer/Material

    A146 Customer hierarchy

    A147 Customer hierarchy (sales deal)

    A148 Product Hierarchy

    A149 Customer-dependent data determination

    A152 Sales Org./Dist. Channel/Plant/Material/Sales Unit/Customer

    A153 Sales Org./Distribution Channel/Plant/Sales Unit/Customer

    A154 SalesOrg./Dist.Channel/PriceList/Material/SalesUnit/Customer

    A155 Sales Org./Dist. Channel/Price List/Material/Sales Unit

    A172 Campaign ID/Material

    A180 Country/Preference Zone/Cross-Plant Grouping

    A185 Order no./Item/Configuration no./Material/Preference zone

    A190 Country/StCla-Mat

    A191 Country/Rec.Country/StCla-Mat

    A192 Country/Goods Rec./StCla-Mat

    A193 Country/Region/StCla-Mat

    A291 Country/Tax Code

    A292 BR: ISS from SD: Ship-to City

    A293 Country/Tax Classification 2 for Customer

    A304 Material with release status

    A305 Customer/material with release status

    A306 Price list category/currency/material with release status

    A307 Customer with Release Status


    A312 no.

    A340 Foreign Trade: CAP: Restitution rates

    A341 Country/Tax Classification 3 for Customer

    A342 Country/Tax Classification 2 for Material

    A343 Substitução Tributária from SD

    A344 ICMS Base Reduction Carrier (Brazil)

    A346 Country/Dynamic Key 1/Dynamic Key 2/Dynamic Key 3/Tax Group

    A347 Country/Ship-From/Ship-To/Key 1/Key 2/Key 3/Tax Group

    A348 Country/Ship-From/Ship-To/ST Gr./Key 1/Key 2/Key 3/Tax Group

    A349 Country/Ship-To/Material No.

    A350 Sales org.

    A352 ST Code/Post.code/PlntRegion

    A353 ST Code/Region/PlntRegion

    A354 Country/Region/PlntRegion

    A355 Jur. code

    A356 Country/PlntRegion/ST Code/TaxCl1Cust/TaxCl.Mat

    A357 Country/Plant/Ctrl code

    A358 Country/Plant/Ctrl code/Material

    A359 Plant/Matl group

    A362 Country/NBM-NCM Code

    A363 Plant/Vendor/Material

    A364 Trading contract/vendor/material


    A367 Country/Plant/Region/Material

    A368 Country/PlntRegion/Region/TaxCl1Cust/TaxCl.Mat

    A369 Country/Plant/Ctrl code/TaxCl1Cust

    A371 Country/Plant/Ctrl code/Ship-to

    A372 Sales org./Ref.doc./Ref.item

    A373 Country/Plant/Material

    A374 Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3Mat

    A375 Country/Sales org./Region/PlntRegion/TaxCl2Cust/TaxCl.2Mat

    A376 Country/Sales org./Region/PlntRegion/TaxCl4Cust/TaxCl.4Mat

    A382 Country/Doc. Ty./Ship-From/Ship-To/Key 1/Key 2/Key 3/Tax Gr.

    A390 Brazil: 100% reversals

    A392 Country

    A393 Country/Vendor

    A394 Country/Ship-to Location

    A395 Arg.: Country/Fisc.Type

    A396 Arg.: Country/Fisc.Type/Material

    A397 Arg.: Tax relevant classification

    A399 Withholding tax code - country-specific

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 30, 2007 at 07:48 AM

    The transaction values of condition types stroed in KONV

    You can get the KNUMV from VBAK table for hte sales document number, give this as input in KONV table for KNUMV and then get all the KSCHL and KWERT from KONV.

    This will give you the values of all condition types in a document.

    The values in condition records can be fetched using various tables like KONP, KONH, KONW etc.

    Hope this helps.

    Reward if this helps.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.