topic Re: SD + Sales document ? in Application Development and Automation Discussions

SD + Sales document ?

Former Member — Fri, 22 Jun 2007 08:45:17 GMT

Hello ,

I have few confusion regarding sales document...

Okey, first I want to know what is the difference between sales order, and sales document, or they are same stuff...table VBAK field VBELN ( is this sales order or sales document ).

Then I want to know the invoice no for this sales order....I guess invoice table is VBRK, but there again the invoice no is VBELN ? ( I guess billing document is actually invoice no ) or ?

Regards,

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 08:49:44 GMT

IN SD for most of the documents same VBELN field is used

so you should be very careful depending upon the table the meaning of this field varies

Generally Sales order, Enquiry,Quotation (which are all in VBAk,VBAP tables) are known as Sales Documents

Invoice, Credit Memo,Debit Memo are known as Billing documents (which are in VBRK,VBRP tables)

delivery doc is different which is in LIKP and LIPS table

All these sales related doc's are in VBUK and VBUP table again

have to differentiate with VBTYP field

Reward points for useful Answers

Regards

Anji

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 08:49:54 GMT

Hi,

The sales order is a contractual agreement between a sales organization and a sold-to party about delivering products or providing a service for defined prices, quantities and times and is created by the supplier/vendor to the customer

Sales Document:

The number that uniquely identifies the sales document.

Use

If, for example, you want to display or change a sales document and you have only the purchase order number from the customer, you can use a matchcode to find the document.

Example

You created a sales order which refers to customer purchase order number 12544-D. To locate the sales order, you can enter =a.12544-D in the sales document field.

The document number can be proposed from a user parameter.

The following parameters are available for the individual document types:

AFN - Inquiry number

AGN - Quotation number

AUN - Order number

LPN - Scheduling agreement number

KTN - Contract number

AMN - Assortment number

<b>Reward points</b>

Regarsd

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 08:57:53 GMT

Hello Anji,

Thanks for your reply, it was very descriptive.....

you mentioned:

Generally Sales order, Enquiry,Quotation (which are all in VBAk,VBAP tables) are known as Sales Documents

So the field VBLELN in VBAK is sales document, then what is sales order ( and in which table ).

Secondly you mentiond:

Invoice, Credit Memo,Debit Memo are known as Billing documents (which are in VBRK,VBRP tables)

So the field VBELN in table VBRK is billing document, what is invoice no then and in which table...

kind regards,

Message was edited by:

Shah H

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 08:58:57 GMT

hello Shah,

any bussiness document related to SD callea a Sales document while Sales order is .. when a company sells the products or services to a customer then it will give document to the cutomer i.e. list of item and quantity etc...

ex. sales documetnts are

1.Sales Order (table VBAK, ABAP, VBEP)

2.Delvery Document(LIKP, LIPS)

3.Invoice(VBRK, VBRP)

in all the table VBELN is the KEY field but the data element is defferent.

the linking b/w these tables as follows.. all the tables are linked at item level it means item table VBAP~~>LIKP~~>VBRP.

linking fields are VGBEL(reference doc header) VGPOS (ref Doc Item).

VBRP-VGBEL contains delivry heardr number

VBRP-VGPOS contains delivry item number

LIKP-VGBEL contains Sales order heardr number

LIKP-VGPOS contains Sales order item number

<b>Please Colse the thred when ur problem is solved,Raward Helpful answers</b>

Regrads

Naresh Reddy

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 09:06:04 GMT

Hi All,

So, I understood like ..in table VBAK the field VBELN is sales order right ? similarly in table VBRK the field VBELN is invoice no ? right...

So now I have to see, if I have sales order ( vbak-vbeln) how to find the invoice no. i.e. vbrk-vbeln....

any way, many thanks and kind regards,

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 09:09:37 GMT

See the table VBAK

and see the field VBTYP

Enquiry, Quotation, Sales Order are differentiated based on Doc.Type(VBTYP field) in VBAK ( for Enquiry VBTYP = A, for Quotation 'B' & for Order it is 'C'.)

simialrly in VBRK check the VBTYP field

K Credit memo request

L Debit memo request

M Invoice

N Invoice cancellation

O Credit memo

Hope you understood

Reward points for useful Answers

Regards

Anji

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 09:17:46 GMT

hello shah,

r u reading the post completely.. i have give the link sales orerd to invoice through delivery..

I wondered u r asking it agian

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 09:21:23 GMT

Hi Naresh,

Thanks for your input.... I have to understand by once doing it, will check the tables and let you know...

Thanks and kind regards,

Shah

Message was edited by:

Shah H

Message was edited by:

Shah H

Re: SD + Sales document ?

Former Member — Fri, 22 Jun 2007 09:42:35 GMT

Hello Naresh,

Unfortunatelly, I did not find the two fields you mentioned in LIKP ?

LIKP-VGBEL contains Sales order heardr number

LIKP-VGPOS contains Sales order item number

( what is the link between VBAP and LIKP )....

Regards,

I guess you mean LIPS.... or...

Message was edited by:

Shah H