Extraction

Updated on 17 Aug 2023
5 Minutes to read
Contributors

Print
Dark
Light
PDF

Article summary

Did you find this summary helpful?

Thank you for your feedback

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

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 icon to extract/download the data.
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 icon to extract/download the data.

Programs (Reports)

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 icon to extract/download the data.
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 icon to extract/download the data.
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 icon to extract/download the data.

Custom Tables

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 icon to extract/download the data.
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 icon to extract/download the data.
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 icon to extract/download the data.

Data elements

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 icon to extract/download the data.
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 icon to extract/download the data.
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 icon to extract/download the data.

Domain

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 icon to extract/download the data.
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 icon to extract/download the data.
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 icon to extract/download the data.

Function Groups

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 icon to extract/download the data.
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 icon to extract/download the data.

Function Modules

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 icon to extract/download the data.
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 icon to extract/download the data.

Function Module Parameters

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 icon to extract/download the data.

Development Class/Component for Custom Objects

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 icon to extract/download the data.
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 icon to extract/download the data.

Was this article helpful?

What's Next

Usage Data

Table of contents

TCode
Programs (Reports)
Custom Tables
Data elements
Domain
Function Groups
Function Modules
Function Module Parameters
Development Class/Component for Custom Objects