Hello,
I am working, for the summer, for a large Corp.
They run SAP on an Oracle dB on NT servers. The problem is the duplicate customer data is input everytime a new order is filled. My job is ‘cleaning’ it.
I suggested tweaking the database to prevent the duplication, but that upset the IT guys. They ‘explained’ that the tables are NEVER to be touched because SAP told them not to, and ONLY to use the SAP interface.
I would have checked the help files but they are not installed, so I’ll ask here . . .
1. Isn’t the DBA or System administrator on an ERP supposed to tweak the database?
2. Can the tables be altered through SAP?
3. If the tables (there are thousands) are so complicated you never touch them what is thepoint of having a dba (Each plant has a dB and 1 – 4 dba’s and sysops working on them).
Regards,
The Curious Cat