Skip to Content
-2

How to delete PRCTR conditions from the structure : BSIK_WHERE .

Dear All,

I have a below query:- .

select (BSID_FIELDS) from BSID
into corresponding fields of table XBSID
for all entries in K_KUNNR
where KUNNR eq K_KUNNR-LOW
and BUKRS in DD_BUKRS
and BUDAT in DD_BUDAT
and BUDAT le DD_STIDA
and ZUONR in DD_ZUONR
and SHKZG in DD_SHKZG
and UMSKZ in DD_UMSKZ
and BSCHL in DD_BSCHL
and (BSIK_WHERE).

The above BSIK_WHERE contains all the values of the LDB :Dynamic selection conditions which we enter in the dynamic selections.

I want to delete Profit center conditions from the table BSIK_WHERE .

Attached is the screen shot of the table BSIK_WHERE .Please suggest some ideas to delete all the profit centers conditions from the table : BSIK_WHERE .prctr-bsik-where.jpg

I am deleting the PRCTR condition values from the above table : BSIK_WHERE.

LOOP AT BSIK_WHERE INTO WA_WHERE.

IF WA_WHERE CS 'PRCTR'.

DELETE BSIK_WHERE WHERE LINE CS 'PRCTR'.

ENDIF.

ENDLOOP.

But some values which are going in the next line like NOT BETWEEN conditions .So unable to delete those conditions of PROFIT CENTER .

Please suggest some ideas and work around .

Regards

Deep B

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Feb 19 at 07:15 AM

    You could try to FM FREE_SELECTIONS_WHERE_2_RANGE, adapt the range, rebuild, the where clause with FREE_SELECTIONS_RANGE_2_WHERE. (NB: The where_clause is calculated in the LDB program, from data of internal table dyn_sel so your changes may be overwritten by the program)

    But you could consider raise an error in selection-screen when user input such selection and let them correct their input. (What is the actual probem you try to solve with this solution?)

    Add comment
    10|10000 characters needed characters exceeded