topic How to get Data from structure COBL in Application Development and Automation Discussions

How to get Data from structure COBL

Former Member — Wed, 28 Nov 2007 21:29:23 GMT

I need to get KOSTL and AUFNR from the cobl Structure. I found the structure name when i did the following

PA30-> employee number->2011 edit->Cost assigment from the tool bar and did a F1 on the field for Order and Cost Center.

Anyway I have to write a query to see if there r any values in those fields in that structure.

Please help me how can i do that.

I have to pull the information by pernr number, date, terminal ID, time and time event type.

Please help

Re: How to get Data from structure COBL

Former Member — Wed, 28 Nov 2007 21:34:57 GMT

Hi,

You can not get data from Structure. For order & Cost center get the data from AUFK.

Regards,

Satish

Re: How to get Data from structure COBL

Former Member — Wed, 28 Nov 2007 21:37:48 GMT

so how can i find out where its saving the data from that screen? I need to pull that data with terminal id and perner and stuff.

Re: How to get Data from structure COBL

Former Member — Wed, 28 Nov 2007 22:00:29 GMT

Hi,

Go to that field in COBL and double click on that and find where that field has been used in tables. find the relevent table which will have link to Order, then link them.

Regards,

Satish

Re: How to get Data from structure COBL

Former Member — Wed, 28 Nov 2007 22:10:06 GMT

You can use the performance trace (ST05) to see what tables are used.

Rob

Re: How to get Data from structure COBL

Former Member — Wed, 28 Nov 2007 22:22:13 GMT

Check the below tables :

COIFT

AFRV

ASSOB

BSEG

Thanks

Seshu

Re: How to get Data from structure COBL

Former Member — Wed, 28 Nov 2007 22:29:24 GMT

I have checked all those tables for the data that i canged in the cost assignment screen. but none of them have my changed/entered data.

When i make my changes i see in 2011 under PDC it shows 'CO'. I am not sure if that means anything to you guys.

Message was edited by:

Anwarul Kabir

Re: How to get Data from structure COBL

former_member191735 — Wed, 28 Nov 2007 22:37:46 GMT

try where used list for those fields, you might find that or use sql trace and run the transaction to check all other tables.

check the following

AD01DLI

AFRV

Re: How to get Data from structure COBL

former_member191735 — Wed, 28 Nov 2007 22:40:26 GMT

check out these tables

CSKS , anlz

Re: How to get Data from structure COBL

Former Member — Thu, 29 Nov 2007 02:49:59 GMT

Just do the trace and in the list search for KOSTL and AUFNR. It won't take more than a minute.

Rob

Re: How to get Data from structure COBL

Former Member — Thu, 29 Nov 2007 15:40:48 GMT

can you give me some direction or direct me to some sources on How to do the trace?

Thanks in advance

Re: How to get Data from structure COBL

Former Member — Thu, 29 Nov 2007 15:45:52 GMT

I found the following from another thread

ST05 - Activate Trace

RSA3 - Give DS name n F8 ( change the dispay calls to max )

ST05 - Deactivate Trace - Click on ur name n Deactivate

Display Trace

First search Help, SDN ..btn wot is d datasource.

But when i put COBL in the Datasource (RSA3) it says

DataSource COBL is not defined in the source system

How can i fix this?

Re: How to get Data from structure COBL

Former Member — Thu, 29 Nov 2007 15:52:26 GMT

Open two sessions.

In the first session, go to transaction ST05 and press the "Activate Trace" button.

Go to the second session and start your transaction. press the appropriate buttons until you see AUFNR and KOSTl.

Go back to the first session and first press the "Deactivate Trace" button and then the "Display trace" Button. Press enter on the popup.

It will display a list. Search for KOSTL and AUFNR in the list. You will likely find a number of entries, but some of them will be against SELECT statements that will show you the tables used and the WHERE clause.

Rob

Re: How to get Data from structure COBL

Former Member — Thu, 29 Nov 2007 16:14:50 GMT


