topic Re: table name in Application Development and Automation Discussions

table name

Former Member — Mon, 05 Nov 2007 15:03:29 GMT

Hi gurus,

I am looking for a field called "FINPRICE" basically it is meant for Planned price of materials, can you please help me to locate the table name for this field. I have been told that this field is in the material master

Thanks

Rajeev..

Message was edited by:

Rajeev Gupta

Re: table name

Former Member — Mon, 05 Nov 2007 15:12:34 GMT

Hi Rajeev,

In which transaction is this filed?

Do you know the structure where the field belong?

Regards.

FC.

Re: table name

Former Member — Mon, 05 Nov 2007 15:14:22 GMT

Hi,

thanks for the reply,

If you go on mm03 and click on the acounting tab, there you will find standard price and planned price, and I am looking for planned price.

Thanks

Re: table name

ferry_lianto — Mon, 05 Nov 2007 15:17:21 GMT

Hi,

Please check table MBEW for field ZPLPR.

Regards,

Ferry Lianto

Re: table name

Former Member — Mon, 05 Nov 2007 15:17:42 GMT

Check the MBEW Table

Thanks

Seshu

Re: table name

Former Member — Mon, 05 Nov 2007 15:19:04 GMT

Here there are a couple of tables who contanins the field FIN_PRICE, but probably they were empty.

UAV0PRICE001

UAV0PRICE001H

UAV0PRICE002

UAV0PRICE002H

UAV0PRICE003

UAV0PRICE003H

UAV0PRICE004

UAV0PRICE004H

Regrads FC.

PS: reward if this helps u

Re: table name

Former Member — Mon, 05 Nov 2007 15:24:11 GMT

Check this field

MBEW-LPLPR

FC.

Re: table name

Former Member — Mon, 05 Nov 2007 19:17:14 GMT

hey thanks for the reply, I could find the desired field in the table UAV0PRICE001, but the problem is this table has only fin_price and I need to update my PO's based on the material, I mean for a specific material there will be different fin_price, so I was just wondering how can we relate this.

Thanks

Rajeev

Re: table name

Former Member — Tue, 06 Nov 2007 02:57:34 GMT

Go to DD03L table in Se11 .

While checking entries give FINPRICE against Fieldname..

U will get the neames of tables where this field is available..

DD03L is a Basis table..

Thanks

Praveen