topic Re: Query in Application Development and Automation Discussions

Query

Former Member — Tue, 13 Dec 2005 20:21:45 GMT

Hi,

Does anybody know the table table name where company code and functional area together resides in the same table.

Thank You,

Seema.

Re: Query

RichHeilman — Tue, 13 Dec 2005 20:23:36 GMT

In what transaction are you seeing these being used?

REgards,

Rich HEilman

Re: Query

suresh_datti — Tue, 13 Dec 2005 20:26:22 GMT

Hi Seema,

Functional Area? is it a custom field?

Regards,

Suresh Datti

Re: Query

Former Member — Tue, 13 Dec 2005 20:32:03 GMT

No it's not a custom field... & neither I am using any transaction... I want to select all the functional area for a given company code...

Re: Query

Former Member — Tue, 13 Dec 2005 20:33:38 GMT

Hi SB,

<b>GLFUNCO</b> Check this table it is having company code and Functional area..

regards

vijay

Re: Query

Former Member — Tue, 13 Dec 2005 20:34:25 GMT

Please define "functional area"... that is not a SAP term with which the group here seems familar.

Where are you seeing that phrase in SAP?

Re: Query

Former Member — Tue, 13 Dec 2005 20:37:36 GMT

<b>GLFUNCA  
GLFUNCO  
GLFUNCP 
GLFUNCT 
GLFUNCU   
GLFUNCV </b>

all of them have Company code and Funcational area.

Re: Query

Former Member — Tue, 13 Dec 2005 20:38:49 GMT

AHHHH.... FI stuff.

Many FI tables have BUKRS and FKBER - BSEG, for example

BSID also.

Re: Query

Former Member — Tue, 13 Dec 2005 20:39:03 GMT

FKBER is the field! It is defined in table TFKB

I think the question is very generic! The relation has to specific to something!

Re: Query

suresh_datti — Tue, 13 Dec 2005 20:39:54 GMT

Hi Seema,

Most of the Asset tables ( ANLP for ex.) also have both the fields.. so like Rich asked, in what context do you need these fields?

Regards,

Suresh Datti

Re: Query

Former Member — Tue, 13 Dec 2005 20:43:19 GMT

check this table <b>GLFUNCA or GLFUNCO</b>

which is having only company code and Functional areas.

regards

vijay

Re: Query

suresh_datti — Tue, 13 Dec 2005 20:45:19 GMT

If it is SALES related you can find them in BSEG, BSID & BSAD

Suresh

Re: Query

Former Member — Tue, 13 Dec 2005 20:49:14 GMT

yep got it.... thank you ....

Re: Query

Former Member — Tue, 13 Dec 2005 20:53:05 GMT

Don't forget those points !!!