Intigreation

[Former Member]

hi,

Could u tell me, How SD is intigreated with FICO & MM.

Please send me the answer at my e-mail id:- catchrah80@yahoo.co.in

Thanking You

Raj

[Former Member]

HI

SENT A MAIL REWRAD IF U FEELS THAT HELPING

Message was edited by:

SHESAGIRI.G

[Former Member]

U R MAIL ID BOUNCING send a test mail at shesagiri@gmail.com can send the doc

[Former Member]

hi

SD-FI Integration

Prepare Revenue Account Determination.

In this step, you allocate the G/L accounts for the revenue account determination. You make the allocation for each of the access sequences defined previously.

In this case, you specify a G/L account depending on the following terms:

Application (key for the Sales and Distribution application), Account determination type, Chart of accounts (from the FI System), Customer account assignment group, Materials account assignment group, Account key

The allocated accounts are used to post revenues, surcharges and discounts automatically.

You have defined the access sequences and the account determination types for Sales and Distribution.

You must define charts of accounts and G/L accounts in the FI System.

Activities

1. Check to what extent you can use the allocations contained in the

SAP standard version.

2. Allocate the G/L accounts for each access sequence.

Path

IMG (Implementation Guide)  Financial Accounting  General Ledger Accounting  Business Transaction  Integration  Sales & Distribution  Prepare Revenue Account Determination.

Transaction Code VKOA

Following Settings Made

Customer Grp./Material Grp./ Account Key

Customer Group/ Account Key

Material Group/Account Ke

Account K

Account Key (Contd)

IMPORTANT POINTS IN SD – FI INTEGRATIONS

1. Customer Account Assignment Groups:

Domestic Customers, Foreign Customers and Affiliated Companies. I think they are finalized.

2. Material Account Assignment Groups :

3. Trading Goods and performances.

They are not exhaustive and they need revision.

Finished Goods & Semi Finished Goods are covered under Trading Goods. Performances are said to be Nil. Shall we have Material Groups as Trading, Finished, Packaging and Services.

3 Condition Types : KOFI & KOFK ( Account Assignment for CO)

4 Account Keys

ERL Sales

RDM Rounding

ERS Sales Deductions

ERF Freight Collected Domestic & Foreign

EIN Transit Insurance Collected

EXD Excise Duty

ERB Rebate Sales Deductions

ERV Rebate Accruals

EVV Cash Clearing

MW3 Sales Tax

MWS Tax on sales & purchases

5 50001 Domestic Direct Sales

50002 Domestic Branch Sales

50003 Domestic Direct Sales 80 1A

50004 Domestic Branch Sales 80 1A

50005 Export Sales

50006 Inter Unit Transfer– Finished Goods

52116 Sale of Free Sample (Domestic)

52117 Sale of Free Sample (Export)

52118 Sale of Captive Consumption

a) What is branch Sales? There are no sales from branches and there are no depots at branches. Invoices are being sent only through branches. Second Sale concept is also not there.

b) Sales of Dadra & Barotiwala are to same account?

6 ERS Sales Deductions

51001 Trade Discount

51002 Cash Discount

51003 Commission

7 Following Accounts to be identified and attached in SD_Fi integration

52001 Job Plating Service Charges

52001 Labor Charges

52001 Testing Analysis Charges Received

52004 Erection & Commissioning Charges

52005 Technical Fees Recd

52006 License Fees Recd

52101 Scrap sales

52102 Sundry Receipts

52103 Commission Recd (Local)

52104 Commission Recd (Foreign)

52105 Insurance Claims Recd

52106 Sundry Balances W/o

52110 Refund of Sales Tax

52111 Refund of Octroi

52112 Rounding Off

55104 Export Benefits & entitlements-Chemicals

69001 Freight & Clearing Imported--Inward

69002 Freight & Clearing Indigenous - Inward

69003 Octroi Charges - Inward

73701 Freight & Clearing Imported--Outward

73702 Carriage & Cartage (Outward)

73703 Octroi Charges (Outward)

8 For Acc. Key

EVV (Cash Clearing) 11602 (Petty Cash) is found attached

ERU (Rebate Accruals) 39024(Out Standing Expenses) is attached

SALES RELATED ACCOUNTS

1. ERL Sales

50001 Domestic Direct Sales

50005 Export Sales

52001 Job Plating Service Charges

52002 Labor Charges

52003 Testing Analysis Charges Received

52004 Erection & Commissioning Charges

52101 Scrap sales

50006 Inter Unit Transfer– Finished Goods

52116 Sale of Free Sample (Domestic)

52117 Sale of Free Sample (Export)

52118 Sale of Captive Consumption

2. RDM Rounding

52112 Rounded off Differences - Invoices

3. ERS Sales Deductions

74951 Trade Discount

74952 Additional Discount

74953 Cash Discounts

74954 Loyalty Discounts

74955 Overriding Commissions

4. ERF Freight Collected Domestic & Foreign

73701 Forwarding Charges (Outward) (Expense Account)

73702 Carriage & Cartage (Outward) (Expense Account)

73703 Octroi Charges (Outward) (Expense Account)

52111 Octroi Refund Account (Income A/c)

5. EIN Transit Insurance Collected

52105 Insurance Claim Received (Income A/c)

6. ERB Rebate Sales Deductions

7. ERV Rebate Accruals

8. EVV Cash Clearing

9. Tax Accounts

EXD Excise Duty

19001 Central excise – Current A/c Bal (PLA)

MW3 Sales Tax

39033 LST Maharastra Sales tax

MWS Tax on sales & purchases

39034 CST Central sales Tax

mail sent

Message was edited by:

prashanth goud

Message was edited by:

prashanth goud

Message was edited by:

prashanth goud

[Former Member]

hi prashant

pl sens that info on SD/FI/MM intigration to the following id

ramch@yahoo.com

advance thanks

ram

[Former Member]

<u><i><b>Link Between SAP SD, MM & FI</b></i></u>

1. In SAP you will always get integration with other modules. SD will interact with FI, MM will interact with SD :-

1a. Looking at MM and SD interaction first, take the scenario of a third party order process. This process uses a purchase order (which is sent to your vendor). Also invoice verification is used further along the process to check that the invoice you send to your customer is the same material and quantity as that which the vendor sends to you (but obviously shipped

directly to your customer).

1b. Billing is an SD function. But SAP needs to know, when processing a customer's payment, to which GL account the payment has to be processed. For instance payment of a UK based material would be placed in a different GL account to that of a non-UK based material. Furthermore, a UK based customer may have a different GL account to that of an Export customer. This is configured in Account Determination.

2. ABAPers are there to essential do some bespoke development. Your integration, or interaction, with them would be when specifying the tables, fields, input fields, a simple process explanation, data mapping (if doing an interface from one system to another) etc. *-- Shahee

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

Tips by: Subha

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 MN

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

To create a sales order we need purchase order number and custmer number. Before that, to create a purchase order we need to have material no, vendor no.

To create vendor tcode is

xk01(create), xk02(change) , xk03(display)

Tables are lfa1.

To create custmer tcode is xd01, xd02, xd03.

Table is kna1.

After creating sales order using this no we can create delivery note tcode is vl01.