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

[Former Member]

Hi,

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

Regards

Ameet.

[Former Member]

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

VBAK and KNA1 are linked with KUNNR (Customer Number)

Sri

[glio_ad]

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

[Former Member]

Hi ameet

just go through this link

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

Rgds

Raghav T

[Former Member]

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