Report with Native SQL

Reports can be created in any desired format by writing native SQL in SAP. This prevents time from being wasted on writing programs. At the same time, changes can be quickly observed. Additionally, a developer will not be required while doing this. Any desired report can be created and viewed with SQL knowledge.

Since all SQL codes can be written in DBACOCKPIT, caution should be exercised when using commands like insert, delete, and update.

A trial can be conducted with the query below.

select distinct country.LANDX50 as country, 
                city.BEZEI as city 
    from T005T as country
    inner join T005U as city
    on country.LAND1 = city.LAND1
    where city.SPRAS    = 'E'
      and country.SPRAS = 'E'