‎2005 Sep 15 1:08 PM
hi to all,
i need clarification and advice regarding the tables..
i have created a table with fields matnr matkl...etc from different tables...
the talble which is not contain any data...i have to creat entries for that.....then it will showing me the data what i stored.....
but i want the table like standard tables mara...for ex: if we are created a material in mm01 then it will be automatically updated in the table......mara...etc
so how can i get the data same like stadard tables....
if i created table with fields matnr matkl....i have to get the data related to the all material numbers and material group like..that....
is it possible or not..if possible how..??
thank in advace..
raju
Message was edited by: mpr raju
‎2005 Sep 15 1:35 PM
I am sorry if I misunderstood you. What you are talking about is to replicate the MM01 transaction. You created this table and you have to provide a way to fill that table. How did you expect to happen automatically? Referring tp those fields, you are not inheriting data. You are only inheriting the properties of those fields such length, type, value table etc.
You will have to either write a small program to insert records into the table or generate the table maintenance for the table and create entries using SM30 or a custom transaction. You can also write a complete dialogue program that is as extensive as MM01 to fill your table. Data doesn't come into the table automatically, there should be some code to do it.
Srinivas
‎2005 Sep 15 1:14 PM
I think what you are looking for is a View. You can create one in SE11 Transaction.
‎2005 Sep 15 1:24 PM
Absolutely, VIEW is a alternative for you.
And you can consider to use USER-EXITS in mm01, add some code to populate the table you create. Then when you create a material in mm01, the USER-EXITS will be runned, and you table will be appended some information you need.
thanks
‎2005 Sep 15 1:35 PM
I am sorry if I misunderstood you. What you are talking about is to replicate the MM01 transaction. You created this table and you have to provide a way to fill that table. How did you expect to happen automatically? Referring tp those fields, you are not inheriting data. You are only inheriting the properties of those fields such length, type, value table etc.
You will have to either write a small program to insert records into the table or generate the table maintenance for the table and create entries using SM30 or a custom transaction. You can also write a complete dialogue program that is as extensive as MM01 to fill your table. Data doesn't come into the table automatically, there should be some code to do it.
Srinivas
‎2005 Sep 15 1:50 PM
thank u very much for valuable knowledge shared with me.....and pls tell me how to code and also give some example coding ...