on 04-18-2009 2:24 AM
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,
Thanks a lot Gurus....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 ??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.