Job Aid

Display Actual Cost Line Items for Projects

Table of Contents Overview............................................................................................................................... 2 1. What can the t-code do? ....................................................................................................... 3 2. How is the t-code used?......................................................................................................... 3 3. Define user-specific layout..................................................................................................... 7 4. Difference between CJI3 and Project Systems Analysis Area in BI ......................................... 9

[Display Actual Cost Line Items for Projects]

Umoja Training

1/9

Display Actual Cost Line Items for Projects

Job Aid

Overview This Job Aid explains the usage of transaction code or T-code CJI3 to generate Projec t Line Item Reports. The transaction is assigned to users with the following Umoja Enterprise Roles:                                        

EMPLOY_TO_DISPOSE: PLANT_MAINTENANCE_APPROVER EMPLOY_TO_DISPOSE: PLANT_MAINTENANCE_PLANNER FINANCIAL_ACCOUNTING: APPROVER_(AP) FINANCIAL_ACCOUNTING: APPROVER_(AR) FINANCIAL_ACCOUNTING: APPROVER_(GL) FINANCIAL_ACCOUNTING: ASSET_ACCOUNTING_SENIOR_USER FINANCIAL_ACCOUNTING: ASSET_ACCOUNTING_USER FINANCIAL_ACCOUNTING: CLOSING_USER FINANCIAL_ACCOUNTING: SENIOR_USER_(GL/AP/AR/CO) FINANCIAL_ACCOUNTING: USER_(AP) FINANCIAL_ACCOUNTING: USER_(AR) FINANCIAL_ACCOUNTING: USER_(GL) FINANCIAL_MANAGEMENT: ACCOUNTING_OFFICE_USER FINANCIAL_MANAGEMENT: BUDGET_APPROVER FINANCIAL_MANAGEMENT: BUDGET_OFFICE_USER FINANCIAL_MANAGEMENT: EARMARKED_FUNDS_DOCUMENTS_CERTIFIER FINANCIAL_MANAGEMENT: FUNDS_COMMITMENT_APPROVER FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_ACCOUNT_APPROVER FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_ACCOUNT_CREATOR FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_ACCOUNT_USER FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_BUDGET_APPROVER_RELEASED FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_BUDGET_APPROVER_UNRELEASED FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_BUDGET_USER_RELEASED FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_BUDGET_USER_UNRELEASED FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_MASTER_DATA_MAINTAINER FINANCIAL_MANAGEMENT: GRANTS_MANAGEMENT_SUPPORT_USER FINANCIAL_MANAGEMENT: MASTER_DATA_MAINTAINER FINANCIAL_MANAGEMENT: SUPPORT_USER PROGRAMME_PROJECT: PROJECT_MANAGEMENT_APPROVER PROGRAMME_PROJECT: PROJECT_MANAGEMENT_USER REAL_ESTATE: FACILITIES_APPROVER REAL_ESTATE: FACILITIES_PLANNER REAL_ESTATE: LEASE_CONTRACT_APPROVER REAL_ESTATE: LEASE_PROCESSOR SERVICES_DELIVERY: DISPOSAL_PLANNER SERVICES_DELIVERY: NOTIFICATION_APPROVER SERVICES_DELIVERY: ORDER_RELEASER SERVICES_DELIVERY: PLANNER SOURCE_TO_ACQUIRE: REQUISITIONER SOURCE_TO_ACQUIRE: REQUISITIONER_DIRECT_PROCUREMENT

[Display Actual Cost Line Items for Projects]

Umoja Training

2/9

Job Aid

Display Actual Cost Line Items for Projects

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *

1. What can the t-code do? The Project Line Item Report shows actual FI postings by Cost Element as well as cost settlements to FI and/or CO. Please note, that CJI3 does not show any commitments or pre-commitments raised against WBS elements. The Project Line Item Report can be run ad-hoc to check and analyse project expenditures within a defined time frame. Please note that a copy of this ECC report was reproduced as a Project Systems Analysis Area in BI. For performance reasons, we recommend to go to BI for bigger analysis of project expenses comprising multiple projects. Based on the Project Line Item Report you can  track project expenses (e.g., good receipts, service entry sheets, payroll and travel)  validate moth-end settlements to AuCs or Cost Centers  validate full settlements from AuC to the final assets  confirm settlement reversals

2. How is the t-code used?

[Display Actual Cost Line Items for Projects]

Umoja Training

3/9

Job Aid

Display Actual Cost Line Items for Projects

[Display Actual Cost Line Items for Projects]

Umoja Training

4/9

Job Aid

Display Actual Cost Line Items for Projects

Note Pre-dfined layout /PJ_AUC includes below dimensions which are relevant to month-end cost settlement;  Business Transaction (=KOAO for all cost settlements to Cost Centers)  Originial Business Transaction (=KOAE for all cost settlements to AuCs)  Reversed (indicator =X for all lines due to settlement reversals)

[Display Actual Cost Line Items for Projects]

Umoja Training

5/9

Job Aid

Display Actual Cost Line Items for Projects

Note Please note that the settlement lines will not show the settlement receiver, i.e. the Cost Center or AuC. To run a report on settlement rules, please go to  KOSRLIST  KOSRLIST_PR (with Selection Variant)

[Display Actual Cost Line Items for Projects]

Umoja Training

6/9

Job Aid

Display Actual Cost Line Items for Projects

3. Define user-specific layout

[Display Actual Cost Line Items for Projects]

Umoja Training

7/9

Job Aid

Display Actual Cost Line Items for Projects

Note

! If the Default setting option is checked, the layout created will be defaulted every user

[Display Actual Cost Line Items for Projects]

Umoja Training

8/9

Display Actual Cost Line Items for Projects

Job Aid

4. Difference between CJI3 and Project Systems Analysis Area in BI Please note that the Project Line Item report was reproduced in the Project Systems Analysis Area in BI to facilitate a more comprehensive analysis of expenditures across projects. To this end, the below fields from the Poject Builder have only become available in BI;      

Thematic Assignment 1 (UN Assignments data tab) Thematic Assignment 2 (UN Assignments data tab) External Symbol (User Fields data tab) External ProjID (User Fields data tab) IMIS Org Unit (User Fields data tab) IMIS Prog ID (User Fields data tab)

Revision History (Soft Copy only) Date 18 March 2016

Version

Prepared by

Description

1

Laura Justus

Initial Draft

[Display Actual Cost Line Items for Projects]

Umoja Training

9/9