Skip to Content
Former Member
Jun 02, 2009 at 08:03 PM

Query FBL3N


FI Experts I am not too familiar with SAP queries, but my Finance dept is in need of a report that provides data from the following fields.

GL Account

Cost Center

Profit Center

Customer #

Customer Name

Document Type

Document #


I can get 80% of the fields thru report FBL3N except customer # and Customer Name. We have PO that I can drill down to in the line item and I can get name, but the tables I get are structured. I can't use FBL5N because this report although the fields for cost centers and Profit centers are available, they do not get display. You can only get these thru FBL3N.

Does anyone knows which tables I can use for a query report, and if someone can point me to some step by step, or if I need the help of ABAP. I want to avoid an ABAP report for now and want to see if I can it thru a query so I can show the users.

Thank You for your help,

Edited by: Frank on Jun 2, 2009 10:03 PM