I have activated some Business Content datasources in R/3 DEV and these are now in a transport ready to go to PRD. However, some of the datasources are already active in PRD. I need to check if the datasources I have activated are different from the ones in PRD - if so I need to analyse the differences to avoid any disruption of PRD datasources being used to load data to BW.
For example, I manually checked 2LIS_08_TRTLP in DEV, and it has a few more fields than in PRD. So I would be changing the PRD datasource if I transport this datasource from DEV. However there are too many datasources activated by the Business Content to check manually.
Does anyone know of a good technique for this? Maybe extracting data from the underlying R/3 table which holds information about the datasources? Does anyone know of such a table?
Any suggestions would be appreciated and rewarded.