During complex and extensive projects, it is often necessary to change large amounts of master data or assignments. You can use the mass change function to make cross-project changes to fields pertaining to project definitions, WBS elements, networks, activities, activity elements, milestones, and relationships. However, the SAP R/3 system carries out the changes only if the corresponding prerequisites have been fulfilled, or the business activity is allowed and you have the appropriate authorization. The same authorization objects as for individual changes are used for mass changes. If the system cannot change a field value in a network, it does not carry out the changes in this network. However, if you want to include other networks or work breakdown structures in your selection for mass changes, and if errors do not occur there, the system carries out the changes in these projects.
Caution: If you make a mass change, remember that this might mean that many objects will be changed simultaneously. In many cases, you cannot undo the changes made. For this reason, always be particularly careful when you use this transaction.
You can carry out a mass change that refers to a single project quickly and easily in the Project Builder, in the project planning board, or in structure planning. When you save the project the system saves the changes.
I n t e r n a l U s e S A P P a r t n e r O n l y I n t e r n a l U s e S A P P a r t n e r O n l y
To carry out a mass change that pertains to more than one project you can use the structure info system or the transaction for mass changes in the Project System. In these cases you can carry out the mass changes online or plan them as background jobs. You can test the extent of your changes before you actually make a mass change. A log of the changes is issued for each mass change. The log can be saved and analyzed later.
When you make a mass change, you can select and change data in a variety of ways. You can carry out a mass change without viewing it first or you can check the planned changes ahead of time in a tabular view and carry out the change there. In both cases you can decide whether SAP R/3 should replace all values of the corresponding field with the new value or if it should replace only a certain value. In the case of numeric fields, you can calculate the new field value using a formula from the old field value.
Figure 73: Mass Change
The table form for mass changes has several advantages compared to the simple transaction.
You can show the old values of object fields (for example, the Company Code field for the object WBS element). In this way you can check the individual changes before you carry them out.
I n t e r n a l U s e S A P P a r t n e r O n l y I n t e r n a l U s e S A P P a r t n e r O n l y
Objects can be selected manually or by entering conditions (for example, select all WBS elements that are in company code 1000 or 2000). Only selected objects are changed.
As long as you are still in the tabular view, you can undo the planned changes.
Figure 74: Mass Change Table
Using substitution you can replace values in master data fields for project definitions, WBS elements, network headers, and activities. However, replacing field values may have other prerequisites than those for mass changes. If the responsible person is Morris, the cost center 4290 is substituted (set). You can set more than one value at the same time using substitution.
A substitution can be composed of more than one step. These steps can be carried out one after the other so that replacing the different fields can be connected with different prerequisites.
You can trigger substitution for a project manually, or the system can carry it out automatically when you save a project. In Customizing for the Project System, you can define default values for substitution in the project profile (or network profile). Using an additional indicator in the project profile, you define whether the system should carry out a substitution when saving the WBS. You define the substitution rules in Customizing for the Project System as well. A substitution step is composed of a prerequisite and substitution values:
I n t e r n a l U s e S A P P a r t n e r O n l y I n t e r n a l U s e S A P P a r t n e r O n l y
In the prerequisite you define which conditions must be fulfilled for carrying out a substitution. If the prerequisite is not fulfilled (FALSE), the transaction continues without substitution. If the prerequisite is fulfilled (TRUE), the transaction continues with the substituted value(s). The prerequisites used can be composed of a simple statement or a complex statement combination and rules.
• Substitution value(s)
The substitution value is a numeric value or an alphabetic string, which replaces the specified value(s). You can replace multiple values for each substitution step.
Furthermore, you can set user exits for substitution. With these user exits, you can calculate values and replace them in substitutions and rules.
Figure 75: Substitution
When you enter data in the SAP R/3 system, it is checked against tables and master data. Validation gives you the opportunity to check project definition entries, WBS elements, network headers, and activities in a way that is not included in the standard SAP R/3 system. For example, you can check if the Billing Element indicator is set on the first level of the hierarchy and whether the project has the project type Customer project. If validation indicates that
I n t e r n a l U s e S A P P a r t n e r O n l y I n t e r n a l U s e S A P P a r t n e r O n l y
error message, or information. A validation can be composed of more than one step so that you can check various fields and value combinations using one validation. Analogous to substitution, you can enter default values for a validation in Customizing for the Project System in the project profile (or the network profile) and you can decide if validation should be carried out automatically when you save a project. In this way, you can prevent incorrect work breakdown structures (WBSs) from being saved. You define validations in Customizing for the Project System as well. A validation step is composed a prerequisite and a check:
• Prerequisite
The values to be checked are selected using the prerequisite. If a value is not selected for checking (if the prerequisite is not fulfilled), the value is valid and the transaction is carried out.
• Check
During the check, the values selected using the prerequisite are checked.
If the check statement is true, the transaction is carried out. If the check statement is false, the system issues a message.
Prerequisites and checks are defined using Boolean logic. You can define simple logical statements or you can define very complex statements as well using rules, user exits, and sets in your logical formulas.
• Validation messages
The system issues the message if the prerequisite has been fulfilled but the check has not been fulfilled. You can define messages (information, warnings, error messages) that are shown. You can create a long text for each message by using up to four variables to integrate field values from the validated object.
I n t e r n a l U s e S A P P a r t n e r O n l y I n t e r n a l U s e S A P P a r t n e r O n l y
Figure 76: Validation
Open PS
Open Project System (Open PS) is a general description for the
communication exchange between the SAP Project System and other project management systems or personal organization systems. Open PS is developed independently from the standard release cycle and can be acquired as an additional package to the Project System. For this reason, the software you require to install Open PS, including detailed information, is located on the Project System home page in SAPNet. Open PS is based on the open PS interface to external project management systems (PS-EPS, Interface to External Project Software), which uses the standardized BAPI technology of SAP since EPS 4.0. The SAP R/3 system is structured into individual components, which arrange business objects according to business criteria.
SAP PS is represented by the business objects Project Definition, Work Breakdown Structure, and Network. Access to business objects occurs using stable, standardized methods, which are known as Business Application Programming Interfaces (BAPIs). Data exchange between the external system and the business object when using BAPIs can occur in both directions. You can maintain your work breakdown structure, for example, using the BAPI maintain, and you can read activity data or WBS element data using the BAPI
I n t e r n a l U s e S A P P a r t n e r O n l y I n t e r n a l U s e S A P P a r t n e r O n l y
getinfo. In addition, you can develop your own interfaces based on the EPS interface. However, with Open PS, SAP provides its own interface solution for connecting to Microsoft Project.
Figure 77: EPS Interface 4.*
Open PS for Microsoft Project (Microsoft Project 98 SR1 and later) is delivered starting with SAP R/3 4.5 by SAP. You can download the required software for installing Open PS and detailed information about data exchange between the SAP Project System and Microsoft Project from the Project System home page in SAPNet. When you install Open PS on your PC, a new push button appears in Microsoft Project. Using this push button, you can create a connection to SAP R/3. For this you require an SAP R/3 user in this system. Once a connection to SAP R/3 has been made, Open PS offers you various options for exchanging data directly with Microsoft Project:
• Create a project in Microsoft Project using one SAP R/3 project
• Copy a project from Microsoft Project to the SAP Project System
• Synchronize data from a project in Microsoft Project with a project in the SAP Project System
Using authorizations you can restrict who can upload a project changed in Microsoft Project or a new project to SAP R/3 starting with Open PS 2.00. Other Open PS functions available starting with Open PS 2.00 include downloading actual costs and actual dates from networks for informational purposes, downloading factory calendars from SAP R/3, and downloading
I n t e r n a l U s e S A P P a r t n e r O n l y I n t e r n a l U s e S A P P a r t n e r O n l y
Microsoft Project. If a person is assigned tasks as resources in Microsoft Project, this assignment is displayed as an activity element when transferred to the SAP Project System. You can display this activity element in the worklist of the Cross-Application Time Sheet (CATS) using a modification (see SAP Note 516141).
Figure 78: Open PS