Query
SBO: Profit and Loss Statements 
Technical Name: 0SBO_C21 _Q001
Use
The query 0SBO_C21 _Q001 is based on the InfoCube 0SBO_C21 SBO General Ledger Transaction Data, so only the data from the SAP Business One system is retrieved. The report shows the profit and loss statement by the selected posting periods.
Filter
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0CHRT_ACCTS |
Chart of Accounts (Chart of accounts (SAP-Exit) 0P_CHAEX) |
|
0FISCVARNT |
Fiscal Year Variant (Fiscal year variant (SAP exit) 0P_FVAEX) |
|
OGL_ACCOUNT__0INCST_FLAG |
Ind.: Bal.Sheet Acct (Restricted type: =’I’;’E’) |
Free Characteristics
|
InfoObject |
Description |
|
0FISCPER |
Fiscal year/period |
Variables Used
|
Variable |
Description |
|
0CMPCODE |
Company Code (Single Value Entry, Optional) |
|
0P_FYEAR |
Fiscal Year (Single Value Entry, Required) (*) |
Rows
|
InfoObject |
Description of the InfoObject (and restriction or calculation formula) |
|
0GL_ACCOUNT__0INCST_FLAG |
Ind.: Bal.Sheet Acct (E/I) |
|
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) |
|
0SBO_C21_CK002 |
Revenues |
|
0SBO_C21_CK001 |
Expenses |