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

[Former Member]

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.

[amit_khare]

You can use the NUMBER datatype for all I think.

[Former Member]

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