Learn which tables the Business Content extractors for PS use to get their data. This will help you achieve more accurate extractions.
Project System (PS) is one of the more frequently used modules of SAP R/3, and not one of the most difficult modules from which to extract data into BW. Still, it is useful to know from which tables the Business Content extractors are getting the data and what that data is. This helps to ensure that you are extracting the information you need.
The list of the PS module’s Business Content objects is quite long, and since the PS module is closely related to the Finance (FI) and Controlling (CO) modules, some of its objects overlap with those of FI or CO. Consequently, I will give you an overview of the most important parts of the PS Business Content objects as delivered in BW 3.0B:
PS master data: The main components of PS master data are project definition, work breakdown structure (WBS) element, network, network activity, and orders. In a project, you can plan the organization of the work and people in your project with the WBS, and you can plan the processes and the sequence of tasks with the networks component. You can also assign various types of orders to a WBS element provided the WBS element is an account assignment element.
Table 1 is a list of Business Content-provided objects and their related information. Keep in mind that this is not a complete list, but just the most commonly used components of PS.
| InfoObject/
Description | InfoArea | DataSources | R/3 Tables | Details | 0PROJECT
Project definition | Financials Management and Controlling (0FMCO) | 0PROJECT_ATTR | PROJ | Extracts information about the project such as created-on date or plant | Oracle Financials (0ORA_FI),
Flexible General Ledger (0RA_FI_GL),
Flexible General Ledger: Characteristics (0ORA_FI_GL_CHA01) | 0PROJECT_TEXT | PROJ | Project description is from PROJ-POST1 | 0WBS_ELEMT
WBS element | Financials Management and Controlling (0FMCO) | 0WBS_ELEMT_ATTR | PRPS, PROJ | Extracts information about the WBS element such as plant or project | | Oracle Financials (0ORA_FI), | 0WBS_ELEMT_TEXT | PRPS | Extracts WBS element description from PRPS-POST1 | | Flexible General Ledger (0RA_FI_GL) | 0WBS_ELEMT_WBSH_HIER | PRPS,
PRHI | Extracts WBS elements hierarchy | | Flexible General Ledger: Characteristics (0ORA_FI_GL_CHA01) | 0WBS_INH_ATTR | PSERB | Extracts inheritance data of WBS elements | 0NETWORK
Network | Supplier Relationship Management (0SRM) | 0NETWORK_ATTR | AUFK, AFKO | Extracts information about the network such as created-on date, project, or WBS element | | e-Procurement (0BBP), Procurement Process - Single Documents (0BBP_PROC), Characteristics: Account Assignment Analysis (0BBP_CHA02) | 0NETWORK_TEXT | AUFK | Extracts network description from AUFK-KTEXT and AUFK-LTEXT | 0ACTIVITY
Network activity | Supplier Relationship Management (0SRM) | 0ACTIVITY_ATTR | AUFK, AFKO, AFVC, AFVU | Extracts information about the activity such as created-on date, WBS element, or network | | e-Procurement (0BBP), Procurement Process - Single Documents (0BBP_PROC), Characteristics: Account Assignment Analysis (0BBP_CHA02) | 0ACTIVITY_TEXT | AFVC | Extracts network description from AFVC-LTXA1 | | 0COORDER Orders | Supplier Relationship Management (0SRM) | 0COORDER_ATTR | AUFK | Extracts information about orders such as created-on date or WBS element | | e-Procurement (0BBP), Procurement Process - Single Documents (0BBP_PROC), Characteristics: Account Assignment Analysis (0BBP_CHA02) | 0COORDER_TEXT | AUFK | Extracts network description from AUFK-KTEXT | | | Table 1 | Business Content objects for PS master data | |
PS transaction data: The tricky thing about extracting PS transaction data is that you will not find the Business Content extractor under PS Application Components. Instead, you will find it under Controlling (CO), specifically under Overhead Projects (CO-OM-PRO) and Overhead Orders (CO-OM-OPA). Table 2 shows a list of the extractors and a detailed description of each extractor.
| DataSource | Description | R/3 Tables | Details | | 0CO_OM_WBS_1 | WBS elements: costs | COSP, COSS | Gets cost plans, actuals, and commitments assigned to WBS elements. Differentiate each value using Value Type (WRTTP) and Version (VERSN). This extractor breaks down the values nicely into fiscal year/period. It extracts records with value types 01, 10, 04, 11, 12, 21, 22, 23, 24, 2A, and 2B. | | 0CO_OM_WBS_2 | WBS elements: budget | BPJA, BPGE | Gets budgets and budget changes assigned to WBS elements. Differentiate between budgets and budget changes using Detailing the value type (VTDETAIL), which uses Budgeting/Planning Activity (BPJA-VORGA) to determine this value. It extracts records with value types 41 and 45. | | 0CO_OM_WBS_6 | WBS elements: actual costs through delta extraction | COVP | Provides delta extraction for actual costs assigned to WBS elements. It extracts from table COVP and uses Posting Date (BUDAT) as a point of reference for the delta. | | 0CO_OM_OPA_1 | Orders: costs and allocations | COSP, COSS | Gets cost plans, actuals, and commitments assigned to orders. Differentiate each value using Value Type (WRTTP) and Version (VERSN). This extractor breaks down the values nicely into fiscal year/period. It extracts records with value types 01, 10, 04, 11, 12, 21, 22, 23, 24, 2A, and 2B. | | 0CO_OM_OPA_2 | Orders: budget | BPJA, BPGE | Gets budgets and budget changes assigned to orders. Differentiate between budgets and budget changes using Detailing the value type (VTDETAIL), which uses Budgeting/Planning Activity (BPJA-VORGA) to determine this value. It extracts records with value types 41 and 45. | | 0CO_OM_OPA_6 | Orders: actual costs through delta extraction | COVP | Provides delta extraction for actual costs assigned to orders. It extracts from table COVP and uses Posting Date (BUDAT) as a point of reference for the delta. | | 0CO_OM_NTW_1 | Network: costs | COSP, COSS | Gets cost plans, actuals, and commitments assigned to networks. Differentiate each value using Value Type (WRTTP) and Version (VERSN). This extractor breaks down the values nicely into fiscal year/period. It extracts records with value types 01, 10, 04, 11, 12, 21, 22, 23, 24, 2A, and 2B. | | 0CO_OM_NTW_2 | Network: actual costs through delta extraction | COVP | Provides delta extraction for actual costs assigned to networks. It extracts from table COVP and uses Posting Date (BUDAT) as a point of reference for the delta. | | 0CO_OM_NWA_1 | Network activity: costs | COSP, COSS | Gets cost plans, actuals, and commitments assigned to network activity. Differentiate each value using Value Type (WRTTP) and Version (VERSN). This extractor breaks down the values nicely into fiscal year/period. It extracts records with value types 01, 10, 04, 11, 12, 21, 22, 23, 24, 2A, and 2B. | | 0CO_OM_NWA_2 | Network: actual costs through delta extraction | COVP | Provides delta extraction for actual costs assigned to network activity. It extracts from table COVP and uses Posting Date (BUDAT) as a point of reference for the delta. | 0PS_DAT_PRJ
| Schedule of projects | Not
applicable | For these extractors, you need to go to BW Customizing (SBIW), under Settings for Application-Specific DataSources>Project System, to describe the schedules, duration and buffer. This has two steps: - Create new combinations of the InfoObjects Value type, Origin, and Event.
- Choose which date field of an R/3 master table is built through a given characteristic vector in BW.
| | 0PS_DAT_WBS | Schedule of WBS elements | | 0PS_DAT_NTW | Schedule of network | | 0PS_DAT_NWA | Schedule of network activity | | 0PS_DAT_NAE | Schedule of network activity element | | 0PS_DAT_MLS | Milestone dates | | 0PS_CLM_CST | Costs of a claim | PRPS, PRHI, QMEL | Gives you the costs information of a claim, the WBS elements and projects associated with the claim, and the notification number. | | 0PS_CSH_NTW | Payment in networks | BPPE, FMSU | The Category (VTYPE), Payment Type (CASHTYPE), and Details of Payment Type (CASHDETAIL) are determined from Value Type (BPPE-WRTTP) and Budgeting/Planning Activity (BPPE-VRGNG). | | 0PS_CSH_NWA | Payment in network activities | | |
Business Content InfoProviders: Business Content has five InfoCubes, two MultiProviders, and seven InfoSets under PS. You can find the InfoProviders for PS on the Administrator Workbench: Modeling screen under Product Lifecycle Management (Figure 1). Table 3 shows a list of the InfoProviders and their details.
Figure 1
Bookmark-related context menu attributes
Currency consideration: Keep in mind that these extractors extract all currency keys in the tables and nicely split them into different records based on the currency key instead of creating a new field for each currency like it is stored in tables BPJA, BPGE, COSS, and COSP. For example, look at the highlighted fields in table BPJA in Figures 2 and 3.
Figure 2
One data record has two values with two different currency keys
Once the data is extracted to BW, however, the records look like Figure 3. One record is split into two records with a new field, Currency type, added as a key to differentiate the two records. Figure 4 shows what the values of the currency type fields mean.
Figure 3
Descriptions of currency type used in BW
Figure 4
Currency type field values
PS transactions and tables: Tables 4 and 5 list the common transaction codes in R/3 and common tables for PS, respectively.
| | Technical Name | Description/Details | InfoSources/InfoProviders | | 0PS_C02 | Project System - Dates Stores data about the duration, start dates, and finish dates | Dates milestones (0PS_DAT_MLS)
Dates network activity element (0PS_DAT_NAE)
Network activity dates (0PS_DAT_NWA)
Network dates (0PS_DAT_NTW)
Project deadlines (0PS_DAT_PRJ)
WBS element dates (0PS_DAT_WBS) | | 0PS_C03 | Project System - Earned Value Stores data about the earned values for each object (order, network, network activity, activity element) | Earned value WBS element (0PS_WBS_EVA)
Earned value for network activity element (0PS_NAE_EVA)
Network activity earned value (0PS_NWA_EVA)
Network earned value (0PS_NTW_EVA)
Order earned value (0PS_ORD_EVA) | | 0PS_C04 | Project System - Controlling Contains the transaction data relevant for PS controlling, such as costs (actual, budgets, planned, commitments), revenues (actual, planned, surplus), and many others | Network activity element: actual costs using delta extraction (0CO_OM_NAE_2)
Network activity element: costs (0CO_OM_NAE_1)
Network activity: actual costs using delta extraction (0CO_OM_NWA_2)
Network activity: costs (0CO_OM_NWA_1)
Network payments (0PS_CSH_NTW)
Network: actual costs using delta extraction (0CO_OM_NTW_2)
Network: costs (0CO_OM_NTW_1)
Orders: actual costs through delta extraction (0CO_OM_OPA_6)
Orders: costs and allocations (0CO_OM_OPA_1)
Orders: total/year plan values (0CO_OM_OPA_3)
Payments on network activity (0PS_CSH_NWA)
Payments on WBS elements (0PS_CSH_WBS)
Project System - residual order plan (80PS_C08)
WBS elements: accruals (0CO_OM_WBS_5)
WBS elements: actual costs through delta extraction (0CO_OM_WBS_6)
WBS elements: overall plan (0CO_OM_WBS_3)
WBS elements: statistical key figures (0CO_OM_WBS_4)
WBS elements: budget (0CO_OM_WBS_2)
WBS elements: costs (0CO_OM_WBS_1) | | 0PS_C07 | Project System - Claims Contains the transaction data of claimed costs, estimated claim costs, and accepted claim costs | Claim costs (0PS_CLM_CST) | | 0PS_C08 | Project System - Residual order plan A staging area to allow for calculating residual order plan available for each object (order, network, network activity, activity element) in the InfoCube 0PS_C04. The residual order plan is calculated with the formula Max(0,'MRP planned value - actual - commitment'). To calculate the residual order plan, first transfer all key figures (MRP planned, actual, commitment) of the relevant objects to the InfoCube 0PS_C04 and the InfoCube 0PS_C08. In this step, the values for actual and commitment in the InfoCube 0PS_C08 are inverted by update rules. Also, the value type (0VTYPE) for these entries is changed to 025. Second, transfer back all key figures to the InfoCube 0PS_C04. The update rules then ensure that the residual order plan can accept positive values only. | Network activity element: actual costs using delta extraction (0CO_OM_NAE_2)
Network activity element: costs (0CO_OM_NAE_1)
Network activity: actual costs using delta extraction (0CO_OM_NWA_2)
Network activity: costs (0CO_OM_NWA_1)
Network payments (0PS_CSH_NTW)
Network: actual costs using delta extraction (0CO_OM_NTW_2)
Network: costs (0CO_OM_NTW_1)
Orders: actual costs through delta extraction (0CO_OM_OPA_6)
Orders: costs and allocations (0CO_OM_OPA_1)
Orders: total/year plan values (0CO_OM_OPA_3) |  | 0PS_C05 | Project System - Controlling/Dates | Project System - Dates (0PS_C02)
Project System - Controlling (0PS_C04) | | 0PS_C06 | Project System - Controlling/Earned Value | Project System - Earned Value (0PS_C03)
Project System - Controlling (0PS_C04) |  | 0ISET_NWA | Infoset: Activity | 0ACTIVITY | | 0ISET_NAE | Infoset: Activity Element | 0ACTY_ELEMT | | 0ISET_CLM | Infoset: Claim | 0CLAIM | | 0ISET_MLS | Infoset: Milestone | 0MILESTONE | | 0ISET_NTW | Infoset: Network | 0NETWORK | | 0ISET_PRJ | Infoset: Project Definition | 0PROJECT | | 0ISET_WBS | Infoset: WBS Element | 0WBS_ELEMT | | | Table 3 | Business Content InfoProviders for PS |
|
| Display project | CJ2A | | Display original budget | CJ31 | | Display budget supplement | CJ37 | | Display cost plans | CJ41 | | Project actual cost line items | CJI3 | | Project commitment line items | CJ76 | | | Table 4 | Common transaction codes in R/3 for PS |
|
| Project definition | PROJ | | WBS element master data | PRHI | | WBS, edges (hierarchy pointer) | PRPS | | Inheritance data, PS | PSERB | | Order master data | AUFK | | Operation within an order | AFVC | | Order header data PP orders | AFKO | | CO object: cost totals for internal postings | COSS | | CO object: cost totals for external postings | COSP | | Totals record for annual total | BPJA | | Totals record for total value | BPGE | | Totals record for period values | BPPE | | FI-FM totals records | FMSU | | Quality notification | QMEL | | Object status | JEST | | | Table 5 | Common tables in PS | |
July Hartono
July Hartono has more than six years of experience as an SAP BW consultant. Currently with Alpha Net Consulting, LLC, she has helped several large clients implement BW. Data conversion and extraction, development of custom DataSources, and data modeling are among her best skills. July received mySAP.com Delta Certification for Business Information Warehouse in 2003.
You may contact the author at julyhartono@sbcglobal.net.
If you have comments about this article or publication, or would like to submit an article idea, please contact the editor.
Premium
Premium