Extraction
  • 17 Aug 2023
  • 5 Minutes to read
  • Contributors
  • Dark
    Light
  • PDF

Extraction

  • Dark
    Light
  • PDF

Article summary

For the discovery and analysis of ABAP customizations, the SAP data is extracted into an Excel/CSV file that will be uploaded into the EdgeReady Cloud. 

To begin the process, login to the SAP Dev/QA/Prod environment. Transaction SE16 will be used to access the DB Tables and download the data. SE16 must be set to display the records in ALV List/ALV Grid Display mode.

Note
This guide is written to extract all custom objects under the Z namespace.  Other custom namespaces can also be extracted using this process, simply replace ‘Z*’ with ‘<Custom namespace>*’.  E.g. to extract the TCodes under the Y namespace, the input parameter would be TCODE = ‘Y*’ instead of TCODE = ‘Z*’.

TCode

  1. To fetch Tcode List, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TSTC.
    • Enter the following Input parameter:
      • Input parameter: TCODE = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  2. To fetch Tcode Description, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TSTCT.
    • Enter the following Input parameters:
      • Input Parameter: SPRSL = ‘EN’
      • Input parameter: TCODE = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.

Programs (Reports)

  1. To fetch Program List, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TRDIR.
    • Enter the following Input parameter:
      • Input parameter: NAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  2. To fetch Program Description, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TRDIRT.
    • Enter the following Input parameters:
      • Input Parameter: SPRSL = ‘EN’
      • Input parameter: NAME = 'Z*
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  3. To fetch Program-Tcode Relationship, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TSTC.
    • Enter the following Input parameter:
      • Input parameter: PGMNA = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.

Custom Tables

  1. To fetch Custom Table List, do the following:
    • Go to TCode SE16.
    • Enter Table Name as DD02L.
    • Enter the following Input parameter:
      • Input parameter: TABNAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  2. To fetch Custom Table Description, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as DD02T.
    • Enter the following Input parameter:
      • Input parameter: TABNAME = 'Z*'
    • Click  Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  3. To fetch Custom Table-Program (Reports) Relationship, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as D010TAB.
    • Enter the following Input parameters:
      • Input Parameter: TABNAME = ‘Z*’
      • Input parameter: MASTER = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.

Data elements

  1. To fetch Data Element List, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as DD04L.
    • Enter the following Input parameter:
      • Input Parameter: ROLLNAME = ‘Z*’
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  2. To fetch Data Element Description, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as DD03T.
    • Enter the following Input parameter:
      • Input parameter: FIELDNAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  3. To fetch Data Element - Custom Table Relationship, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as DD03L.
    • Enter the following Input parameters:
      • Input Parameter: ROLLNAME = ‘Z*’
      • Input parameter: TABNAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.

Domain

  1. To fetch Domain List, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name DD01L.
    • Enter the following Input parameter:
      • Input parameter: DOMNAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  2. To fetch Domain Description, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as DD03T.
    • Enter the following Input parameter:
      • Input parameter: FIELDNAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  3. To fetch Data Element - Custom Table Relationship, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as DD03L.
    • Enter the following Input parameters:
      • Input Parameter: DOMNAME = ‘Z*’
      • Input parameter: TABNAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.

Function Groups

  1. To fetch Function Group List, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TLIBG.
    • Enter the following Input parameter:
      • Input parameter: AREA = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  2. To fetch Function Group Description, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TLIBT.
    • Enter the following Input parameter:
      • Input parameter: AREA = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.

Function Modules

  1. To fetch Function Module List and to fetch Function Module - Function Group Relationship, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TFDIR.
    • Enter the following Input parameters:
      • Input Parameter: FUNCNAME = ‘Z*’
      • Input parameter: PNAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  2. To fetch Function Module Description, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TFTIT.
    • Enter the following Input parameter:
      • Input parameter: FUNCNAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.

Function Module Parameters

  1. To fetch Function Module Parameter List, Description, and Parameter – Function Module Relationship, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as FUPARAREF.
    • Enter the following Input parameter:
      • Input parameter: STRUCTURE = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.

Development Class/Component for Custom Objects

  1. To fetch Development Class for the Custom Objects, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TADIR.
    • Enter the following Input parameters:
      • Input parameter: PGMID = 'R3TR'
      • Input parameter: OBJECT (Multiple values as mentioned below)
        • 'DEVC' and 'PROG' and 'TABL' and 'DOMA' and 'DTEL' and 'FUGR' and 'SRFC’ 
      • Input parameter: OBJ_NAME = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.
  2. To fetch Component for the custom Development Class, do the following:
    • Go to TCode SE16.
    • Clear the value in “Maximum No. of Hits”.
    • Enter Table Name as TDEVC.
    • Enter the following Input parameter:
      • Input parameter: DEVCLASS = 'Z*'
    • Click Execute.
    • After the list is displayed, click the button(2)icon to extract/download the data.






Was this article helpful?

What's Next
ESC

Eddy, a generative AI, facilitating knowledge discovery through conversational intelligence