Accessing Oracle Tables using ABAP

[Former Member]

Dear All,

We are using SAP ECC 6.0, we need to access some of the tables in oracle system using ABAP program. Is there any wany to access the oracle tables.

Please suggest and do the needful.

Thanks in advance,

Chandra

[Former Member]

Dear All,

We are using SAP ECC 6.0, we need to access some of the tables in oracle system using ABAP program. Is there any wany to access the oracle tables.

Please suggest and do the needful.

Thanks in advance,

Chandra

[Former Member]

Hi,

I didn't get your question, in SAP you have a data base which could be ORACLE in your case, so you can access these tables in SAP using SE16 or SELECt statements in ABAP.

Regards,

Pankaj

[Former Member]

Put your oracle select query in between EXEC... ENDEXEC statement.

Reward if useful

Regards

ANUPAM

[Former Member]

Hi chandrasekhar,

1. For this you will have to use the concept of

native sql.

(Pls see F1 help on EXEC statement)

2. Basically, the sql will come between EXEC and ENDEXEC statement.

regards,

amit m.

[Former Member]

U can also use RFCs.

RFC provide the logic to update the data in SAP DB.

RFC reads data from oracle by mapping sap fields and oracle fields.

Chandra M

[Former Member]

DECLARE YOUR ORACLE INSTANCE INTO TABLE DBCON

AND USE THE FOLLOWING FM TO ACCESS YOUR DATA

RSDBC_DB_DATA_GET

RSDBC_DB_DSOURCE_CHECK

RSDBC_DB_DSOURCE_CONVERT

RSDBC_DB_DSOURCE_GENERATE

RSDBC_DB_FIELDS_CHECKS

RSDBC_DB_FIELDS_GET

RSDBC_DB_SCHEMAS_GET

RSDBC_DB_TABLES_GET

RSDL_CONNECTION_CHECK

RSDL_DB_GET_ALL_TABLES

RSDL_DB_GET_DATA

RSDL_DB_GET_DATA_BWS

RSDL_DB_RFC_GET

RSDL_TRACEFILE_DISPLAY

RSDS_ACCESS_DB_DATA_UPLOAD

RSDS_ACCESS_DB_DATA_UPLOAD_2

RSDS_ACCESS_DB_FIELDS_GET

RSDS_ACCESS_DB_TABLES_GET

OR WRITE YOUR OWN CODE USING THIS OBJECTS

cl_sql_connection

cl_sql_statement

cl_sql_result_set