SAP Knowledge Base Article - Public

2585067 - Product Category is not Shown in the G/L Accounts - Line Items Report

Symptom

You are running a G/L Accounts - Line items report and see that the Product Category is showing as #(not assigned) for few G/L Accounts.

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to General ledger work center.
  2. Go to Business Analytics View.
  3. Open G/L Accounts - Line items report.
  4. Enter the selection criteria along with G/L Account.

For some G/L accounts, the product category is not determined and appears as “#”.

Cause

The items in the invoice/GSR do not have a Product ID as it contains the Product Category only.

In such a case, the Product Category is not derived in the report.

Resolution

The Product Category is not stored in the accounting line item tables used by the G/L Line Item report.
These reports are built purely on financial posting data and therefore do not include logistics attributes such as Product Category.
Product Category is maintained and available in logistics (sales/purchasing) data or analytical reports, but not in the accounting document itself.

Including Product Category in G/L reports would require additional joins between financial and logistics data, which is not part of the standard design due to performance considerations.

What can be done: Product category is not derived in G/L line items; use analytical/profitability reports for this field, or build a custom report with the necessary data joins if required.

This is standard system behavior, not a defect 

Keywords

G/L Accounts - Line items, Product Category g/l accounts - line items,product category , KBA , SRD-FIN-ANA , Analytics Content , Problem

Product

SAP Business ByDesign all versions