topic Re: doubt in SD in Application Development and Automation Discussions

doubt in SD

Former Member — Thu, 01 Jun 2006 13:52:47 GMT

hi,

functionally what does it mean by vendor number in SAP for customer.

my reqr. is i have to fill LIFNR on delivery note.

how do i get it? do i get it from KNVV?

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 13:53:52 GMT

use LFA1 OR A021 TABLE

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 13:57:38 GMT

hii

check LFA1 TABLE Vendor Master TABLE

can u explain little more briefly

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 13:57:47 GMT

you can get Account Number of Vendor or Creditor from LFA1 master table

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 13:59:44 GMT

hi ray,

use LFA1table it is the Vendor master table and lifnr is key field.

hope this helps,

priya.

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 13:59:58 GMT

Hi,

If it Customer then you need to use KNA1-KUNNR.

If it Vendor then you need to use LFA1-LIFNR.

Cheers,

Bujji

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 14:00:01 GMT

If you have the sales order number and the item number, then you can get the vendor number from VBPA-LIFNR.

Regards,

Ravi

Re: doubt in SD

abdul_hakim — Thu, 01 Jun 2006 14:01:09 GMT

Vendor is the person who sells the goods..Your customer can also be a vendor for his/her customers....

Cheers,

Abdul Hakim

Mark all useful answers......

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 14:04:56 GMT

this is the case of outbound delivery.

IDoc DELVRY03

messagy type WHSORD

how do i get it?

i have no access to get KUNNR. if so i can get LIFNR from LFA1.

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 14:14:40 GMT

hi ravikanth,

yes, i have access to VBPA but i have outbound delivery doc no. item no. so KUNNR is filled in VBPA, not LIFNR

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 15:20:16 GMT

Hi Surendra,

first thing u need to do before start looking into various tables is, ask the consultant wat exactly they mean by vendor n where they enter it...from the transaction n field where they enter it, u can easily track down the table where this value is stored... now vendor can be anything..lets say for selling this good, u had to purchase raw material from a vendor, this will be available in PO details( EKPO table ), or vendor for ur customer is urself...so verify first wat exactly this vendor is....

Re: doubt in SD

Former Member — Thu, 01 Jun 2006 15:37:13 GMT

In all probability, you are looking for a carrier partner of a delivery, because this partner will be a vendor(you pay the carrier to deliver your goods to the customer). So ask your functional/business person to show you which partner they want on the delivery number. Then you can find that partner value in VBFA using that partner function, document number and line number(if partners are maintained at item level.

There is also a possibility that your customer is also a vendor in your system. In that case, you will maintain the customer number on the vendor master and vendor number on the customer master. So if you look at KNA1 record for the customer, you will see that there is a field LIFNR in there and there is KUNNR in LFA1.