In my previous blog https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/9622 , I had explained Basic PS terminologies with the help of a simple example.
Now let me go to some technicalities of the same.
If some body asks me to develop report in PS module what basic information do I need?
Mainly I need to find out three things :
- Master tables and there relationship with each other.
- Standard transactions in PS module and
- BAPIs used to deal with PS data.
Let's start with the master table
PS Master Tables and their relationship:
Object | Master Table |
Project Definition | PROJ |
WBS element | PRPS |
Network | AFKO ,AUFK |
Activity | AFVV , AFVC |
Activity Element | AFVV , AFVC |
Activity Type | CEPC |
Milestone | MLST |
Budget | BPGE , BPJA |
Following diagram depicts the linkage between various master tables in PS module.
Frequently used PS Transactions
Object | Transaction | Description |
Project Definition | CJ06 | Create Project Definition |
CJ07 | Change Project Definition |
CJ08 | Display Project Definition |
CJ20N | Project Builder |
WSB Element | CJ01 | Create Work Breakdown Structure |
CJ02 | Change Work Breakdown Structure |
CJ03 | Display Work Breakdown Structure |
CJ11 | Create WBS Element |
CJ12 | Change WBS Element |
Cj13 | Delete WBS Element |
Network | CN21 | Create Network |
CN22 | Change Network |
CN23 | Display Network |
CN24 | Overall Network Scheduling |
CN24N | Overall Network Scheduling |
CJ20N | Project Builder |
Activity | CJ20n | Project Builder |
Milestone | CN53N | Overview: Milestones |
CJ20N | Project Builder |
Relationship | CN49 | Overview: Relationships |
CN49N | Overview: Relationships |
CNS49 | Overview: Relationships |
Confirmations | CN25 | Confirm Completions in Network |
CN27 | Collective confirmation |
CN28 | Display Network Confirmations |
CN29 | Cancel Network Confirmation |
CN2X | Confirm Completions in Network |
Settlement | CJ02 | Create Settlement Rule |
CJ88 | Settle Projects and Networks |
CJ8A | Act.-setlmt: Proj. retirmt. from IM |
CJ8G | Actual Settlement: Projects/Networks |
Budget | CJ30 | Change Project Original Budget |
CJ31 | Display Project Original Budget |
CJ35 | Budget Return from Project |
CJ36 | Budget Supplement to Project |
CJ37 | Budget Supplement in Project |
CJ38 | Budget Return in Project |
CJ3A | Change Budget Document |
CJ3B | Display Budget Document |
BAPIs used in PS Transactions
Project Definition:
BAPI to extract details of Project Definition:
BAPI Name | BAPI Description |
BAPI_PROJECTDEF_EXISTENCECHECK | To check whether a project definition exists |
BAPI_BUS2001_GETDATA | To get detailed information about a project definition. To do this, you must transfer the external ID of the project definition in the parameter I_PROJECT_DEFINITION. If required, you can also specify in which language the language-dependent fields, such as time units, system status, and so on, are to be returned. If you do not specify a language, the system language is used |
BAPI_PROJECT_GETINFO | To read detailed information about project definitions and the WBS elements of projects from the system. |
BAPI_PROJECTDEF_GETDETAIL | To read detail information about the project definition |
BAPI_BUS2001_GET_STATUS | To get both the active system statuses and the user statuses for a project definition |
BAPI_PROJECTDEF_GETLIST | Provides a list of project definitions |
BAPI_GET_PROJECT_STATISTICS | Display project statistics |
BAPI to create/update Project Definition data:
BAPI Name | BAPI Description |
BAPI_BUS2001_CREATE | Create a project definition |
BAPI_PROJECTDEF_CREATE | Create a project definition |
BAPI_BUS2001_CHANGE | Change Project Definition |
BAPI_PROJECTDEF_UPDATE | Change Project Definition |
BAPI_BUS2001_DELETE | Delete Project Definition |
BAPI_BUS2001_SET_STATUS | one system status and one user status can be revoked each time, and one system status and one user status can be set each time for a project definition |
WBS - Work Breakdown Structure:
BAPI to extract details of WBS element:
BAPI Name | BAPI Description |
BAPI_BUS2054_GETDATA | To get detailed information about WBS elements. |
BAPI_BUS2054_GET_GUID_FROM_KEY | Read the GUID (Global Unique Identifier) using the external object key. |
BAPI_BUS2054_GET_STATUS | To read the active system statuses and user statuses for a list of PSP elements |
BAPI_BUS2054_GET_KEY_FROM_GUID | Read the externalobject key (WBS Key) using the GUID (Global Unique Identifier). |
BAPI create/update WBS element data:
BAPI Name | BAPI Description |
BAPI_BUS2054_CREATE_MULTI | Create WBS Element |
BAPI_BUS2054_CHANGE_MULTI | Change WBS Element |
BAPI_BUS2054_DELETE_MULTI | Delete WBS Element |
Network:
BAPI to extract details of Network:
BAPI Name | BAPI Description |
BAPI_NETWORK_EXISTENCECHECK | Check whether network exists |
BAPI_NETWORK_GETDETAIL | Read detailed information about a network including all objects from the system. |
BAPI_NETWORK_GETINFO | Read detailed information about a network including all objects from the system |
BAPI_NETWORK_GETLIST | Produces a list of networks with descriptions. Returns a container of network numbers |
BAPI_BUS2002_GETDATA | Returns Detail Data for Network Header. |
BAPI_BUS2002_GET_GUID_FROM_KEY | Read GUIDS Using the Network Keys |
BAPI_BUS2002_GET_KEY_FROM_GUID | Read Network Key Using the GUIDs |
BAPI_BUS2002_GET_STATUS | Get network Status |
BAPI create/update Network data:
BAPI Name | BAPI Description |
BAPI_NETWORK_MAINTAIN | To edit network headers, activities and relationships |
BAPI_BUS2002_CREATE | Create Network Header. Only one network can be created each time this BAPI is called. |
BAPI_BUS2002_CHANGE | Change Network Header. Only one network header can be changed each time this BAPI is called. |
BAPI_BUS2002_DELETE | Delete Network Header. Only one network can be processed each time the BAPI is called. |
BAPI_BUS2002_SET_STATUS | Set/Reset Network Status. At the same time, you can revoke one system status and one user status, or set one system status and one user status in a list of activities for the network. |
Activity:
BAPI to extract details of Activity:
BAPI Name | BAPI Description |
BAPI_BUS2002_ACT_GETDATA | Detail Data for Activities |
BAPI_BUS2002_GET_ACTGUID_4_KEY | Read the GUIDs Using the Network Activity Key. Read the GUID (Global Unique Identifier) using the external object key. |
BAPI_BUS2002_GET_ACTKEY_4_GUID | Read the Network Activity Key Using the GUIDs. Read the external object key using the GUID (Global Unique Identifier). |
BAPI_BUS2002_GET_STATUS | Read active system statuses and user statuses for a network header (NUMBER) as well as its activities |
BAPI create/update Activity data:
BAPI Name | BAPI Description |
BAPI_BUS2002_ACT_CHANGE_MULTI | Change one or more activities. Activities of one network only can be changed each time this BAPI is called. |
BAPI_BUS2002_ACT_CREATE_MULTI | Create one or more activities. Activities of one network only can be changed each time this BAPI is called. |
BAPI_BUS2002_ACT_DELETE_MULTI | Delete one or more activities. Activities of one network only can be changed each time this BAPI is called. |
Activity Element:
BAPI to extract details of Activity Element:
BAPI Name | BAPI Description |
BAPI_BUS2002_ACTELEM_GETDATA | Get detailed information about activity elements. |
BAPI_BUS2002_GET_ELEGUID_4_KEY | Read the GUIDs Using the Activity Element IDs |
BAPI create/update Activity Element data:
BAPI Name | BAPI Description |
BAPI_BUS2002_ACTELEM_CHANGE_M | Change one or more activity elements. Each time this BAPI is called, only the activity elements for one network can be changed |
BAPI_BUS2002_ACTELEM_CREATE_M | Create one or more activity elements. Each time this BAPI is called, only the activity elements for one network can be changed |
BAPI_BUS2002_ACTELEM_DELETE_M | Delete one or more activity elements. Each time this BAPI is called, only the activity elements for one network can be changed |
Activity Type:
BAPI to extract details of Activity Type:
BAPI Name | BAPI Description |
BAPI_ACTIVITYTYPE_GETDETAIL | Detailed information on a selected activity type on Key Date. |
BAPI_ACTIVITYTYPE_GETLIST | List of Activity Types Using Selection Criteria |
BAPI_ACTIVITYTYPE_GETPRICES | Determines, for a given day, activity prices for cost center/activity type combinations. |
BAPI create/update Activity Type data:
BAPI Name | BAPI Description |
BAPI_ACTTYPE_CHANGEMULTIPLE | Change One or More Activity Types |
BAPI_ACTTYPE_CREATEMULTIPLE | Create One or More Activity Types |
Confirmation:
BAPI to extract details of Confirmations
BAPI Name | BAPI Description |
BAPI_NETWORK_CONF_GETDETAIL | Using this method you can make the detail data of a confirmation for a network available for the transferred object. You can also make goods movement posted together with the confirmation available. |
BAPI_NETWORK_CONF_GETLIST | All confirmations are determined for the specified network activity or activity element. The transferred capacity category and split are interpreted as additional constraints |
BAPI_NETWORK_CONF_GETPROP | To make default data available for confirming network activities |
BAPI create/update Confirmation data:
BAPI Name | BAPI Description |
BAPI_NETWORK_CONF_ADD | To enter confirmations for network activities/ activity elements and splits. |
BAPI_NETWORK_CONF_CANCEL | To cancel a network confirmation that has already been booked. |