G/L Account Line Item Display (FAGL_ACCOUNT_ITEMS_GL)
For the extraction of the G/L Account Line Item Display report, there are two different output formats available, which are shown as tables of the type structure in the SmartExporter Data Dictionary.
Note:
If the tables are not displayed, please check in the application options in SmartExporter whether the correct Data Dictionary has been selected.
| Table | Description |
|---|---|
| /AUDIC/FAGL_ACCOUNT_ITEMS_SPL | G/L Account Line Item Display (FAGL_ACCOUNT_ITEM) - Print list |
| /AUDIC/FAGL_ACCOUNT_ITEMS_ALV | G/L Account Line Item Display (FAGL_ACCOUNT_ITEM) - Field list |
The /AUDIC/FAGL_ACCOUNT_ITEMS_SPL table returns an output of the report on a row-by-row basis. This output is comparable to the Spool output of the SAP® report.
The /AUDIC/FAGL_ACCOUNT_ITEMS_ALV table enables you to extract data on a column-by-column basis. This makes the data compliant with other applications like IDEA.
You can configure the output format using the variants for the FAGL_ACCOUNT_ITEMS_GL report. You can also use the variants to define limits for the individual selection fields, e.g. Company Code, to prevent unauthorized access.
The maintenance of the variants in the SAP® system in the SE38 transaction has to be done by a user with the required authorizations.
The SmartExporter SAP Components\DataSources\Report\DataRequest folder contains the following Data Requests which you can import in SmartExporter:
- Reports - FAGL_ACCOUNT_ITEMS_GL - Print list
- Reports - FAGL_ACCOUNT_ITEMS_GL - Field list
Import the Data Requests in SmartExporter by clicking the Import button in the Run or manage Favorites task.
Please refer to the Notes area in the Introduction step of the Data Request wizard for information on how to use the Additional Data Source.