Table name

[Former Member]

Hi

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

[Former Member]

Hi,

Check the Table CRHD.

Regards,

Balakumar.G

Reward Points if helpful.

[Former Member]

Hi Bala

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

Regards

Nanda

[Former Member]

Hi

Check table IFLOT for Fun Location

and Work center AFRV

regards

Shiva

[Former Member]

Hi Shiva

There is no such field AFRV in the table IFLOT

Regards

Nanda

[Former Member]

Hi

TPLNR is IFLOT

ARBPL is in AFRV

regards

Shiva

[Former Member]

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

[Former Member]

Hi,

IFLOT is the table name that contains the work center.

Also use the tables IFLOTX, ILOA for further necessities.

Regards,

Sankar.

[Former Member]

Hi,

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

Regards,

Chandu

[Former Member]

Hi Chandu

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

Regards

Nanda

[Former Member]

Hi

any one can answer plz

[rodrigo_paisante3]

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

[Former Member]

Hi

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

Regards

Nanda

[Former Member]

HI,

CRTX

[Former Member]

hi check this ...

T024I -

---

> PLANGROUP

T001W -

---

> PLANGROUP_PLANT

TPAR -

---

>NOTIF_PAR_ROLE

regards,

venkat.

[Former Member]

Hi

can any one suggest me the join condition for the same

[rodrigo_paisante3]

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.

RP