SAP Note 19995 - CSSL Performance Problems

Symptom:

During performance checks, you find that a large number of accesses to database CSSL take place (for example, via Transaction KB21).

Cause and prerequisites

The table is not buffered.

Solution

The table can be partially buffered:

1. Use Transaction SE11 to maintain table CSSL. Set the buffer type in the technical configuration to "P" (partial) in Release 2.2 or "Individual records" in Releases 3.0 and 3.1.

2. Only for Release 2.2:
Use Transaction SE38 in Include RKPLNI02 to change the two accesses with SELECT SINGLE to table CSSL: FORM routines READ_RECORD and GET_COMBINATIONS.

Old coding
SELECT SINGLE * FROM CSSL WHERE KOKRS = RKPLN-KOKRS
AND KOSTL = RG-KOSTL
AND LSTAR = RG-LSTAR
AND GJAHR = ITCOSLA-GJAHR.

New coding
SELECT SINGLE * FROM CSSL BYPASSING BUFFER
WHERE KOKRS = RKPLN-KOKRS
AND KOSTL = RG-KOSTL
AND LSTAR = RG-LSTAR
AND GJAHR = ITCOSLA-GJAHR.