Skip to Content
1

How to convert pool table to transparent table

Feb 16, 2017 at 08:10 AM

207

avatar image
Former Member

HI ,

I converted the pool table t009t to a transparent table in our BW system to create a view on it and extract data. But now i want to convert it back to pool table.

Can you suggest me how to go about it.

My table->change table category is disabled.

Kindlty suggest a suggestion.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Horst Keller
Feb 16, 2017 at 09:05 AM
3

See Transforming Pooled Tables and Cluster Tables.

The Transparent on following DBs flag "determines that a table on each database where it has once been made transparent is no longer transformed to a pooled table or cluster table, even if a transport with the corresponding table definition is imported or an attempt is made to perform the transformation in ABAP Dictionary. Before this can happen, the flag must be removed explicitly."

Share
10 |10000 characters needed characters left characters exceeded
Sandra Rossi Feb 16, 2017 at 09:14 PM
1

Former Memberexplained how to do it in this thread: https://archive.sap.com/discussions/message/8221962

Excerpt:

  • Converted from pooled to transparent in SE11 (needs object key, opens repair)
  • Activate -> error because it wants converting in SE14
  • SE14 -> convert direct -> OK, table is now transparent
  • Made a few structure changes to the table (add field etc.), activated new version
  • SE11 -> Extras -> Change Table Category --> specified "Pooled" (option was not greyed out)
  • Tab "Delivery and Maintenance" -> entered pool "ATAB"
  • Activate -> no error but table stayed transparent
  • Technical Settings: check box "Maintain as transparent table" was checked (which is why the conversion request was ignored) -> cleared the check box
  • SE11 -> Extras -> Change Table Category --> specified "Pooled" (option was not greyed out)
  • Tab "Delivery and Maintenance" -> entered pool "ATAB"
  • Activate + SE14 conversion => table was again pooled
Share
10 |10000 characters needed characters left characters exceeded