Skip to Content
author's profile photo Former Member
Former Member

SD, MM & FI Flow

HI All,

Can any one let me know about the integration of SD , MM & FI modules in detail with the flow.

Thanks in Advance.

Khan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 12:22 PM

    Hi Khan,

    SALES & DISTRIBUTION MODULE RELATED TABLES:

    Cycle:

    Enquiry->Quotation->Sales Order->Delivery(Picking, Packing, Post Goods

    Issue and Shipment)->Billing-> Data to FI

    TABLES and Important Fields:

    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'.)

    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)

    VTTK: Shipment Table (Header Data)(TKNUM)

    VTTP: Shipment Table (Item Data)( TKNUM,TPNUM,VBELN)

    (VTTP-VBELN = LIKP-VBELN)

    VTFA: Shipping Document Flow(TKNUM,VBELV,VBELN)

    VTPA: Shipping Partners data(VBELN,PARVW,KUNNR,PERNR)

    VTTS: Stages in Shipment(TKNUM,TSNUM,TSTYP)

    VTSP: Transport Stage/Shipment Item Allocation(TKNUM,TSNUM,TPNUM)

    VEKP: Handling Unit: Header(Packing)(VENUM,VSTEL)

    VEPO: Handling Unit: Item (Packing)(VENUM,VEPOS,VBELN)

    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.

    VBUK: All Sales Documents status & Admn. Data(Header)(VBELN,VBTYP)

    VBTYP= ‘C’(Sales Order) VBTYP=’J’(Delivery) VBTYP=’M’(Invoice)

    VBUP: Sales Documents status & Admn. Data(Item)(VBELN,POSNR)

    VBEP: Sales Doc. Schedule Lines Data(VBELN,POSNR,EDATU,WMENG)

    VBKD: To get sales related Business data like Payment terms etc.(VBELN,ZTERM)

    VBFA: sales document flow data(VBELV,VBELN,POSNV,VBTYP)

    VBPA: Partner functions Data(VBELN,PARVW,KUNNR,LIFNR)

    VEDA: Contract Data(VBELN,VPOSN)

    VEDAPO: Contract Data(VBELN,VPOSN)

    KONA: Rebate Agreements (KNUMA,VKORG,VTWEG,SPART)

    VBRL: SD Document: Invoice List(VBELN,POSNR,VBELN_VF,NETWR,KUNAG)

    VKDFS: SD Index: Billing Indicator(FKTYP,VBELN,FKART,VKORG)

    VBSK: Collective Processing for a Sales Document Header(SAMMG,SMART)

    VBSS: Collective Processing: Sales Documents(SAMMG,VBELN,SORTF)

    VRKPA: Sales Index: Bills by Partner Functions(VBELN,BELNR,KUNDE,PARVW)

    VRPMA: SD Index: Billing Items per Material(MATNR,VBELN,BELNR,KUNNR)

    TVLKT: Delivery Type: Texts(LFART,VTEXT)

    KNA1: Customer Master-General(KUNNR,NAME1,LAND1)

    KNB1: Customer Master(Company Code)(KUNNR,BUKRS,PERNR)

    KNC1: Customer Master Data (Transaction Figures)(KUNNR,BUKRS,GJAHR)

    KNVK: Customer Master Contact Partner(PARNR,KUNNR,NAME1)

    KNVV: Customer Master sales data(KUNNR,VKORG,VTWEG,KDGRP)

    KNBK: Customer Bank Details(KUNNR,BANKS,BANKL,BANKN)

    KNVH: Customer Hierarchy (HITYP,KUNNR,VKORG,VTWEG,SPART)

    KNVP: Customer Master Partner Functions(KUNNR,PARVW,KUNN2)

    KNVS: Customer Shipment data(KUNNR,VSTEL,TRANS)

    KNVI: Customer Tax data(KUNNR,ALAND,TATYP)

    LFA1: Vendor Master-General (LIFNR,NAME1,ORT01)

    LFB1: Vendor Master(Company Code)(LIFNR,BUKRS,PERNR)

    LFC1: Vendor Master (Transaction Figures)(LIFNR,BUKRS,GJAHR)

    MARA: Material Master-General (MATNR,MTART,MATKL)

    MARC: Material Master-Plant data(MATNR,WERKS,EKGRP)

    MARD: Material Master- St.Location Data(MATNR,WERKS,LGORT,LABST)

    EBEW: Sales Order Stock Valuation(MATNR,VBELN,BWKEY,BWTAR)

    TVKO: Sales Organizations(VKORG)

    TVTW: Distribution Channel(VTWEG)

    TSPA: Divisions(SPART)

    TVKOV: Distribution Channels for S.Orgn(VKORG,VTWEG)

    TVKOS: Divisions for S.Orgn(VKORG,SPART)

    TVTA: Sales Areas(VKORG,VTWEG,SPART)

    TVBUR: Sales Offices(VKBUR,ADRNR)

    TVKBT: Sales Office Texts(VKBUR,SPRAS,BEZEI)

    TVKBZ: Sales Office Assign.to Sales Area(VKORG,VTWEG,VKBUR)

    TVKGR: Sales Group(VKGRP)

    TVGRT: Sales Group Texts(VKGRP,SPRAS,BEZEI)

    TVBVK: Sales Group to Sales office(VKBUR,VKGRP)

    TVKWZ: Plants Assign.to S.Orgn(WERKS,VKORG)

    T171T: Sales District Texts(BZIRK,BZTXT,SPRAS)

    TVLA: Loading Points(LSTEL)

    TVST: Shipping Points (VSTEL)

    TVSWZ: Shipping Point to Plant(VSTEL,WERKS)

    TVPT: Item Categories (PSTYV)

    TINC: Customer Incoterms(INCO1)

    T077D: Customer Account Group (KTOKD)

    T001W: Plants (WERKS)

    T001L: Storage Locations (LGORT)

    T499S: Locations(WERKS,STAND,KTEXT)

    TWLAD: To get address of Storage Location and Plant(LGORT,ADRNR)

    TVAK: Sales Document (Order) Types (AUART)

    TVAU: Sales Documents: Order Reasons (AUGRU)

    TVFK: Billing Document Types (FKART)

    TVLK: Delivery Types(LFART)

    TVSB: Shipping Conditions (VSBED)

    TTDS: Transportation Points(TPLST)

    TVKT: Account Assignment Groups (KTGRD)

    KONV: Condition Types pricing)(KNUMV,KSCHL,KWETR)

    ADRC: To get Addresses of Partners(ADDRNUMBER,NAME1)

    VBBE: Sales Requirements: Individual records(VBELN,POSNR,MATNR)

    VBBS: Sales Requirement totals Record(MATNR,WERKS,LGORT,CHARG)

    VBKA: Sales Activities Data(VBELN,KTAAR)

    VBPV: Sales Document Product Proposal(VTWEG,MATNR,KUNNR,CHARG)

    T682: Access Sequences (KOZGF)

    T682T: Access Sequence Texts (KOZGF,VTXTM)

    T683: Pricing Procedures (KALSM)

    T683T: Pricing Procedures Texts(KALSM,KAPPL,SPRAS,VTEXT)

    T685: Pricing Condition Types (KSCHL)

    T685T: Condition Type Texts(KSCHL,SPRAS,KAPPL,VTEXT)

    KONH: Conditions (Header)(KNUMH,KAPPL,KSCHL)

    KONP: Conditions (Item)(KNUMH,KOPOS,KAPPL,KSCHL)

    KONV: Conditions (Transaction Data)(KNUMV,KSCHL,KBERT,KWERT)

    KOND: Conditions (KNUMD,ZUSKO,KSCHL)

    MATERIAL MANAGEMENT MODULE:

    Cycle:

    Purchase Requisition->Request for Quotation(RFQ)->(Vendor Evaluation)->Purchase Order(PO)->Goods Receipt Note(GRN)->Invoice Verification->Data to FI

    TABLES and Important Fields:

    LFA1--Vendor Master-General (LIFNR,NAME1,ORT01)

    LFB1--Vendor Master(Company Code)(LIFNR,BUKRS,PERNR)

    LFC1--Vendor Master (Transaction Figures)(LIFNR,BUKRS,GJAHR)

    LFM1—-Pur.Orgn. Related Vendor Data (LIFNR,EKORG)

    MARA--Material Master-General (MATNR,MTART,MATKL)

    MARC--Material Master-Plant data(MATNR,WERKS,EKGRP)

    MARD--Material Master- St.Location Data(MATNR,WERKS,LGORT,LABST)

    MAKT--Material Descriptions(MATNR,MATKL,MAKTX)

    MBEW--Material Valuation Data(MATNR,BWTAR)

    MVKE—-Material Master: Sales related Data(MATNR,VKORG,VTWEG)

    MDKP--MRP related data(Header)(DTART,MATNR,PLWRK,PLSCN)

    MDTB—-MRP Table(DTNAM,DTPOS,PLANR)

    MCHA--Batches (MATNR,WERKS,CHARG)

    MCHB—-Batch Stocks(MATNR,WERKS,LGORT,CHARG)

    EBAN-- Pur.Reqn. Data (BANFN,BNFPO,BADAT,MATNR)

    EBKN-- Purchase Requisition Account Assignment(BANFN,BNFPO,VBELN)

    EINA—- Purchase Info.Record (General Data)(INFNR,MATNR,LIFNR)

    EINE-- Purchase Info.Record (Pur.Orgn Data )(INFNR,EKORG)

    ELBK-- Vendor Evaluation Header Data(LIFNR,EKORG,KLASS)

    ELBM-- Vendor Evaluation: Material-Related Item(LIFNR,MATNR,EKORG,INFNR,HKRIT)

    ELBP—- Main Criteria for Vendor Evaluation (LIFNR,EKORG,HKRIT)

    EKKO-- Purchase Order Data (Header)(EBELN,BSTYP,BSART)

    EKPO-- Purchase Order Data (Item)(EBELN,EBELP,MATNR)

    RFQ and PO are differentiated by Doc Type(BSTYP)in EKKO table.

    For RFQ it is ‘A’ and for PO it is ‘F’.

    MKPF-- GRN Data (Header) (EBELN,BLDAT,BUDAT,XBLNR,BKTXT)

    MSEG-- GRN Data (Item)(MBLNR,BWART,LIFNR,MATNR,EBELN)

    Apart from this there are lot of tables which begin with 'M'& 'E', but we

    use the following very often.

    EQUK--Quota(header) (QUNUM,MATNR)

    EQUP—-Quota(item) (QUNUM,QUPOS,LIFNR)

    ESLH--Service Package Header Data (PACKNO,EBELN,VBELN)

    ESLL--Lines of Service Package (PACKNO)

    ESUH--Ext. Services Management: Unpl.Service Limits: Header Data(PACKNO)

    ESKN--Account Assignment in Service Package(PACKNO)

    EKKN--Account Assignment in Purchasing Document(EBELN,EBELP,VBELN)

    EKBE--PO History Data (EBELN,EBELP,BELNR,BLDAT,MATNR,VGABE)

    EKBZ--PO History with delivery Costs(EBELN,BELNR,LIFNR,XBLNR)

    EKET--Schedule lines data of a PO (EBELN,EINDT,SLFDT)

    EKES--Vendor Confirmations Data(EBELN,EBTYP,EINDT,XBLNR)

    T001W-- Plants (WERKS)

    T001L-- Storage Locations (LGORT)

    T300—- Warehouse Numbers(LGNUM)

    T301—- Storage Types(LGNUM,LGTYP)

    T320—- Assign. Stor.Locn to WM Warehouse(WERKS,LGORT,LGNUM)

    T163F--Confirmation Texts(EBTYP,EBTXT)

    T156-- Movement Types(BWART)

    T024-- Purchasing Groups(EKGRP,EKNAM)

    T024E--Purchase Organizations(EKORG,BUKRS)

    T024W--Plants Assign.to P.Orgn(WERKS,EKORG)

    T161-- Purchasing Document Types(BSTYP,BSART)

    T163-- Item Category’s in Purchasing Documents(PSTYP)

    T149D--Valuation Types(BWTAR)

    T134-- Material Types(MTART)

    T179—- Material Product Hierarchies(PRODH)

    T179T—-Material Product Hierarchies: Texts(PRODH,SPRAS,VTEXT)

    TJ02T—-System status texts(ISTAT,SPRAS,TXT30)

    STKO-- BOM(Bill of Material)(Header)( STLTY,STLNR,STLAL)

    STPO—- BOM(Bill of Material)(Item)( STLTY,STLNR,STLKN,STPOZ)

    STPU-- BOM Sub-Item (STLTY,STLNR,STLKN)

    STPN-- BOM Follow-Up Control (STLTY,STLNR,MATNR)

    STST-- Standard BOM Link (STOBJ,STLNR,STLAN,STLAL)

    STZU—- Permanent BOM data( STLTY,STLNR,STLAN,ALTST)

    RKPF-- Document Header: Reservation(RSNUM,BWART,ANLN1,KOSTL)

    RBKP-- Document Header: Invoice Receipt(BELNR,BLART,GJAHR,BUDAT)

    RSEG-- Document Item: Incoming Invoice(BELNR,BUZEI,EBELN,MATNR)

    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

    Regards,

    Satish

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 12:27 PM

    FI

    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)

    Full MM Transaction Codes Flow:

    RFQ to Vendor - ME41

    Raising Quotation - ME47

    Comparison of Price - ME49

    Creation of PO - ME21N

    Goods Receipt - MIGO

    Invoice (Bill PAssing) - MIRO

    Goods Issue - MB1A

    Physical Inventory - MI01( Create doc)

    MI04 (Enter Count)

    MI07 (Post)

    MM FLOW.

    PURCHASE REQUISITION(ME51)

    |

    REQUEST FOR QUOTATION(ME41)

    |

    QUOTATION(ME47)

    |

    PRICE COMPARITION(ME49)

    |

    PURCHASE ORDER(ME21)

    |

    GOODS RECEIPT(MIGO)

    |

    INVOICE RECEIPT(MIRO)

    FI FLOW

    ************

    Creation of customer account group (OBD2)

    |

    Create no ranges (XDN1)

    |

    Assign no range to customer group(OBAR)

    |

    Create GL accounts(FS00)

    |

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

    |

    Documnet tyoe and no range (OBA7)

    |

    Sales Invoice(F-22)

    |

    Customer receipt (Incoming pmt) (F-28)

    |

    Credit Memo(F-27)

    |

    View customer balance (FD10N)

    |

    Clear AR (F-32)

    IF HELPFULL REWARD

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.