SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for SAP HANA and ABAP, HANA Database, SQLScript, SAP UI5, Screen Personas, Web Dynpro, Workflow

List SAP Tables by ABAP Code

ABAP tutorial shares programmers ABAP codes to list SAP tables from DD02L - SAP Tables ABAP table. By querying DD02L system table, it is possible for developers to reach all SAP table information.


ABAP Code to List SAP Tables

All tables created are recorded in an other SAP table named DD02L - SAP Tables
By querying DD02L table, ABAP programmer can get the list of SAP tables on the current SAP system and filter according to search criteria.

SELECT tabname INTO TABLE @DATA(gt_saptable)
 FROM dd02l
 WHERE tabclass = 'TRANSP'
 ORDER BY tabname.
" possible Table category options
*TRANSP Transparent table
*INTTAB Structure
*CLUSTER Cluster table
*POOL Pooled table
*VIEW General view structure
*APPEND Append structure

LOOP AT gt_saptable REFERENCE INTO DATA(gr_saptable).
 WRITE:/ gr_saptable->tabname.
ENDLOOP.
Code

ABAP programmers can use above ABAP code to get the list of transparent SAP tables.
Using a pointer with REFERENCE INTO hint all SAP tables can be written on screen in an ABAP Loop statement.

list ABAP tables using DD02L - SAP Tables
ABAP codes to list SAP Tables


List of SAP Tables and Descriptions

IF ABAP programmer joins the "DD02L SAP Tables" with "DD02T - SAP DD: SAP Table Texts" on field TABNAME (Table Name), the description or text description of each table can be fetched programmatically.

SELECT dd02l~tabname dd02t~ddtext
INTO TABLE @DATA(gt_saptable_text)
FROM dd02l
INNER JOIN dd02t ON dd02t~tabname = dd02l~tabname
WHERE tabclass = 'TRANSP' AND ddlanguage = 'E'
ORDER BY dd02l~tabname.

LOOP AT gt_saptable_text REFERENCE INTO DATA(gr_saptable_text).
 WRITE:/ gr_saptable_text->tabname, gr_saptable_text->ddtext.
ENDLOOP.
Code


SAP HANA and ABAP

Install SAP Free
CRM Companies List
Web Based CRM Software


Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.