Get Universal Journal Balance
In order to extract a Universal Journal balance on a S/4 HANA SAP system, the Get Universal Journal Balance function is used.
| 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 | Ledger ID e.g. “0L” |
| Actual Flag | A = Actual |
| Category | Plan category required for querying plan data instead of actuals. |
| Currency Type | The Currency Type as configured in SAP e.g. “10” = Company Code Currency; “30” = Group Currency |
| Company Code | The Company Code(s); It is important to note that all company codes selected for a single formula must have the same currency code for the currency type selected, share the same chart of accounts, as well as all belong to the same controlling area. |
| GL Account | A single value representing a child or group; a range of child values; a list of child or group values; child values to be excluded; or any combination of the preceding value inputs |
| Cost Center | Optional |
| Profit Center | Optional |
| Segment | Optional |
| Currency | Optional, unless Document Currency is chosen as Currency Type |
| Movement | “D” = Debit; “C” = Credit’ blank or “*” for both Debits and Credits |
Authorization Objects
A communications user is used for the public cloud scenario and therefore end user authorizations cannot be tested.