27.1.11

SAP Note 19410 - INFO: Char.validity check f.external data transfer

Symptom:

    1. When you transfer external data to CO-PA, some of the imported records are placed in an error file. The system displays the error message KE100: "The characteristic value & is not allowed".
    2. You want to deactivate the validity check for a certain characteristic during an external data transfer.
Cause and prerequisites


The system generates the above-mentioned error message KE100 when

      a) you import a characteristic value that does not exist in the corresponding check table,
      b) you import a characteristic value that does belong to a characteristic with a value table in the system, but this value table is not recognized as a check table in the data structures for CO-PA because a foreign key text has not been maintained.

      Example:
      You want to fill field "Cost element" during an external data transfer. Field 'KSTAR' (cost element) has the check table entry "*". The value table for the corresponding domain is 'CSKA'.
      Here error message KE100 is displayed because the foreign key dependency is not maintained for field "KSTAR", even though the external data transfer fills a field whose domain has a value table in the CO-PA data structures ("CSKA"). This can be seen in the fact that the CO-PA data structures contain "*" for field "KSTAR" in the ABAP/4 Dictionary for the field "Check table".

In case a) above, the message is correct. In case b), the message is displayed because no check can be performed to ensure that no incorrect characteristic values are transferred to the system.

If, in case b), you do not want to receive the error message (because you can be certain that the data being imported is correct), you can make the modification described below. Note that when you transfer actual data (Transaction KE4X), the records that contain errors are stored in an error file instead of a batch-input session.

Solution

Modify program LKEI1U04 (in Release 4.0, LKEA4U06) as follows (changes are marked with " <--- insert "): ....
LOOP AT PRUEFTAB.
CHECK PRUEFTAB-FIELDNAME NE 'XXXXX'. <--- insert
CHECK PRUEFTAB-CHECKTABLE NE '*'. <--- insert
....
ASSIGN COPA_EINZELPOSTEN+(PRUEFTAB-INTLEN) TO .
....

Caution!:

These modifications make it possible to supply all the characteristics with the check table "*" via external data transfer without a check being run against any existing data in the R/3 System, or to deactivate the check for one characteristic with the field name "XXXXX".
In the above example, one could replace "XXXXX" with "KSTAR" to supply field "Cost element" without any check being run against the value table "CSKA". If you make this modification, you need to make sure yourself that the characteristic is filled with valid values.


Additional key words

KE4X, KE1X, RKEE0000, RKEExxxx, COPA_CHECK_CEEP, CSKA

No comments:

Post a Comment