Tuesday, April 19, 2022

How to get table id in D365FO

 In D365FO is difficult to find the table id. We have 2 ways.


way 1: For this we need to write the below code.

            Info(strFmt('%1', tableNum(CustGroup)));


way 2: Written sql statement.

    For Table id:

    select * from SYSTABLEIDVIEW where name = 'custGroup'--id = '22163'



     For Table field id:

    select * from SYSTABLEFIELDIDVIEW where id = '4319'




Keep Daxing!!


No comments:

Post a Comment