In my previous blog SAP Project System - A ready Reference ( Part 1 ) , 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.
|
