Skip to main content
Question

How to reference virtual tables in a PRD environment database

  • April 20, 2026
  • 2 replies
  • 18 views

Forum|alt.badge.img

When I access the database in the PRD environment using ‘IFSDBREADONLY’, I can view standard tables and add-on tables, but I am unable to view virtual tables whose names begin with ‘IC_’.
Could you therefore please explain the steps required to view these virtual tables?

 

 

 

2 replies

Jens
Hero (Employee)
Forum|alt.badge.img+10
  • Hero (Employee)
  • April 21, 2026

Hi ​@Ryuichi Takahashi 

When you create a new table using the migration tool using the procedure CREATE_TABLE_FROM_FILE then an IC_-table will be created AND in parallel also a database view.

So in your case instead of using IC_DM_MO_HEADER_CRE_TAB try to use IC_DM_MO_HEADER_CRE without _TAB at the end.

/Jens


Forum|alt.badge.img

Hi Jens,

I ran the command without the _TAB at the end, but the same error occurred.
 

 

Best Regards,
Ryuichi