Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How to convert pool table to transparent table

Go to solution
former_member357209
Explorer

‎02-16-2017 8:10 AM - edited ‎01-21-2024 9:40 PM

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.

1 ACCEPTED SOLUTION

Go to solution
horst_keller
Product and Topic Expert
Product and Topic Expert

‎02-16-2017 9:05 AM

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."

2 REPLIES 2

Go to solution
horst_keller
Product and Topic Expert
Product and Topic Expert

‎02-16-2017 9:05 AM

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."

Go to solution
Sandra_Rossi
Active Contributor

‎02-16-2017 9:14 PM

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