Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from LCC352 on Feb 1 at 8:46 AM James - "Z" tables are just tables that are user-defined (IT department) instead of SAP defined. If your underlying database is Oracle, those tables are part of that database. They could occupy their own table space, but they are still part of Oracle, still able to be touched by SQL externally, etc.. If your client wants them "in Oracle" it sounds like they want the data in the Z tables to appear in their SAP-delivered reports and screens. For the screens, there are ways to add the information into separate tabs to associate the Z table data with SAP-delivered table data, assuming there are proper keys that link the data together. SAP provides user exits for the purpose of doing what might be needed to accomplish this. For reporting, the SAP report would have to be copied, and the Z tables would have to be added into the copied program logic and worked accordingly. Is that closer to what you're asking? - Lou
| | | ---------------Original Message--------------- From: jth1015 Sent: Thursday, January 31, 2013 9:50 PM Subject: How to Insert Data from SAP Ztables to Oracle Tables? how to insert data from sap ztables to oracle tables? client prefers data in oracle tables and will extract data from oracle tables using stored procedures ms sql and update their tables. Using ABAP code how to insert data from ztables to oracle tables? Thanks, James | | Reply to this email to post your response. __.____._ | _.____.__ |