Get the data types of all fields in a table
After some research I’ve managed to find an answer to my own question here:
and I would like to share this with you.
Basically, in oder to find the types of all fields of a given table, just make the following query to table DD03L:
SELECT tabname fieldname rollname
INTO TABLE some_table
WHERE tabname = some_name.
BUT, sometimes, fields might be either a structure, or a table as well (deep table\structure). In those cases, we need to select the field type from tables DD03M (if structure) or DD40L (if table). Here are examples:
SELECT typename rowtype
INTO TABLE some_other_table
WHERE typename = some_row_from_some_table-rollname.
SELECT tabname fieldname rollname domname
INTO TABLE some_other_different_table
WHERE tabname = some_row_from_some_table-rollname.
Note the differences between the two queries.
Any additions, corrections, or maybe a name of an existing function that does all that faster and easier, will be appericiated!
Hope that helps someone 🙂