SAP FICO/MM/SD CONFIGURATION ## FICO GL ## FICO AP ## FICO AR ## FICO ASSETS ## TABLES ## TDS ## LSMW ## AND MANY MORE ##
Saturday, November 12, 2011
Friday, November 11, 2011
EXEMPTED TDS FROM INCOME TAX, MAINTAIN EXEMPTED TDS IN VENDOR
YOU CANNOT POST TO ASSET IN COMPAY CODE XXXX FISCAL YEAR 2011
CHECK :
1) OBH2 à FOR A/C TYPE +, S, A
2) OAAQ
3) AJAB
SAP FI-MM-SD INTEGRATION
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 availability 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 background. 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.
FI-MM Integration
Transaction code : OBYC (in easy access)
In this transcation we have to specify GL account codes for material valuation created by MM consultants.
The process in MM is herebelow,
1) Purchase Order : Tr code ME21N - here no integration required with FI
2) Goods Issue : Tr Code MIGO - here no integratinwith FI
3) Invoice Reciept - Tr Code MIRO - here when the invoice is recieved & MM process the transaction based on OBYC configuration system will generate FI document. System also generates Material document as well
4) Payment : Tr code F110 - Here also the the transcation affects FI
FI-SD integation:
This integration done using Tr Code VKOA. here we have to define GL account codes to Condition types.
Process
1) SD Raises Sales Order - No implication in FI
2) SD raises Delivery doc - No implication in FI
3) SD processes billing - no implication in FI
4) SD releases billing doc to FI - FI document gets generated (Tr Code VFX3)
1. When you create sales order in SD, all the details of the items are copied from Material master of MM.
2. MRP and availability 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 background. 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.
FI-MM Integration
Transaction code : OBYC (in easy access)
In this transcation we have to specify GL account codes for material valuation created by MM consultants.
The process in MM is herebelow,
1) Purchase Order : Tr code ME21N - here no integration required with FI
2) Goods Issue : Tr Code MIGO - here no integratinwith FI
3) Invoice Reciept - Tr Code MIRO - here when the invoice is recieved & MM process the transaction based on OBYC configuration system will generate FI document. System also generates Material document as well
4) Payment : Tr code F110 - Here also the the transcation affects FI
FI-SD integation:
This integration done using Tr Code VKOA. here we have to define GL account codes to Condition types.
Process
1) SD Raises Sales Order - No implication in FI
2) SD raises Delivery doc - No implication in FI
3) SD processes billing - no implication in FI
4) SD releases billing doc to FI - FI document gets generated (Tr Code VFX3)
Thursday, November 10, 2011
HOW TO CHANGE MOVING PRICE FROM MATERIAL MASTER
MR21
Creation of Cost Elements
Cost Element Accounting
In SAP system, you do not need to enter cost data separately. This is because each business transaction that involves costs updates the CO component itself. Each consumption transaction in Material Management (MM), each billing in Sales and Distribution (SD) (= revenue), and each external transaction for invoice verification flows directly through the G/L Account (= cost element) to the corresponding account assignment object.
Master Data
1. Creation of Primary Cost Element
Before creating a Primary Cost element there has to a G/L account with the same account number.
Accounting à Controlling à Cost Element Accounting à Master Data à Cost element à Individual Processing à KA01- Create Primary
Transaction Code: KA01
Enter Controlling Area: 1000
Press ENTER
Enter the following details in the screen above:
1. Cost Element: Enter the Cost Element number (Same as G/L account no.)
2. Valid from: Enter valid from date eg: 01.04.2000
Click on Master Data
Click on Save or press Ctrl + S
You will get a message that cost element has been created.
2: Creation of Secondary Cost Element
Secondary Cost Elements are created for internal purpose only, they do not have any corresponding G/L account in FI.
Accounting à Controlling à Cost Element Accounting à Master Data à Cost element à Individual Processing à KA06- Create Secondary
Transaction Code: KA06
Enter the following details in your screen:
1. Cost Element: Enter secondary cost element number.
2. Valid From: Enter valid from date eg: 01.04.2000
Click on Master Data
Enter the following details in the above screen:
1. Name: Name of the secondary cost element
2. Description of the secondary cost element
3. Cost Element Category: Enter category 41, 42 or 43 accordingly.
Click on Save or Press Ctrl + S.
You will get a message that cost element has been created.
3: Change cost element
Accounting à Controlling à Cost Element Accounting à Master Data à Cost element à Individual Processing à KA02- Change
Transaction Code: KA02
Enter the cost element number in the screen below.
Click on Master Data.
4: Display cost element
Accounting à Controlling à Cost Element Accounting à Master Data à Cost element à Individual Processing à KA03- Display
Transaction Code: KA03
Enter the cost element number in the screen below.
Click on Master Data.
Here you can view the master data details.
5: Delete cost element
Accounting à Controlling à Cost Element Accounting à Master Data à Cost element à Individual Processing à KA04 - Delete
Transaction Code: KA04
Enter the following details in the above screen:
1. Cost Element: Enter the cost element number you want to delete.
2. Test Run: Select test run before actually deleting a cost element.
Click on Execute.
Now if you want to delete the cost element then go back and deselect the Test Run button.
Click on Execute.
You will get the following message:
Click on Yes, cost element will be deleted.
YEAR END PROCEDURE
Generally Followed Year end procedures in SAP:
1. Ensure postings of all the GR’s upto 31st March
2. Ensure posting of all GR done pending for IR related entries till 31st March. (MB5S).
3. Ensure posting of all GR done pending for Excise postings till 31st March. (J1I7).
4. Ensure all Capitalizations till 31st March. – (T.code:AIAB & AIBU).
5. Run the Depreciation in Asset Accounting - (T.code: AFAB).
6. Ensure posting of all Goods Deliveries and Billing Documents – Verify VL06G & VF04 -
7. Verify through VFX3 whether all Billing documents are posted to accounts or not. –
8. Check if any provisional entries to be posted -
9. Check if any accrual entries to be posted –(T.Code:FBS1).
10. Run automatic clearing for GR/IR clg. Etc., - (T.code F.13).
11. Forgien currency Valuation - ( T.code FAGL_FC_VAL).
12. Check and post all parked documents – (T.code FBV0).
13. Check and clear open items of Customers & Vendors – (T.code: F-32 & F-44).
14. Ensure the postings of all Excise related postings, Like any adjustment entries during the financial year
15. Ensure all the process orders closing which are not in operation –
16. Ensure WIP Calculations – If process following by your company – . (T.code: KKAX, KKAO).
17. Cost center adjustments – .(KB61,KSV5, KSU5).
18. Ensure all production / process orders settlements till 31st March. (T.Codes: KO88 & CO88).
19. Maintain the number ranges for all document types
20. Maintain the number ranges for all excise series groups for all excise number range objects.
21. Maintain TDS challan and certificate number ranges
22. Periods open in MM – .(T.code: MMPV)
23. FI Periods needs to be maintained – (T.code: S_ALR_87003642).
24. Balances carry forward to next financial year – In case of G/L,A/R and A/P – (FAGLGVTR, F.07).
25. Fiscal Year Change in Asset Accounting – AJRW transaction code.
26. Reverse Bill liability (Customers) - (T.Code: F-20).
27. Maintain exchange rates if required – (T.Code: S_BCE_68000174).
28. Issue balance confirmation letters –
29. Bank Réconciliation - ( T.codes : ZFF67).
30. Run Interest - ( T.code : F-52)
Thursday, November 3, 2011
Wednesday, August 24, 2011
most asking interview question
1) Can we give line item display for “Inventory a/c”.
Ans. We cannot give for G/L a/c update automatically through transactions in subledgers (AP, AR, AA).
2) Open item management in which accounts if an organization maintains 1000 G/L.
3) In which condition we can give price indicator ‘V’ in material master A/cing view.
4) If client requires can we configure Posting periods as-
1-25, 26-20, 21-15 like wise.
5) Delivery of inventory made but not reached to customer till 31st march. Will you take this revenue in this year or in next year?
Ans. We will take in this year. We will make provision for all goods we delivered but not billed.
6) What are the most sensitive fields in G/L master (3-4).
Field status group, accout group,
7) What you configure in SAP (except master data).
8) Any idea about tables and fields.
9) Business area is within the company code or company code is within the business area. Which is in higher level?
1) What terminology we will use for Freight when it comes separately in MIRO (not mentioned in P.O.).
2) MIGO @ Rs. 10/pc. Stock consumed and now getting vendor invoice MIRO @ Rs. 11/pc.
3) What is Cutover Activity?
4) MIGO of 10 Qty. MIRO of 08 what about 02 Qty.(if we are not returning & even not scarping , suppose it was disapproved by quality people).
5) Can we post Invoice manually?
F-43 & FB60
6) Where we are giving G/L a/cs in FI-MM integration.
OBYC
7) What is Core User? & Team Member
8) Where batch input session comes in picture.
9) T/c for Interest run and APP run.
10) When you started Go-Live in Munjal Showa Corp.
11) How you post depreciation in 1st period of 2005 if 2004 assets not closed.( suppose using calendar yr. Is financial yr. closed always till next yr. 1st period?
12) Month ending closing.
13) LSMW (through it what u did). What is in 1st page screen of LSMW?
1) What issues you handled in G/L, A/R, A/P.
2) P.O. price should not be more than down payment (What setting requires).
3) Invoice for Revenue & Capital purchase (how it will assign to G/L).
4) What setting requires when we posted TDS in Adv. Payment posting so it should not to be ask at the time of Invoice posting.
5) What is the configuration setting in W/tax type & W/tax code.
6) How you will post Service & Material invoice together.
7) How we can see the Vendor Balance.
8) What is vendor Ageing purpose? How you will reach till this.
9) What Drilldown reporting & ___.
10) Surcharge will applicable from 1000000 onwards, how you will configure.
11) Difference between business place & ________.
12) Challan posting in TDS (end user part).
13) What is No accumulation (radio button) in TDS.
14) When VAT implemented minute changes in setting done. What are those?
INTERVIEW 6
1) Foreign currency valuation.
2) Yours strength & weakness.
3) Currency in GL.
4) Sort key & Open Item mang.
5) GR/IR clearing (month end).
6) How u upload assets data(AS91)
7) Ranking order in APP (why exactly we are giving).
8) Cheque Issue in Reconcillation (what happen actually- amt/cheque no/date).
9) Cost element accounting (Reconciliation).
10) Month end closing.
11) Invoice Qty diff. how system will post it.
12) Integration FI-MM.
INTERVIEW 7
1) Why giving Pmt. Medium Prog. in APP.
2) How we can set Cash Journal for 4 different business area.
3) Dep. Run left for 01 assets. What u will do.
4) After dep. Run what u will do?
5) Meanwhile the year if u want to change to the other FY then how will do.
6) What u gave in Global Parameter?
7) How data flow in COPA.
8) What is assets class and its functions.
9) How many dep areas are there? Can we post dep to more than 01 Dep. Area?
10) How many plants are there in Organizational Structure? How they assigned to Company Code.
INTERVIEW 8
1) What is B/S provisional?
2) What are JE at Dep posting?
3) Where we can give default cost ctr for cost element.
4) Can we post dep manually
OASV
Ans. Yes, by deselecting the post automatically check box.
5) What are the accounting relevant fields in Material Master? =>> PRICE CONTROL, MOVING PRICE, VALUATION CLASS
6) Is vender is asking for payment for all items on 3rd. Is it possible?
7) What is Next Payment date in APP execution? => This date is needed in order to check the due date of payables. If an item is already overdue on the date of the next payment run, or would lose cash discount, the system pays the item in this payment run
8) What are the fields we can change after posting the FI documents? è Base line date, assignment, Text.
9) What is the table for doc header, doc line item? Is there any for both (together). => BKPF
10) What is Baseline date? Date to which the periods for the cash discount deadline and the due date for net payment refer. This is the case for line items in open item accounts.
11) Terms of payment. Can we configure 05 Installment for a payments for vendor?
12) If customer gives order of 5 lacs. His credit limit is only 1 lac but business does’nt want to loose the business. How u will release the orders of all pipeline materials.
Ans. Deselect the credit limit check boxes.
13) What were the fields for Bank Reconciliation? Ff67, ff68
14) Execution of APP F110
15)
INTERVIEW 9
1) What is commitment management?
2) What are variances?
3) What and how u testing in configuration.
4) Landscape of ur project. Landscape is like a server system or like a layout of the servers or some may even call it the architecture of the servers viz. SAP is divided into three different lanscape DEV, QAS and PROD.
5) What is A/c Group? The account group determines the fields for the entry screens if you create or change a master record in the company code. The account group also determines in which number interval the account number must be.5) How data flow in COPA.
6) PCC.
7) If an organization has 1000 GL out of which 600 B/S a/c and 400 P&L then how many cost element u can create.
8) What is secondary cost element? It is use for settlement or allocation purpose. Financial entry will not pass through that gl a/c.
9) What is diff. between cost ctr. & Profit Ctr.?
10) Integration FI-MM.
11) PRD at Invoice Verification.
12) How are the control parameters of doc?
Ans. Screen layout – FSG & PK
Doc header—Doc Type
Doc Line Item – PK.
1. Why we are giving GL for Exp. & Rev. in Cash Journal.
2. Why relevant to cash flow in GL master.
3. Why giving next payment date in APP run F110.
4. Why we are defining each & every branch of Bank as a House Bank.
5. Why is Dep. Area & why we are using it in India .
6. Integration FI-SD & FI-MM.
7. What is Multilevel Method in Assets accounting.
8. Use of Assets class.
9. What is Depreciation key/COD/Dep. area in Asset accounting?
10. In COPA (ke4i) why we are giving condition types (purpose of it).
11. What should be similarities in case of 1: N (co area: company code).
Ans. COA (only operational COA), FYV & currency.
12. If vendor is customer also, is there any setting in master data.
Ans. There is an option in vendor master in control tab à A/c control—customer. Here we will give customer.
13. If we have given wrong depreciation key in asset master & already run the depreciation then how u will rectify.
Ans. We will 1st change the depreciation key in assets master then again post the dep. In AFAB with Repeat option (Radio Button).
14. How u will post TDS on 50000 out of 100000.
15. Business area is assigned with both plant & sales org. so at the time of raising sales order system will consider which business area.
Ans. Plant.
16. Can we make profit centre as one of the characteristics of COPA.
INTERVIEW 5
1) PRD in mm
2) Account modifier in goods issue/receipt.
3) Flow SD, MM
4) Can we make single payment for all open items? APP together payment for all open items.
5) Foreign payment in APP.
6) How u can change the format of cheque.
7) Setup payment method per company code for payment trans. Single payment for marked item & payment per due date (check boxes).
8) Reconciliation in Cost Element Accounting.
9) At the time of Implementation how many Company (Standard) were available there.
10) Can we assign more than 01 a/c in House Bank? If yes, then from which a/c it will use amt. for payment.
11) Which secondary cost element u configure.
12) JE at Goods Issue
Ans. Stock a/c Dr. COGS Dr.
To Gross sales a/c To FG Inventory a/c
13) What account modifier is used at the time of Goods Issue?
14) customising transport request transaction vs workbench transport request
15) How effective will be the Financial Statements generated through Business Areas
16) What influenced you to go in for SAP career
Subscribe to:
Posts (Atom)