We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-dev] How to Insert Data from SAP Ztables to Oracle Tables?

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

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.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
Copyright © 2013 Ziff Davis, Inc. and message author.
Ziff Davis, Inc. 28 E 28th Street New York, NY 10016
LCC352  

President
19 achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Toolbox.com for iPhone & Android: Ask Questions & Get Answers Anywhere. Download the Free App

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language