SAP Knowledge Base Article - Public

2799716 - Product Category Not assigned in Projects - Line Items Report

Symptom

  • You create expenses for project ABC (ABC represents the ID of the project), for example, Supplier Invoice XXX (XXX represents the ID of the invoice). You maintain product category AA (AA represents the ID of the product category) for the supplier invoice item XXX-X (XXX-X represents the supplier invoice item ID).
  • You open the Project - Line Items report for project ABC.
  • For the business transaction of supplier invoice XXX the Product Category ID (Product Category) attribute displays #- Not Assigned.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to the Supplier Invoicing work center.
  2. Go to the Invoices and Credit Memos view.
  3. Search and open supplier invoice XXX.
  4. Navigate to Items tab and find item XXX-X.
  5. Here, product category AA maintained. 
  6. Run the Projects - Line Items report (for example from the Project Management work center) for project ABC. 
  7. In the View section, add the Product Category ID (Product Category) attribute  to the Row fields.
  8. For supplier invoice XXX the Product Category ID displays # Not Assigned.

Cause

  • For business transactions with Overhead Costs line items, the product category is derived from cost center market segment, provided the product category is maintained in the cost center master data.
  • For the business transactions with Other Direct Cost line items, the product category is derived from the Profit Analysis Attributes of the Project header (Accounting tab), provided it is maintained here.
  • For all other business transactions that neither post overhead costs or other direct costs, the product category is derived from the Product master data.

Resolution

Open the journal entry of supplier invoice XXX.

Go to the Other Direct Cost line item and there you notice a product category.

However, this product category is not maintained in the project header Accounting tab:

  1. Go to the General Ledger work center.
  2. Go to the Journal Entries view.
  3. Show All Postings and search for XXX.
  4. Open the journal entry of supplier invoice XXX.
  5. Choose YYY to open the project.
  6. In the Project header go to the Accounting tab. 
  7. Here, under Profit Analysis Attributes the Product Category field is empty: To display the product category for the Product Category ID (Product Category) attribute in the report maintain the product category here. 

Keywords

Product Category, Project, Projects - Line Items , KBA , SRD-FIN-ANA , Analytics Content , Problem

Product

SAP Business ByDesign all versions