topic Problem with IMPORT FROM DATABASE in Application Development and Automation Discussions

Problem with IMPORT FROM DATABASE

Former Member — Mon, 07 Feb 2011 15:06:45 GMT

Hello Members,

I have a program which reads content of INDX table (cluster table) using

IMPORT tab = lt_ccris1 FROM DATABASE indx(xa) TO wa_indx CLIENT

sy-mandt ID 'DETAILLIST'.

sy-subrc return is 0.

But internal table lt_ccris1 is not populated. I expect entries to be populated here as there is an raw data entry in the INDX - CLUSTD field of database.

1) Also I am intereseted to knoe where is the data exported to this INDX table? Usual searches does not show any export statement.

2) Is there a FM which can directly read content of INDX table?

Your help is much appreciated.

Re: Problem with IMPORT FROM DATABASE

Former Member — Mon, 07 Feb 2011 15:21:57 GMT

Any input on this?

I assume that memory id for export statement to be same as import statement but cannot be found any where in this or related program.

Regards

Ram

Re: Problem with IMPORT FROM DATABASE

ThomasZloch — Mon, 07 Feb 2011 15:41:55 GMT

How do you know your IMPORT syntax must look exactly like this? Is it a custom development or SAP standard?

How did you search for the EXPORT statement? There should be an export somewhere, otherwise it wouldn't make sense, would it? If you suspect the export in a certain package (or several packages), you can use program RS_ABAP_SOURCE_SCAN to look for the EXPORT, in case the navigation index for table INDX is incomplete.

Also try an SE16 for table INDX with RELID = 'XA' and SRTFD = 'DETAILLIST' to check if there are any entries at all to be imported.

Thomas

Re: Problem with IMPORT FROM DATABASE

Former Member — Mon, 07 Feb 2011 17:44:51 GMT

Hi Thomas,

Thanks for the reply.

//How do you know your IMPORT syntax must look exactly like this? //

I did not write this custom report and IMPORT statement is exactly the same as I have given. It is correct as per syntax.

In SE16 INDX does contain an entry for the given key.

I searched for EXPORT stmt in varall ways including debugging (Please note there is a SUBMIT <program> before IMPORT and if at all there is an export it should be in there). Could not find from debugging as well.

RS_ABAP_SOURCE_SCAN does not exist in my 4.7.

Regards

Ram

Re: Problem with IMPORT FROM DATABASE

Former Member — Thu, 10 Feb 2011 10:24:32 GMT

Hey Folks,

Can some one answer my query above? This has been an issue for a very long time and I am sure some one would have come across it.

other than IMPORT FROM DATABASE Is there a way by which we can read exactly what is contained in the raw data of INDX table? because i need to check in production system what is data contained in the INDX table as import from database is not returning any value....

Regards

Ram

Re: Problem with IMPORT FROM DATABASE

Former Member — Fri, 18 Feb 2011 09:57:50 GMT

Hi,

We are facing this issue for a long time. Can any one please throw some light on this?

One more thing I wanted to update was the same statement IMPORT FROM DATABASE is reading data from INDX table in sandbox and development system but not reading in production system ! But in those system the IMPORT FROM DATABASE statement populates internal table with same entries irrespective of what ever selection-screen input is. The report is designed in such a way that based on the selection-screen input especially cost centre a report painter program displays a primary list. It is also expected to export a table data in to INDX table which should be dynamic based on the primary list. Up on pressing back button the report should read data from INDX table and display a secondary list.

Regards

Ram