SAP WHERE LOGEXP IN SUBQUERY
Get Example source ABAP code based on a different SAP table
ARTICLE
• IN WHERE - subquery
Syntax
Effect
This expression can be formed with a scalar
Example
Reading the geographical latitude and longitude of a town from the
conn_id TYPE spfli-connid.
DATA: city TYPE sgeocity-city,
lati TYPE p LENGTH 8 DECIMALS 2,
longi TYPE p LENGTH 8 DECIMALS 2.
SELECT SINGLE city latitude longitude
INTO (city, lati, longi)
FROM sgeocity
WHERE city IN ( SELECT cityfrom
FROM spfli
WHERE carrid = carr_id AND
connid = conn_id ).