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

[Former Member]

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.

[arul_murugan]

This message was moderated.

[Former Member]

I already said/did that above.

[che_eky]

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

[Former Member]

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

[che_eky]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[matt]

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

[Former Member]

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.

[Former Member]

See solution above.