PR00

[Former Member]

hi Gurus,

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

[former_member183879]

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.

[Former Member]

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

A311 TrCont.no.

A312 TrCont.no./Item 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

A366 TrCont.no.

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