- SAP Managed Tags:
Dear Experts,
i got an error when execute the report of fbl1n if i tick normal items and parked items, if only one of them is checked then there is no problem.
is there any way of solving this problem?.
thanks in advance,
mahfud
Category ABAP programming error
Runtime Errors SAPSQL_PARSE_ERROR
Except. CX_SY_DYNAMIC_OSQL_SEMANTICS
ABAP Program SAPDBKDF
Application Component Not assigned
Date and Time 01.11.2023 09:28:24
Short Text?
An error has occurred while parsing a dynamic entry.
What happened?
Error in the ABAP application program.
The current ABAP program "SAPDBKDF" had to be terminated because it found a
statement that could not be executed.
What can I do?
Note which actions and entries caused the error to occur.
Consult your SAP administrator.
Using transaction ST22 for ABAP dump analysis, you can view, manage,
and retain termination messages for longer periods.
Using Transaction ST22 for ABAP Dump Analysis, you can look
at and manage termination messages, and you can also
keep them for a long time.
Error analysis?
An exception has occurred which is explained in more detail below. The
exception is assigned to class 'CX_SY_DYNAMIC_OSQL_SEMANTICS' and was not
caught in procedure
"PUT_BSIK" "(FORM)", nor was it propagated by a RAISING clause.
Since the caller of the procedure could not have anticipated this
exception, the current program was terminated.
The reason for the exception is:
The current ABAP program attempted to execute an Open SQL statement
containing a dynamic entry. The parser returned the following error:
"Unknown column name "H_BUDAT". until runtime, you cannot specify a field
list."
Information on where terminated
The termination occurred in ABAP program or include "SAPDBKDF", in "PUT_BSIK".
The
main program was "RFITEMAP".
In the source code, the termination point is in line 1528 of program or
include "SAPDBKDF".
The termination is due to exception "CX_SY_DYNAMIC_OSQL_SEMANTICS" occurring
in procedure "PUT_BSIK" "(FORM)".
This exception was not handled locally or declared in the RAISING
clause in the procedure's signature however.
The procedure is in program "SAPDBKDF ". The
source code begins in line 1454 of
(include) program "SAPDBKDF ".
Source Code Extract
Line SourceCde
1498 perform WRITE_INTO_BSIK tables XBSAK
1499 using CURSOR-BSAK LD_ARCH. "#EC ENHOK
1500
1501 endif. "<<<<<<<<<<<<<<<<<<<<<<<<<<< normal documents <<<<<<<<<<<<<<<<<
1502
1503 if B0SG-XSTAV = 'X'.
1504 * vorerfasste Belege ueber DB-Index nach lifnr
1505 SAVE_BSTAT = 'V'.
1506 * modification of WHERE clause: remove AUGDT, AUGBL, DABRZ, IMKEY
1507 refresh: VBSEGK_WHERE.
1508 VBSEGK_WHERE[] = BSIK_WHERE[].
1509 perform BUILD_VBSEG_WHERE(FI_LDB_UTIL) tables VBSEGK_WHERE
1510 using 'AUGDT'.
1511 perform BUILD_VBSEG_WHERE(FI_LDB_UTIL) tables VBSEGK_WHERE
1512 using 'AUGBL'.
1513 perform BUILD_VBSEG_WHERE(FI_LDB_UTIL) tables VBSEGK_WHERE
1514 using 'DABRZ'.
1515 perform BUILD_VBSEG_WHERE(FI_LDB_UTIL) tables VBSEGK_WHERE
1516 using 'IMKEY'.
1517 perform BUILD_VBSEG_WHERE(FI_LDB_UTIL) tables VBSEGK_WHERE
1518 using 'PROJK'.
1519 perform BUILD_VBSEG_WHERE(FI_LDB_UTIL) tables VBSEGK_WHERE
1520 using 'PRCTR'.
1521 perform BUILD_VBSEG_WHERE(FI_LDB_UTIL) tables VBSEGK_WHERE
1522 using 'KOSTL'.
1523 perform BUILD_VBSEG_WHERE(FI_LDB_UTIL) tables VBSEGK_WHERE
1524 using 'AUFNR'.
1525
1526
1527 * BSTAT W oder Z sind nicht im VBKPF
>>>>> select * from V_VBSEGK where LIFNR = SAVE_LIFNR
1529 and BUKRS = SAVE_BUKRS
1530 and GJAHR between '0001' and '9999'
1531 and BUDAT in KD_BUDAT
1532 and BUDAT le KD_STIDA
1533 and ZUONR in KD_ZUONR
1534 and UMSKZ in KD_UMSKZ
1535 and HKONT in KD_HKONT
1536 and GSBER in KD_GSBER
1537 and BLART in KD_BLART
1538 and BLDAT in KD_BLDAT1539 and BSCHL in KD_BSCHL1540 * AND BSTAT IN KD_BSTAT1541 and WAERS in KD_WAERS1542 and ZLSPR in KD_ZLSPR1543 and ZLSCH in KD_ZLSCH1544 and (VBSEGK_WHERE).154515461547 clear BSIK.
