SE14 BSEG table adjust and activate table failed with errors.

[Sandra_Rossi]

Hi All,

As we were doing validation for the Goods Movement screen in CO11N Tcode, I used BADI Workorder_goodsmvt for this and did validation for the quantity field in the Goods Movement screen. But there was a dump error(attaching screenshot) and after analyzing it, there was a syntax error in a standard program(GBTWIFI0) in include "GBTWIFIJ". This error "Field GSTN not found in table BSEG". When I checked this table there was no GSTN field in the table. As this was a standard program and we cannot change the code I searched the forum and appended the table with 4 fields. But my functional asked me to delete these fields to further analyze the case of the error. So I first deleted the append structure from SE11 and then in SE14, I tried to adjust the table. Now it is giving an error that these four fields are used by a standard view V_QCMBSEG. Now those 4 append structures are deleted but still showing in BSEG table. The BSEG table is still in an active state having those 4 append structures. Kindly suggest any solution for this.dump-error.png

[Sandra_Rossi]

QCM stuff (V_QCMBSEG for instance) are things created during SE14 adjustment. Be careful after SE14 adjustment failed, it might happen that you lose the contents of the adjusted table if you don't follow carefully SAP instructions. There are some SAP notes about how to proceed to recover errors.

• 2180238 - DDIC Inconsistency Check [VIDEO]
• 1994569 - Error during conversion of pooled table or cluster table
• 1925322 - How to roll back table conversion?
• 1248769 - Inconsistency between database and ABAP Dictionary

See also note 2769310 - Frequently-asked questions about table conversion on cluster table such as BSEG (not sure if you use S/4HANA or an older version).

Before continuing the adjustment, I advise to first ask people to stop working, and immediately backup BSEG, just in case.

As I said again in your other question, GBTxxxxx are programs generated from data of GGB0/GGB1 transaction codes. From there, you should find somewhere the 4 fields to be removed. RGUGBR00 is used to regenerate. See procedure in note 493892 - Syntax error in program GBTmmaa0 Include GBTmmaaB