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
-
Go to General ledger work center.
-
Go to Business Analytics View.
-
Open G/L Accounts - Line items report.
-
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
SAP Knowledge Base Article - Public