Get Example source ABAP code based on a different SAP table
VX_EXA_ONLY
WITH>, Client Handling This example demonstrates client handling in the statement WITH>>.
ABAP_SOURCE_CODE DEMO CL_DEMO_CTE_CLIENT_HANDLING
ABAP_DESCRIPTION In the subquery of the common table expression> +cte>, the addition USING ALL CLIENTS> is used to access the client-dependent DDIC database table SCARR>>. This means data is read from all clients. The client column is part of the SELECT> list. The main query of the WITH> statement reads the common table expressions. A restriction to one specific client is specified. The client column can be specified after WHERE> since the result set of +cte> is not client-dependent. The column MANDT> is not used as a client column.