Skip to Content
-6

hello i would like to know how to add fields of one table to another table...??

Dec 16, 2017 at 08:39 PM

99

avatar image
Former Member

for example i have material numbers in one table marc and descriptions in the other table makt ,, how to add the maktx field to table marc???

10 |10000 characters needed characters left characters exceeded

If I take the question as is, I would answer why do you want to make such a column redundant in another table !? The classic answer is NEVER DO THAT, use an SQL join to read the data from both tables at runtime !

6
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Michelle Crapo Dec 18, 2017 at 06:31 PM
4

Of course I totally agree with Sandra. If your question is looking at making redundant fields - it doesn't make sense. If you want to add your own fields to an SAP table - you can do so with append structure.

It's always a good idea to explain as much as you can. If you truly did want to add mara-matnr and makt-maktx together, you may want to read up on data redundancy. If you want to generate a table maintenance and have both - I'd have a different answer. If for some reason you need them both in the same table. (I'm not sure when that would be.) You can create a view. However, I rarely create those unless they are really needed.

Please try to explain a bit more and you would get a better answer. And of course searching first helps. However, I wouldn't be surprised if you didn't find anything on this.

Michelle

Share
10 |10000 characters needed characters left characters exceeded
Rob Dielemans Dec 20, 2017 at 04:03 PM
1

Hi,

What is your functional requirement?

What you are proposing is joining 2 tables into the first table with different keys, this is bad practice.

Kind regards, Rob Dielemans

Share
10 |10000 characters needed characters left characters exceeded
Sathya Gunasekaran Dec 20, 2017 at 03:07 PM
0

Create a database view joining marc and makt with the required fields

Share
10 |10000 characters needed characters left characters exceeded