Price report with prices and conditions for customer/material

[Former Member]

Hello,

we need a price report with price and condition information per combination customer and material. This report should excecute in all of our sales organisations.

Is there a standard report or function module for our requirement in SAP ERP ECC 5.0 available?

Thanks and regards,

Heiko

[Former Member]

May be you can try to use V_NL Transaction code and get the net price list. I think this is what you are looking for.

[Former Member]

Hi Santosh,

thanks for your tip. With this table-join we receive only prices from sold materials from the past.

We need a actual valid price list for all materials from a customer. Do you know a transaction,

a function module... with which we can generate a list like that?

Thanks and regards,

Heiko

[Shiva_Ram]

Hi,

I never tried this, but you can check with BAPI_SALESORDER_SIMULATE.

Regards,

[Former Member]

Hello,

thanks for your answers. We tried the condition lists (V/LD).

We need a price report for customer/material with the calculated prices. For example:

condition type ZBP1 (gross price)

- (minus) condition type ZBR1 (Discount 1 for the selected customer and material)

- (minus) condition type ZBR2 (Discount 2 for the selected customer and material)

= (resualt) net prices

Is there for this requirement a standard solution in the ERP?

Thanks and regards,

Heiko

[Former Member]

Hi,

There is no STANDARD REPORT as such in SAP.

You can create a Custom report by linking VBAK and KONV tables

The link between the VBAK and KONV is by KNUMV which is the document condition.

The condition types you can get from KSCHL and the Vales from KWERT of KONV

Please ask your ABAPer to create the Z report and check the result

regards,

santosh

[Former Member]

as suggested you can check V/LD if there are any standard reports avaialble or else create your own in V/LA

Hope this hekps

Chandra Kiran

[former_member188076]

Hi

Check V/LD transaction.

Regards

Amitesh Anand