Variante 1 (CREP)
SELECT c~crep_id,
c~crep_type,
c~crep_stype,
c~crea_user,
c~crea_time,
c~chng_user,
c~chng_time,
t~descript,
h~archivpath,
r~r3db_tab
INTO TABLE @DATA(it_crep)
FROM crep AS c " CREP: KPRO CMS: Content-Repositories"
INNER JOIN crepdescr AS t ON ( c~crep_id = t~crep_id ) " CREPDESCR: KPRO CMS: Beschreibungen der Content-Repositories"
LEFT OUTER JOIN crep_http AS h ON ( c~crep_id = h~crep_id ) " CREP_HTTP: KPRO CMS: Content-Repositories (HTTP)"
LEFT OUTER JOIN crep_r3db AS r ON ( c~crep_id = r~crep_id ) " CREP_R3DB: KPRO CMS: Content-Repositories (R3DB)"
WHERE t~langu = @sy-langu.
cl_demo_output=>display( it_crep ).
Variante 2 (SCMS_SDOKSTRE_LIST)
DATA: it_sdokstre TYPE STANDARD TABLE OF sdokstre WITH DEFAULT KEY.
CALL FUNCTION 'SCMS_SDOKSTRE_LIST'
TABLES
i_sdokstre = it_sdokstre
EXCEPTIONS
not_found = 1
OTHERS = 2.
cl_demo_output=>display( it_sdokstre ).