cancel
Showing results for 
Search instead for 
Did you mean: 

complete master data fields in one table or structure

Former Member
0 Kudos

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,

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Thanks a lot Gurus....

Former Member
0 Kudos

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

Lakshmipathi
Active Contributor
0 Kudos
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

Former Member
0 Kudos

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 ??