SAP AVOIDING INVALID VALUES - Guide

Get Example source ABAP code based on a different SAP table
  SAP Help

Avoiding Invalid Values

ABAP_BACKGROUND
For performance reasons, the ABAP runtime framework does not check whether the target field contains a valid value after each and every assignment. Particularly for target fields of the character-like data type n and the date/time types d and t, the conversion rules allow any characters as the result of an assignment. However, only the following values are valid:

For type n: digits only

For type d: a calendar date in the format YYYYMMDD

For type t: a time in the format HHMMSS
For a detailed description of the validity of date fields and time fields, see also the relevant section of the documentation.
A lossless assignment can be used to force checks on valid values.

ABAP_RULE
Only assign valid values
In assignments and calculations, data objects are filled with data types n, d, and t with valid values only.

ABAP_DETAILS
Statements that work with variables with types n, d, or t can only be guaranteed to behave correctly if values are valid. If date and time fields are required, it is important to be aware of their special characteristics. Since the initial value for variables of type d is itself not a valid value, a suitable start value must always be specified by using the addition VALUE. Note that in arithmetic calculations with date fields, if an assignment to a target field with data type d has 0 as a result value, this is an invalid initial value and may require special handling.
If the responsibility for filling data objects of the critical data types lies elsewhere, it is best to always check the validity of their content before use. Lossless assignments with the operator EXACT can be used to do this. Note that the initial value of a date field of type d is interpreted as valid for a lossless assignment, but the value 00010101 is considered to be a valid date only in AB_SQL .

ABAP_EXAMPLE_BAD
The following source code shows a case where the conversion rules in ABAP can lead to problems if not used properly in combination with date fields. The literals can be transferred to the date fields, without raising an exception, to give the values 07092009 and 16092009. Unfortunately, these are interpreted as 09.20.0709 and 09.20.1609, which are invalid dates. During the calculation, they are both converted to the value 0 and the result is 0. Looking at the dates, you would expect the result to be 9. DATA: date1 TYPE d,
date2 TYPE d,
result TYPE i.
date1 = '07092009'.
date2 = '16092009'.
result = date2 - date1.
ABAP_EXAMPLE_END

ABAP_EXAMPLE_GOOD
The following source code shows a date calculation that does give the expected result of 9, thanks to valid values in the date fields. The validity of the literal values is guaranteed by the use of the operator EXACT. TRY.
DATA(result) = EXACT d( '20090916' ) - EXACT d( '20090907' ).
CATCH cx_sy_conversion_no_date.
...
ENDTRY.
The following source code shows how you can check whether the date fields are valid in the calculation, if they are not filled in the same program. Since the EXACT operator does not perform a check for compatible types, the data fields are first converted to temporary text strings, and these are checked. TRY.
result = EXACT d( CONV string( date2 ) ) -
EXACT d( CONV string( date1 ) ).
CATCH cx_sy_conversion_no_date.
...
ENDTRY.
ABAP_EXAMPLE_END