topic Re: Table name in Application Development and Automation Discussions

Table name

Former Member — Tue, 25 Mar 2008 13:01:52 GMT

In the Tcode IH06. I want the table from which it was fetching the work center. Or else any other which will be having both the fields Functional Location and work center also. I got the Table ALM_ME_D997. But i want some other which will be having both the fields.

Regards

Nanda

Re: Table name

Former Member — Tue, 25 Mar 2008 13:05:43 GMT

Hi,

Check the Table CRHD.

Regards,

Balakumar.G

Reward Points if helpful.

Re: Table name

Former Member — Tue, 25 Mar 2008 13:06:44 GMT

Check table IFLOT for Fun Location

and Work center AFRV

regards

Shiva

Re: Table name

Former Member — Tue, 25 Mar 2008 13:06:49 GMT

Hi,

IFLOT is the table name that contains the work center.

Also use the tables IFLOTX, ILOA for further necessities.

Regards,

Sankar.

Re: Table name

Former Member — Tue, 25 Mar 2008 13:07:30 GMT

Hi,

Place the cursor on Work center input field and press F1 and click on Technical information,there u can find.

Regards,

Chandu

Re: Table name

Former Member — Tue, 25 Mar 2008 13:10:59 GMT

HI,

CRTX

Re: Table name

Former Member — Tue, 25 Mar 2008 13:11:35 GMT

hi check this ...

T024I -

> PLANGROUP

T001W -

> PLANGROUP_PLANT

TPAR -

>NOTIF_PAR_ROLE

regards,

venkat.

Re: Table name

Former Member — Tue, 25 Mar 2008 13:14:24 GMT

Hi Bala

I already Checked CRHD but there is no relation between a Functional location and work center

Regards

Nanda

Re: Table name

Former Member — Tue, 25 Mar 2008 13:15:18 GMT

Hi Shiva

There is no such field AFRV in the table IFLOT

Regards

Nanda

Re: Table name

Former Member — Tue, 25 Mar 2008 13:16:11 GMT

Hi Chandu

I already all checked like that but i havnt found any related tables

Regards

Nanda

Re: Table name

Former Member — Tue, 25 Mar 2008 13:30:00 GMT

any one can answer plz

Re: Table name

rodrigo_paisante3 — Tue, 25 Mar 2008 16:35:01 GMT

Hi,

PM tables

http://erpgenie.com/index.php?option=com_content&task=view&id=180&Itemid=76

But what you will to do? A select? I dont know if exists a table with the both fields.

Tell us what is your need, hope we can help you.

Thanks

Re: Table name

Former Member — Wed, 26 Mar 2008 06:17:44 GMT

Based upon that functional location i have to fetch the work center

Regards

Nanda

Re: Table name

Former Member — Wed, 26 Mar 2008 06:22:37 GMT

TPLNR is IFLOT

ARBPL is in AFRV

regards

Shiva

Re: Table name

Former Member — Wed, 26 Mar 2008 06:24:55 GMT

But i want both the fields in a single table other wise i have to use any join query for that

Re: Table name

Former Member — Wed, 26 Mar 2008 06:43:51 GMT

can any one suggest me the join condition for the same

Re: Table name

rodrigo_paisante3 — Wed, 26 Mar 2008 13:58:14 GMT

Ok, try this to use VIAUFKS and AFRV, like:

select arbpl

into table tg_afrv

from afrv

inner join viaufks on viaufks_{aufnr = afrv}aufnr

where viaufks~tplnr in s_tplnr.