Would it be possible to create a custom table in M3 (On Premise), load the table with API and report via CMS010 (Custom list) or advanced report content to the users?
It seems hard to find documenation and any help is appreciated!
Yes, of course, you can use the MAK for developing the new table and the new API.
After that, probably you have to update the M3 dictonary (CFIHEA, CFIFFD, CFIACP) and then the table should be visible in CMS010
Agree, except if you create a Custom API, there should be no need for CMS010 (unless you would like to Join additional Tables) since you already have a NEW API in MRS001 (you have to create the records here of course to support the API).
Thanks for your help! Can I create a custom API to update the custom table? I must say I always used them read data so far
yes, of course, with MAK you can do everything :-)