-------------------------------------------------------------------------------
|Transaction PA30|Work process no 1|Proc.type  DIA|Client  130|User     AKABIR|
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Duration |Obj. name |Op.    |Recs.|RC    |Statement                                                                                |
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|        9|AKB_PRODC |REOPEN |     |     0|SELECT WHERE "SRV_INTF" <> ' '                                                                                |
|    1,880|AKB_PRODC |FETCH  |    1|  1403|                                                                                |
|        7|AKB_PRODC |REOPEN |     |     0|SELECT FROM "AKB_PRODCOMP"                                                                                |
|    1,089|AKB_PRODC |FETCH  |    1|  1403|                                                                                |
|        0|CSKS      |REOPEN |     |     0|SELECT WHERE "MANDT" = '130' AND "KOKRS" = '1000' AND "KOSTL" = '0000012250' AND "DATBI" >= 20070113 AND "DATAB" <= 20070113 AND ROWNUM <= 1                                                                      |
|    1,960|CSKS      |FETCH  |    1|     0|                                                                                |
|        9|CEPC      |REOPEN |     |     0|SELECT WHERE "MANDT" = '130' AND "PRCTR" = '0000012200' AND "KOKRS" = '1000' AND "DATAB" <= 20071129 AND "DATBI" >= 20071129 AND ROWNUM <= 1                                                                      |
|      955|CEPC      |FETCH  |    1|     0|                                                                                |
|        9|CEPC_BUKRS|REOPEN |     |     0|SELECT WHERE "MANDT" = '130' AND "KOKRS" = '1000' AND "PRCTR" = '0000012200'                                                                                |
|    1,103|CEPC_BUKRS|FETCH  |    0|  1403|                                                                                |
|        9|PCL1      |REOPEN |     |     0|SELECT WHERE "CLIENT" = '130' AND "RELID" = 'TX' AND "SRTFD" LIKE '001248382011       2007011320070113000'                                                                                |
|    1,746|PCL1      |FETCH  |    0|  1403|                                                                                |
|       10|TEVEN     |REOPEN |     |     0|SELECT WHERE "MANDT" = '130' AND "PDSNR" = 000006771652                                                                                |
|    1,089|TEVEN     |FETCH  |    1|     0|                                                                                |
|    2,197|TEVEN     |REEXEC |    1|     0|UPDATE SET "PERNR" = 00124838 , "LDATE" = 20070113 , "LTIME" = 070000 , "ERDAT" = 20071129 , "ERTIM" = 100938 , "SATZA" = '01' , "TERID" = 'K002' , "ABWGR" = ' ' , "EXLGA" = ' ' , "ZEINH" = ' ' , "HRAZL" = 0...|
|        6|PCL1      |REOPEN |     |     0|SELECT WHERE "CLIENT" = '130' AND "RELID" = 'B1' AND "SRTFD" = '00124838' AND "SRTF2" >= 0 ORDER BY "CLIENT" , "RELID" , "SRTFD" , "SRTF2"                                                                        |
|    1,311|PCL1      |FETCH  |    1|  1403|                                                                                |
|      990|TEVEN     |REEXEC |    1|     0|INSERT VALUES( '130' , 000006771655 , 00124838 , 20070113 , 070000 , 20071129 , 101038 , '01' , 'K002' , ' ' , ' ' , ' ' , 0 , 0 , 'M' , ' ' , ' ' , 00000123 , 'S' , 00000123 , ' ' , ' ' , 'AKABIR' , 2007112...|
|    1,016|TEVEN_MORE|REEXEC |    1|     0|INSERT VALUES( '130' , 000006771655 , 00124838 , 00000000 , 20070113 , 000000 , 20071129 , 000000 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , 00000000 , ' ' , 00000000 , ' ' , ' ' , ' ' , 0000000000 , 00000000 , '...|
|    1,143|PCL1      |REEXEC |    1|     0|UPDATE SET "HISTO" = ' ' , "AEDTM" = 20071129 , "UNAME" = 'AKABIR' , "PGMID" = 'SAPUP50R' , "VERSN" = '04' , "CLUSTR" = 1027 , "CLUSTD" = <LRAW> WHERE "CLIENT" = '130' AND "RELID" = 'B1' AND "SRTFD" = '00124...|
|      488|PCL1      |REEXEC |    0|     0|DELETE WHERE "CLIENT" = '130' AND "RELID" = 'B1' AND "SRTFD" = '00124838' AND "SRTF2" = 1                                                                                |
|    2,564|          |EXECSTA|    0|     0|COMMIT WORK ON CONNECTION 0                                                                                |
-------------------------------------------------------

Ok Activated the trace.

on my second session

Added 12250 for Cost center and saved

and deactivate the trace

I see select command where it gets the 12250 from CSKS

and when it updates it updates table called TEVEN. but in taven it some how doesn't put the value directly. i am guessing its some hoe linking the number with the CSKS table. can you help me find what is the link here?

Re: How to get Data from structure COBL

Former Member — Thu, 29 Nov 2007 16:21:37 GMT

Never mind i think i have found the Table. its called teven_more.

I will reward points.

Thanks for the help