Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

No insert Statements for EKKO EKPO in ST05 sql trace for transaction me21n

Former Member
0 Kudos

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

9 REPLIES 9

SuhaSaha
Advisor
Advisor
0 Kudos

That might be because the tables are updated via BAPIs ... Do you think SAP uses direct update statements on the DB tables ??

Former Member
0 Kudos

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.

Former Member
0 Kudos

Hi Guys,

any update..

0 Kudos

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.

0 Kudos

Hi Vinod,

Thanks for your reply, I will try again and get back.

0 Kudos

>

> 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.

0 Kudos

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

Former Member
0 Kudos

Create a recording for ME21N and do some initial steps of LSMW you will get the field names.

Former Member
0 Kudos

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!