Query SBO: Balance Sheet Reports
Technical Name: 0SBO_C21 _Q002
Use
The query 0SBO_C21 _Q002 is based on the InfoCube
0SBO_C22 SBO Profit Center Transaction Data
, so only the data from the SAP Business One system is retrieved. The report shows the account balance by the selected posting periods.
Filter
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|---|---|
0FISCYEAR |
Fiscal Year (Fiscal Year (Single Value Entry, Required) 0P_FYEAR) |
0VTYPE |
Value type (Value Type (Single Value Entry, Required) 0P_WTYP) |
0VERSION |
Version (Actual/Plan Version (Single Value Entry, Optional) 0P_VERSN) |
0CURTYPE |
Currency Type (Currency Type (Single-Value Entry, Mandatory) 0P_CURRT) |
Variables Used
Variable |
Description |
|---|---|
0P_CHAEX |
Chart of Accounts |
0P_COCD |
Company Code |
0P_FVAEX |
Fiscal Year Variant |
Rows
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|---|---|
0FISCPER3 |
Fiscal year/period |
0GL_ACCOUNT |
G/L Account |
Columns
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|---|---|
0DEBIT |
Total Debit Postings (hidden) |
0CREDIT |
Total Credit Postings (hidden) |
0BALANCE |
Cumulative Balance |