Restriction on number of conditions in Where clause?

[vinod_vemuru2]

Hi all,

Is there any restriction on number of conditions that can be given in a where clause of a select. I am using a standard BAPI where in where clause is being built dynamically based on inputs to BAPI. For some input data i can see the number of where conditions is around 40000+. So it is dumping.

BAPI is BAPI_COPAPLANNING_GETDATA.

Also is there any transaction(Other than KEPM)/any FM to post the planning data to system. i tried BAPI_COPAPLANNING_POSTDATA.. But it is not giving me correct results.

Any help on this is highly appriciated.

Thanks,

Vinod.

[JozsefSzikszai]

hi,

there is length restriction, just check my question about the same topic:

hope this helps some

ec

[former_member182371]

Hi,

the only thing i´ve found is

(not sure if it may be useful to you but here it goes):

http://66.102.9.104/translate_c?hl=en&sl=ru&u=http://www.sapnet.ru/viewtopic.php%3Ft%3D1950&usg=ALkJ...

Have a look just in case.

Best regards.

[former_member182371]

Hi,

the bapi BAPI_COPAPLANNING_POSTDATA makes a call

to program RK2P%ERK_BAPI where %ERK is the OPERATINGCONCERN.

  PERFORM COPAPLANNING_POSTDATA IN PROGRAM (L_REPNAM)
              USING    OPERATINGCONCERN
                       TYPEOFPROFITANALYSIS
                       TESTRUN
                       SELECTEDFIELDS[]
                       SELECTION[]
                       DATA[]
              CHANGING RETURN[].

You could consider as well using a call to this program.

Best regards.

[vinod_vemuru2]

Hi Pablo,

Thanks for the reply. I have debugged this BAPI all the way

and finally landed here in SDN:-) Some how it is segregating the data and creating the documents.

eg: If i pass 300 records it is segregating and posting around 15 documents.

Do u find any other transaction for posting planning data other than KEPM/KEFC?

Thanks,

Vinod.

[former_member182371]

Hi,

have you cheked this fm´s? :

function group: KED3

function module: RKE_POST_PLAN_LINE_ITEMS

function group: KEIB

function module: RKE_POST_CO_ITEM_PLANNING

function group: KEIO

function module: RKE_POST_ORDER_ITEM_PLAN

function group: KEPT

function module: COPA_POST_PLANSTRUCTURE

Best regards.

[vinod_vemuru2]

Hi Pablo,

Thanks again for your help. I have seen these FMs while debugging the BAPI but haven't tried these. I will try these FMs in my program. It seems one of them will solve my problem.

Thanks,

Vinod.

[Former Member]

it is possible to give 2000 conditions in single where clause.

regards,

manju