How to get Data from structure COBL

[Former Member]

Hi

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

[Former Member]

Hi,

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

Regards,

Satish

[Former Member]

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.

[Former Member]

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

[Former Member]

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

Rob

[Former Member]

Check the below tables :

COIFT

AFRV

ASSOB

BSEG

<b>CC1ERP</b>

Thanks

Seshu

[Former Member]

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

[Former Member]

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

Rob

[Former Member]

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

Thanks in advance

[Former Member]

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?

[Former Member]

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

[Former Member]

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

[Former Member]

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

I will reward points.

Thanks for the help

[former_member191735]

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

[former_member191735]

check out these tables

CSKS , anlz