Skip to Content
author's profile photo
Former Member

Relationship between SD tables VBAK,VBAP VBKD VEDA and table KNA1

Hi,

What is the relationship between SD tables VBAK,VBAP VBKD VEDA and table KNA1.

Regards

Ameet.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Posted on Sep 27, 2007 at 12:54 PM

    Hi,

    KNA1 is the customer master table and in order to use a customer in SD, you will have to create its Sales View data (main tables: KNVV, KNVP an others).

    VBAK-KUNNR is usually the Sold-To party. The customer tha actually orders the goods or service.

    VBAP has nothing to do with the customers, It is just the Sales Order line item.

    VBKD holds the slaes document's business data. if VBKD-posnr = 000000, then it holds the header business data. If posnr <> 000000, then it holds the specific item data (related to VBAP-posnr).

    VEDA holds data of a sales contract document. It is related to VBAP and VBAK.

    Gnerally, the customers are linked to sales documents mainly through table VBPA and the respective "partner functions". So, check with your SD Consultants which are the "partner functions" you need to access VBPA and the rest. You can also check table VAKPA, an index table on customer/partner function, if you need select sales orders by customers only as the main selection criterion.

    Please reward if helpful.

    Cheers,

    George

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 06:58 AM

    Hi

    KNA1 is the customer master

    VBAK-KUNNR = KNA1-kunnr

    VBAK-VBELN = VBAP-VBELN

    VBAK-VBELN = VBKD-VBELN

    VEDA doesn't have link with the above sales order tables

    see the SD module flow

    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

    Add comment
    10|10000 characters needed characters exceeded

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

    VBAK VBAP VBKD and VEDA - all are tied up with VBELN (Sales Order Num)

    VBAK and KNA1 are linked with KUNNR (Customer Number)

    Sri

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 05:23 AM

    Hi ameet

    just go through this link

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

    Rgds

    Raghav T

    Add comment
    10|10000 characters needed characters exceeded