10-03-2008 11:48 AM
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 ?
10-03-2008 8:57 PM
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
10-04-2008 5:05 AM
what is the runtime error you are getting..? can you post the first page of it.
10-04-2008 7:59 AM
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
in
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 ?
10-04-2008 11:28 AM
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.