We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

CPD43A1 - The query with data change table reference cannot be run. ( OS/400 )

CPD43A1 - The query with data change table reference cannot be run. ( OS/400 )

ROGBILLS - Synchronize billing plans   General Data in Customer Master  
This documentation is copyright by IBM.
SAP E-Book


Message : CPD43A1
The query with data change table reference cannot be run.

Message Long Text :

Cause . . . . . : The target of data change table reference &1 in library &2 is not valid for reason code &3. The reason codes and their meanings follow:
1 -- The view has an INSTEAD OF trigger defined.
2 -- The view contains a function that is not deterministic, or has external action, or modifies SQL data in its where clause.
3 -- The view or its underlying view contains a scalar subselect, or scalar fullselect, or subquery.
4 -- The logical file is a select/omit, or join logical file.
5 -- A distributed file is used as data change table reference.
Recovery . . . :
-- If the view has an INSTEAD OF trigger specified, then remove the INSTEAD OF trigger and try the operation again.
-- Functions that are not deterministic, or have external action, or modify SQL data cannot be used in the where clause of views as the target of data change reference.
-- If a view, or its underlying view contains a scalar subselect, or fullselect. or subquery, then the view cannot be used as the target of data change table reference.
-- Select/omit, or join logical file cannot be used as the target of data change table reference.
-- A distributed file cannot be used as the target of data change table reference.
Change the SQL statement and try the operation again.

Message File : QCPFMSG
Library Message File : QSYS2924


CL_GUI_FRONTEND_SERVICES - Frontend Services   ABAP Short Reference  
This documentation is copyright by IBM.

Length: 3261 Date: 20201027 Time: 074903     sap01-206 ( 33 ms )