10-10-2007 5:52 AM
HI Experts,
I need to know the full flow of SD & FI with respective tables & T-Codes. Kindly help me. Thakns.
Khan
10-10-2007 5:54 AM
Hi,
SD FLOW
SD Flow Cycle and T Codes:
INQUIRY ( VA11)
|
QUOTATION (VA21)
|
PURCHASE ORDER (ME21)
|
ORDER CONFIRMATION (VA01)
|
PICKING LIST (VL36)
|
PACKING LIST - (VL02, VL01)
|
SHIPPING (VT01)
|
INVOICE (VF21, VF01)
|
AR
Explantion with relavent tables:
Enquiry - Customer enquires about the Products services that were sold by a company - VA11
Quotation - Company Gives a Quotation for the products and Services to a Customer
Sales Order - Customer gives a Purchase order to the company agaionst which a Sales order will be raised to Customer in SAP.
VBAK: Sales Document(Header Data) (VBELN)
VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)
Enquiry, Quotation, Sales Order are differentiated based on Doc.
Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,
for Quotation 'B' & for Order it is 'C'.)
Delivery(Picking, Packing, Post Goods Issue and Shipment)->
Company sends the material after picking it from Godown and Packing it in a Handling Unit(box) and Issues the goods
LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)
LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)
(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)
Billing - Also company bills to the customer for those deliveries
And in FI against this billing Accounting doc is created.
VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)
VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)
(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)
Apart from these tables there are lot of other tables which starts with
V, but we use the following tables frequently.
Links for sd:
http://www.sapgenie.com/abap/tables_sd.htm
Please check this SD online documents.
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCSD/CAARCSD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_SD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMSD/BCBMTWFMSD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLISPLN/LOLISPLN.pdf
Also please check this SD links as well.
http://help.sap.com/saphelp_47x200/helpdata/en/92/df293581dc1f79e10000009b38f889/frameset.htm
http://help.sap.com/saphelp_erp2005/helpdata/en/dd/55f33e545a11d1a7020000e829fd11/frameset.htm
http://www.sap-basis-abap.com/sapsd.htm
http://www.sap-img.com/sap-sd.htm
http://www.sapgenie.com/abap/tables_sd.htm
http://searchsap.techtarget.com/featuredTopic/0,290042,sid21_gci961718,00.html
http://www.sapbrain.com/TUTORIALS/FUNCTIONAL/SD_tutorial.html
All help ebooks are in PDF format here
http://www.easymarketplace.de/online-pdfs.php
see this link
http://www.sap-basis-abap.com/sd/sap-sd-processing-flow.htm
<b>FI FLOW :</b>
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.
thanks.
10-10-2007 5:54 AM
Hi,
Check this.
1)
Customer is asking for some product..For that create a sales order using the VA01...Tables used VBAK, VBAP, VBEP, VBUK, VBUP, VBKD...
2)
Then creating a delivery for the sales order..using the transaction VL01N..
Tables used LIKP, LIPS..
3)
The pick the quantity and post the goods issue using the transaction VL02N..
Tables used LIKP, LIPS,MKPF & MSEG.
4)
creating an invoice for the delivery..using the transaction VF01.
Tables used VBRK, VBRP.
5) When the billing document is created..the accounting document is created ..The tables used are BKPF, BSEG, BSID..
Thanks
Naren
10-10-2007 5:54 AM
Hi,
SD FLOW
SD Flow Cycle and T Codes:
INQUIRY ( VA11)
|
QUOTATION (VA21)
|
PURCHASE ORDER (ME21)
|
ORDER CONFIRMATION (VA01)
|
PICKING LIST (VL36)
|
PACKING LIST - (VL02, VL01)
|
SHIPPING (VT01)
|
INVOICE (VF21, VF01)
|
AR
Explantion with relavent tables:
Enquiry - Customer enquires about the Products services that were sold by a company - VA11
Quotation - Company Gives a Quotation for the products and Services to a Customer
Sales Order - Customer gives a Purchase order to the company agaionst which a Sales order will be raised to Customer in SAP.
VBAK: Sales Document(Header Data) (VBELN)
VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)
Enquiry, Quotation, Sales Order are differentiated based on Doc.
Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,
for Quotation 'B' & for Order it is 'C'.)
Delivery(Picking, Packing, Post Goods Issue and Shipment)->
Company sends the material after picking it from Godown and Packing it in a Handling Unit(box) and Issues the goods
LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)
LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)
(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)
Billing - Also company bills to the customer for those deliveries
And in FI against this billing Accounting doc is created.
VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)
VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)
(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)
Apart from these tables there are lot of other tables which starts with
V, but we use the following tables frequently.
Links for sd:
http://www.sapgenie.com/abap/tables_sd.htm
Please check this SD online documents.
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCSD/CAARCSD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_SD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMSD/BCBMTWFMSD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLISPLN/LOLISPLN.pdf
Also please check this SD links as well.
http://help.sap.com/saphelp_47x200/helpdata/en/92/df293581dc1f79e10000009b38f889/frameset.htm
http://help.sap.com/saphelp_erp2005/helpdata/en/dd/55f33e545a11d1a7020000e829fd11/frameset.htm
http://www.sap-basis-abap.com/sapsd.htm
http://www.sap-img.com/sap-sd.htm
http://www.sapgenie.com/abap/tables_sd.htm
http://searchsap.techtarget.com/featuredTopic/0,290042,sid21_gci961718,00.html
http://www.sapbrain.com/TUTORIALS/FUNCTIONAL/SD_tutorial.html
All help ebooks are in PDF format here
http://www.easymarketplace.de/online-pdfs.php
see this link
http://www.sap-basis-abap.com/sd/sap-sd-processing-flow.htm
<b>FI FLOW :</b>
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.
thanks.
10-10-2007 5:56 AM
<b>5 FI/CO :
5.1 FI :
5.1.1 Master data</b>
SKA1 Accounts
BNKA Bank master record
<b>5.1.2 Accounting documents // indices</b>
BKPF Accounting documents
BSEG item level
BSID Accounting: Secondary index for customers
BSIK Accounting: Secondary index for vendors
BSIM Secondary Index, Documents for Material
BSIP Index for vendor validation of double documents
BSIS Accounting: Secondary index for G/L accounts
BSAD Accounting: Index for customers (cleared items)
BSAK Accounting: Index for vendors (cleared items)
BSAS Accounting: Index for G/L accounts (cleared items)
<b>5.1.3 Payment run</b>
REGUH Settlement data from payment program
REGUP Processed items from payment program
<b>5.2 CO :</b>
TKA01 Controlling areas
TKA02 Controlling area assignment
KEKO Product-costing header
KEPH Cost components for cost of goods manuf.
KALO Costing objects
KANZ Sales order items - costing objects
<b>5.2.1 Cost center master data</b>
CSKS Cost Center Master Data
CSKT Cost center texts
CRCO Assignment of Work Center to Cost Center
<b>5.2.2 Cost center accounting</b>
COSP CO Object: Cost Totals for External Postings
COEP CO Object: Line Items (by Period)
. COBK CO Object: Document header
COST CO Object: Price Totals
<b>
6 Sales and Distribution (SD) :</b>
VBFA Document flow (alg.)
VTFA Flow shipping documents
<b>6.1 Sales order :</b>
VBAK Header data
VBAP Item data
VBPA Partners in sales order
VBKD Sales district data
VBEP Data related to line items, delivery lines
<b>6.2 Billing document :</b>
VBRK header data
VBRP Item data
<b>6.3 Shipping :</b>
VTTK Shipment header
VTTP Shipment item
VTTS Stage in transport
VTSP Stage in transport per shipment item
VTPA Shipment partners
VEKP Handling Unit - Header Table
VEPO Packing: Handling Unit Item (Contents)
<b>6.4 Delivery :</b>
LIKP Delivery header
LIPS Delivery item
<b>6.5 Pricing :</b>
KONH Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order)
KOND
<b>6.6 contracts :</b>
VEDA Contract data
10-10-2007 5:56 AM
Hi
See the fi Flow
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
http://www.thespot4sap.com/IntroTo/SAP_FI_Module_Introduction.asp
http://www.thespot4sap.com/IntroTo/SAP_CO_Module_Introduction.asp
for tables check out link..
http://www.sapgenie.com/abap/tables_fi.htm
Take a look at this.
http://www.sap-img.com/sap-fi.htm
http://www.erpgenie.com/sapfunc/fi.htm
http://www.sap-img.com/index.htm
http://www.amazon.com/Configuring-SAP-Essential-Financial-Controlling/dp/0782125972
SD
SD FLOW
SD Flow Cycle and T Codes:
INQUIRY ( VA11)
|
QUOTATION (VA21)
|
PURCHASE ORDER (ME21)
|
ORDER CONFIRMATION (VA01)
|
PICKING LIST (VL36)
|
PACKING LIST - (VL02, VL01)
|
SHIPPING (VT01)
|
INVOICE (VF21, VF01)
|
AR
Explantion with relavent tables:
Enquiry - Customer enquires about the Products services that were sold by a company - VA11
Quotation - Company Gives a Quotation for the products and Services to a Customer
Sales Order - Customer gives a Purchase order to the company agaionst which a Sales order will be raised to Customer in SAP.
VBAK: Sales Document(Header Data) (VBELN)
VBAP: Sales Document(Item Data) (VBELN,POSNR,MATNR,ARKTX,CHARG)
Enquiry, Quotation, Sales Order are differentiated based on Doc.
Type(VBTYP field) in VBAK,VBAP Tables( for Enquiry VBTYP = A,
for Quotation 'B' & for Order it is 'C'.)
Delivery(Picking, Packing, Post Goods Issue and Shipment)->
Company sends the material after picking it from Godown and Packing it in a Handling Unit(box) and Issues the goods
LIKP: Delivery Table (Header Data)(VBELN,LFART,KUNNR,WADAT,INCO1)
LIPS: Delivery Table (Item Data)(VBELN,POSNR,WERKS,LGORT,MATNR,VGBEL)
(LIPS-VGBEL = VBAK-VBELN, LIPS-VGPOS = VBAP-POSNR)
Billing - Also company bills to the customer for those deliveries
And in FI against this billing Accounting doc is created.
VBRK: Billing Table(Header Data)(VBELN,FKART,BELNR)
VBRP: Billing Table(Item Data)(VBELN,POSNR,FKIMG,NETWR,VGBEL,VGPOS)
(VBRP-AUBEL = VBAK-VBELN, VBRP-VGBEL = LIKP-VBELN)
Apart from these tables there are lot of other tables which starts with
V, but we use the following tables frequently.
Links for sd:
http://www.sapgenie.com/abap/tables_sd.htm
Please check this SD online documents.
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/CAARCSD/CAARCSD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/MYSAP/SR_SD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMSD/BCBMTWFMSD.pdf
http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLISPLN/LOLISPLN.pdf
Also please check this SD links as well.
http://help.sap.com/saphelp_47x200/helpdata/en/92/df293581dc1f79e10000009b38f889/frameset.htm
http://help.sap.com/saphelp_erp2005/helpdata/en/dd/55f33e545a11d1a7020000e829fd11/frameset.htm
http://www.sap-basis-abap.com/sapsd.htm
http://www.sap-img.com/sap-sd.htm
http://www.sapgenie.com/abap/tables_sd.htm
http://searchsap.techtarget.com/featuredTopic/0,290042,sid21_gci961718,00.html
http://www.sapbrain.com/TUTORIALS/FUNCTIONAL/SD_tutorial.html
All help ebooks are in PDF format here
http://www.easymarketplace.de/online-pdfs.php
Regards
Anji