Our team has to select option from mapping tables location while working on interfacig object development.
We are using Biztalk as middleware.
Depending on your past xperiences I would like to have your suggestions if the mapping table should reside in biztalk or in R/3.
There are pros and cons to both of this..
If we have some mapping tables in r/3 and some in biztalk again there will be maintainence problem. But if I we keep all the mapping tables in Biztalk it will be a big overhead because then even for r/3 to r/3 interfacing we would have to go through biztalk. But then during upgradation it won't be a problem because now the mapping tabs are all in biztalk..