SAP query for Material pricing group changes in material.

[Former Member]

Dear all,

I'm trying to generate a query for Material Pricing group changes in material. For that I've to retrieve data from follwing three tables MVKE, CDHDR & CDPOS.

Firstly while generating infoset -

I tried it by joining tables MVKE & CDHDR, but system is not allowing it, also table CDPOS can't bejoined.

Then I tried by reading dirctly from table MVKE and then adding additional fields in it. query created using this infoset is giving the output, however it's giving only 1 entry per material entered in input.

for multiple entries in output for MPG changes in same material I tried creating addtional structure for table CDHDR & CDPOS but again I'm getting only 1 entry per material.

please suggest how I can get MPG changes done in specified time period for a material.

Thanks.

[Former Member]

Dear,

No need to link MVKE and CDHDR.

Take only single table which is " CDPOS" and Here object valuve is nuthing but material number.(Input field is Material number)

& Make a default of Table & Field(MVKE & MPG)

assign makrs if it useful.

Thanks,

Raj

[eduardo_hinojosa]

Hi

Check the report RSSCD100 and run it for object MAT_FULL for table MVKE. Use this report as a template for your own development.

I hope this helps you

Regards

Eduardo

PD: sorry, the table is DMVKE

Edited by: E_Hinojosa on Sep 2, 2011 9:37 AM

[Former Member]

Hi,

The standard report is available for display changes for material where you will get who changed, when changed, which fields changed.

Use t-code MM04

kapil

[Former Member]

@ kapildev:-

Thanks,

The std. report MM04 gives the change details for only one material at a time.

However our clients requierment is, the i/p will be Sales org. Distri. Channel and the date range.

Depending upon these i/p they want the material list for which MPG has been changed in the given date range,

also details of changes like old value, new value etc.

Edited by: Wish@SAP on Sep 2, 2011 10:57 AM