Hi gurus,
I'm doing SD billing. After billing doc is created via VF01, i tried to release the billing document to get the FI/CO documents created, but the error occurred, paste log as following
Runtime Errors SAPSQL_INVALID_FIELDNAME
Exception CX_SY_DYNAMIC_OSQL_SEMANTICS
Short text
A dynamically specified column name is unknown.
What happened?
Error in the ABAP Application Program
The current ABAP program "SAPLV61Z" 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_SEMANTICS', was
not caught in
procedure "SEL_KONDTAB" "(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
"RKE_BESKZ" does not exist in any of the database tables from the FROM clause.
How to correct the error
Check the field name in the SELECT clause.
If the error occures in a non-modified SAP program, you may be able to
find an interim solution in an SAP Note.
If you have access to SAP Notes, carry out a search with the following
keywords:
"SAPSQL_INVALID_FIELDNAME" "CX_SY_DYNAMIC_OSQL_SEMANTICS"
"SAPLV61Z" or "LV61ZU01"
"SEL_KONDTAB"
Information on where terminated
Termination occurred in the ABAP program "SAPLV61Z" - in "SEL_KONDTAB".
The main program was "SAPMV60A ".
In the source code you have the termination point in line 709
of the (Include) program "LV61ZU01".
The termination is caused because exception "CX_SY_DYNAMIC_OSQL_SEMANTICS"
occurred in
procedure "SEL_KONDTAB" "(FORM)", but it was neither handled locally nor
declared
in the RAISING clause of its signature.
The procedure is in program "SAPLV61Z "; its source code begins in line
266 of the (Include program "LV61ZU01 ".
Source Code Extract
Line SourceCde
679 up to 1 rows
680 where kappl = se_kappl
681 and kschl = se_kschl
682 and datbi >= se_date
683 and datab <= se_date
684 and (coding_tab).
685 h_subrc = sy-subrc.
686 else.
687 select * from (t681-kotab) appending table <cond_tab>
688 where kappl = se_kappl
689 and kschl = se_kschl
690 and datbi >= se_date
691 and datab <= se_date
692 and (coding_tab).
693 endif.
694
695 if select_split ne 0 and h_subrc ne 0.
696 modify coding_tab from coding_alter index select_split.
697 select * from (t681-kotab) appending table <cond_tab>
698 up to 1 rows
699 where kappl = se_kappl
700 and kschl = se_kschl
701 and datbi >= se_date
702 and datab <= se_date
703 and (coding_tab).
704 endif.
705 endif.
706 else.
707 if t681-ksdat is initial.
708 if not <entrytab> is assigned.
">>>>> select * from (t681-kotab) appending table <cond_tab>
710 where kappl = se_kappl
711 and kschl = se_kschl
712 and (coding_tab).
713 else.
714 select * from (t681-kotab) appending table <cond_tab>
715 for all entries in <entrytab>
716 where kappl = se_kappl
717 and kschl = se_kschl
718 and (coding_tab).
can anyone tell me what should this problem be?
TIA.
Any responses will be awarded,
Regards,
Samson