Table Conversion - Frequently Asked Questions - Technology Troubleshooting Guide. Questions. Basics. What is table conversion? When table conversion happens?
The conversion process for cluster table is the same as that for transparent table? Can I convert cluster table to be transparent? What will happen if I unlock the table from conversion in SE1. Can I unlock a table from conversion? How to check table entries during BSEG. Why this table exists in our database and to solve this issue? Dump CONVT. How to contine the conversion?
Dump. How to contine the conversion? Table conversion for table BSEG took very long time during upgrade. How to do? Answers.
Conversion Exit in sap abap - Download as Word Doc (.doc /.docx), PDF File (.pdf), Text File (.txt) or read online. Please can any one tell me what is conversion programs and where it is useful. SAP Books SAP Certification, Interview Questions, Functional, Basis Administration and.
Basics. What is table conversion? When table conversion happens? If you change ABAP dictionary definition in SE1. ABAP dictionary definition is changed by transport), database structure of the table is adjusted to the change in the ABAP Dictionary during activation. The database structure of a table can be adjusted to its changed ABAP Dictionary definition in three ways: By deleting and recreating the database table. If the table does not contain any data, the existing table is deleted in the database and recreated. By changing the database catalog (ALTER TABLE)If there is data in the table, the system tries to change the structure using ALTER TABLE.
If the database system cannot execute the structural change with ALTER TABLE, the table is converted. So generally when there is data in table and database system cannot execute the structural change with ALTER TABLE to update the database table, table conversion is triggered. The conversion process for cluster table is the same as that for transparent table? NO. They are different. Generally conversion process for transparent table TAB is as below: Step 1: Set lock to against further structural changes. Step 2: Rename table TAB to QCMTAB in the database, delete all indexes, generate nametab for.
But in the conversion for cluster table, table QCMTAB is newly created with the new structure. Can I convert cluster table to be transparent table?
It is possible for you to convert cluster table to transparent table. But it is recommended to convert all cluster tables in the same table cluster to be transparent, not only part of them. The standard table conversion via T- cd: SE1. Instead, the change has to be done cluster table by cluster table. While a single cluster table is being converted, it must not be updated because basically the entire conversion is downtime. The problem is that there is no mechanism during a cluster table conversion that prevents update accesses during the conversion. If the cluster table is updated by the application during the conversion, the result is undefined, i.
And because there are huge data contained in cluster tables, pay attention to make sure there are enough space on database. If you already converted cluster tables into transparent tables, pay attention not to convert them back into cluster tables during next upgrade.
It is very important that you should not skip SPDD adjustment for these tables. Otherwise these table will be converted back to cluster table during upgrade. It is suggested to double check the inactive version of the tables during upgrade in the shadow system before starting the activation phase. During upgrade, the active version in the shadow system will show these tables as cluster tables, and inactive version as transparent ones. The inactive version is the one that will be active after the activation phase.
In case the inactive version is not OK or does not exist, it has to be adjusted or created by changing the table in the shadow system in transaction SE1. What will happen if I unlock a table from conversion in SE1.
Can I unlock a table from conversion? The following will happen if you unlock table TAB from conversion: Delete corresponding data from TCNV and TCNVDATAWrite SYSLOG (T- cd: SM2. Write related. But sometimes when you noticed that. For exmaple, if conversion stopped at step. QCMTAB to QCM8. TAB), you can unlock the conversion, delete QCM8 table.
But QCMBSEG has no dictionary defination in SE1. If you try to display table content for QCMBSEG via SE1. SAP does not deliver any changes that would result in a conversion of the table BSEG. Unfortunately we still can find some conversion issues that happened on table BSEG. Possible reasons for BSEG conversion are: Customer- specific fields are deleted due to . See note 1. 28. 31. You can refer to note 2.
Please do not trigger conversion for table BSEG during SPDD adjustment. In ACT. If you find cluster table BSEG in SPDD list, please DO NOT just reset to original for it. If you click the yellow traffic light for BSEG, generally an . You can check the inactive version via SE1. So it makes sense to ensure that BSEG conversion will not be triggered beforehand.
You can set a breakpoint to let SAPup or SAPehpi stop just after finishing phase PARDIST. If there is no entry with MODEFLAG=U for BSEG in table DDXTT, you can ensure that conversion will not happen on BSEG afterwards. While it is only possible to set breakpoint before a specified phase starts, using option . As from Netweaver 7. You can find the phase name is the upgrade Gui screen, or you can.
If the MODEFLAG for table BSEG is A, not U, then it indicate that conversion is not triggered, and you can continue. But if you find the entry for BSEG with MODEFLAG=U in table DDXTT, please contact SAP for help. Trouble Shootings. We noticed that a new table QCMBSEG was created after updating support package stacks. Why this table exists in our database and to solve this issue? BSEG conversion finished completely, table QCMBSEG was not deleted and still existing in database.
The reason is that if. It is SAP design, not a problem. In such a case, you can just delete table QCMBSEG via SE1. Extras > Invalid Temp. Table > select table QCMBSEG > Delete.
Dump CONVT. How to continue the conversion? The reason is that one or some table fields were changed from Character type to Number type (which triggered table conversion), and the table contains data which are not compatible with this change. The data is mentioned in the dump file, you can find the sentence like . How to continue the conversion? The reason is that the length of.
Generally it was caused by wrong operation, so it is necessary to roll back the conversion. For details, please refer to the following link: http: //wiki. Yz. How to do? If BSEG conversion already started, check at which step it is running or terminated. If conversion is running or terminated at step. In case that step. SM3. 7 > . Unlock BSEG conversion via SE1. BSEG > . Delete table QCMBSEG via SE1.
QCMBSEG > . Change BSEG definition in SE1. YY* or ZZ* customized fields) to avoid conversion.
Activate table BSEG in SE1. If step 2 has already been completed, you have to continue the conversion. Generally the runtime will be extremely long. So if you find BSEG conversion is still running at step. Labels parameters.