04-28-2010 7:25 AM
No insert Statements for EKKO EKPO in ST05 sql trace for transaction me21n.
IN ST05 I set a filter for ME21N and executed transaction to create a Purchase Order and then checked
ST05 but there is NO insert for EKKO or EKPO??
How Do I find in which columns of EKKO and EKPO data is inserted in ST05?
Edited by: DeepakNandikanti on Apr 28, 2010 8:27 AM
04-28-2010 7:30 AM
That might be because the tables are updated via BAPIs ... Do you think SAP uses direct update statements on the DB tables ??
04-28-2010 7:41 AM
might be..
my consern is :
How Do I find in which columns of EKKO and EKPO data is inserted in ST05?
or
Any other alternative.
04-28-2010 8:19 AM
04-28-2010 9:06 AM
Hi,
I tried in my system and I can see INSERT statement on EKKO and EKPO tables. What exactly you are looking for? Some one else might have switched on the trace at the same time. Can you try again and see.
ST05=>Switch on trace
ME21N=>Create PO.
ST05=>Switch off and display trace.
In trace list search for EKKO and EKPO.
Column names are not shown in the trace list. It is the SQL trace and column list is generated dynamically like :A0, :A1....
@ Suhas,
That might be because the tables are updated via BAPIs ... Do you think SAP uses direct update statements on the DB tables ??
I didn't get above statement. Is there any other way of updation that happens when using BAPI? I believe that, even in case of BAPI there will be update task FMs called during database update. Please correct if i got it wrong.
Thanks,
Vinod.
04-28-2010 9:34 AM
04-28-2010 9:40 AM
>
> I didn't get above statement. Is there any other way of updation that happens when using BAPI? I believe that, even in case of BAPI there will be update task FMs called during database update. Please correct if i got it wrong.
What i meant was generally SAP would not use direct INSERT, UPDATE statements on the DB table. It would bundle the DB operations in a single LUW & execute the LUW in an update task as mentioned.
04-28-2010 12:28 PM
Hi Vinod,
I tried in my system with me21n filter in st05 and created standard PO in me21n.
In the trace,against ekko and ekpo there are select statements but no insert statements!!?.
--Dep
04-28-2010 9:43 AM
Create a recording for ME21N and do some initial steps of LSMW you will get the field names.
04-28-2010 12:32 PM
Simple, really, isn't it? SAP would (most probably) have internal table of type EKPO and a structure of EKKO. SAP programming would have populated these based upon your configuration and with values input on screens. If you have fields populated in these tables, SAP programming is inserting or updating, or flagging for deletion (LOEKZ if I recall correctly).
Of course, SAP is doing an insert, modify or update...how else would data get there? It's not magic!