Hi Experts,
We are using a job having program "ATPBD001" to Refresh the buffer. Yesterday this job failed with the short dump error
DBIF_RSQL_TABLE_UNKNOWN.
The message is coming like " One of the tables in the statement accessing table "ATP_RESB " is unknown ".
Today the same job run successfully. what could be the possible root cause of the error ?
Here is the source code for reference :
004370 atp_resb-sobkz = sobkzk
004380 *} INSERT
004390 CLEAR atp_resb-sobkz.
004400 * checks
004410 resb_check atp_resb
004420 p_atpmex.
004430 ENDSELECT.
004440 ENDIF. " IF NOT g_t441v-skbdp IS
004450
004460 ENDIF. " IF s_index_flg = swoff.
004470 ELSE.
004480 SELECT *
004490 FROM atp_resb
004500 INTO atp_resb
004510 WHERE matnr = atpmat-matnr
004520 AND werks = atpmat-werks
004530 AND xloek = space
004540 AND kzear = space
004550 *{ REPLACE PA8K040916
004560 *\ AND sobkz IN (space, sobkzk)
004570 *XFO 16.12.2005 H908220 wrong ATP for spe
004580 *(del) AND sobkz IN (space, sobkz
004590 *} REPLACE
004600 AND bdmng > atp_resb~enmng
004610 AND txtps = space
004620 AND schgt = space
004630 AND dbskz = space
004640 AND ( vorab IS NULL
-
> OR vorab = space ).
004660 *{ INSERT PA8K040916
Bluesky
