SAP WITH CLIENT HANDLING ABEXA



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.