Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

ABAP command "import from database..."

Former Member

‎2004 Aug 24 8:53 PM

0 Likes
2,570

Can someone in this forum explain to me the low level details behind the ABAP command "import from database"?

The select in tables like stxl, indx, moni just retrieves data in hex format for the fields of type raw or lraw.

But the command import from database works fine!

What's the magic? Compression? Hash algorithms? etc?

Thanks!

Can someone in this forum explain to me the low level details behind the ABAP command "import from database"?

The select in tables like stxl, indx, moni just retrieves data in hex format for the fields of type raw or lraw.

But the command import from database works fine!

What's the magic? Compression? Hash algorithms? etc?

Thanks!

Reply
1 REPLY 1
Read only

nablan_umar
Product and Topic Expert
Product and Topic Expert

‎2004 Aug 24 10:38 PM

0 Likes
545

When you import a field from a database, it should be the same name and format when it was exported. These databases are a cluster table where data is stored in raw. I assumed it will read the cluster portion of the record and convert it into the field structure byte by byte. These tables have field CLUSTR which store the byte size of the record. So if you are willing to program the read, where you find out the length of the field you want to IMPORT, then read that number of byte from the cluster data, move it to the field you are importing, you should be able to do your own read. However, if we can do it in 1 statement using IMPORT, we don't need to program it.

Cluster table is used to save space since you don't need to create a new database record for each line of internal table you stored into them. Hope this helps.