Fields tables ?

[Former Member]

Hello,

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

Thks.

[Former Member]

Hi!

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

Regards

Tamá

[Former Member]

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.

[Former Member]

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

[Former Member]

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.

[Former Member]

I think there is no table with this combination .

Refer t001 for company code.

Refer marc for material number.

Regards,

Muneesh Gitta.

[Former Member]

Hi,

use this table you will find required fields.

EKPO

plz don't forget....

Regards,

venkat

[Former Member]

Hi,

In EKPO table,

all three fields -

company code,

material number

and plant

are present.

Bye,

Mamta

[Former Member]

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

Regards

Balu