Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

FBL1N Error Unknown column name "H_BUDAT"

0 Kudos
483

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.

1 ACCEPTED SOLUTION

DavidLY
Product and Topic Expert
Product and Topic Expert
0 Kudos
417

Implement the following notes:

2315607 KDF: Dump after ASSERT
2314692 SDF: Dump for parked documents
2301110 SDF - Dump after ASSERT

And then execute the following actions from note 2204787:

Solution

Start transaction HDBVIEWS.

Choose menu path View >> Generate (F8).

2 REPLIES 2

DavidLY
Product and Topic Expert
Product and Topic Expert
0 Kudos
418

Implement the following notes:

2315607 KDF: Dump after ASSERT
2314692 SDF: Dump for parked documents
2301110 SDF - Dump after ASSERT

And then execute the following actions from note 2204787:

Solution

Start transaction HDBVIEWS.

Choose menu path View >> Generate (F8).

0 Kudos
417

Thanks you have solved my problem. Thanks a lot for the help.

Mahfud.