Skip to Content

Fetch LAEPR field based on MATNR

hi

I have to enhance a datasource MATATTRIB with the u201CLast Price Change dateu201D field.

As of now MATATTRIB is getting data from a view on MARA.

Now the last price change date is MBEW-LAEPR, and the primary key of MBEW is Valuation Area and Valuation Type apart from the Material Number.

Can you tell me whether there is anyway I get the LAEPR field based on only the Material Number...

Edited by: Grame Smith on Aug 8, 2008 4:01 PM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Aug 08, 2008 at 02:06 PM

    Hi

    U need to do a join between MBEW and MARA using MATNR in where condition.

    If you can't know the Valuation Area and Valuation Type u should get them from a selection-screen.

    Max

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Max

      Thanks for your help.. well just wanted to update you that I have consulted with MM Functional Associate in my company and he informed that there are no valuation types associated with the Material unless its a Split type evaluation ( which is not maintained in my company anyways), so now I am down to Material and Plant to select data from MBEW

      Btw.. the CDHDR contains the fields which were last modified for any material.. so may be I can develop a view using a join between MARA and CDHDR..

      This Question is still open.. if anybody has any suggestions regarding this view development please let me know

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.