根据单据的标识获取单据表名

 --销售订单为例

 select FKERNELXML.query('//HeadEntity/TableName').value('(TableName)[1]','varchar(max)') as '单据头表名',

 FKERNELXML.query('//SubHeadEntity[Key="FSaleOrderFinance"]/TableName').value('(TableName)[1]','varchar(max)') '子单据头表名',

 FKERNELXML.query('//EntryEntity[Key="FSaleOrderEntry"]/TableName').value('(TableName)[1]','varchar(max)') '单据体表名' from 

 T_META_OBJECTTYPE where FID='SAL_SaleOrder' 

星空如何根据数据表名查业务对象标识https://vip.kingdee.com/questions/259378729716127232/answers/259379079537721856?productLineId=1