Skip to Content
author's profile photo Former Member
Former Member

Fields tables ?

Hello,

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

Thks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

7 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2008 at 12:12 PM

    Hi!

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

    Regards

    Tamá

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2008 at 01:21 PM

    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 t001wwerks = marcwerks

    inner join t001k

    on t001kbwkey = t001wbwkey

    where lvorm = space.

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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 22, 2008 at 01:34 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 07:21 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 08:54 AM

    I think there is no table with this combination .

    Refer t001 for company code.

    Refer marc for material number.

    Regards,

    Muneesh Gitta.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 23, 2008 at 09:33 AM

    Hi,

    use this table you will find required fields.

    EKPO

    plz don't forget.... 😊

    Regards,

    venkat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 24, 2008 at 05:02 AM

    Hi,

    In EKPO table,

    all three fields -

    company code,

    material number

    and plant

    are present.

    Bye,

    Mamta

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.