Welcome!
By Felipe Lamounier, state of Minas Gerais, Brazil – powered by 🙂My Easy B.I.
In this post, you will learn how to find metadata from table fields in SAP in a massive way. This guide arose from the need to obtain information about the structure of tables, including:
- Data element
- Data type
- Field length
- Description
Go to transaction SE16 and use View DD03M (Table fields with data elements, text, and domains).
This view is the joining of the tables:
- DD03L: – Table Fields
- DD04L:– Data elements
- DD04T: – R/3 DD: Data element texts
- DD01L: – Domains
Access the View and fill in the fields in the selection:
TABNAME = table name
FLDSTAT = A (Activated)
DDLANGUAGE = your language code
The list of all the metadata for the selected table will be displayed as shown in the image below:
The information I use the most is:
- TABNAME: Table Name
- ROLLNAME: Data element
- DATATYPE: Data Type
- LENG: Length (No. of Characters)
- DECIMALS: Number of Decimal Places
- DDTEXT: Description
Bonus
Below are other important system (environment) tables of SAP.
| Table | Description | Comments |
|---|---|---|
| D010TAB | Table for Use Report<->Tables | Find the report that use a Table. Use also D010B |
| DD02L | SAP Tables | Table type |
| DD02T | SAP DD: SAP Table Texts | Text of tables |
| DD03L | Table Fields | Look in which tables contains some field. Views: DD03VT, DD03VV |
| DDFTX | Run-time object with Screen Painter texts | |
| DD08L | R/3 DD: relationship definitions | |
| DD26S | Base tables and foreign key relationships for a view | Tables of Views – View DD25VV , DD25T for Text, DD28S ->relationship |
| E071 | Change & Transport System: Object Entries of Requests/Tasks | Change Requests |
| TADIR | Directory of Repository Objects | |
| TBTCP | Background Job Step Overview | Job – SM37 |
| TFDIR | Function Module | Text tables: TFTIT, V_FDIR |
| TSTC | SAP Transaction Codes | Text tale: TSTCT |
| TRDIR | Program Tables | Program, Report Tables. Text Table: TRDIRT |
Feel free to leave any questions, suggestions, or comments in the comments section below, at the end of the page.
Keywords: sap table metadata; sap fields table metadata; SAP system tables; How to Extract SAP Table Metadata Efficiently; SAP Table Metadata: Find Field Details in Bulk; The Ultimate Guide to Extracting SAP Table Metadata; How to Retrieve SAP Table Fields and Metadata Instantly; SAP Metadata Extraction: Get Data Elements, Types, and More; Mastering SAP Table Metadata: A Step-by-Step Guide; How to Use SE16 to Find SAP Table Field Metadata; Extracting SAP Table Structure: Data Types, Length, and More; SAP System Tables: How to Retrieve Metadata Like a Pro; Unlocking SAP Table Metadata: A Simple Yet Powerful Method; SAP Table Metadata; SAP Fields Metadata; SE16 Table Extraction; How to extract metadata from SAP tables; Find SAP table fields, data types, and descriptions; Retrieve SAP table metadata using SE16
Did you like the content? Want to get more tips? Subscribe ↗ for free!
🔭See Also:
Want to learn more? Access our area 🎓🚀Training&Education↗
Follow on social media:
- How to Find Deleted VTTK Transport in SAP ECC
Bem Vindo! | Welcome! By Felipe Lamounier, Minas Gerais, Brasil🇧🇷 – powered by 🙂My Easy B.I. 📑 Table of Contents: Introduction In this post, we will learn how to identify which transports were deleted in SAP ECC. We will also see how this data is removed from the VTTK table over a specific period. InContinuar lendo “How to Find Deleted VTTK Transport in SAP ECC” - How to identify SAP BW Process Chains with Recurring Errors
This post by Felipe Lamounier focuses on identifying recurring errors in Process Chains (RSPC) within SAP BW over a 65-day period. It provides a structured approach to filter and analyze execution logs, aimed at improving resource management and system efficiency by addressing improperly executed chains. The analysis concludes with recommendations for maintaining or removing chains based on error frequency. - How to Retrieve SAP Table Metadata Efficiently
This post by Felipe Lamounier provides a guide on efficiently retrieving metadata from SAP table fields using transaction SE16 and the DD03M view. Key elements include data element, data type, field length, and descriptions. Additionally, the post lists important SAP system tables, enhancing understanding of SAP metadata extraction.
🙂My Easy B.I. 