Cash flow statement via direct method using BW/BI

depends on your format of cash flow. You have to obtain a cash flow format and work accordingly to include the relevant GL accounts. I have given a sample format.

Operating Profit before Depreciation
.
Add (Less): Decrease / (Increase) in Working Capital
.
(Increase) / Decrease in Debtors
(Increase) / Decrease in Inventory
(Increase) / Decrease in Loans & Advances
Increase / (Decrease) in Creditors & Provisions
.
Less: (Capital Expenditure)
.
Net Cash generated from operations
.
Add: Opening Balance of Cash & Cash Equivalents
Less: Closing Balance of Cash & Cash Equivalents.

The BI Business Content for the application Accounting for Financial Instruments contains a process that can be used to display and merge the data from the Bank Analyzer subledger and general ledger. This enables you to meet the requirements of IFRS, country-specific reporting requirements, and your bank's own reporting requirements regarding financial instruments.


SD flow basically has ORDER TO CASH flow

Customer comes to Business for Inquiry of a material with cost and Delivery & Payment terms
Business will raise a Quotation with reference to Inquiry and send to Business, if customer agrees then ,
Customer Places a Purchase order ( which is an external document like phone call or fax) for some material to the company and we will generate an order against the Purchase order
Delivers the goods to the customer
Bills the customer

The Amount will be posted to respective GL accounts

This is the Main flow and in between there are many integrations with other Modules like MM, FI, PP
So first get familiarize with the SD stuff and then you can learn the Integration.

You have to know the functionality of each field , then it will be easy to understand the End to End flow.

load master data of SD, MM , HR and FI-CO from R/3

Step 1: Activate the Master Data Data Source in R/3 using RSA5 transaction.
Step 2: Replicate the Data Source to BI.
Step 3: Craete Transformation using the above data source.(Before this step make sure that your InfoObject is in the InfoProvider menu as a data target. If not make this. To do this go to the InfoArea under which you wnated this InfoObject, Right Click and Insert Characteristic as InfoProvider)
Step 5: Create DTP.
Step 6: Create InfoPackage and load the data upto PSA.
Step 7: Then run the DTP and load to the InfoObject.

Then activating and attribute change run are commonly...

SD Data Sources:

Document Header: 2LIS_11_VAHDR

Document Item: 2LIS_11_VAITM

Document Condition: 2LIS_11_VAKON

Document Schedule Line: 2LIS_11_VASCL

Document Item Allocation: 2LIS_11_V_ITM

Allocation Schedule Line: 2LIS_11_SCL

Order Delivery: 2LIS_11_SSL.

MM Data Sources:

Goods Movements: 2LIS_03_BF

Stock Revaulations: 2LIS_03_UM.

The preconfigured Financial Data Mart scenario contains the following objects:

• Extractors

  Transfer of aggregated transaction data from the Analytics Layer of the Bank Analyzer subledger

• Preconfigured data model that contains the following objects:

  • Three DataStore objects

    Extraction targets for the data from the Bank Analyzer subledger and general ledger

  • Six InfoCubes

    Balance sheet, income statement, ERP GL, Financial Data Mart, and three virtual providers

  • Process chains

  • Queries

    Balance sheet, income statement, and notes

The data from the Bank Analyzer subledger adn general ledger are reconciled using a rule-based logic defined in the transformations. This ensures that the level of detail used in the subledger is retained, and that none of the amounts that exist in both sources are duplicated in reporting.