topic Re: create table in oracle from SAP, using the equivalent data types in Application Development and Automation Discussions

create table in oracle from SAP, using the equivalent data types

Former Member — Tue, 27 Jan 2009 23:19:25 GMT

i'm having my doubt about this......

i'm doing a copy of a table of a ABAP(MARA) on to a external ORACLE database, but this ABAP table has some data type that i don't know what's the equivalent on Oracle.

i haven't fine anything thats says about this 3 data type (QUANTITY, UNIT and NUMC) of ABAP and his equivalent ORACLE data type.

what i thing is that this are the ones...............

ABAP -

> ORACLE

Quantity -

> Float

Unit -

> Char(3)

Numc -

> Char(255)

......... but don't want to wait to find out until a make the tests, does anybody knows about this?

thanks in advance.

Re: create table in oracle from SAP, using the equivalent data types

amit_khare — Wed, 28 Jan 2009 00:20:36 GMT

You can use the NUMBER datatype for all I think.

Re: create table in oracle from SAP, using the equivalent data types

Former Member — Fri, 30 Jan 2009 03:21:34 GMT

Hi Erik,

I dont know what u mean by quantity and unit as data types in ABAP , but yes you can use number for quantity, and varchar for unit. NUMc is something like numeric character , where you have a number as a string, so you can use varchar for that too.

Regards,

Sam Charles J