topic Re: Material -Issue in Application Development and Automation Discussions

Material -Issue

Former Member — Fri, 12 Dec 2008 15:29:56 GMT

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

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

Re: Material -Issue

Former Member — Fri, 12 Dec 2008 15:42:45 GMT

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

Re: Material -Issue

nkr1shna — Fri, 12 Dec 2008 15:44:47 GMT

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