Query
MultiCube: Balance Sheet Reports 
Technical Name: 0SBO_MC21 _Q002
Use
The query 0SBO_MC21 _Q001 is based on the InfoCube 0SBO_MC21 SBO Integrated General Ledger Transaction Data, so both the data from the SAP Business One system and from the SAP R/3 system are 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) |
|
0GL_ACCOUNT |
G/L Account |
|
0FISCPER3 |
Fiscal Year/Period |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DEBIT |
Total Debit Postings |
|
0CREDIT |
Total Credit Postings |
|
0BALANCE |
Cumulated Balance |