topic Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD) in Application Development and Automation Discussions

Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Thu, 20 May 2010 09:59:38 GMT

Hi All,

I have a requirement where I need to add a field in the header item of VA03,

So I have add new field or APPEND structure in VBAK.

I appended structure ZZLAND1 having component field LAND1 in VBAK.

In SE11, structure ZZLAND1 is activated and has no log of errors.

In SE14, table VBAK is successfully adjusted as well and no log of errors.

When I execute SE16, I have runtime error:

Short text

SQL error in the database when accessing a table.

Missing Handling of System Exception

Program /1BCDWB/DBVBAK

Trigger Location of Exception

Program /1BCDWB/DBVBAK

Include /1BCDWB/DBVBAK

Row 547

Module Name START-OF-SELECTION


 544 CASE ACTION.
 545   WHEN 'ANZE'.
 546 try.
 547 SELECT * FROM VBAK                     "client specified  <<-- Error Occurs here
 548                  APPENDING TABLE IVBAK
 549                  UP TO RSEUMOD-TBMAXSEL ROWS BYPASSING BUFFER
 550    WHERE VBELN IN I1.

Am I missing any other part here? In VBAP, after I added a field, I didn't encounter this one.

Thanks all.

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

arul_murugan — Thu, 20 May 2010 10:35:49 GMT

This message was moderated.

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Thu, 20 May 2010 10:37:17 GMT

I already said/did that above.

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

che_eky — Thu, 20 May 2010 10:48:31 GMT

Hi,

I would delete the new append and start again. Make sure you use the "Create Append" option in SE11 to create and activate your append. Also I notice your append structure contains field LAND1, it is a good idea to append fields in the customer namespace like ZLAND1. Save and activate the append. If SE11 says you must adjust table VBAK then do so using SE14.

Che Eky

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Thu, 20 May 2010 10:57:44 GMT

Hi,

Yes, I did it just now, I delete the appended structure ZZLAND1.

This time I did the following:

- appended a new Structure ZZLAND1

- inside the structure I have component field ZZLAND1 with domain LAND1

- executed SE14 and it is success and no error logs

Then I run SE16 again, and have the same runtime error again.

[See here the details of the runtime error log|http://www.megaupload.com/?d=0U09KWE5]

Thanks

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

che_eky — Thu, 20 May 2010 11:03:14 GMT

Can you please go back into SE11 and reactivate VBAK, see if you get any errors or not? I know you have used SE14 but go back to SE11 and reactivate.

Che Eky

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Thu, 20 May 2010 11:08:36 GMT

Hi,

Yes I double and double ensure that all of the objects are activated as well.

[Please see the actual screenshot here|http://img40.imageshack.us/img40/2938/vbakaddnewfield.jpg]

thanks

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Thu, 20 May 2010 11:52:54 GMT

As we see you have done everything correctly. However check whether following things are also in place:

The fields of an append structure must lie in the customer namespace, that is the field names must begin with ZZ or YY. This prevents conflicts with fields inserted in the table by SAP.

An append structure must be flat, that is each field of the append structure must either refer to a data element or be directly assigned a data type, length, decimal places and short text.

If a foreign key or search help attachment is already defined for a field in the table, you cannot change this definition with the append structure.

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Thu, 20 May 2010 13:14:59 GMT

Hi Saud, that's what I exactly did above and I ensure that I follow the SAP-wiki guidelines in appending structure to VBAK.

Hi All,

Anyone who have encountered this scenario?

thanks.

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Fri, 21 May 2010 02:20:59 GMT

Hi All,

Now I did the same changes in other SAP system/box, my changes went through without any issues on dumping.

What other objects should I check aside from the one I mentioned above?

thanks

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

matt — Fri, 21 May 2010 09:14:19 GMT

When you change the table, the program that SE16 uses needs to be regenerated - usually this is done automatically. Have you tried: SE16, put the table name in, then press F8 (which is Generate Program), instead of "enter".

matt

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Sun, 23 May 2010 18:53:53 GMT

Hi Matt,

Problem solved.

Solution: I used other laptop to modify VBAK, and follow the SAP standard process in appending a structure.

Weird O_O

Thanks All.

Re: Runtime Error in SE16 after adding fields in VBAK (ABAP-SD)

Former Member — Sun, 23 May 2010 18:57:19 GMT

See solution above.