If you had a chance to read my other posts, we are working towards enabling reports development in AX using SQL, no X++ thing. On of the issue we faced was getting Base Enum Labels. Dynamics AX transactional DB only keeps Enum values (0,1,2,3…). All labels and names are stored in the Model DB. However, you cannot access it through TSQL query as data is stored in the binary format.
I have found a post, where one smart guy actually did a good reverse engineering to parse that binary field. His script provides a function with name of the Enum + you need to specify a value of Enum for which you would like to get a Label.
I have changed it a bit to get all available Labels for specific Enum. Now, you just need to loop through all available Enums to get your table populated for reporting.
It takes around 2-3 minutes to get into table all Base Enum Labels.
Orinial Script can be found here + explanation on how to parse binary field: Link