2007 Sep 27 1:38 PM
Hi,
What is the relationship between SD tables VBAK,VBAP VBKD VEDA and table KNA1.
Regards
Ameet.
2007 Sep 27 1: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
2007 Sep 27 1: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
2007 Sep 28 6:23 AM
2007 Sep 28 7: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