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 SAP ABAP Programming and HANA Database Tutorials
Development resources, articles, tutorials, samples, codes and tools for .Net, SQL Server, Windows, Windows Phone, SAP and ABAP, like SAP UI5, Screen Personas, etc.




CRM Companies List
Web Based CRM Software


Find List of Namespaces used in a SAP System


I recently required to get the list of namespaces used in SAP system and I found that ABAP table TRNSPACET stores transportable namespaces.

If you diplay contents of ABAP table TRNSPACET using SE11 or SE16, programmers can get the full list of namespaces created on that SAP system

SAP namespaces from ABAP table TRNSPACET

Or ABAP developers can query the TRNSPACET table for namespaces and TRNSPACETT for namespace description using following SQL query

select n~namespace, t~descriptn
 from trnspacet as n
 left join trnspacett as t
  on n~namespace = t~namespace and t~spras = 'E'
 into table @data(lt_namespaces).
loop at lt_namespaces reference into data(lr_namespace).
 write :/ lr_namespace->namespace, lr_namespace->descriptn.
endloop.

ABAP developers can also check TRNSPACE table or TRNSPACEL as well






SAP Tutorials

SAP Tutorial

SAP Forums

SAP Tools

SAP Transaction Codes Table








Copyright © 2004 - 2017 Eralper YILMAZ. All rights reserved.
Community Server by Telligent Systems