1808318 - Project report shows Not assigned values for Project characteristics in relation to some Financial and Sales transactions

SAP Knowledge Base Article - Public

1808318 - Project report shows Not assigned values for Project characteristics in relation to some Financial and Sales transactions

Symptom

You run the Project Cost and revenue by Project report with a specific selection and you can see that some rows have Not Assigned (#) Project, Project task and Project Status although the respective Key figures for the like of ITD Planned Cost, ITD Incurred Cost and ITD Incurred Cost Variance are showing some amounts. You would like the reason of such behavior and where the data, behind these amounts, is coming from.

Reproducing the Issue

  1. Go to Home work center then open the Project Cost and revenue by Project (FINCACU04_Q0003) report.
  2. From the variable selection you enter the mandatory fields:
    • Company: XYZ
    • Set of Books: XYZ
    • Accounting Period/Year: XYZ
    • Project Status: Leave it empty or choose Not Assigned.
  3. Add the following characteristics and Key figures to the rows and columns.
    • Characteristics: Project, Project task and Project Status.
    • Key Figures: ITD Planned Cost, ITD Incurred Cost and ITD Incurred Cost Variance.
  4. You can see that some rows have Not Assigned (#) Project, Project task and Project Status although the respective Key figures for the like of ITD Planned Cost, ITD Incurred Cost and ITD Incurred Cost Variance are showing some amounts.

Cause

With the current version the system behavior is as designed.

Resolution

From the Project Cost and revenue by Project (FINCACU04_Q0003) if you clear the project status selection the report will show every transaction available on the involved data sources like FINCACB01 (Cost Center - Line Items ) and FINPRFU24 (Sales Ledger Line Items).
This means that the report will also show non project based lines (transactions). For this reason the Project, Project task and Project Status field are shown as Not assigned although the respective Key figures for the like of ITD Planned Cost, ITD Incurred Cost and ITD Incurred Cost Variance are showing some amounts.

To see the details of the transactions associated to these amounts you may open report like the Cost Centers - Line Items (FINCACU01_Q0001) or Sales Documents - Line Items (FINPRFU24_Q0001) and using the filtering on the G/L Account characteristic you’ll be able to see all the transactions details. You will also be able to see that these activities are not related to any project.

In conclusion, if you don’t want to see the transactions which are coming from cost center, sales data sources you must have the selection for the project related fields filled. For example project status = 5;2;1 (started, release & planning).

Keywords

KBA , AP-PRO , Project Processing , How To

Product

SAP BUSINESS BYDESIGN 1708