Listing Conditions Values for all materials

[Former Member]

Hi SAP Experts,

We need the SAP Tables which store the Conditions data like Condition types, Condition Values, Validity from date, Validity to date, and Materials for pulling a conditons Report for all materials.

We have checked the pricing report t-code : V\LD . But this does not give all data (it does not show all conditions).

Appreciating your quick reply.

Thanks and Regards,

Umesh Karane.

[Former Member]

You can check data in KONP, KONV tables. And as Anupa has mentioned you can go through these stadard reports also. One mre option is try to search for the tables starting from A0, these all are pricing table.

Thanks.

Raja

[Former Member]

Hi,

It is totally depend in the pricing configuration you have done for your client.

What you can do is create a new Pricing report for your requirement.

Follow these steps to create a Pricing report.

To create the Pricing Report

Tx: V/LA

u2022 Enter Name for the List (Starting from a letter) & a Title

u2022 Press "Forward Foot Print"

u2022 In the new screen you have to select all key fields that should be taken into consideration in the pricing report.

u2022 Highlight all relevant fields

u2022 Press AND or OR appropriately

If you select OR ; all condition tables are evaluated, that contain at least one of the selected key fields.

If you select AND; all condition tables are evaluated, that contain all selected key fields.

u2022 Now youu2019ll be directed to condition table list that are to be evaluated. Highlight relevant condition tables (Which you have created for your customers requirement)

u2022 Select "Forward Foot Print" to define the screen structure for the pricing report.

u2022 You can configure the report layout here.

u2022 Once everything is done, save the report.

To run a pricing report

Transaction: V/LD

u2022 Enter pricing report number

u2022 Press EXECUTE

u2022 Execute it by giving relevant data.

You can get all values in one screen.

Alternative option

As an alternative to your question, you can use "Condition Information" Button option in the VK11, VK12 & VK13 transactions.

But there you cannot see the value in the same screen.

To view those, go to "Condition Information" button.

BLANK All fields.

Then Execute.

You have to double click and go in to see the value.

Best regards,

Anupa