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: 

How to read spool list's text

Former Member
0 Kudos

Hi,

i need to read the spool list text in order to understand which of the KS04 elements have been deleted and which one are not.

KS04 runs in background and in batch i can not get the log via call transaction too.

Any offer?

thanks.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Check table TSP01, It will store all the spool numbers...

3 REPLIES 3

Former Member
0 Kudos

check the table log

CDPOS Change document items.

CDHDR Change document header

Former Member
0 Kudos

Check table TSP01, It will store all the spool numbers...

SuhaSaha
Advisor
Advisor
0 Kudos

Hello,

I think you should be looking into the table CDHDR & CDPOS.

Try selecting the records from CDHDR:

SELECT OBJECTID CHANGENR 
FROM CDHDR
INTO IT_CDHDR
WHERE OBJECTCLAS = 'KOSTL'
AND UDATE = <date on which KS04 job was run>

Using these records, query CDPOS:

CHECK IT_CDHDR IS NOT INITIAL.
SELECT OBJECTID 
FROM CDPOS
INTO IT_CDPOS
FOR ALL ENTRIES IN IT_CDHDR
WHERE OBJECTCLAS = 'KOSTL'
AND OBJECTID = IT_CDHDR-OBJECTID
AND CHANGENR = IT_CDHDR-CHANGENR
AND TABNAME = 'CSKSB'
AND CHNGIND = 'D'. "D--> For Deletion

Once you've the list of OBJECTID you can get the Cost Centres deleted:

CDHDR-OBJECTID = Controlling Area + Cost Centre

Hope this helps.

BR,

Suhas