on 08-06-2007 4:21 PM
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
HI
SENT A MAIL REWRAD IF U FEELS THAT HELPING
Message was edited by:
SHESAGIRI.G
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
<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.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.