topic Re: import from INDX in Application Development and Automation Discussions

import from INDX

Former Member — Tue, 01 May 2007 15:03:18 GMT

Hi experts,

I got a requirement to import the data from INDX table using RELID & SRTFD fields.

But how do i know the structure of the table to import the data into ITAB?

Is there any FM existing to now the structure??

Iam trying to get the data like this..


import gt_display = lt_display
       from database indx(rm) id 'BILLING'.

Pls let me know.

Ravi

Re: import from INDX

Former Member — Tue, 01 May 2007 15:06:14 GMT

u should do this way...

EXPORT gt_display from DATABASE indx(ar) CLIENT sy-mandt

Re: import from INDX

Former Member — Tue, 01 May 2007 15:07:27 GMT

Hi ravi,

1. We have to know beforehand itself.

2. U can also check help on Import Directory syntax.

This comand helps to know the structure of the content inside the cluster.

regards,

amit m.

Re: import from INDX

Former Member — Tue, 01 May 2007 15:36:38 GMT

Hi,

The structure of fields, field strings and internal tables to be imported must match the structure of the objects exported to the dataset.In addition, the objects must be imported under the same name used to export them. If this is not the case, either a runtime error occurs or no import takes place.Exception: You can lengthen or shorten the last field if it is of type CHAR , or add/omit CHAR fields at the end of the structure.

Regards

Sudheer

Re: import from INDX

Former Member — Tue, 01 May 2007 18:21:15 GMT

Hi experts,

Now i got the structure.

Iam trying to improt data into gt_display table. Sy-subrc is showing 0.

But why iam not able to get the data? Where iam doing wrong? Any clue pls..!



data: gt_display type table of zrmsrept with header line.
data: indxkey like indx-srtfd value 'BILLING'.

import lt_display = gt_display from database indx(rm) id indxkey.

Re: import from INDX

Former Member — Tue, 01 May 2007 19:11:45 GMT

Hi,

Try

import gt_display from database indx(rm) id indxkey.

Thanks,

Naren