09-01-2008 12:37 PM
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.
09-01-2008 12:45 PM
09-01-2008 12:45 PM
09-01-2008 12:51 PM
Hi,
the only thing i´ve found is
(not sure if it may be useful to you but here it goes):
Have a look just in case.
Best regards.
09-01-2008 2:27 PM
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.
09-01-2008 2:43 PM
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.
09-01-2008 3:48 PM
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.
09-02-2008 6:58 AM
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.
09-02-2008 1:44 PM
it is possible to give 2000 conditions in single where clause.
regards,
manju