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

Please tell me on these: LIKP, LIPS, VBAP, VBEP, VBUP, VBUK...

Hi all,

I need to understand the tables of SD Module.

However there are many tables each resembling each other.

Please tell me in the correct way(according to work flow).

All replies will be rewarded and of course more helping ones will be rewarded with large points.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 09:43 AM

    Hi,

    See the order of the SD is as follows:

    Inquiry by Customer--> Quotation by vendor --> Purchase Order by Customer (Tables EKKO and EKPO) --> Sales Order against PO (Tables VBAK and VBAP) --> Delivery against Sales Order (Tables LIKP and LIPS) --> Invoices (VBRK and VBRP).

    In between the Sales Order and Delivery processing there are a lot of steps like MRP run, Manufacturing etc.

    Rest of the Info is as belows:

    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,

    Himanshu

    Message was edited by:

    Himanshu Aggarwal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 09:49 AM

    Hi Deniz.

    If It is useful for u plz give the REWARD POINTS FOR ME.

    SALES ORDER FLOW:

    SOME TERMINOLOGY ABOUT SD:

    Flow of SD in brief:

    1) Quotation -> Vendor sends the quotation based on Purchase

    Requisition sent by Customer

    2) Purchase order -> this is raised by the customer once the

    quotation is accepted.

    3) Sales Order -> if Quotation is accepted then Vendor shall raise a

    sales order for the raised purchase order

    4) Delivery ->delivery to the Customer( to whom to send,what to

    send,material, qty Etc)

    5) Shipping -> Shipping ( Shipping details where to send , what is

    the mode of transport ,)

    6) Billing -> bill is sent to customer with respect to goods.

    7) Payment -> payment is given by the customer to Vendor

    SD FLOW ALONG WITH TRANSACTION CODES AND TABLES

    inquery / document type is IN

    tcode for creation VA11,VA12,VA13. tables VBAK,VBAP

    quotation / QT

    tcode for creation VA21,VA22,VA23. tables VBAK,VBAP

    purchase order PO

    tcode for creation ME21,ME22,ME23. tables EKKO,EKPO.

    sales order OR

    tcode for creation VA01,VA02,VA03. tables VBAK,VBAP

    delivery LF

    tcode for creation VL01,VL02,VL03. tables LIKP,LIPS

    billing MN

    tcode for creation VF01,VF02,VF03. tables VBRK,VBRP

    to create a sales order we need purchase order number

    and custmer number.

    before that, to create a purchase order we need

    material no,vendor no.

    to create vendor tcode is

    xk01(create) ,xk02(change) ,xk03(display)

    tables are lfa1.

    to create customer tcode is xd01,xd02,xd03.

    table is kna1.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 20, 2007 at 09:47 AM

    VBAK and VBAP are sale order header and item data.

    after creating order, then delivery

    LIKP and LIPS are delivery header and item

    relations are

    vbak-vbeln = vbap-vbeln.

    vbap-vbeln = liks-vgbel and

    vbap-posnr = liks-vgpos

    likp-vbeln = lips-vbeln

    lllly

    after this billing

    VBRK and VBRP are billing header and item tables

    VBRK-VBELN = VBRP=VBELN

    LIPS-VBELN = VBRP-VGBEL AND

    LIPS-POSNR = VBRP-VGPOS

    http://www.sap-basis-abap.com/sd/sap-sd-processing-flow.htm

    sd-flow

    REGARDS.

    SANTHOSH REDDY

    Message was edited by:

    Santhosh Reddy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 09:46 AM

    HI

    have a look at this..

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

    this describes every thing.

    <b>Reward if usefull</b>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 20, 2007 at 10:08 AM

    VBAK , VBAP - Sales order

    VBRK, VBRP - Billing

    LIKP, LIPS - Delivery related

    Sales order to delivery link can be determined by VBFA table which contains both sales order number and delivery number. You can find out all sales related key in VBFA table( Sales Document Flow).

    With regards,

    Murugan Arumugam

    Message was edited by:

    Murugan Arumugam

    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.