Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Error DBIF_RSQL_INVALID_RSQL CX_SY_OPEN_SQL_DB in program

Good Morning Wise People,

                                        I ask you for this type error. I saw by transaction ST22 for this error and I have these possible error causes:

                                       

o The maximum size of an SQL statement was exceeded.
  o The statement contains too many input variables.
  o The input data requires more space than is available.
  o ...

and also it to point at this statements:

SELECT    pep,acao,conta_debito,ccusto_debito,conta_credito,ccusto_cretito

    FROM        zistps_mtcd_acao

    INTO TABLE    tl_mtcd_acao

    FOR ALL ENTRIES    IN tl_perc_fae

    WHERE    pep  IN     rl_pep_ran

        AND acao EQ tl_perc_fae-acao.

I think that could be the first cause, because:

-the table Z 'zistps_mtcd_acao' has 258 records

-the internal table 'tl_perc_fae' has 57.

-But, the 'Range' rl_pep_ran' has 5747 records. This is the problem I suppose.

My first idea is to separate the condition 'where'. First I'll take records by rl_pep_ran and then I'll take by tl_perc_fae_acao.

Would be correct to face this problem so?

I would appreciate your help.

Thanks in Advance.

Best Regards.

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question