12-12-2008 3:29 PM
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
12-12-2008 3:42 PM
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
12-12-2008 3:44 PM
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