How to create View on table T001S

[Former Member]

Hi All,

I get the following error message when I try to create the View. Please help.

Thanks.

Regards,

bw_newbie

Error Message:

Table T001S is not transparent

Message no. MC068

Diagnosis

Transparent matchcode IDs (update type I) are implemented directly as a database view. Therefore they may only contain transparent tables.

Procedure

Remove all the tables which are not transparent tables from the matchcode ID.

[ferry_lianto]

Hi,

Have you looked maintenance view V_T001S?

Regards,

Ferry Lianto

[Former Member]

Hi Ferry,

Thanks for the quick reply.

I am actually trying to extract the data from the table T001S into BW. When I use the table T001S or V_T001S I get the following message:

Error Message:

"Only transparent tables and database views can be extracted"

Thanks.

Regards,

bw_newbie

[Former Member]

Here's a trick - don't know if it'll work for you, but maybe it's worth a try:

Copy view V_T001S to a Z view.

In the data dictionary:

Extras->Change view type

Change it to a projection view. (This is where I'm not sure if it'll work.)

Save and activate.

See if you can extract from this.

Rob

[ferry_lianto]

Hi,

Sorry ... I am not familiar with BW.

Perhaps you may need to write custom progam to extract these data to BW.

Regards,

Ferry Lianto