Sitemap

Amicuk Programming Answers

Balance Sheet and Profit and Loss

-0001-11-30   Views:0

Advertisement

Dear experts, I've posted a thread just like this but I've closed it, because the info needed changed. Now I open this one so it will be easier to follow. I need to extract data from tables BKPF and BSEG. So I thought in extractor 0FI_GL_4. This mean

Dear experts,
I've posted a thread just like this but I've closed it, because the info needed changed. Now I open this one so it will be easier to follow.
I need to extract data from tables BKPF and BSEG. So I thought in extractor 0FI_GL_4. This means I need an ODS so I can use delta extraction. Rasim suggested ODS 0FIGL_O02. (Thanks for your quick answer)
Basically I need a few reports, Profit and loss, and Balance. This reports work with a structure that groups certain accounts to get the right value. How can I load this structure in BW? Or I need to create my own hierarchy?
Also, this reports in R3 are working with a special fiscal variant according to the client. What they need is to see this reports with fiscal variant K4. I thought to modify the update rules in BW so that the fiscal period gets filled according to the "Posting date in the document" (field BUDAT in R3).
Does anyone thinks this will work? Any other ideas?
Best Regards,
Rodrigo.

The replay answer
Advertisement
How can I know if there is a GL Account Hierarchy? - Ask ur functional guy - check 0GL_ACCOUNT_T011_HIER datasource in RSA3 if they have std hierarchies
Also I'd like know if with extractor 0FI_GL_4 I will be able to create a balance sheet with cumulated values and period values, and also create the profit and loss report. It will be enough with this extractor?  - if you are looking for cumulated balances - use 0FI_GL_6. check the link below for financial statements
http://help.sap.com/saphelp_bw33/helpdata/en/6e/ff703b3de59e4fe10000000a114084/frameset.htm
I want to fill fiscal period with posting document because in R3 the balance uses a fiscal variant different from k4, and they want to see it with k4. So I thought in filling the period with the posting document date.
The period is determined from posting date only - unless it is a special period - 13,14,15,16 - that has to be manually updated while creating a FI doc.So you can go ahead and map the posting period - to either fiscalyear/period or posting date. They both are one and the same.

Go to See the other 10 answers

Balance Sheet and Profit and Loss

Category:DefaultRelease time:-0001-11-30Views:130

Dear experts, I've posted a thread just like this but I've closed it, because the info needed changed. Now I open this one so it will be easier to follow. I need to extract data from tables BKPF and BSEG. So I thought in extractor 0FI_GL_4. This mean[More]

Profit Center wise balance sheet and Profit and Loss account

Category:DefaultRelease time:2015-10-11Views:130

Hi Experts, I will explain my scenario The is cleint having Head Office for handling procurement of goods for all branches(8) and the physical delivery happens for goods at the requested branch and GR and IR also makin at the branch level. And we are[More]

Plant wise Balance Sheet and Profit and Loss report generation

Category:DefaultRelease time:-0001-11-30Views:130

Hi, Can any one please give me the configuration steps for generating plant wise P&L stat and B/S. The client has a single  company code with 5 plants and wants to generate the statements  plant wise. Thank u, Regards, SP.Hi, I SAP we can draw the B/[More]

What are the data sources for 0FIGL_V10 cube Balance Sheet and Profit& Loss

Category:DefaultRelease time:2015-10-11Views:130

What are the data sources for 0FIGL_V10 (G/L (New): Balance Sheet and Profit and Loss) cube. and whether we can install business content regarding this. Please help me out. thanks, sapsdnhelpHi, Check this:------- Urgent: Relevant Master Data Data So[More]

Balance sheet and Profit & Loss reports

Category:DefaultRelease time:-0001-11-30Views:130

Hi all I need some help with the Balance sheet and Profit and Loss statement, I created new fields on both repors to hide the "ZAR" and round the amount fields to 2 decimal places. But when ever I print preview the report I get this error :- 23/[More]

Can we take Balance sheet and profit & Loss account as per plant & Sales

Category:DefaultRelease time:-0001-11-30Views:130

