Skip to Content
0
Former Member
Jan 06, 2012 at 02:15 PM

The contained field name "ADTAGR" does not exist in any of the database tab

34 Views

hı all

how can l solved thıs problem

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS', was

not caught in

procedure "PUT_QMFECAT" "(FORM)", 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:

An Open SQL clause was specified dynamically. The contained field name

"ADTAGR" does not exist in any of the database tables from the FROM clause.

Information on where terminated

Termination occurred in the ABAP program "SAPDBZQNQ" - in "PUT_QMFECAT".

The main program was "ZQMR_BILDIRIM ".

In the source code you have the termination point in line 732

of the (Include) program "SAPDBZQNQ".

Error occurred during batch input processing

The termination is caused because exception "CX_SY_DYNAMIC_OSQL_SEMANTICS"

occurred in

procedure "PUT_QMFECAT" "(FORM)", but it was neither handled locally nor

declared

in the RAISING clause of its signature.

The procedure is in program "SAPDBZQNQ "; its source code begins in line

715 of the (Include program "SAPDBZQNQ ".

FORM put_qmfecat.

DATA: l_tab_fields TYPE rsfs_tab_fields.

DATA: l_ds_clauses TYPE rsds_where.

  • Dynamische Feldselektion

MOVE 'QMFECAT_C' TO l_tab_fields-tablename.

READ TABLE select_fields WITH KEY l_tab_fields-tablename

INTO l_tab_fields.

IF sy-subrc <> c_rc00.

CLEAR l_tab_fields.

ENDIF.

  • Dynamische Selektionskriterien

MOVE 'QMFECAT' TO l_ds_clauses-tablename.

READ TABLE dyn_sel-clauses WITH KEY l_ds_clauses-tablename

INTO l_ds_clauses.

  • DB-Zugriff

>>>>> SELECT (l_tab_fields-fields) FROM qmfe

INTO CORRESPONDING FIELDS OF TABLE qmfecat_tab

WHERE qmnum = rqmqmel-qmnum

AND kzloesch = space

AND (l_ds_clauses-where_tab)

ORDER BY PRIMARY KEY.

regard sinan

Edited by: eyup_sinan on Jan 6, 2012 3:21 PM

Edited by: eyup_sinan on Jan 6, 2012 3:30 PM