insertion of data into oracle table

[Former Member]

Hello SAP Gurus,

I want to insert the data from ztables into oracle tables.is this possible in sap?

If yes can anyone take pains to explain me the same?

Regards,

Prasad Dhaygude.

please update me on dhaygudeprasad_25@rediffmail.com

[Former Member]

Hi Rahul,

Am a bit confused on ypur requirement and the the suggestions.

What i have understood, u have a Ztable and u want to populate the data fron this Ztable into one of the standard tables. Is it so.

First what do u mean by oracle tables?

In sap , if the db is in oracle then all the tables are oracle tables.

Ztables are created by customers where as the other table (except z and y ) are SAP standard tables.

Pl clarify a bit more regarding yr requirements

Regards

[Former Member]

Actually i want to send data from ztable to oracle database which is used by dot net.

[Former Member]

Hi,

Perhaps u didnt went thru what i wrote or prob misunderstood it.

Actually when you create a ztable in sap its actually a oracle table if the bkend is oracle.

a ztable is basically a oracle table so when you create it in sap it actually gets created in oracle.U can even view it from oracle

select * from sap<sid>.ztable.

If u want to send it to some other oracle database (apart from the sap oracle database), there has to be a communication mode between the two and u may use something like rfc for the same. Am not very sure.

Better your oracle DBadm can guide you better in this regard.

Regards

[Former Member]

Hi Rahul,

Any data you entry to this Ztable from sap also will be store in Oracle.

So you can use the .Net to read the data directly in Oracle table

Like Select * from <oracle schema>.ztable;

Regards,

Fendi Suyanto

[former_member204746]

rahuil,

is you SAP system running on Oracle? do you want that Ztable's contents to reside in this ORacle databse? if so, create table definition in SE11 and like everyonwe said earlier, the Oracle table will be create for you by SAP.

or are you talking about an external database? If so, investigate usage of DBCON.

[Former Member]

Friend

Do following option

Just create the table from SE11, and its will create in Oracle database as same name.

And if you want to fill the table just create use SM30.

shailesh Tiwari

[Former Member]

Hi Rahul,

Just create the table from SE11, and its will create in Oracle database as same name.

And if you want to fill the table just create use SM30.

Hope this answer you question.

Regards,

Fendi Suyanto

[Former Member]

Just create the table from SE11, and its will create in Oracle database as same name.

And if you want to fill the table just create use SM30.

hello sir ,

can u unfold the task mentioned above.

i mean, an ellaboration.

thanks for sparing your valuable time for my query.

Regards,

Rahul

[fidel_vales]

Hi,

I have no clue what are you talking about.

What is ztables?

What oracle tables are you talking about ( SAP/No SAP/Other )?