Get SPL Balance
In order to extract an SPL balance, the Get SPL Balance function is used. The usage of SPL firstly requires a change within the User Options.
Within User Options in the GL Wand ribbon, tick the “Use SPL” box and select the relevant Table Group from the dropdown. Then Save and click the Change Company Code button from the GL Wand ribbon to re-initiate the login process.
| Parameter | Description |
|---|---|
| Year | A value, e.g. “2017” |
| Period | Period number e.g. “1” |
| Balance Type | YTD – summarizes the full year balance up to the period parameter input
PTD – summarizes the movement for the period parameter input QTD – summarizes the movement for the quarter based on the period parameter input CTD – summarizes the custom period criteria based on the period parameter input e.g. “2:4” |
| Ledger | The ledger defined for the table group |
| Actual Flag | A = Actual; B = Budget |
| Version | If you have selected Budget values, enter the applicable Version. The wizard will automatically insert the correct version for Actuals. |
| Currency Type | The Currency Type as configured in SAP e.g. “10” = Company Code Currency; “B0” = Operating Concern Currency |
| SPL Table Group | The SPL table group that you are getting a balance from |
| Company Code | The Company Code. |
| GL Account | General Ledger account. |
| Currency | Optional |
| Movement | Optional |
| Unit of Measure | Optional |
| Custom Fields | Optional |
Up to a maximum of 20 custom fields can be configured for the SPL table group. The configuration is done in the /n/excel4ap/wands_5_mt SAP transaction.
Authorization Objects
| Authorization Object | Description |
|---|---|
| F_BKPF_KOA | Accounting Document: Authorization for Account Types |
| F_BKPF_BUK | Accounting Document: Authorization for Company Codes |
| F_BKPF_BES | Accounting Document: Account Authorization for G/L Accounts |
| F_FAGL_LDR | General Ledger: Authorization for Ledger |
| K_REPO_CCA | CO-CCA: Reporting on Cost Centers/Cost Elements |
| K_CCA | CO-CCA: Gen. Authorization Object for Cost Center Accounting |
| K_PCA | EC-PCA: Responsibility Area, Profit Center |
| F_FAGL_SEG | General Ledger: Authorization for Segment |