Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Material -Issue

Former Member
0 Kudos

Hi,

I have z table in which i have main material and this is key field.

For this material there are sub material for which i need to perform certain calculations.

Since in z table material is key field .Will it better to put give

main matnr matnr1 matnr 2 matnr3 - all separately in columns

or

main matnr matnr1,matnr2, matnr3 - all in one text field separated by ,.

Any other suggestion are welcome.We are not prefering to change material master table.

Regards

Ivneet

2 REPLIES 2

Former Member
0 Kudos

Hi Ivneet,

Another solution is make a ztable with you main matnr and index number as key and add one column for the submaterial.

First submaterial will have index 1, next index 2 and so on.

In this case is doesn't matter how many subitem it is connected to the main item.

And the table record is a small one.

Regards

Åsa Thenstedt

nkr1shna
Contributor
0 Kudos

Hi,

My suggestion is to add matnr1 matnr2 separately, since you will have advantage to do validations on each sub-materials on material master and other transactional tables using the key field matnr.

Also there will be performance issues if you combine all materials into one and try to use where condition on SAP standard materials where you need to calculate substring of the material you are searching.

Let me know what is your opinion on this?

Best Regards,

Krishna