Ansicht
Dokumentation

ABAPUD_CLIENT_OBSOLETE - UD CLIENT OBSOLETE

ABAPUD_CLIENT_OBSOLETE - UD CLIENT OBSOLETE

CL_GUI_FRONTEND_SERVICES - Frontend Services   PERFORM Short Reference  
This documentation is copyright by SAP AG.
SAP E-Book

UPDATE WHERE, DELETE WHERE, CLIENT SPECIFIED

... CLIENT SPECIFIED ...

Effect

The addition CLIENT SPECIFIED can be used instead of the USING additions in the variants UPDATE SET and DELETE FROM of those write statements in which a WHERE condition can be specified. This is obsolete and forbidden in strict mode from Release and whenever global temporary tables are accessed. The addition USING should be used instead of CLIENT SPECIFIED.

The addition CLIENT SPECIFIED disables implicit client handling for the current write statement. No implicit condition is created for the current client and the client column of client-dependent data sources can be specified in the WHERE condition for selecting clients.

If it is known statically that the target of the write statement specified in target is not client-dependent, the addition CLIENT SPECIFIED cannot be specified.

Notes

  • If the addition CLIENT SPECIFIED is specified in UPDATE SET and DELETE FROM without specifying a WHERE condition, all lines of the target specified in target are processed. The DELETE statement then deletes the entire content. The addition USING ALL CLIENTS serves as a replacement for this behavior.
  • If the addition CLIENT SPECIFIED is used for a dynamically specified database table or view and they are not client-dependent, the addition is ignored.
  • If specified for statically specified client-independent database tables or views, the addition CLIENT SPECIFIED produces a syntax error in the strict modes of the syntax check from Release or else a syntax warning.

Example

This example demonstrates two uses of the obsolete addition CLIENT SPECIFIED and how it is replaced by USING. The UPDATE statement selects a client, which can be implemented by switching implicit client handling to this client using USING CLIENT. The DELETE statement is intended to delete the data of all clients, which can be implemented by the addition USING ALL CLIENTS.






SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Length: 3495 Date: 20240423 Time: 094410     sap01-206 ( 59 ms )