list of condition records

[cathy_liang]

Hi experts,

Any reports to capture list of condition records for one sales organization? U know, VK13 just can list one customer's condition record if the key combination is customer/material with release status.

Pls advise. Thx.

[Lakshmipathi · Accepted solution]

Go to V/LD, key in 28 and execute. Maintain sales organisation and remove the from date and execute. You will get customer wise all pricing details.

thanks

G. Lakshmipathi

[Former Member]

Hi,

Alternate to this is: go to VBAK table, key in the sales org for which you want the data( conditions). execute it & the copy the condition record numbers from the table. Then go to KONV table & key in the condition record numbers, execute it & it will give you the condition types along with the condition values..

Hope this may help solving your problem.

Thanks

[Former Member]

Hi,

Go to SE16 n & Try using these tables:

A501 Sales org./Partner/Material

A502 Sales org./Partner

A503 Sales org./Partner/Key

A700 Sales org./RecipCntry/TaxCl.Mat/Currency/Material

A701 Sales org./RecipCntry/Currency/TaxCl.2Mat/Material

A720 Sales org/Dep Cntry/Dest Cntry/Incoterm/TaxCl Cust/T

A721 Saleorg/SorCntry/DesCntry/Incotrms/TaxCl1Cus/TaxClMa

A801 Return VAT

A816 Order type/Sales off./Sold-to pt/Ship-to/PH1/PH2/PH3

A817 Order type/Sales off./Sold-to pt/PH1/PH2/PH3/PH4/PH5

A818 Order type/Sales off./PH1/PH2/PH3/PH4/PH5/PH6/Materi

A820 Sales org.

A826 SalesDocTy/Sales off./Sold-to pt/Ship-to/PH1/PH2/PH3

A827 SalesDocTy/Sales off./Sold-to pt/PH1/PH2/PH3/PH4/PH5

A828 SalesDocTy/Sales off./PH1/PH2/PH3/PH4/PH5/PH6/Materi

A901 Transfer price by PC, Part PC, and SKU

A902 Profit center and material only

A903 Table for Cost Plus Transfer Price

A904 Profit center and material only

A905 Transfer Price by Material

A906 Table for Cost Plus Transfer Price

A907 Sales org./Distr. chl/Customer/PH1/PH2/PH3/PH4/PH5/P

A908 Sales org./Distr. chl/Price list/PH1/PH2/PH3/PH4/PH5

A909 Sales org./Distr. chl/Price List Type /Mat.pr.grp

Based upon the combination, u can get the condition records associated.

You can use A820.. This will give the condition record numbers for a particular Sales Org.

Thanks

[cathy_liang]

Many thx for all your valuable advice.

For V/LD, I got some questions about the fields "cond. marked for deletion" & "exclusive" under "list screen". When just checking one of the boxes for those two fields, why conditions that have NOT been marked deletion or exclusive still show in this report?

Moreover, can some pricing reports be suppressed from the selection scope? U know, not all the reports are useful for customer.

Edited by: Cathy on Apr 16, 2009 12:43 PM

[cathy_liang]

Any response?

[Former Member]

hello, cathy.

try pricing reports, using V/LD.

regards.

[Former Member]

I need to download the material number, material description, with the condition (price) listing... appears to have only the material number .. any suggestions?