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'd be grateful if someone could confirm a problem I am seeing in using the new erodible dry media brushes in CS6.  The problem is that the boundaries of an image re-created with the Pattern Stamp Tool and a new dry media brush, say the Square Charco [More]
Not sure where to post this, but I'm wondering where I can purchase the Sims 2 Holiday Pack for Mac online, and have it available as a digital download? Seems like I have t o have it shipped, but I'd rather just download it.I finally got the solution [More]
Hi to all! I installed the latest version of Firefox and my browsing started being very slow and a lot of error connections and loading troubles occured. I have already tried the "Restart with Add-ons Disabled" mode and also the "Troublesho [More]
I read that Lightroom uses the large ProPhoto color Space and then again, that it's gamma curve ist close to sRGB. So what is my color space when working in Lightroom? ProPhoto, or sRGb, or something else? And what kind of a color management workflow [More]
how do you program page down page up in step loopsHi STEP LOOPS Step Loops are type of screen table . Step loops are repeated blocks of field in a screen. Each block contains one or more fields and these blocks are repeated. Step loops aren’t like ac [More]
I'm trying to load pre-2006 lso files into Logic 8 on my new intel Mac Pro, but they crash the app every time. files saved 2006 and later load OK. Anybody shed any light on this or know of a fix (other than the laborious work-around of re-saving all [More]
Page size defaults to "letter" size on switch-on and doesn't "remember" being set to A4. Memory/battery problem? Any help on disassembly welcomed Thanks DaveThat printer looks like it would have a battery that powers the memory in it. [More]
My ipod charges fine, but it all of a sudden just stopped telling me when it was charging, i plug it in and the screen turns itself off instead of changing to the screen that has the picture of the battery and how full it is, it also does not show up [More]
hello everybody, i read about FlowLayout,BorderLayout,GridLayout,BoxLayout,CardLayout and GridBagLayout,but i still have a problem in aligning the components. I want to desgin a Wizard Frame like in this Following Website: http://java.sun.com/product [More]
It's only just started doing this today, after I installed the updates that came with Mavericks. I have been using this feature for 5 years to email receipts to clients... Please tell me that this isn't an ongoing problem! I hit command-P to print, t [More]