Best & quick option, and which is SAP standard is to execute CN43N keeping selection as blank and then filter on status column, to get all budgeted WBS. you can use SQVI option, but I don't think functional consultants will have direct access in production to execute SQVI.
On project definition system status will never show BUDG i.e. budgeted. system status BUDG will always be against WBS. You can run table PRPS with all section field BLANK, that will give you list of all the WBS in the particular landscape(Note-Make sure to keep maximum hit as 999999999). Copy the object number of WBS from PRPS table and then execute table JEST with all the object numbers in it. Make sure to enter STATUS = I0067 in JEST table, thus you will get all the budgeted WBS.
I agree with Sammar. I think, you need to go for SQVI query by joining PROJ and JEST table because your idea is to get only those projects/WBS which are budgeted wherein I believe OPSX and CN43N still needs Project Code as a credentials and you are not aware of Project code.
if Siddu is not aware of project code then he at-least know the coding mask then pass that character with * report will consider all project which is starting with coding mask character.
check standard report CN43n with status column as if budget is allocated to few project/wbs out of 1000-1200 as you said. then budgeted wbs would be have BUDG status so it will come in status and you can find those or filter from all project/wbs.
you can check in tcode :OPSX - just run the tcode with "test run" and "details list" you will find the all budgeted and non budgeted WBS number with name.
yes gone through tcode SQVI i am not getting data thru Table JEST, but we are following Overall budget, i gone through table PRPS and BPGE still it's not satisfying..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.