on 09-22-2014 8:18 AM
Hello,
I exported the list of all Projects from SE16, PROJ table. How I can export all closed Projects from table?
Thank you.
Rodica
Hi Rodica,
Pass the Project OBJNR numbers from PROJ table to the JCDS table, with System Status as I0046 for Closed (You can check it in TJ02T).
This will give you all the projects which are in CLSD status out of the list you have..
Hope it helps..
Sammar.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Yes you are correct. If you want to get when the first time E0004 was set on a particular WBS or project definition. You need to give the Change Number in JCDS =1. Also you can give Insert or Update Indicator as I, because if it is the first time the status was set it will be I.
Do you want when the E0004 was last changed or do you want whether E0004 is currently active or not? Please explain the requirement?
Cheers
Sammar
Hi Rodica,
You can use CNS41/ CN41N instead to check 'Status' of projects and filtering them with 'CLSD' status and then transporting them to Excel will work for you I think.
OR
For table level, you will have to go with JCDS,JEST and PROJ tables to write SQVI query and pass object number through PROJ to get its status.
Regards
Saurabh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You don't need JEST.. Just pass the Project OBJNR with Status as I0046 to JCDS.. will do the job for you..
JEST is the table which stores the statuses of the objects. and JCDS is the change pointer table..
Pass the Project numbers in batches of 6000 max.. else system can give dump due to large memory issues..
Cheers
Sammar
System Inact needs to be blank. this means that status is active.. if it is checked it means that status is not active..
So in your case.. you take the PROJ-OBJNR and pass these OBJNR to the OBJNR of the JCDS table, with Systen Inact as Blank and Status as I0046. You will get all the Projects which are in CLSD status..
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.