cancel
Showing results for 
Search instead for 
Did you mean: 

SD Flow and Tables?

Former Member
0 Kudos

Hi Experts,

Can anyone explain me SD flow along with Transaction codes and DB table names for each step which are needed?

Regards

Faisal

Points rewarded for correct answers.............

Edited by: Abdul Faisal on Apr 29, 2008 1:50 PM

Edited by: Abdul Faisal on Apr 29, 2008 1:50 PM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hi,

this is SD flow

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

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

Configuration:

Normal Sales Order Cycle:-

Step 1: Sales Document Type

IMG > Sales and Distribution > Sales > Sales Documents >

Sales Document Header:

1. Sales Document Type:The sales document types represent the different business transactions, such as Inquiry, Quotation, Sales Order, etc. To create new sales order type, always copy as with reference to similar sales order. If possible use standard sales order.

2. Define Number Ranges For Sales Documents: Maintain number range with discussion with core team.

3. Assign Sales Area To Sales Document Types:

A. Combine sales organizations / Combine distribution channels / Combine divisions: Ensure to maintain these, else Sales Order creation will give error.

B. Assign sales order types permitted for sales areas: Assign only required Sales Order Types to required Sales Area. This will minimize selection of Sales Order Type as per sales area.

Sales Document Item:

1. Define Item Categories: If possible use Standard Item Category. Incase if required to create new, copy as from standard & maintain New.

2. Assign Item Categories: If possible, use standard. Formula for deriving item category: Sales Document Type + Item Category Group + Usage + Higher Level Item Category = Item Category

Schedule Line:

1. Define Schedule Line Categories: If possible use Standard Schedule Lines. Incase if required to create new, copy as from standard & maintain New.

2. Assign Schedule Line Categories: If possible, use standard. Formula for deriving Schedule Line: Item Category + MRP Type / No MRP Type.

Step 2:

IMG > Logistic Execution > Shipping > Deliveries >

1. Define Delivery Types: If possible use Standard Delivery Type. Incase if required to create new, copy as from standard & maintain New.

2. Define Item Categories for Deliveries: If possible use Standard Item Categories for Delivery Type. Incase if required to create new, copy as from standard & maintain New.

3. Define Number Ranges for Deliveries: Ensure to maintain number range.

Step 3:

IMG > Sales and Distribution > Billing >

1. Define Billing Types: If possible use Standard Billing Type. Incase if required to create new, copy as from standard & maintain New.

2. Define Number Range For Billing Documents: Ensure to maintain number range.

3. Maintain Copying Control For Billing Documents: Maintain relevant copy controls such as Sales Order to Billing, Deliver to Billing, etc.

Note: Ensure that Copy Control settings are done

Sales Order to Sales Order (QT --> OR): VTAA

Sales Order to Delivery (OR --> LF): VTLA

Sales Order to Billing (OR --> F1): VTFA

Delivery to Billing(LF --> F2): VTFL

Billing to Sales Order (F2 --> RE): VTAF

The configuration differs from scenario to scenario & requirement of the client.

Answers (3)

Answers (3)

Former Member
0 Kudos

hello, friend.

the simplest presentation of your requirement as follow:

1. VA01 create sales order

2. VL01N create outbound delivery, post goods issue (w/o WMS)

3. VF01 create billing

the tables would be:

1. VBAK sales order header, VBAP sales order item

2. LIPS outbound delivery header, LIKP outbound delivery item

3. VBRK billing header, VBRP billing items

of course you would also need KNA1 (customer) and MARA (material). there are literally dozens more tables for SD. these are covered in earlier threads.

regards.

Lakshmipathi
Active Contributor
0 Kudos

Below is the SD 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 MN

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

thanks

G. Lakshmipathi

Former Member
0 Kudos

Hi,

Pls find the below mentioned flow for SD

Flow is Inquiry -> Quotation -> SO -> Delivery -> Billing

SD Flow

SD Transaction Code Flow:

Inquiry / Document type IN

Tcode for creation,change & display VA11,VA12,VA13. tables VBAK,VBAP

Quotation / QT

Tcode for creation,change & display VA21,VA22,VA23. tables VBAK,VBAP

Sales Order OR

Tcode for creation,change & display VA01,VA02,VA03. tables VBAK,VBAP

Delivery LF

Tcode for creation,change & display VL01,VL02,VL03. tables LIKP,LIPS

Billing F2 Tcode for creation,change & display VF01,VF02,VF03. tables VBRK,VBRP

Regards,

Mallesh