Hi Team, Can we take Balance sheet and profit & Loss account as per plant wise & sales office wise also. Regards JKMhi jkm Hi This can solve your issue could be helpful to you. Go to this menu path for report painter Accounting - Financial Account[More]

Balance Sheet and Profit Loss Account for Statutory Reporting

Category:DefaultRelease time:-0001-11-30Views:130

Hi, For a company which is based in Vietnam, it is required that Balance Sheet and Profit Loss Account is reported in the Local Language Vietnamese. Is it possible to make such setting using the Country Specific Chart of Accounts ? RegardsHi, This an[More]

Balance Sheet by Profit Center

Category:DefaultRelease time:2015-10-11Views:130

Hi Gurus, Just a clarification for the profit center balance sheet. Let say for example I purchase an item from vendor A for the profit center A. The profit center is then inherited from the expense line item. Debit    Expense      900               [More]

Balance Sheet in Profit Center

Category:DefaultRelease time:-0001-11-30Views:130

Hello All, How can you generate balance sheets for Profit Centers when the profit centers are linked to the sales order? so that whenever there is a sales order generated, the line items are all assigned to the profit centers. Thanks, Please respond[More]

Difference between business area balance sheet and profit centre accounting

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, I want to know what are the differences between business area balance sheet and profit centre accounting. Please tell the merits and demerits of both. If, I want to get plant-wise profitability of a company then which method is more recommend[More]

Balance sheet using profit center

Category:DefaultRelease time:-0001-11-30Views:130

My client require balance sheet using profit centers... I will activate document splitting which should be able to provide the same. The other requirement is that they have profit center division wise eg. manufacturing, refurbishment, etc How will pr[More]

Hot
I don't know how to get to the crash ID since I can't get into the Firefox window to go to 'help'. The crash report details: AdapterDeviceID: 0322 AdapterVendorID: 10de Add-ons: [email protected]:1.0,{972ce4c6-7e08-4474-a285-3208198ce6fd}:6.0.2 AvailableVi [More]
iTunes will open just fine, but when I click play on a song it won't play. The tracking icon won't move at all. I tried uninstalling and reinstalling itunes and the problem still stands. It started when I upgraded to the latest version of iTunes. Als [More]
Dear Experts. Is there any standard way out to get a report where we can find the approver's name with the employee name. I want a report where i can find all the employee name with his approvers name, which is assigned in org.structure( reports line [More]
Friends I have the following SQL statement: SELECT a.acct, a.date_field, UPPER(b.feegroup) feegrp, SUM (a.fee1) fee1, SUM (a.fee2) fee2, SUM (a.fee3) fee3 FROM table1 a, table2 b WHERE 1 = 1 AND a.fee_id = b.fee_id GROUP BY a.acct, a.date_field, b.fe [More]
Dear experts, I have a file to RFC scenario. I imported the RFC and create files exactly according to the RFC structure, so I don't use a mapping. When I create a file, it provides the following error in the adapter log: <i>Exception caught by adapt [More]
I'm trying to install the Java Enterprise System (java_es_05Q1-windows-x86) to a Win 2k workstation. I get the following error msg: "system doesn't have Fully Qualified Domain Name. Setup Fully Qualified Domain Name and then continue installation&quo [More]
Hi, When I am saving some changes in my chart of depreciation, I receive an error for two areas 60 and 64. "Depreciation area 64 posts to ledger group L6 with leading ledger Message no. ACC_AA030 Diagnosis The non-leading depreciation area 64 is assi [More]
  Easy printing the test reports with the Front panel as per the A4 Standard. For making the A4 Standard printing needs the option to make Pane A4 Size. Then we can make easily create the front panel reports easy manner, add Indicator (result ,title, [More]
I'm now in a situation to make a choise how we want to design our UUT. There are 2 situation in which I think of. - use a popup in a sequence as a UUT. - Build a UUT in labview which then calls the teststand API like the teststand operator interface [More]
Hi I have the iMac with iLife08 (iPhoto08) Is there an easy way to print my creation (e.g. Postcard) on my own printer rather than sending the request to Apple to print? Much appreciated.Welcome to the Apple Discussions. Close iPhoto, delete the iPho [More]