cancel
Showing results for 
Search instead for 
Did you mean: 

Simple Question about BW reports p&l and balance sheet

Former Member
0 Kudos

I haev two reports Balance sheet and P&L both have the same fields AS below, i want to know what is the key field which i can make the variable for user to display balance sheet or P&L is that 0GLACCEXT financial statement can do that.Any hints will also be appreciated

Account Number

Company code

Business area

Joint Venture

Controlling area

Fiscal year/period

Currency

Transaction Type

Trading partner

Profit Center

Cost Center

Cost Element

Functional Area

Key Figures

Financial Statement

Account Segment

Chart of accounts

Company code

Currency Type

Comparative Fiscal year/ period

Fiscal Year Variant

Fiscal year/ period

Version

thanks

Regards

Soniya Kapoor

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

in order to give the user the choose P/L or Balance sheet. You can create a variable on OGLACCEXT using the hierarchy. The user can run the whole hierarchy for balance sheet, and just a net income node.

orelse you can add these two reports on portal on the same screen to choose which one the user would like to see, but actually it would two different reports in the backend.

Former Member
0 Kudos

Can u PLEASE clarify if 0GL_ACCT HAS two nav attribute which can be used as filter P&L Account and Balance sheet Account to distingush the between the p&l and BAl sheet

but now user want one field like "psbl" which will write on report either pl or bs

please tell how to make the field as free characteristic so that it will pop as pl or bs once user click on it .i will reward all points after this small help

thanks

soniya