New Custom Report for Newly Created Materials.

[former_member424759]

Hi All,

I have posted a subject last week regarding this issue.

I would like to create a new report for materials created under the specified date range with details of, MATERIAL NUMBER, DESCRIPTION, PLANT, UNIT OF MEASURE, CURRENT PRICE (Standard Price only), PREVIOUS PRICE and DATE PRICE CHANGED.

Can you give me an idea how can I retrive all these data for a praticular Plant and Specified date range.

Thanks

John K.

[Former Member]

Hi John,

You can also write a query yourself (ABAPer will not be required then) using SQVI Tcode.

Join the following tables:

MARA, MAKT, MARC, MBEW, MBEWH

YOUR PROBLEM SHOULD BE RESOLVED.

[rani_ap]

Hi john,

You will get these details from MM60 standard report.

Material

Plant

Valuation Type

Material Description

Last Change

Material Type

Material Group

Base Unit of Measure

Purchasing Group

ABC Indicator

MRP Type

Valuation Class

Price control

Price

Currency

Price Unit

Created by

Material creation date and chaged fields are mentioned below. took from MARA table.

Material creation Date:- ERSDA

Last Changed date :-LAEDA

Anil patreddy

[Former Member]

Hi John,

If you want to develop cuctomise report with details of MATERIAL NUMBER, DESCRIPTION, PLANT, UNIT OF MEASURE, CURRENT PRICE (Standard Price only), PREVIOUS PRICE and DATE PRICE CHANGED, you can use tables like MARA (MATERIAL NUMBER, UNIT OF MEASURE, Material creation date), MAKT (DESCRIPTION), MARC (MATERIAL NUMBER, PLANT) and MBEW (CURRENT PRICE (Standard Price only), PREVIOUS PRICE and DATE PRICE CHANGED).

You can pass creation date in MARA table from where u will get all the materials created between these dates then from MAKT u can get description for these materials. then Pass those materials to MARC to get the plants for which materials are extended. then based on material and plant (valuation area ) you can get CURRENT PRICE (Standard Price only), PREVIOUS PRICE and DATE PRICE CHANGED information.

You check with ABAPer how to incorporate this logic in program.

Regards

Chetan

[Former Member]

Dear,

Seen last week post too. Checked but the selection is typical, like material number, description, plant, uom, price (Current procuremnet price) will be displayed in MM60. --- But only difference is Instead of CREATION DATE, it will gives LAST CHANGE date (basing on changes made to material master).

Secondly, Previous price, date price changed - This is typical to choose. The price of material updated some times with manual adjustments and changes also took place with inforecord updates and revaluation. The typical is to retrieve this data. I feel that may be your ABAPer can help in developing customizing report with all these data for our (I guess).

Regards,

Syed Hussain.