cancel
Showing results for 
Search instead for 
Did you mean: 

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

Lars_Becker
Advisor
Advisor
0 Kudos

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!

View Entire Topic
Lars_Becker
Advisor
Advisor
0 Kudos

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.