Skip to Content
avatar image
Former Member

complete master data fields in one table or structure

Hi Gurus...

Is there any method is available to view the complete master data fields - with their technical field name (Customer master,Pricing master,Output master,Cust-Material master,material master)...including the suppressed fields- each of them in one single respective tables or structures.

Thanks in advance,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Apr 18, 2009 at 02:32 AM

    Hi,

    What are you trying to achieve ? There is a specific reason why SAP has designed diff tables.. do you have a specific requirement to consolidate ??

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2009 at 04:48 AM
    Is there any method is available to view the complete 
      master data fields - with their technical field name 
       in "one single respective tables" or structures.

    Your question itself is wrong. As you would be aware customer master would be stored in multiple tables like KNA1, KNVV etc.

    If at all you want to see the master datas in one screen, you can go for SQVI where you can table join and see all the fields from respective tables.

    thanks

    G. Lakshmipathi

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18, 2009 at 05:13 AM

    Basker,

    Use SE11 and enter the table name and click Display button. to view the data as well as technical names

    or

    you choose the field and click F1 and click technical details there you can find the table name and field name...

    You Should know that each master data is shared and stored in seperate tables as per classification

    For Ex: take Customer Master Data - you have different datas that you need to fill and the datas are stored in seperate Tables

    a. General Data - KNA1

    b. Company Code data - KNB1

    c. Sales araea Data - KNVV

    Similarly we have Material Master Data

    a. Material Master Data - MARA

    b. Material Master Description - MAKT

    c. Material master Plant data - MARC

    d. Material Master Storage Location - MARD

    like this we have yet mant tables depending upon views and topics the datas are assigned to Tables

    Pricing

    a. Conditions Header Data - KONH

    b. Conditions Item Data - KONP

    c. Conditions Transaction data - KONV

    d. Conditions data - KOND and so on.... Similarly we have for Customer material info

    For output types you can create Tables as per your requirement too...

    Regards

    Sathya

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 23, 2010 at 10:15 PM

    Thanks a lot Gurus....

    Add comment
    10|10000 characters needed characters exceeded