topic Problem in updating standard database table ? in Application Development and Automation Discussions

Problem in updating standard database table ?

Former Member — Fri, 03 Oct 2008 10:48:31 GMT

Hi,

I have added two fields in the structure CI_AUFK ( AUFK----> CI_AUFK ) and had activated the structure.... the problem now is when i enter order number in co11n transaction it throwing the runtime error at this point. :

' IF NOT SY-SUBRC IS INITIAL.

IF VSNMR IS INITIAL.

> SELECT SINGLE * FROM CAUFV WHERE AUFNR = AUFNR.

IF SY-SUBRC NE 0.

l_aufnr = AUFNR.

TRANSLATE AUFNR TO LOWER CASE. "#EC TRANSLAN

IF AUFNR NE l_aufnr.

SELECT SINGLE * FROM CAUFV WHERE AUFNR = AUFNR.

ENDIF.

ENDIF.'

can anyone tel me whats the mistake i have done ?

Re: Problem in updating standard database table ?

Former Member — Fri, 03 Oct 2008 19:57:26 GMT

Usually when you add new fields to a table you have to adjust the database afterwards using the Database Utility. Structure CI_AUFK is in the middle of the table not at the end therefore the sequence of the columns changed which will require a DB adjustment.

You can check this in SE11 - Utilities - Database Object - Check.

Make sure you select 'keep data' when adjusting the DB with the database utility.

Hope that helps,

Michael

Re: Problem in updating standard database table ?

Former Member — Sat, 04 Oct 2008 04:05:06 GMT

what is the runtime error you are getting..? can you post the first page of it.

Re: Problem in updating standard database table ?

Former Member — Sat, 04 Oct 2008 06:59:37 GMT

Hi Vijay and Michael,

I activated and adjusted the table in se14 ( both aufk and ci_aufk are active ) . when i enter order number in co11n the error iam getting it on first page was :

****************************************************************************************************************

Runtime Errors DBIF_RSQL_SQL_ERROR

Except. CX_SY_OPEN_SQL_DB

Date and Time 04.10.2008 12:05:04

Short text

SQL error in the database when accessing a table.

What happened?

An error occurred when reading from the database.

Error analysis

An exception occurred that is explained in detail below.

The exception, which is assigned to class 'CX_SY_OPEN_SQL_DB', was not caught

procedure "CO_DB_HEADER_READ" "(FUNCTION)", nor was it propagated by a RAISING

clause.

Since the caller of the procedure could not have anticipated that the

exception would occur, the current program is terminated.

The reason for the exception is:

In a SELECT or FETCH command, the INTO clause contains more

variables than the SELECT list fields.

Missing RAISING Clause in Interface

Program SAPLCODB

Include LCODBU02

Row 1

Module type (FUNCTION)

Module Name CO_DB_HEADER_READ

Trigger Location of Exception

Program SAPLCODB

Include LCODBU02

Row 32

Module type (FUNCTION)

Module Name CO_DB_HEADER_READ

***********************************************************************************************************************

For your Information : When i checked the consitency of the table in se11--> utilities -

> database object , its showing the list of fields that is inconsistent ( almost 30 to 40 fields ) ?

what is the error amd what should i do now ?

Re: Problem in updating standard database table ?

Former Member — Sat, 04 Oct 2008 10:28:18 GMT

some thing wrong with CAUFV, the Dump is coming from which select and what is the table/view used at that point.

what ever fields you added those fields are missing in CAUFV, thats what my opinion.