Query
MultiCube: Profit and Loss Statements 
Technical Name: 0SBO_MC21 _Q001
Use
The query 0SBO_MC21 _Q001 is based on the MultiCube 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) |
|
OGL_ACCOUNT__0INCST_FLAG |
Ind: Balance Sheet Account (Value Type (Single Value Entry, Required)) |
|
OGL_ACCOUNT__0BAL_FLAG |
Ind: Balance Sheet Account (X / I / E) |
|
0P_FVAEX |
Fiscal Year Variant (Fiscal Year Variant (SAP exit) - 0P_FVAEX) |
Free Characteristics
|
InfoObject |
Description |
|
0FISCPER |
Fiscal Year/Period |
Variables Used
|
Variable |
Description |
|
0P_CHAEX |
Chart of Accounts |
|
0P_COCD |
Company Code |
|
0FISCYEAR |
Fiscal Year (Fiscal Year (Single Value Entry, Required) 0P_FYEAR) |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0GL_ACCOUNT |
G/L Account |
Columns
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0DEBIT |
Total Debit Postings |
|
0CREDIT |
Total Credit Postings |