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

[Former Member]

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.

[Former Member]

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

[Former Member]

HI

have a look at this..

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

this describes every thing.

<b>Reward if usefull</b>

[SantoshKallem]

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

REGARDS.

SANTHOSH REDDY

Message was edited by:

Santhosh Reddy

[Former Member]

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.

[Former Member]

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