cancel
Showing results for 
Search instead for 
Did you mean: 

UD Connect to Oracle Database: Converting Oracle dates -> SAP Format

Former Member
0 Kudos

Hi all,

I connected a Oracle DB via DB Connect to SAP BW 2004s.

The Datasource field from Oracle has following parameters:

Database Type: DATE

Length in DB: 7

Type in DDIC: DATS

Lenght in DDIC: 8

When i upload or preview data i get only following as result:

-0.UG.29-A

The only solution to get this converted is to create a view.

The question is now:

Can i use UD Connect instead for this problem, without the need of creating a view on the Oracle DB?

Thanks a lot in advance for any help, best regards

Frank

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Frank,

back again for the SAP note: 518241.

Cheers, HS.

Former Member
0 Kudos

Hi,

with the help of NW2004s (DB Connect) it was possible in the datasource to write the date into a char field (10 chars). Then with the help of ABAP it was possible to "convert" it into our SAP-Format.

Thanks anyway, best regards

Frank

Message was edited by:

Frank Rebholz

Answers (2)

Answers (2)

Former Member
0 Kudos

Frank,

Tony is on the right track. it is general best practice procedure to acquire data using a table view.

the other issue is the date conversion. there exists a special sap note (sorry, i don't know the id-number) recommending to do the date conversion from ORA-internal date format (the weird 7 digit packed object) to the required SAP dats and/or tims format already in the view definition on oracle db.

Good luck and cheers,

Harald

Former Member
0 Kudos

Hi,

You can use UDConnect, but creating a view is less expensive than configuring the UDConnect.