Get SAP MII MDO column names in DB tools

[senthil_kumar44]

Hello All,

We need one help on getting the MDO table column names in SSMS or Dbeaver tools. We are creating SQL SP based on the MDO fields. But when accessing the MDO outside of work bench, it is showing column names as Field1, Field2 like that. But when we execute same MDO in workbench, it is giving correct column names.

Is there anyway to get MDO column names in DB tools? Is there any reference maintained in like reference tables?

Thanks,

Senthil

[steve_stubbs]

Hi Senthil,

There is not any table-based reference to mdo table column names from mdo object Attribute Names. The reference is defined only in the mdo object created in WorkBench.

Regards, Steve