Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SAP DATS datatype

roheieJul 28 2004 — edited Aug 3 2004

Hi,

We have SAP R3 4.x running on an Oracle server. I have successfully imported the metadata I need (using RFC) into OWB (v9.2.0.4), and now I am trying to create some simple PL/SQL mappings to copy some tables into a staging schema in the DWH database using the copy and map wizard.

What puzzles me is that it seems that columns with datatype DATS in SAP are converted to DATE in the mapping. This causes the PL/SQL mappings to fail as the source columns are not DATE but VARCHAR2 (on the form 'yyyymmdd' with default value '00000000')

I can get around this easily by changing the datatype of the DATS columns to varchar2 in the mapping, but surely this is not the way you are supposed to do it?? Am I missing something here?

Regards,
Roald

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 31 2004

Added on Jul 28 2004

#data-warehousing, #warehouse-builder

5 comments

1,539 views