Get the revision level for each material number in a specific plant

[Former Member]

hi my requirement is that,

i have to get the revision level for each material number in a specific plant,

is there any function module which can get this data,

actually this revision level has to be brought from table AEOI table,

but its key fields are

AENNR

AETYP

OBJKT

i donot know how to get these fields.

can some one help.

thanks & rgds.

Edited by: Alvaro Tejada Galindo on Apr 22, 2008 4:11 PM

[Former Member]

Hi,

For a given Material and Plant u can get the revision levels of material by linking these tables

In Table MAPL--->Assignment of Task Lists to Materials

u have fields

MATNR----->Material Number

WERKS----->Plant

AENNR----->Change Number

In Table AEOI--->ECH: Object Management Records for Change Master

u have fields

AENNR----->Change Number

AETYP----->Object Category

OBJKT----->Identification of object to be changed

so u can link these two tables with AENNR----->Change Number field.

<REMOVED BY MODERATOR>

raam

Edited by: Alvaro Tejada Galindo on Apr 22, 2008 5:03 PM

[Former Member]

Hi Sanjana,

Go to CDHDR table and get the change number by passing the OBJECTCLAS as AENNR .

Then go to table AEOI and pass the change number, object catagory(AETYP) as 41- for material master and for Object Category(OBJKT) pass the material number.

Hope it will solve your problem.

Thanks,

Greetson

[Former Member]

thanks to both kodandarami reddy and greetson ,

kodandarami reddy,

in the table MAPL apart from matnr and werks,

there are other key fields like plnty, plnnr, planl, zkriz, zaehl

dont we need to give these remaining key fields.

is it that matnr and werks combination occurs only once irrespective of wat other keyfields are ?

As mentioned by you if i pass AENNR and AETYP ( 41 for material ) dont we need to pass OBJKT ( it is also key field )

Is it not mandatory to provide all key fields to get unique combination.

Greetson,

i didnot understand what to pass as objectclass and object id to get change number, can u please help with that.

thanks to both of you.

your advices really help,

i appreciate your help.

rgds.

[Former Member]

Hi Sanjana,

Instead of that logic try to use the FM : MATNR_GET_ALL_VERSIONS

Thanks,

Greetson

[Former Member]

hi greetson,

i just exected this function module, it shows some out as version, is it the same as revision level,

i am really having trouble finding out which function module suits my requirement.