Query Determining Selling Price versus Cost Price

[Former Member]

Dear Colleagues,

I am trying to create a query for the following to be displayed:

u2022 Matnr no (MARA)

u2022 Old Matnr no (MARA)

u2022 Material Description (MAKT or automatic)

u2022 Cost Price(mm02-03/costing 2/standard price (MARC/MBEW)

u2022 List/Selling price (for specific price group/material combination, distribution channel (02),price group (01) )

We only have one plant

I have used a table join for MARA/MARC/MAKT/MBEW/KONP/VAPMA/KNVV but unfortunately,I get no data.

I've also tried joining MARA/MARC/MAKT/MBEW/KONP/KNVV BUT to no avail.

Im getting the data easily for the cost price for fields: material no/old material no/material description/cost price, by joining MARA/MARC/MAKT/MBEW but not so easily for the list price under conditions(ie price group/material combination and distribution channel/price group.

How do i go on obtaining the list price as mentioned on the same query please?

All help appreciated,

PAPJ1

[Former Member · Accepted solution]

Hi,

If your basic price and cost is in sales document then try to take data from VBAK,VBAP table

include all material table,condition table

Kapil

[Former Member · Accepted solution]

Thanks for your reply, Kapil.

Do you suggest linking VBAK,VBAP with the rest of tables I mentioned previously (to obtain the cost price), i.e. MARA (MATNR,Old Materiial no) ,MAKT (Material Description),Cost Price (MARC/MBEW).

I will lleave out KONP/KNVV for the moment...

PAPJ1

[Former Member]

Conditions are date dependent, so it's futile to try to incorporate these in a query with simple joins.