Skip to Content
avatar image
Former Member

SD TABLES

hi friends,

Can anybody tell me the SD Table process Flow???

thanks

manu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    May 01, 2008 at 12:33 PM

    Hi Manu,

    sales order - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

    Delivery - Transaction VL01N - Tables LIKP, LIPS, VBUK, VBUP.

    Goods issue - Transaction VL02N - Tables MKPF, MSEG

    Billing document - Transaction VF01 - Tables VBRK, VBRP.

    Customer is returning...

    Return order - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

    Returns delivery - Transaction VL01N - Tables LIKP, LIPS, VBUK, VBUP.

    Goods Receipt - Transaction VL02N - Tables MKPF, MSEG

    Credit memo - Transaction VF01 - Tables VBRK, VBRP.

    Customer wants some money back.

    Credit memo request - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

    Credit memo - Transaction VF01 - Tables VBRK, VBRP.

    Customer was charged less money ..Meaning we want some money back from customer..

    Debit memo request - Transaction VA01 - Tables VBAK, VBAP, VBEP, VBKD, VBPA, VBUK, VBUP.

    Debit memo - Transaction VF01 - Tables VBRK, VBRP.

    Also please check this links.

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

    http://www.sap-basis-abap.com/sapsd.htm

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

    Common Tables used by SAP MM:

    Below are few important Common Tables used in Materials Management Modules:

    EINA Purchasing Info Record- General Data

    EINE Purchasing Info Record- Purchasing Organization Data

    MAKT Material Descriptions

    MARA General Material Data

    MARC Plant Data for Material

    MARD Storage Location Data for Material

    MAST Material to BOM Link

    MBEW Material Valuation

    MKPF Header- Material Document

    MSEG Document Segment- Material

    MVER Material Consumption

    MVKE Sales Data for materials

    RKPF Document Header- Reservation

    T023 Mat. groups

    T024 Purchasing Groups

    T156 Movement Type

    T157H Help Texts for Movement Types

    MOFF Lists what views have not been created

    A501 Plant/Material

    EBAN Purchase Requisition

    EBKN Purchase Requisition Account Assignment

    EKAB Release Documentation

    EKBE History per Purchasing Document

    EKET Scheduling Agreement Schedule Lines

    EKKN Account Assignment in Purchasing Document

    EKKO Purchasing Document Header

    EKPO Purchasing Document Item

    IKPF Header- Physical Inventory Document

    ISEG Physical Inventory Document Items

    LFA1 Vendor Master (General section)

    LFB1 Vendor Master (Company Code)

    NRIV Number range intervals

    RESB Reservation/dependent requirements

    T161T Texts for Purchasing Document Types

    Transaction Codes:

    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)

    Also please check this links.

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

    http://www.sap-basis-abap.com/sapmm.htm

    Reward points if helpful,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 01, 2008 at 03:16 AM

    hello, friend.

    there are a minimum of 3 sets of tables involved in SD:

    1. sales order header and item - VBAK and VBAP, respectively

    2. delivery header and item - LIPS and LIKP, respectively

    3. billing header and item - VBRK and VBRP, respectively

    after SD billing is posted to accounting, look for table BSEG

    table VBFA is for you to track the transaction flow (via created doc and subsequent doc, or if you wish an existing doc and referenced doc)

    regards.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 01, 2008 at 03:13 AM

    Hello,

    Could you please elaborate your question??? are you asking for SD tables?

    Prase

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 01, 2008 at 04:08 AM

    Hello,

    The tables for Sales order process are:-

    VBAK - Sales order Header

    VBAP - Sales order Item

    VBEP - sales order Schedule lines

    KNA1 - Customer

    KONV Conditions Pricing

    KONP Conditions for Items

    Delivery Processing:

    LIKP Delivery Header Data

    LIPS Delivery: Item data

    Invoice Processing:

    VBRK Billing: Header Data

    VBRP Billing: Item Data

    Prase

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 01, 2008 at 04:43 AM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 01, 2008 at 02:05 PM

    Hi,

    just to add, try to understand the in a normal sales process what happens.... like a customer makes an inquiry for which we have IN- inquiry doc, then we give a quote - QT followed by the actual sales process. So the VBAK / VBAP / VBEP play an imp role here. foloowed by delivery LIKP, LIPS then billing VBRK, VBRP.

    regards

    sadhu kishore

    Add comment
    10|10000 characters needed characters exceeded