Get Example source ABAP code based on a different SAP table
VERSION 5 OUT • CLIENT SPECIFIED UPDATE WHERE (obsolete) • CLIENT SPECIFIED DELETE WHERE (obsolete)
UPDATE WHERE, DELETE WHERE, CLIENT SPECIFIED
ABAP_SYNTAX_OBS ... CLIENT SPECIFIED ...
What does it do? The addition CLIENT SPECIFIED can be used instead of the USING additions in the variants UPDATE SET and DELETE FROM of those write AB-SQL statements in which a WHERE condition can be specified. This is obsolete and forbidden in ABAP_STRICT_777 strict mode from ABAP_RELEASE ABAP_777 / and whenever global temporary tables are accessed. The addition USING should be used instead of CLIENT SPECIFIED. The addition CLIENT SPECIFIED disables implicit AB_SQL 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.
Latest 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 ABAP_RELEASE ABAP_740_SP05 or else a syntax warning. ABAP_HINT_END
Example ABAP Coding
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. ABEXA 00746 ABAP_EXAMPLE_END
