where we can find price list of all FERT material

[Former Member]

where we can find price list of all FERT material.

finish goods

Regards

Gaurav

[Former Member · Accepted solution]

Hi,

First you need to get a list of all FERT materials.

That can be done by downloading MARA table (In SE11 or SE16N) using field Material Type (MTART) = FERT

There are various methods to find the prices of those materials.

1- Try using Tx: V/LD (Price reports)

Go to V/LD and check all available reports and see whether they can be used for your requirement.

Else you can create own pricing report using V/LA as well

2 - Using tables

First you need to identify the condition table your storing those prices. (Condition table you have created in the SPRO - Tx: V/05)

Let's say the condition table used for access sequence is 900.

Then go to SE11or SE16N and enter table as A900 and execute it for those list of FERT materials.

Then Get the condition record no (KNUMH) of those.

Again go to the table KONP in Tx: SE11 or SE16N and enter those copied condition record number and execute.

Now you'll be able to see those prices with validity periods there.

Better you can code a query for this.

Best regards,

Anupa

[Former Member · Accepted solution]

Hi,

Adding to option 1, please find below on how to create and run a pricing report.

How to Create a pricing report

Tx: 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

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.

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.

How to run a pricing report

Transaction: V/LD

u2022 Enter pricing report number

u2022 Press Execute

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

Hope this is useful to you!

Best regards,

Anupa

[Lakshmipathi]

Go to V/LD, input Pricing Report 28 and execute.

thanks

G. Lakshmipathi

[Former Member]

Hi Gaurav,

Go to table MARA in t-code SE16 and specify FERT as the material type (MTART)

Regards.