Selling price - can be used in SQ query?

[Former Member]

Dears,

please, I have a querry created in SQ01 which shows the requirements for top assemblies (it is a combination of tables PBIM - PBED - MARC - MAKT).

I would like to upgrade this query by adding selling price for the MATNR in PBIM. Is selling price field available in some table?

I tried to add table VBAP (field NETPR).... price was there, but the result was duplicated rows in the query output.

Thanks in advance for your help

[eduardo_hinojosa]

Hi,

Check the relations or cardinality between tables. Surely you need an additional relation between tables, so, you have the replication of records.

Regards

Eduardo

Edited by: E_Hinojosa on Feb 25, 2011 10:14 AM