functional module extractor for INDX

[Former Member]

Help to write please an optimum code of the functional module for an extractor from table INDX

[andrea_previati · Accepted solution]

Hi you can make a copy of the standard fm 'RSAX_BIW_GET_DATA_SIMPLE' in SE37

But the simpler way to extract data from table INDX is to create a generic extractor with RSO2 in R/3

Hope it helps

Andrea

[Former Member]

Hi,

How many tables you are going to use for your extractor.

If it is one or 2 table and if there no much conditions, you can go view based extractor itself.

Juts think it over.

-Jayasudha

[Former Member]

While in the functional module on the basis of RSAX_BIW_GET_DATA_SIMPLE ' has made the following

************************************************************************
* Data transfer: First Call      OPEN CURSOR + FETCH
*                Following Calls FETCH only
************************************************************************
* íà÷àëî îáðàáîòêè

* First data package -> OPEN CURSOR
    IF S_COUNTER_DATAPAKID = 0.

delete from zdbasetable1.
import inttable1 inttable2 inttable3 from database INDX(IM) ID 'IDENT'.

loop at inttable1.
  move-corresponding inttable1 to zdbasetable1.
  modify zdbasetable1.
  clear  zdbasetable1.
endloop.

      OPEN CURSOR WITH HOLD S_CURSOR FOR
      SELECT (S_S_IF-T_FIELDS) FROM zdbasetable1.

    ENDIF.                             "First data package ?

* Fetch records into interface table.
*   named E_T_'Name of extract structure'.
    FETCH NEXT CURSOR S_CURSOR
               APPENDING CORRESPONDING FIELDS
               OF TABLE E_T_DATA
               PACKAGE SIZE S_S_IF-MAXSIZE.

    IF SY-SUBRC <> 0.
      CLOSE CURSOR S_CURSOR.
      RAISE NO_MORE_DATA.
    ENDIF.

    S_COUNTER_DATAPAKID = S_COUNTER_DATAPAKID + 1.

  ENDIF. 

But it would be desirable, without use database table - zdbasetable1