ABAP Data Types lead to which Column Content in Oracle DB?

[Lars_Becker]

Hi all!

Just trying to find a clear explanation for this miracle:

The native or built-in data types in ABAP will lead in the end to a stored content in the oracle database. What I need is an overview which pattern or logic is used for this storage procedure.
Two examples:

DATS as a date format is handled in ABAP like '20210114' - is it stored physically in the same way? What is the native content when looking on pure data?

What happens really with NUMC content when stored to Oracle - What is really written down to the DB?

Background:
Someone wants to read data directly from the oracle db (12.1.0.2.0) of an ERP 7.50 and needs to know what he will find there.
Is it possible to tell him without analyzing the whole stack of tables and their contents? Or how can I tell him by looking on my abap data types to be found in the DDIC?

Thx for help in advance!

[Lars_Becker]

Thx again!

Helps a lot.

Just understood that the runtime data is stored directly in the native data formats of oracle.
Some are packed and some are simple strings...

That's it.

[Lars_Becker]

Thanks for help!

I'm looking for patterns or rules to know how all the abap types are stored in the oracle database. However I will try your hint. 🙂

Cheers - Lars

[janos_mucsi-besze]

Anytime. The mapping you are searching for is SAP internal information. I mean the whole mapping. Basically almost everything is stored in VARCHAR2 with different length. Except (here is an incomplete list is coming):

• currencies and number data types stored in Oracle NUMBER.
• RAW is stored in Oracle RAW.
• LCHR,VARC,STRG stored in CLOB,LONG
• LRAW in Oracle BLOB,LONG RAW

[janos_mucsi-besze]

Hi Lars,

Both ABAP Datatype is stored as VARCHAR2 in the Oracle Database.

Using TO_DATE and TO_CHAR funtions can be a great help when reading this data.

This is all I can tell you.