PS Program Custom development Mass upload

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

  • CJ20N Project Builder. Creates the project on screen element by element; does not read a file.
  • CJ11 Create WBS Element. Creates a single WBS element; does not load a hierarchy in bulk.

Tables used

The tables the program reads and updates. ECC and S/4HANA differences are marked separately.

TableRoleAccessSystem
PROJProject DefinitionProject definition: number, description, profile, company codeWriteECC + S/4
PRPSWBS Element Master DataWBS element: description, responsible person, profit center and indicatorsWriteECC + S/4
PRTEScheduling Data for WBS ElementWBS basic start and finish datesWriteECC + S/4
PRHIWork Breakdown Structure HierarchyWBS hierarchy (up, down, neighbours)WriteECC + S/4
TCJ41Default Values for Work Breakdown Structure (Project Profile)Project profile checkReadECC + S/4
TCJ04Person Responsible for ProjectResponsible person checkReadECC + 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

ParameterDescriptionTypeReference fieldRequiredExample
P_FILEUpload file (XLSX or CSV)Single value—YesC:\temp\proje_wbs.xlsx
P_TESTTest mode (check without posting)Checkbox—NoX
P_EXISTAdd WBS elements to an existing projectCheckbox—No—

Input file columns

The columns of the upload template and the SAP fields they are written to. Columns with an asterisk are mandatory.

#ColumnTarget fieldRequired
1Project definitionPROJ-PSPIDYes
2Project descriptionPROJ-POST1No
3Project profilePROJ-PROFLNo
4Company code (project)PROJ-VBUKRNo
5WBS elementPRPS-POSIDYes
6WBS descriptionPRPS-POST1Yes
7Parent WBS (blank = level 1)PRPS-POSIDNo
8Company code (WBS)PRPS-PBUKRNo
9Profit centerPRPS-PRCTRNo
10Responsible person noPRPS-VERNRNo
11Planning elementPRPS-PLAKZNo
12Account assignment elementPRPS-BELKZNo
13Billing elementPRPS-FAKKZNo
14Basic startPRTE-PSTRTNo
15Basic finishPRTE-PENDENo

Sample upload file

1Project definition *Project descriptionProject profileCompany code (project)WBS element *WBS description *Parent WBS (blank = level 1)Company code (WBS)Profit centerResponsible person noPlanning elementAccount assignment elementBilling elementBasic startBasic finish
2P-26-0020Solar power plant installationZPS00011000P-26-0020-01Engineering1000PC110012XX01/04/202703/31/2027
3P-26-0020P-26-0020-01-01Electrical designP-26-0020-011000PC110012XX01/04/202702/26/2027
4P-26-0020P-26-0020-02Panel and inverter supply1000PC110015XXX02/01/202705/31/2027
A view built with fictional sample data; not real system data.

Result list columns

#ColumnSource
1RowCalculated Row number in the file
2ProjectPROJ-PSPID
3WBS elementPRPS-POSID
4LevelPRPS-STUFE
5DescriptionPRPS-POST1
6Profit centerPRPS-PRCTR
7StatusCalculated From the BAPI return messages: checked, created or error
8MessageCalculated First error or success message from the BAPI return table

Sample result list

RowProjectWBS elementLevelDescriptionProfit centerStatusMessage
2P-26-0020P-26-0020-011EngineeringPC1100CreatedWBS element P-26-0020-01 created
3P-26-0020P-26-0020-01-012Electrical designPC1100CreatedWBS element P-26-0020-01-01 created
4P-26-0020P-26-0020-021Panel and inverter supplyPC1100ErrorResponsible person 15 is not defined
A view built with fictional sample data; not real system data.

How does the program work?

  1. 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.
  2. 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.
  3. BAPI_PS_INITIALIZATION is called; if the project does not exist, the project definition is created with BAPI_BUS2001_CREATE.
  4. 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.
  5. 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

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.

Related report: Project Definition and WBS Structure Upload from Excel Program