Project Definition and WBS Structure Upload from Excel Program
Short answer: A custom program that creates the project definition and a multi-level WBS structure in bulk from Excel rows, including descriptions, dates, responsible person, profit center and planning / account assignment / billing indicators. It checks the whole hierarchy in test mode first, then lists the result of every WBS row.
- Estimated effort
- L · 7–10 working days
- System
- ECC and S/4HANA
- Tables
- 6
- Scope
- Global
- Built by
- NeKuDos Teknoloji
- Last updated
Why is the standard not enough?
CJ20N creates the project on screen, element by element. Standard templates (CJ91, CJ92) copy the structure but do not take each element's description, dates, responsible person and profit center from a file. The graphical CJ20N screens are not suitable for an LSMW recording. Entering structures with hundreds of elements by hand for every new project takes time and causes errors.
Who uses it? Project controllers, PS consultants and project offices that move the quotation-stage work breakdown into the system.
Closest standard alternatives
Tables used
The tables the program reads and updates. ECC and S/4HANA differences are marked separately.
| Table | Role | Access | System |
|---|---|---|---|
| PROJProject Definition | Project definition: number, description, profile, company code | Write | ECC + S/4 |
| PRPSWBS Element Master Data | WBS element: description, responsible person, profit center and indicators | Write | ECC + S/4 |
| PRTEScheduling Data for WBS Element | WBS basic start and finish dates | Write | ECC + S/4 |
| PRHIWork Breakdown Structure Hierarchy | WBS hierarchy (up, down, neighbours) | Write | ECC + S/4 |
| TCJ41Default Values for Work Breakdown Structure (Project Profile) | Project profile check | Read | ECC + S/4 |
| TCJ04Person Responsible for Project | Responsible person check | Read | ECC + S/4 |
BAPIs and functions used
- BAPI_PS_INITIALIZATIONInitialize PS BAPI Processing. Initializes the PS BAPI unit of work
- BAPI_BUS2001_CREATECreate Project Definition. Creates the project definition
- BAPI_BUS2054_CREATE_MULTICreate WBS Elements. Creates the WBS elements in bulk in hierarchy order
- BAPI_PS_PRECOMMITPrecommit for PS BAPIs. Runs the consistency checks before saving
- BAPI_TRANSACTION_COMMITCommit a BAPI transaction. Saves a successful project permanently
- BAPI_TRANSACTION_ROLLBACKRoll Back BAPI Transaction. Rolls back changes in test mode or on error
Selection screen parameters
| Parameter | Description | Type | Reference field | Required | Example |
|---|---|---|---|---|---|
| P_FILE | Upload file (XLSX or CSV) | Single value | — | Yes | C:\temp\proje_wbs.xlsx |
| P_TEST | Test mode (check without posting) | Checkbox | — | No | X |
| P_EXIST | Add WBS elements to an existing project | Checkbox | — | No | — |
Input file columns
The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.
| # | Column | Target field | Required |
|---|---|---|---|
| 1 | Project definition | PROJ-PSPID | Yes |
| 2 | Project description | PROJ-POST1 | No |
| 3 | Project profile | PROJ-PROFL | No |
| 4 | Company code (project) | PROJ-VBUKR | No |
| 5 | WBS element | PRPS-POSID | Yes |
| 6 | WBS description | PRPS-POST1 | Yes |
| 7 | Parent WBS (blank = level 1) | PRPS-POSID | No |
| 8 | Company code (WBS) | PRPS-PBUKR | No |
| 9 | Profit center | PRPS-PRCTR | No |
| 10 | Responsible person no | PRPS-VERNR | No |
| 11 | Planning element | PRPS-PLAKZ | No |
| 12 | Account assignment element | PRPS-BELKZ | No |
| 13 | Billing element | PRPS-FAKKZ | No |
| 14 | Basic start | PRTE-PSTRT | No |
| 15 | Basic finish | PRTE-PENDE | No |
Sample upload file
| 1 | Project definition * | Project description | Project profile | Company code (project) | WBS element * | WBS description * | Parent WBS (blank = level 1) | Company code (WBS) | Profit center | Responsible person no | Planning element | Account assignment element | Billing element | Basic start | Basic finish |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | P-26-0020 | Solar power plant installation | ZPS0001 | 1000 | P-26-0020-01 | Engineering | 1000 | PC1100 | 12 | X | X | 01/04/2027 | 03/31/2027 | ||
| 3 | P-26-0020 | P-26-0020-01-01 | Electrical design | P-26-0020-01 | 1000 | PC1100 | 12 | X | X | 01/04/2027 | 02/26/2027 | ||||
| 4 | P-26-0020 | P-26-0020-02 | Panel and inverter supply | 1000 | PC1100 | 15 | X | X | X | 02/01/2027 | 05/31/2027 |
Result list columns
| # | Column | Source |
|---|---|---|
| 1 | Row | Calculated Row number in the file |
| 2 | Project | PROJ-PSPID |
| 3 | WBS element | PRPS-POSID |
| 4 | Level | PRPS-STUFE |
| 5 | Description | PRPS-POST1 |
| 6 | Profit center | PRPS-PRCTR |
| 7 | Status | Calculated From the BAPI return messages: checked, created or error |
| 8 | Message | Calculated First error or success message from the BAPI return table |
Sample result list
| Row | Project | WBS element | Level | Description | Profit center | Status | Message |
|---|---|---|---|---|---|---|---|
| 2 | P-26-0020 | P-26-0020-01 | 1 | Engineering | PC1100 | Created | WBS element P-26-0020-01 created |
| 3 | P-26-0020 | P-26-0020-01-01 | 2 | Electrical design | PC1100 | Created | WBS element P-26-0020-01-01 created |
| 4 | P-26-0020 | P-26-0020-02 | 1 | Panel and inverter supply | PC1100 | Error | Responsible person 15 is not defined |
How does the program work?
- The file is read; each row is one WBS element and carries the project definition, WBS number, parent WBS number, description, organizational data and dates.
- Checks: project profile (TCJ41), responsible person number (TCJ04), company code and profit center; WBS numbers must follow the coding mask and every parent must come before its children in the file.
- BAPI_PS_INITIALIZATION is called; if the project does not exist, the project definition is created with BAPI_BUS2001_CREATE.
- The WBS elements are created in hierarchy order in one call to BAPI_BUS2054_CREATE_MULTI; the parent and left neighbour are derived from the row order in the file. BAPI_PS_PRECOMMIT then runs.
- In test mode everything is rolled back with BAPI_TRANSACTION_ROLLBACK; in a real run BAPI_TRANSACTION_COMMIT is done per project. Results and messages are listed per row, and failed rows can be downloaded as a separate file.
Performance notes
The PS BAPIs require one logical unit of work per project; all elements of a project are processed in the same call, and on error the whole project is rolled back. A background job is recommended for structures with several thousand elements.
Features
- Test mode (check without posting)
- Line-by-line result and error log
- Download failed lines as a separate file The corrected file can be uploaded again with the same template.
- Export to Excel An empty upload template can be downloaded as Excel.
- Runs as a background job
Authorization objects
- C_PROJ_TCDCreate authorization by project business transaction
- C_PROJ_KOKProject authorization by controlling area
- C_PRPS_PRCWBS element authorization by profit center
Frequently asked questions
Can networks and activities be loaded as well?
The base version covers the project definition and WBS structure. Networks and activities can be added as a second sheet with BAPI_BUS2002_CREATE and the activity BAPIs; this increases the effort range.
Are budget or planned costs loaded from the same file?
No. Budget and plan values are separate processes with their own approval steps. A separate upload program is recommended for them.
Can this program be used on S/4HANA?
Yes. The PS BAPIs are supported for classic Project System on S/4HANA. If enterprise projects are used, a separate design with the related APIs is needed.
Related reports
WBS Budget vs Actual vs Commitment Report with Remaining Budget
A custom report that shows, for each WBS element, the current budget, plan, actual cost, requisition and order commitments, remaining budget and …
Project WBS Schedule Slippage Report (Basic, Forecast and Actual Dates)
A custom ALV report that compares the basic start and finish dates of each WBS element with the forecast and actual dates, calculates the slip in days …
Let us build this program for your system
Briefly describe your system and expectations. We will clarify the scope and come back with an effort and price quote.