Link between Accounting Document and Sales Order

[Former Member]

Dear SD Gurus,

How to find the Sales Order number and Sales Order Item from the accounting document- like document types DZ, DG, ID etc.

Kindly specify the table links and fields to fetch the above details

Regards

Vimal

[Former Member]

Link Between SAP SD, MM & FI

The link between SD and MM :-

1. When you create sales order in SD, all the details of the items are copied from Material master of MM.

2. MRP and availibility check related data is also taken from MM although you control this data in SD also.

3. While you create inbound/outbound delivery with reference to a sales order,the shipping point determination takes place with the help of the loading group, plant data, shipping conditions etc. This also refers to Material Master.

4. The material which you are entering in a sales order must be extended to the sales area of your sales order/customer otherwise you cannot transact with this material.

There are many such links between SD and MM.

Now the link between SD and FI :-

1. Whenever you create a delivery with reference to a sales order, goods movement takes place in the bacgground. eg. In case of standard sales order, you create an outbound goods delivery to the customer.

Here movement 601 takes place. This movement is configured in MM. Also, this movement hits some G/L account in FI. Every such movement of good s hits some G/L account.

2. The accounts posting in FI is done with reference to the billing documents (invoice, debit note, credit note etc) created in SD. Thus this is a link between SD and FI

3. Tax determination: In case of a tax determination also, there is a direct link between SD and MM

SD Integration points with other modules

SD module is highly integrated with the other modules in SAP.

Sales Order –

Integration Points Module

•Availability Check - MM

•Credit Check - FI

•Costing - CO/ MM

•Tax Determination - FI

•Transfer of Requirements - PP/ MM

Delivery & Goods Issue –

Integration Points Module

•Availability Check - MM

•Credit Check - FI

•Reduces stock - MM

•Reduces Inventory $ - FI/ CO

•Requirement Eliminated - PP/ MM

Billing -

Integration Points Module

•Debit A/R - FI/ CO

•Credit Revenue - FI/ CO

•Updates G/ L - FI/ CO

(Tax, discounts, surcharges, etc.)

•Milestone Billing - PS

Return Delivery & Credit Memo -

Integration Points Module

•Increases Inventory - MM

•Updates G/ L - FI

•Credit Memo - FI

•Adjustment to A/R - FI

•Reduces Revenue - FI

SD Transaction Code Flow:

Inquiry / Document type IN

Tcode for creation VA11,VA12,VA13. tables VBAK,VBAP

Quotation / QT

Tcode for creation VA21,VA22,VA23. tables VBAK,VBAP

Purchase Order PO

Tcode for creation ME21,ME22,ME23. tables EKKO,EKPO.

Sales Order OR

Tcode for creation VA01,VA02,VA03. tables VBAK,VBAP

Delivery LF

Tcode for creation VL01,VL02,VL03. tables LIKP,LIPS

Billing F2

Tcode for creation VF01,VF02,VF03. tables VBRK,VBRP

• <b>The SD & FI link is established through mapping of appropriate G/L accounts through T.Code: VKOA</b>

Regards,

Rajesh Banka

Reward suitable points.

• How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).

[Former Member]

Thanks Srini..

I will try what yu have said

Regards

Vimal

[Former Member]

Hi Vimal,

Enter the Accounting doc. no. in Table BKPF. Here the field Object Key will give you the Billing document number.

Enter this Billing document no. in table VBFA -- in VBELN field, also enter "M" in VBTYP_N and "C" in VBTYP_V field and execute

This will give you the Sales order no.

If you want the material no. & Qty entered in the document - Enter the Billing document no. in Table VBRP table and execute.

Hope this meets your requirement.

REWARD if it helps you!!

Regards,

Ajinkya

[Former Member]

Hi Vimal Anand,

Accounting documents data is stored in tables in SAP. all the accounting documents data both cleared and uncleared is in BSEG table. So go to BSEG and pass the accounting document no as BELNR and execute (F8) and then pick up VBELN (which is a Billing document number), pass billing document no as VBELN is VBFA table and pick VBELV (which is the sales document number).

Once you get the sales doc number pass it in VBAK / VBAP to see the Header and Item data of Sales documents and pick up which ever data you are looking for.

Hope this helps

Reward points if it helps and revert back for clarifications.

Regards

Srini

[Former Member]

Hi

Refer below reward if helps

Sales Order OR

Tcode for creation VA01,VA02,VA03. tables VBAK,VBAP

Billing MN

Tcode for creation VF01,VF02,VF03. tables VBRK,VBRP

Sales and Distribution (SD) :

VBFA Document flow (alg.)

VTFA Flow shipping documents

Sales order :

VBAK Header data

VBAP Item data

VBPA Partners in sales order

VBKD Sales district data

VBEP Data related to line items, delivery lines

Billing document :

VBRK header data

VBRP Item data

www.ecediinc.com/la/abap@yahoogroups.com/att-7150/SAP-Tables.doc

[former_member183879]

Hi Vimal Anand,

I dont know your case is order related billing or delivery related billing.

If order related billing

From sales order document number (VBAK-VBELN) find out the document flow in VBFA and then find out the billing document number (VBRK-VBELN) which is created with reference to sales document.

Once this is known, you can easily find out the accounting document number in BSEG table. Just explore the fields and you can find the answer.

Delivery related billing

The same logic, but you have to find out the delivery which was created with reference to ur order in VBFA table and then the invoice created with reference to the delivery in the same table. Once that is found, then it is a joint between VBRK and BSEG tables. You get wht you want.

Rwd if it helped you to find what you wanted.