display material based on sales org, distrubution chanel and sales office

[Former Member]

Hello Experts,

I have one requirement where if i give input sales org, distrubution chanel , division and sales office input

,it should give me all material in that sales org, distrubutibution and office.

i have one transaction V/ ld , in that transaction maintained material for sales org, dist chanel and sales office.

but if i see the material which stored in the structure KOMG.

How can i retrive that. how can i find structure KOMG relation to the database table.

Thanks in advance.

Best regards,

Zubera

[Former Member]

Hi,

Do you want to see the Condition records maintained for "sales org, distrubution chanel , division and sales office"?

V/LD is to execute Pricing Reports.

If it's not giving you correct output, You have to create a new Pricing Report for your requirement from V/LA.

You can check below on how to configure a pricing report.

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/90637622-7289-2c10-a3bb-f94d9fa4a5e8

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