Hello all,
we are using Ecc 6.0 and we havent installed Enhancement Package 3. However our requirement is to create a custom datasource (ZFI_GL_14) similar to the standard one (0FI_GL_14). Initially we created the custom DS same as the standard one with the extraction method using Function Module. By default custom DS was assigned with extraction method F2. By running a program we changed F2 to F1 to resemble the standard one and made it as delta enabled as specified in the standard extractor.
when we started extracting the custom DS using RSA3, we encountered so many errors and resolved them. However still we are getting some more errors which requires your help.
1. While testing One of the function module FAGL_GET_LINE_ITEMS, it throws following ABAP dump.
Short text
| A dynamically specified FROM clause has an unexpected format.
-
-
|What happened?
| Error in the ABAP Application Program
|
| The current ABAP program "SAPLYPFI_FAGL_ITEMS_SELECT_BW" had to be terminated
| because it has come across a statement that unfortunately cannot be executed.
-
-
|Error analysis
| An exception occurred that is explained in detail below.
| The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SYNTAX', was not
| caught in
| procedure "YPFI_FAGL_GET_LINE_ITEMS" "(FUNCTION)", nor was it propagated by a
| RAISING clause.
| Since the caller of the procedure could not have anticipated that the
| exception would occur, the current program is terminated.
| The reason for the exception is:
| The running ABAP program attempted to execute an Open SQL statement in
which a FROM clause was specified dynamically in the field "LD_DBTAB_SYNTAX".
| In this
| FROM clause, either a table name after a join operator is missing, or an
| alias name after the key name "AS". The field "LD_DBTAB_SYNTAX" could be empty as well.
-
-
|Missing RAISING Clause in Interface
| Program SAPLYPFI_FAGL_ITEMS_SELECT_BW
| Include LYPFI_FAGL_ITEMS_SELECT_BWU01
| Row 1
| Module type (FUNCTION)
| Module Name YPFI_FAGL_GET_LINE_ITEMS
-
-
|Trigger Location of Exception
| Program SAPLYPFI_FAGL_ITEMS_SELECT_BW
| Include LYPFI_FAGL_ITEMS_SELECT_BWU01
| Row 353
| Module type (FUNCTION)
| Module Name YPFI_FAGL_GET_LINE_ITEMS
-
-
|Source Code Extract
-
|Line |SourceCde
-
| 323| lt_fields_flexgl
| 324| lt_fields_table1
| 325| lt_fields_table2
| 326| gv_si_table "erste Tab immer Flexgl?
| 327| gc_bkpf
| 328|* ' '
| 329| gc_bkpf_aedat
| 330| 'X'
| 331| CHANGING ld_dbtab_syntax
| 332| lt_fldlist_s
| 333| lt_where_tab[].
334
| 335|* open cursor
| 336| DESCRIBE TABLE lt_where_tab LINES ld_lines.
| 337| IF ld_lines GT 0.
| 338| delta_dbcnt = 0.
| 339| old_dbcnt = 0.
| 340| flag_cursor_open = 'X'.
| 341| cursor_flag = 'X'.
342
| 343| OPEN CURSOR WITH HOLD i_cursor FOR
| 344| SELECT (lt_fldlist_s)
| 345| FROM (ld_dbtab_syntax) CLIENT SPECIFIED
| 346| WHERE (lt_where_tab).
| 347| ELSE.
| 348| delta_dbcnt = 0.
| 349| old_dbcnt = 0.
| 350| flag_cursor_open = 'X'.
| 351| cursor_flag = 'X'.
352
|>>>>>| OPEN CURSOR WITH HOLD i_cursor FOR
| 354| SELECT (lt_fldlist_s)
| 355| FROM (ld_dbtab_syntax) CLIENT SPECIFIED.
| 356| ENDIF.
357
| 358| st_selection[] = lt_selection[].
| 359| st_fieldlist[] = lt_fieldlist[].
| 360| sd_dbtab_syntax = ld_dbtab_syntax.
| 361| st_fldlist_s[] = lt_fldlist_s[].
| 362| st_where_tab[] = lt_where_tab[].
| 363| st_seltable2[] = lt_seltable2[].
364
| 365| ENDIF. "cursor_flag
366
| 367| lt_selection[] = st_selection[].
| 368| lt_fieldlist[] = st_fieldlist[].
| 369| ld_dbtab_syntax = sd_dbtab_syntax.
| 370| lt_fldlist_s[] = st_fldlist_s[].
| 371| lt_where_tab[] = st_where_tab[].
| 372| lt_seltable2[] = st_seltable2[].
-
Line 353 contains the error.
1. L_DBTAB_SYNTAX. As per the statement this field should bring the table name, but it is not bringing any value whiledebugging.
2.also lt_fldlist_s should bring the field names.
As this is for New GL line item datasource, I am not sure what fields should lt_fldlist_s and what table name , and wheretab value should come , so that the function module can extract the data.
Kindly help me to get an insight into this issue and to get it resolved.
thanks,
Praba...