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 can only view one at a time on the map?Not an Apple product, have you visited: https://support.mozilla.org/en-US/kb/keyboard-shortcuts-perform-firefox-tasks-qu icklyRead other 2 answers [More]
Hello all, I am trying to figure out how to debug adapter module in PI 7.1. I guess runtime debugging ( switch AS java in debug mode and attach NWDS to the AS Java to debug as module is being executed) is not possible with adapter module. Please let [More]
When I raise PO with account assignment u2018 Ku2019 it ask cost center and pick the GL account automatically from OBYC table. But when I raise PO for service with item category u2018 D u2019 and account assignment u2018 k u2018 it picks different GL [More]
I am trying to create a form that would be emailed to one person, they would complete part of it, email it on to a second user who would then complete another part based on the input from the first, and then forward it onto a third for their input. t [More]
Can we change FTP Server Dynamically using Adapter Specific configurations if we can modify SourceFTPHost in the dynamic Configuration ?Hi No. I believe in a sender adapter, you can indeed add the message specific attibutes such as hostname to the me [More]
For video capture of webcams for sites with flash (youtube, livestream and etc) I use a driver and DirectShow filter. The user loads a page with flash and chooses a driver or filter from the camera list of flash's Parameters for video capture. My pro [More]
I'm strongly considering getting an Apple TV for use as an HTPC, and the biggest problem I've run into is that my TV only supports component as the highest resolution input. What is the best/least expensive way to convert it from HDMI/mini display to [More]
Anyone experienced Vista resetting during general use on the Ultra 24? Ultra 24 with 2GB RAM. Latest firmware installed from Tools and Drivers 1.1 DVD. Standard config with NVS290 graphics and not RAID configured. All Windows drivers came from the Su [More]
Hello all, The user performed the Balance carry forward  (F.16) but didn't close the 12th period of 2009. In January/2010 the original billing document is reversed (VF11) with Document date december/2009. This modified the 2009 balance sheet. How can [More]
Dear friends, We have a problem in our test system. One developer performed a transport which tried to change column from length 11 to 10 and after the transport, table is missing from database. We observed ABAP dumps DBIF_RSQL_SQL_ERROR with ORA-014 [More]