Table

[Former Member]

Hi all

In PP ,TCode- CO02,after giving order number when i click on header and go to serial numbers.I am getting all the serial numbers for a particular material number & order number.But i am not getting any tables which have relation with Matnr,(serial Num)Gernr,Aufnr .Can anybody suggest me the table names with these relations?

I will be thankfull to you all.

with regards,

sharmishta.

Edited by: Dadapure sharmishta on Aug 7, 2008 7:19 AM

[Former Member]

Hi,

Check the table AFKO , Here Fields AUFNR and PLNBEZ.

Here PLNBEZ has Foreign key relationship with Matnr in MARA table.

Regards,

Sujit

[Former Member]

Hi Sujit,

Aufnr and matnr r there in AUFK table.

The problem is with MATNR and GERNR.

I am unable to get relation between these two.

Thanks for your reply

[Former Member]

Hi,

In tabel EQUI you will find the the Field MATNR and GERNR.

Just check it.

Regards,

Sujit

[former_member195383]

and in the table AFIH u will get gernr and aufnr...

u can find this urself..by going to se11..giving each of these dataelement names in datatype tab..then going in to each..u can see the where used list...and it will help u in finding the respective tables...