Skip to Content

date issue oracle db to sap bw extraction

Hi,

I am facing a problem with date fields from Oracle DB sources. The date format of the field in DB table is 'Date base type is DATE and DDIC type is DATS'.

I mapped the date fields to Date characters in BI. Now the data that comes to PSA is in weird format. It shows like -0.PR.09-A

Thanks,

Sreeni

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jul 16, 2018 at 01:41 PM

    Dear All,

    we achieve this on changing the view at DB, after that issue resolved, but we need permanent solution, we need to extract data form 100 of tables, every time we can't create a view on the table, anybody can have idea, please share.

    Regards,
    Sreeni

    Add comment
    10|10000 characters needed characters exceeded