Quick Tip: Add Fields to Dynamic Selections in FI Line Item Display Reports

by Yuval Nir, Managing Director, Financial Systems Consulting, TLR Tech Ltd.

Learn how to add fields to dynamic selections in the G/L account, customer, and vendor line item display reports by maintaining selection views in the underlying logical database.

Categories: ABAP, Accounts Receivable/Accounts Payable, Financials, General Ledger, Reporting

The G/L account, customer, and vendor line item display reports are some of the most often-used reports in FI. These reports provide numerous basic selection criteria as well as additional dynamic selections. Dynamic selections provide users additional fields they can add to the report selection criteria.

Occasionally, you may need to add fields that are not part of the existing dynamic selections. You can do this by following three simple steps. These steps change the selection views in the logical database on which the FI reports are based.

A logical database is a view of SAP tables by which ABAP programs read and process data. The following are the logical databases underlying the reports mentioned above:

• General Ledger: SDF

• Accounts Payable: KDF

• Accounts Receivable: DDF

Other reports use many other logical databases throughout the system. I will not discuss them as they are beyond the scope of this article.

In this example, I will show you how to add the personnel number field and the order number field to the vendor line item display report.

Would you like to see the full version of this article?

If you are an electronic license holder to Financials Expert, please click here to log in.

If you would like information about becoming an electronic license holder — and having 24/7 unrestricted access to all articles and content in the Financials Expert online knowledgebase — click here to see the available subscription options.

Or call 1-781-751-8799 to speak directly with a subscription and licensing specialist about customized access for you and your team.

Isn't your SAP implementation worth world-class information support?

Copyright © 2010 Wellesley Information Services. All rights reserved. Email: customer.service@financialsexpertonline.com.
Financials Expert, 20 Carematrix Drive, Dedham, MA 02026, USA.
Sales and Customer Service: 1-781-751-8799
SAP and the SAP logo are trademarks or registered trademarks of SAP AG in Germany and several other countries.