Re: fi module

Former Member · ‎2008 Feb 27

hai sir

so far i didt do on fi module.i want to try on fi module.

what i need to learn to face interview which is regarding fi module.

Former Member · ‎2008 Feb 27

hai sir

can we use for all entries and inner join in one program. plz say immedaitely

Former Member · ‎2008 Feb 27

Hi,

can we use for all entries and inner join in one program. plz say immedaitely

No we can't use both.

JOIN is the SQL statement in which the tables on which queried are internally joined. FOR ALL ENTRIES,You first get the details in one internal table based on that you query another DB table.

INNER JOIN - This is used to join two different DATABASE tables.

FOR ALL ENTRIES - This is used to avoid the SELECT inside a loop. Usually if we want the child details for all the header records of a internal table then you loop at the header table and fire the SELECT. We can avoid the SELECT inside the looop using the FOR ALL ENTRIES clause.

Check these links

http://www.thespot4sap.com/articles/SAPABAPPerformanceTuning_ForAllEntries.asp

http://www.thespot4sap.com/articles/SAPABAPPerformanceTuning_InnerJoinStatement.asp

http://www.sswug.org/see/28439

http://web.mit.edu/ist/org/admincomputing/dev/abap_review_check_list.htm

http://www.sapgenie.com/abap/performance.htm

Regards,

Priyanka.

Former Member · ‎2008 Feb 27

HI,

Regarding FI.

Basically there are 5 major topics/areas in FI,

1. GL Accounting -

related tables are SKA1, SKB1 Master data

BSIS and BSAS are the Transaction Data

2. Account Receivables- related to Customer

All the SD related data when transfered to FI these are created.

Related Tables BSID and BSAD

3. Account Payables - related Vendor

All the MM related documents data when transfered to FI these are created

Related Tables BSIK and BSAK

All the above six tables data is present in BKPF and BSEG tables

You can link these tables with the hlp of BELNR and GJAHR and with Dates also.

4. Special Purpose Ledger.. which is rarely used.

5. Asset Managment

In CO there are

Profit center Accounting

Cost center Accounting will be there.

Cross-Application Components -> Financial.

http://help.sap.com/saphelp_470/helpdata/en/e1/8e51341a06084de10000009b38f83b/frameset.htm

you will go through this link

http://www.sapgenie.com/sapfunc/fi.htm

Check this Link it out

http://www.sap-img.com/sap-download/sap-tables.zip

FI-CO

http://www.sapbrain.com/TUTORIALS/FUNCTIONAL/FI_tutorial.html

http://www.sapbrain.com/TUTORIALS/FUNCTIONAL/CO_tutorial.html

Check this flow:

http://www.erpgenie.com/abap/tables_fi.htm

http://www.sap-img.com/financial/document-flow-confusion-in-sap-fi.htm

http://www.sap-img.com/financial/sap-fi-technical-interview-questions-2.htm

FI FLOW :

1. Creation of customer account group - OBD2

2. Create no ranges - XDN1

3. assign no range to customer group - OBAR

4. Create GL accounts - FS00

5. Create customer master record - XD01 / XD02(change) / XD03 (Display)

6. Documnet tyoe and no range - OBA7

7. Sales Invoice - F-22

8. Customer receipt (Incoming pmt) - F-28

9. Credit Memo - F-27

10. View customer balance - FD10N

11. Clear AR - F-32

Data flow can happen in finance module from many quarters in SAP and non SAP system depending upon the landscape of the ERP system implemented. I am giving below the general overview of data flow.

The Financial Accounting (FI) application component fulfills all the international requirements that must be met by the financial accounting department of an organization. It provides the following features:

Management and representation of all accounting data

All business transactions are recorded according to the document principle, which provides an unbroken audit trail from the financial statements to the individual documents.

Open and integrated data flow

Data flow between Financial Accounting and the other components of the SAP System is ensured by automatic updates.

Data is available in real time within Financial Accounting. Postings made in the subledgers always generate a corresponding posting in the general ledger.

Preparation of operational information to assist strategic decision-making within the organization

Integration:Integration of Financial Accounting with other components

All accounting-relevant transactions made in Logistics (LO) or Human Resources (HR) components are posted real-time to Financial Accounting by means of automatic account determination. This data can also be passed on to Controlling (CO).

This ensures that logistical goods movements (such as goods receipts and goods issues) are exactly reflected in the value-based updates in accounting.

Integration within Financial Accounting

Every posting that is made in the subledgers generates a corresponding posting to the assigned G/L accounts. This ensures that the subledgers are always reconciled with the general ledger.

Features: The Financial Accounting application component comprises the following sub-components:

General Ledger (FI-GL)

Accounts Payable (FI-AP)

Accounts Receivable (FI-AR)

Bank Accounting (FI-BL)

Asset Accounting (FI-AA)

Funds Management (FI-FM)

Travel Management (FI-TV)

Special Purpose Ledger (FI-SL)

Hope I had been able to provide help to you. please reward points and let me know if you need anything in specific.

The dataflow as functional process below are the points:

1) Purchasing Requsition -> sent by inventory dept to purcharsing dept

2) Request for Quotation(RFQ)-> Purchasing Dept shall ask the vendors to give the quotation for the requested materials by inventory.

3) Quotation -> Quotation is sent by vendors to the company

4) Purchase order-> Based on all paramers of a quotation sent by vendors. Vendors are selected from whom the material has to be obtained. The company gives purchase order to the vendor.

5) Good's receipt -> vendors sends the goods to the company with goods receipt

6) Invoice verification -> this done based on good's receipt. this means that the ordered goods have reached or not.

7) Payment -> payment is done based on invoice verification. this is (FI/CO)

FI Flow