What is the table name that contains the Field properties for ADSO fields?

[Former Member]

I have an Advanced ADSO that has a couple hundred fields in it. What is the table that stores the field definitions/properties of these fields? I would like to know where the data type, length, unit, etc. are stored. This would be for field that are not defined by an Infoobject.

I know that table RSOADSOT contains all the fields that are in my ADSO, but I an unable to find the table that describes these fields.

[roeas_sap]

In the table DD03L, provide table name of the DSO (for example '/BIC/AXXXXX2' - Active Data Table). It will list all the field names. For Custom Key Figures - it will return as '/BIC/XXXXXXX'.

If you wish to find only the Info-Object name of the Key-figure without '/BIC/', then download the table contents in an excel file. Add a new column beside the FIELDNAME column and provide formula as per below.

Example:  =MID(B2,6,LEN(B2)-5) {B2 is the cell in excel}

This will give Info-Object name without '/BIC/'.

This is the method I followed to get the Field Names in a DSO.