download intercompany prices

[cathy_liang]

Hi experts,

The condition type ZI01 is created with reference to the standard condition type (Intercompany price - standard cost). It's based on sales organization, distribution channel, division, plant, customer & material. U know, one customer may order different products against different intercompany prices.

Example (Tcode VK13):

sales organization A

distribution channel B

division C

plant D

customer E

material 123 - intercompany price $10

material 456 - intercompany price $20

Q1. Any chances to download those prices (Intercompany price - standard cost) to Excel at one time via VK13, or ...?

Q2. Must SE11/ SE16 be used? If yes, how to limit the condition type when running it? U know, except ZI01, there're many other condition records exist.

Plz help. Many thanks.

[Former Member]

Hi,

This can be easily handled by Pricing reports in SAP. This is how you do it. First you need to create a pricing report for you combination,

How to Create a pricing report

Transaction: V/LA

u2022 Enter Name for the List (Starting from a letter, not numbers fully) & a Title

u2022 Press FOOTPRINT button

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 (sales organization, distribution channel, division, plant, customer & material)

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 used to store ZI01)

u2022 Select "FOOT PRINT to define the screen structure for the pricing report.

u2022 You can configure the report layout here.

o Mark BLANK under u201CSelectionu201D; for fields that are not used as selection criteria.

o Mark TICK to set mandatory fields on the selection screen.

o Use POSITIONING to place different filed in the layout of the report.

o SORT is the number determining the sequence in which the individual objects are displayed.

o TEXT is used to view only Field ID or Field Text or both Field ID & Field Text.

u2022 Once everything is done, save the report. A TR number will get generated.

Now you need to run the report to extract pricing for ZI01.

How to run a pricing report

Transaction: V/LD

u2022 Enter pricing report number (Which you created from above steps)

u2022 Press Execute

u2022 Based on the configuration you have done, selection screen will appear.

Once your get the output, use below Menu option.

List -> Save -> File

Select "Spreadsheet" option and download it to Excel.

Thanks and best regards,

Anupa