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: 

Need to create ABAP report for creating project and WBS elements with multiple hierarchy levels

0 Kudos

I am new to ABAP and I need to create an ABAP report which should create project and multiple level WBS elements taking input from excel sheet(it contains both project details and WBS details). Please guide me the path forward.

Thanks,

Dhara.

4 REPLIES 4

Softwaris
Participant

Does your report needs an input screen? What kind of input parameters are required? Do you just want a screen with one "Create project"? What columns will be in the Excel sheet?

Anyway, what I'm trying to say is I hope you don't expect a community member to just post a complete (working) application underneath your question based on the limited set of requirements you have given us.

Although your "new to ABAP" I hope you have some kind of knowledge on how-to write ABAP code because it is going to be difficult if you haven't. Here's some guidance:

  • Build a ABAP screen in which you can select a Excel sheet from whatever directory it's located at. Look into examples of ABAP class CL_GUI_FRONTEND_SERVICES to get started
  • Process the information taken from the Excel sheet (which will most likely be in some kind of internal table) and start creating projects from there. For creating a project you might want to peek into ABAP class CL_PS_PROJECT_MAINTAIN on how-to create one. Especially method PROJECT_MAINTAIN might suit your needs. Or as Simone Milesi suggested use BAPI's to fulfill your needs. I believe we're talking about BAPI's such as BAPI_PROJECTDEF_CREATE and BAPI_PROJECT_MAINTAIN for example
  • Give the user of your report some feedback on the whole process by posting the results of the project creation through an ALV or so. Have a look into ABAP class CL_SALV_TABLE or CL_GUI_ALV_GRID to achieve this.

There are some wonderful BAPIs so... why suggesting that class?
I do not want to sound polemic, but I'm really curious about your choice.

0 Kudos
No, you're absolutely right, hadn't even given BAPI's a thought for a moment, but that might be even more helpful for the topicstarter.

Why I chose this class? Because it helped me out with a somewhat similar requirement in the past and I do recall it giving me a tad more flexibilty while coding and a little less overhead at that time.

former_member617564
Participant

Refer this link here u can find the list of BAPI'S to create project WBS activity for CJ20N transaction.

https://wiki.scn.sap.com/wiki/display/PLM/How+to+use+BAPI+in+Project+System+Module