topic Re: Fields tables ? in Application Development and Automation Discussions

Fields tables ?

Former Member — Tue, 22 Jul 2008 11:56:16 GMT

Hello,

Is there any table in which company code, material number, and plant are there in a single table.

Thks.

Re: Fields tables ?

Former Member — Tue, 22 Jul 2008 12:12:51 GMT

Hi!

Unfortunately no. You have to collect them from 2 tables: MARC and T001K.

Regards

Tamá

Re: Fields tables ?

Former Member — Tue, 22 Jul 2008 13:21:14 GMT

Hi,

You could try the following :

types: begin of ty_pdata,

matnr type matnr,

werks type werks_d,

bwkey type bwkwy,

bukrs type bukrs,

end of ty_pdata.

data: gt_pdata type standard table of ty_pdata.

select marc~matnr "Material

marc~werks "Plant

t001w~bwkey "Valuation Area

t001k~bukrs "Company code

into table gt_pdata

from marc

inner join t001w

on t001w_{werks = marc}werks

inner join t001k

on t001k_{bwkey = t001w}bwkey

where lvorm = space.

You can add extra conditions to the where clause if you want.

Re: Fields tables ?

Former Member — Tue, 22 Jul 2008 13:34:09 GMT

Hi,

For Company Code you have to refer table -T001.

For Materail no and plant table MARC.

Table EKPO Contains the three fields togather.You can check this.

Regards,

Sujit

Re: Fields tables ?

Former Member — Wed, 23 Jul 2008 07:21:27 GMT

Hi Balu,

I checked in Tables VBRK and VBRP . In these tables the field BUKRS exist in VBRK whereas the fields MATNR and WERKS exist in VBRP. You can fetch data from VBRK and use for all entries to fetch data from VBRP on some condition.

The same will be the case with VBAK and VBAP tables respectively.

Hope this works fine.

Regards,

Swapna.

Re: Fields tables ?

Former Member — Wed, 23 Jul 2008 08:54:52 GMT

I think there is no table with this combination .

Refer t001 for company code.

Refer marc for material number.

Regards,

Muneesh Gitta.

Re: Fields tables ?

Former Member — Wed, 23 Jul 2008 09:33:57 GMT

Hi,

use this table you will find required fields.

EKPO

plz don't forget....

Regards,

venkat

Re: Fields tables ?

Former Member — Thu, 24 Jul 2008 05:02:48 GMT

Hi,

In EKPO table,

all three fields -

company code,

material number

and plant

are present.

Bye,

Mamta

Re: Fields tables ?

Former Member — Thu, 24 Jul 2008 05:07:51 GMT

Hi thks for your answer the same answer was giving by venkat. By which i have already solved my problem.

Regards

Balu