topic Re: Table in Application Development and Automation Discussions

Table

Former Member — Thu, 07 Aug 2008 05:19:19 GMT

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

Re: Table

Former Member — Thu, 07 Aug 2008 05:34:34 GMT

Hi,

Check the table AFKO , Here Fields AUFNR and PLNBEZ.

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

Regards,

Sujit

Re: Table

Former Member — Thu, 07 Aug 2008 05:39:28 GMT

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

Re: Table

Former Member — Thu, 07 Aug 2008 05:41:53 GMT

Hi,

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

Just check it.

Regards,

Sujit

Re: Table

former_member195383 — Thu, 07 Aug 2008 05:44:51 GMT

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...