15.12.10

SAP Note 13734 - OB08 incorrect validity date cannot be deleted

Symptom:

A date stored in table TCURR, whose form contradicts the date standards when being displayed using transaction OB08, cannot be deleted.

Cause and prerequisites

An entry with an incorrect date was delivered by SAP which you cannot maintain online. The program outputs the FC236 error message "Enter valid date", to which you cannot react.

The same problem could be generated with Report RFDEV310 up to Release 3.1H if nothing had been entered in the field date.

Solution
The incorrect entry can be deleted via an ABAP program you have to
write yourself.
Example:

REPORT ZZDTCURR.
TABLES: TCURR.
DELETE FROM TCURR WHERE KURST = 'B' "Exchange rate type
AND FCURR = 'BEF' "From currency
AND TCURR = 'DEM' "To currency
AND GDATU = '50000000'. "Valid from

The entry for the GDATU field is to be determined using transaction SE16 (Release 2.2) or SE17 (Release 3.0) and applied to table TCURR. The value stored in the database is displayed under the 'Valid from' field.
Delete your program after running it.

Key word: TCURR

No comments:

Post a Comment