SAP FICO,MM,PP

SAP Integration of FICO with Other Modules

2009-01-09T19:34:00.002+05:30

What are the steps for integration of FICO with other modules SD, MM etc. ?

Some basic information :

FI-MM: The integration between FI-MM happens in T-code OBYC.

1. When PO is created :

---- No Entry -----

2. When GR is posted

Inventory Account dr (Transaction Key BSX in OBYC)
To GRIR account (T.Key WRX in T-code OBYC)

3. When Invoice is posted

GRIR account Dr.
Vendor account Cr.

4. Payment made to Vendor

Vendor A/c Dr
To Bank Clearing A/c Cr.

Points to know : Movement Types, Assignment of Movement types to T-keys (T-code OMJJ), Value string (I also need some information on this) , OMWN and OMWB transactions.

---

There is a close integration b/w FI & MM, actually document flows from MM to FI in the following areas such as,

1. Movement Types:

Used to enable the system to find the predefined posting rules determining how the accounts of financial accounting system are to be posted & to update the stock fields in the matrl master data.(Goods Receipt, Goods Issue, etc)

2. Valuation Class:

Assignment of material to grp of gl account, used to determine the gl accounts that are updated as a result of goods movement.

3. Transaction/Event key:

Used to control the storage or filing of documents & assignment of documents.Used to differeniate b/w various transactions such as goods movement tht occur in inventory.

4. Material Type:

Each material should assign mtrl type in mtrl master record used to update whether changes made in qty are updated in material master record & change in value also updated in stock account.

FI-SD Integration: The integration is done in T-code VKOA

1. Sales Order Created

---No Entry---

2. PGI done (Goods issue)

Cost of Goods Sold Dr (Configured in OBYC GBB T-Key)
To Inventory Account

3. Billing document released to Accounting

Customer Account Dr.
To Sales Revenue Account (ERL T-key in Pricing procedure)

Note : The GL account is assigned to this ERL in VKOA

4. Payment Received

Bank Clearing A/c Dr
Customer A/c Cr.

Points to Know : Good to understand the pricing procedure and how the different transaction keys are used like ERL, ERS etc.

FAQs for SAP Financial

2009-01-09T19:34:00.001+05:30

Q1-What are adjustment postings and its use? Give t.codes and paths if possible?

Answer: fb50,f-02 and others could be used for adjustments. These adjustments are to correct any financial representation that has already been booked into the accounts.

Q2-Suppose I have purchased goods of 10 units(raw materials or semi-finished goods) worth Rs10000 from vendor A (suppose) and also made payment for the same. Now during the manufacturing process, it was observed that 3 units are defective, now my question is how do we deal with the defective units in SAP as I have already made payment for the 10 units(i.e Rs10000).

Answer: If you have a GRN against these materials, then the same can be return delivered. An appropriate movement type needs to be configured for the same. As for the payment, raise a credit note on the vendor.

* Using Debit Memo you can get the money for defective 3 units. *-- Gnan Eswari

Q.3-We always copy company code or we can create manually also? If possible give reasons also.

Answer: There are loads of tables that get copied over when copying co codes. This might be incomplete in a manual copy, and hence the manual route is not advisable.

Q.4-In case of APP, when bank master data updated?

Q.5-Suppose in 2004 I have depreciation key 'AB&in 2005 depreciation key I have changed to"CD". In what way my balances would be affected like balances of depreciation,accumulated depreciation,assets etc.

Answer: The difference in the depreciation that is posted already, and what should be posted with historical effect will be posted in the current accounting period.

Q.6 How many chart of accounts can be assigned to company code we can assign company code to chart of account through OB62? Now my question is in what way we can assign three types of chart of account to company code in one transaction code (I might be wrong plz correct me)

Answer: Three, although the group and country chart of accounts are optional. The group chart of accounts is assigned to the
operational chart of accounts, and the only mandatory CoA is the Operational CoA.

Q.7 How many financial statement versions can be assigned to co.code?

Answer: As many FSVs as you want can be assigned to the co code i.e. 1:n as of Co Code: FSV.

I have created Company Code and all other configuration related to the CCode. Also in MM I have created purchase order, created vendor, material etc. I couldn't activate the PO due to the following error messages in red:

1. MAINTAIN TOLERANCE LIMITS FOR TOLERANCE KEY PE ACCOUNT ASSIGNMENT
2. CONTROL INDICATORS FOR CONTROLLING AREA DO NOT EXIST.

I have assigned controlling area to company code and I could see the controlling area in existance via master file and gl verification.

1. MAINTAIN TOLERANCE LIMITS FOR TOLERANCE KEY PE ACCOUNT ASSIGNMENT ----> Please follow this link --> SPRO ---> MM---> Purchasing --> Purchase Order --> Set Tolerance limits for price variance --> Here you have to set for Tolerance keys PE and SE. Just copy them from std co. code.

2. CONTROL INDICATORS FOR CONTROLLING AREA DO NOT EXIST. ---->

In Controlling --> General Controlling --> Maintain Controlling Area --> Maintain Controlling Area --> Activate Components/Control Indicators --> You need to check if you want to activate the order management/activity based costing/commitment management etc.

SAP Questionnaire with Answers for SAP FICO

2009-01-09T19:33:00.002+05:30

What is the difference between company and company code?
A company is the organizational unit used in the legal consolidation module to roll up financial statements of several company codes.
The Company Code is the smallest organizational ! unit for which a complete self-contained set of accounts can be drawn up for purposes of external reporting.

How many chart of accounts can be attached to a company code?
One or more Operative Chart of Accounts can be assigned to a company code.

A COA must be aasigned to a company code. This COA is the operative COA and is used in both FI and CO. One Chart of Account can be assigned to many Company codes i.e., Multiple company codes can either share the same or have separate COA. But a company code (Country specific Company code or International Company code) can have a country specific COA also along with Operative COA. The link between the regular COA and the country COA appears in the alternate number field of the G/L master record.

Eg: If a company's subdidiaries are located in both US & Mexico. We need to configure 2 Company codes - one for US and another for Mexico,for eg U100 and M100. The same way we create 2 COA's one for US & one for Mexico, USCA and MXCA. Mexico has different govt reporting requirements than the US so we will need to define a company code specific to Country Mexico and also create a country specific COA to be used, in addition to normal COA. In tcode OBY6(Comp Code Global Parameters) of CC M100 we define normal COA i.e.,USCA in Chart of Accounts field and MXCA in Country Chart/Accts field.

What are substitutions and validations? What is the precedent?
Validations are used to check settings and return a message if the prerequisite check condition is met.
Substitutions are similar to validations; they actually replace and fill in field values behind the scenes without the user’s knowledge unlike validations that create on-screen msgs to the user.

What is a controlling area?
The Controlling Area is the central organizational unit within CO module. It is representative of a contained Cost Accounting envt where costs and revenues can be managed.

Define relationship between controlling area and company code?
A controlling area may include one or more company codes which must use the same operative chart of accounts as the controlling area. A Controlling Area can contain multiple company code assignments but a single company code can be assigned to only one controlling area.

What is a fiscal year variant?
Fiscal Year is a period of 12 months and SAP provides 4 special periods to posting adjustment Entries. Fiscal year determines posting periods. Posting periods are used to assign business transactions. Fiscal year may be year dependent or year independent.

What are special periods used for?
The Special periods in a fiscal year variant can be used for things like posting audit or tax adjustments to a closed fiscal year.

What do you mean by year dependent in fiscal year variants?
Year Dependent: the financial year is same as calendar year. Starting from 1st Jan to 31st Dec (where posting periods and the calendar months are equal)
Year Independent: the financial year is different from calendar year Starting from 1st April to 31st March (where the posting period months are not equal to calendar year months)

What are shortened fiscal year? When are they used?
Shortened Fiscal Year: a financial year, which has less than 12 periods.

What are posting periods?
The Posting period variant controls which posting periods, both normal and special, are open for each company code. It is possible to have a different posting period variant for each company code in the organization. The posting period is independent of the fiscal year variant.

What are document types and what are they used for?
Document type is the identifier of differentt account transactions like SA for G/L,AA for Asset Accounting etc.The doc. Types controls things like type of the account that can be posted to, the number range assigned to it, and required doc header fields.

How are tolerance group for employees used?
Tolerance group stores Posting amount defaults. Tolerance groups are assigned to User ID’s that ensures only authorized persons can make postings.

What are posting keys? State the purpose of defining posting keys?
Posting keys determine whether a line item entry is a debit or a credit as well as the possible field status for the transaction. Posting keys are SAP delivered. If u want changes like making additional fields optional on payment type posting keys then the best possible action is to copy the posting key that needs to be modified and then modify it.

What are field status groups?
Field status groups control the additional account assignments and other fields that can be posted at the line item level for a G/L account.

SAF FICO Frequently Asked Questions I

2009-01-09T19:33:00.001+05:30

1. Where to assign activity type in cost centers? OR how to link cost centers & activity types?

>> There is no direct assignment. You plan the output for a cost center first in kp26. Then you've to plan the value of that cost center which you budget for a period in kp06. Planned Activity expenditure / Planned Actvty qty gives yoa planned act rate which you can use to valuate your activity confirmations in mfg ordrs. You can also define your own prices,but you have to run the price revaluation if you want to revaluate your actual activity prices.

2. For stat. key figure what is the significance of sender & receiver cost elements & cost centers?

>> Stat key fig are not real account assignments. In simple traditionl terms it is the base to allocate or define praportions with which the cost is allocated. SKFs are used to calculate the debit on a receiver object. These values can be used for assessing common costs which are used by all the other cost centers.

3. How SKF works .. Kindly give me T Codes Also.

>> You create & plan SKF.
Create using KK01 & PLAN the parameters of SKF in KP46

SAP Tips by: Dhiraj

1. Does any one know what is Software life cycle, it was a question asked in an interview.

2. In GL master we have a option "Balance in local currency" and "Account currency". What does it mean?

3. In movement type(MM), what is value & quantity string I know it updates values and quantities in GL with mix of valuvation class, transaction key modifier and GL A/c. But how does it work when doing a mvt type?

4. In FI when doing Special GL transaction what determines the fields statues of the screen and why do we have so many screens followed by it. Is it determined by Posting Keys? is it to determine Account type for which we are using the Special GL and debit and credit?

Q: Software Life Cycle,

Ans: it is nothing but Road Map - five phases like, Project Preparation, Blue print, Realisation, Final preparation and Go-live support.

Q: In GL master we have a option "Balance in local currency" and "Account currency".What does it mean?

Ans: Account currency is that the GL account in which currency do you want to maintain. if you decided that you want maintain in company code currency, you can post any currency in that account.
If not, you want to maintain separate currency for that GL then exchange rate difference will come because the conversion rate.

Balance in local currency - some GL account can't be maintain on open item basis and can't in foreign currency like clearing account and discount account etc., in such case you can assign this indicator to show the balance in local currency.

Q. In movement type(MM), what is value & quantity string I know it updates values and quantities in GL with mix of valuvation class, transaction key modifier and GL A/c. But how does it work when doing a mvt type?

Ans: Basically, the system does not know which GL has to be updated with what. here, we are giving a direction to the system to update the data.

What you said is correct, the system will update the value and qty in the material master. You would have seen some more fields also, like Movement indicator, consumption, value string and transaction event key etc.,

While creating a PO, the system will take the Movement type as a base, with MT, it will identify the MI(movement indicator - used to define whether it is goods movement for production order, purchase order, delivery note etc), and it will identify the consumption,( like it is assets, or consumption or sales order) and it will identify the value string ( it is must to assigned to movement type, through allocation of value string to movement type, system will automatically identify the GL ) and it will post the entry (dr/cr)in the GL based on the transaction and event key figure which is used to determine the debit and credit entry of a GL

SAF FICO Frequently Asked Questions I

2009-01-09T19:32:00.002+05:30

1. Whether any FI doccument will be created during PO(Purchase order)? If please mention the entry also.
2. What factors differentiates from one dunning level and other dunning level?
3. APP There will be many banks in a house bank. If the payment should be maid from particular bank GL account. Where it is need to configured.
4. What are various types of servers in SAP R/3
5. Can anybody explain me FI-MM integartion.pl explain in detail
i. movement types
ii. account class
iii. material types
6. Maximum no. of dunning levels are created?
7. In how many ways APP is configured
8. What is diff between AAM, Recurring entries, Sample doccument?

Find here with the answers for your questions

1.Whether any FI document will be created during PO(Purchase order)?If pl mention the entry also?

Ans: There is no document that is created in FI side during PO. But in controlling there can be a commitment posting to a Cost Center. The offsetting entry is posted at the time of GR.

2.What factors differentiates from one dunning level and other dunning level

Ans: The most important thing that differentiates the dunning levels are the dunning texts. The dunning text defines the urgency of the dunning notice. The other things can be the dunning charges, minimum & maximum amounts etc.

3.APP

There will be many banks in a house bank. If the payment should be maid from particular bank GL account. Where it is configured.

Ans: There can be several accounts in the same house bank. We should assign the GL accounts exclusively at the time of creating the Bank master data and the bank accounts. Accordingly we can do the bank determination in FBZP for the individual banks and the corresponding sub accounts.

Tr code for Defining bank : FI12.

4.What are various types of servers in SAP R/3?

Ans: The Typical SAP landscape looks something like figure 1.4 below:

5.can anybody explain me FI-MM integartion.pl explain in detail

i. Movement types:

Classification key indicating the type of material movement (for example, goods receipt, goods issue, physical stock transfer).

The movement type enables the system to find predefined posting rules determining how the accounts of the financial accounting system (stock and consumption accounts) are to be posted and how the stock fields in the material master record are to be updated.

ii. Valuation class

Assignment of a material to a group of G/L accounts

Along with other factors, the valuation class determines the G/L accounts that are updated as a result of a valuation-relevant transaction or event, such as a goods movement.

The valuation class makes it possible to:

- Post the stock values of materials of the same material type to different G/L accounts
- Post the stock values of materials of different material types to the same G/L account

iii. Transaction/Event Key

Key allowing the user to differentiate between the various transactions and events (such as physical inventory transactions and goods movements) that occur within the field of inventory management.

The transaction/event type controls the filing/storage of documents and the assignment of document numbers.

iv. Material Type

Groups together materials with the same basic attributes, for example, raw materials, semifinished products, or finished products.

When creating a material master record, you must assign the material to a material type. The material type you choose determines:

- Whether the material is intended for a specific purpose, for example, as a configurable
material or process material
- Whether the material number can be assigned internally or externally
- The number range from which the material number is drawn
- Which screens appear and in what sequence
- Which user department data you may enter
- What procurement type the material has; that is, whether it is manufactured in-house or
procured externally, or both

Together with the plant, the material type determines the material's inventory management requirement, that is:

- Whether changes in quantity are updated in the material master record
- Whether changes in value are also updated in the stock accounts in financial accounting

6.Maximum no. of dunning levels are created?

Ans: 9 levels maximum.

7.In how many ways APP is configured?

Tr Code: FBZP

8.What is diff between AAM,Recurring entries,Sample doccument?

Account Assignment Model:

A reference for document entry that provides default values for posting business transactions. An account assignment model can contain any number of G/L account items and can be changed or supplemented at any time. In contrast to sample documents, the G/L account items for account assignment models may be incomplete.

Recurring Entries:

A periodically recurring posting made by the recurring entry program on the basis of recurring entry original documents.

The procedure is comparable with a standing order by which banks are authorized to debit rent payments, payment contributions or loan repayments.

Sample Documents:

Special type of reference document. Data from this document is used to create default entries on the accounting document entry screen.

Unlike an accounting document, a sample document does not update transaction figures but merely serves as a data source for an accounting document.

SAP FI FAQs

2009-01-09T19:32:00.001+05:30

1. There is "company" field in the Company Code global settings. The R/3 help says that it is being used for consolidation. We can use Group Chart of account to do the same.
What is the significance of this field?
What is different between company & company code?

2. When we copy the COA, only one Fin Stat Version is being copied. A COA can have many Fin Stat Version. Why copying of COA allows only one Fin St Ver?

3. What are the information that are not copied to new company code when we copy company code?

4. Whether one group chart of account can be assigned to 2 Operational charts. For Eg. INTA and INTB is being used by group of company as OCA. Whether GCA GRP can be assigned to INTA and INTB?

1A). Company is an organizational unit which is generally used in the legal consolidation to roll up financial statements of several company codes. A company can include one or more company codes. If we are going for Consolidation , we need to enter the 6 character alphanumeric company identifier that relates to this company code.

Company Codes within a Company must use the same chart of accounts and fiscal year. And for consolidation purpose we use Group COA wherein we link the Operating COA thru entering the GL account no. of the Group COA in the GL Account of the Operating COA.

2A). A financial statement version corresponds to the chart of accounts and wherein Individual (operational) accounts are assigned to the corresponding FS item on the lowest level of this version. But as for the rollup of Accounts is not possible in all the FSV which can be copied, n rather can update manually n create multiple FSVs if necessary depending on the Financial Statements which are necessary for the Organisation.

3A). All the Organizational units (Global Data) for a company code will b copied to new company code upon using the copy function except for the transactional data.

4A). Yes, Group COA can be assigned i.e., the GL A/c.No. is linked to the GL Accounts of the both Operating COA . That means Group COA consists of Unique set of Accounts which can be linked to Op.COA –1 and Op.COA –2.

SAP FI/CO Tips by: Sneha Reddy

Ans: Q.No.1. In the SAP system, consolidation functions in financial accounting are based on companies. A company can comprise one or more company codes. for example: Company A have 4 company codes which is existing in different state and / or country. When Company A wants to consolidated the accounts, it will give the common list of accounts which in turn called group chart of accounts. Group chart of account is used to define/ list the GL account uniformly for all company codes.

Ans: Q.No.2. In SAP R/3 system, will allow only one financial statement version for single COA which you need to assign the same while copying the COA. T.code OBY7

Ans: Q.No.3. When you want to create FYV, PPV, COA etc for new company code which is as same as existing company code, then you can copy all the information from the source company code to the target company else whatever is required as per the new company code requirement you can only copy the same, rest you can create as per the requirement. for example Fiscal year for new company code may be shortented fiscal year which is differ from the existing company code. In this case, fiscal year for new company code you have to create and assign it to company code.

Ans: Q.No.4. Operational chart of accounts is something differ from the Group chart of accounts but Group chart of account can be assigned to Operating chart of account 1 and 2 through GL account no.

Operating chart of accounts: The operating chart of accounts contains the GL accounts that you use for posting in your company code during daily activities. Financial accounting and controlling both use this chart of accounts. You have to assign an operating chart of account to a company code.

Group chart of accounts: The group chart of accounts contains the GL accounts that are used by the entire corporate group. This allows the company to provide reports for the entire corporate group.

SAP FI/CO Tips by: Palanivel Elangovan

How do I know which target cost version we are using?

To find out which version is used for your Target Cost, try this menu path

IMG > Controlling -> Product Cost Controlling -> Cost Object Controlling -> Product Cost by Order -> Period-end Closing -> Variance Calculation -> Define Target Cost Versions (tcode OKV6).

How do you change the "Input tax code - Assets without input tax" value for a company in Asset Accounting? Technically, how do you change field MWSKZVA field in table T093C? TIA.

You can used transaction 'OBCL'.

Via customizing: Asset accounting -> Integration with general ledger -> Assign input tax indicator for non-taxable acquisitions

Require GR & IV report

Is there any report on GR pending for IV?

You could try executing program RFWERE00, without postings.
This is the same program which is used for period end closing- regrouping of GR/IR...but for only a report do not create postings.

May be transaction MB5S can help you out.

Retained Profit Account

After you run the GL balance carry forward, you only manage to know the balance carry forward for the retained profit account but you don't how much is actually post to the particular account. You have try almost all of the standard report but still can't find any report that can show you the figure.

The balance carried forward is only a 'calculated' figure and not a 'posted' figure. The break-up of the retained earnings figure is available when you run the balance carried forward report.
You can also derive the balance by selecting only the P&L Accounts for the relevant period. The net balance of these accounts should equal the retained earnings account.

ACH payment configuration

Based on 4.0B. Is it possible to configure the system for ACH payments or do we need to upgrade?

You can use RFFOUS_T to produce an ACH file. You may have to use user exits to write header and trailer records. Please read documentation on this program and it is self-explanatory.

Locking of Planning Data in Profit Center Accounting

How to lock planning data in profit center accounting.

In 4.6 b the transaction is S_ALR_87004395 - Maintain Versions you can lock versions for each fiscal year

Changes in vendor master

Is there a report which shows changes in vendor master data.
Not only for one like MK04 or XK04 but for a range like all changes in vendors per ccode.
(should be similar to customer master transdaction OV51)

You can used report "RFKABL00".

In the accounts payable reporting menu this program can be found via:
Accounts payable -> Adequacy and documentation -> Master data -> Display of vendor changes

(depending on your SAP version of course)

Bank Statement Upload

How to used the program RFEBKATX? This creates two files STATE.TXT and ITEM.TXT.
How are these files imported into SAP?

Try using program RFEBKA00 to upload the two files.

- one is the header file containing the House bank & account information along with the date and the statement number
- the other is the item details.

SAP FI Errors and Probable Solutions

2009-01-09T19:31:00.000+05:30

These are some of the issue for which probable solutions are given, hope they are helpful :

Scenario 1:
I have configured FBZP, Fi12 for house bank. But when I am doing payment run in F110 I am getting following error:

Company codes X1YZ/X1YZ do not appear in proposal 05/03/2006 REMI2.

Diagnosis
No data exists for the specified paying company code X1YZ and the specified sending company code X1YZ in payment proposal 05/03/2006 REMI2.

System response
The payment proposal cannot be edited.

Procedure
Check the flow trace and payment proposal list in order to determine why the specified company codes are not contained in the proposal

Solution :
* That’s generic error for payment run, check whether there are any due items as on date (tcode fbl1n). You can also change the baseline date there and rerun it. if you still get same error.. Check the proposal log, you will find the reason.

* Try to see first whether any open items exist. By using FBL1N.

Scenario 2:
How to make the payment through automatic payment program, through F-110 .What are the prerequisites?

Solution :
For Down payments to be paid using APP we have create a Down Payment request F-47.

Scenario 3:
While doing APP, after, " the payment proposal has been created message " if edit proposal is selected, I am getting the error as "Company code ABC/ABC do no appear in the proposal "

Solution :
This type of error comes when your Payment proposal doesn't have any items to process. Check the parameters and ensure invoices are due as on run date.

Scenario 4 :
While posting customer invoice (FB70) why system asks for G/L account? As per accounting rules customer is debited and Customer reconciliation a/c is credited that ends double entry book keeping rule. Why one more G/L account on top of Recon a/c, which is posted automatically?

Solution :
* Entry gets posted to Customer a/c through reconciliation account. You have to give a GL a/c for revenue.

Your entry would be
Customer (Reconciliation a/c) Dr
To Revenue Cr

* Reconciliation is a fictious entry so you cannot consider as an entry to be entered by the user. This rule is derived from the fact that 'we cannot enter/post directly to RECON account'.

That is why system needs a GL account to make the account balance as zero. Manual entry could be:

Customer a/c Dr
To Domestic Sales a/c
(Sales invoiced posted)

Recon entry is automatically made once you post this entry since you have configured your RECON in the IMG.

Scenario 5 :
I am unable to figure out how to attach my GL Accounts to my company code [copied chart of accounts, have my own company code, assigned my company code to the chart of accounts].

Solution :
You can attach the GL Accounts by just filling the details in the company code segment of the GL A/c. Hence you can use that gl a/c for your co code.
But that would be individually creating the accounts. Right?? How about creating all accounts at one shot. Create in FS00

Scenario 6 :
Difference between Standard Hierarchy and Alternate Hierarchy.

Solution :
Standard Hierarchy is basic structure of company but alternative hierarchy is just for reporting or temporary usage.

Scenario 7:
I have created depreciation keys (diminishing balance) and assigned to asset classes respectively. But at the time of asset master creation the system ask for Useful Life of the asset while my understanding is that in diminishing balance method there is useful life, just percentage is defined.

Solution :
Useful life is required for depreciation change. Normally a company with WDV depreciation may want to write off its assets which have crossed their useful life in 2 or 3 installments. This is achieved by depreciation change, where after useful life, a new method takes over.

Scenario 8 :
I have some conceptual problem in Internal Order.

Solution :
Internal order can only take a statistical posting & cost centre shall take a true posting when the relevant internal order is defined as statistical I/O IN T. code KO01(CONTROL DATA ) tab. So while making a posting in FB50 and assigning both I/O & COST CENTRE as relevant cost object in the transaction you shall get the stated status of these 2 cost object.

Scenario 9 :
In fb50, in the details tab, only if I tick 'calculate tax' will the tax get calculated.
Our user wants this to happen always (by default), i.e. he does not want to tick this for each transaction. Is there any setup to be done for the tax to get calculated always?

Solution :
Even now you are not clear. T_Code FB50 is used for posting GL account only. I fail to understand how you can calculate tax which is generally from purchase / vendor or Sales / Customer oriented through FB50.

In case of local distribution, if we forget to pay taxes on certain items and we need to pass tax entries, then such a case is needed. This can be achieved thru default parameter id for that particular user through transaction code SU3.

In SU3, in Parameters Tab put "XTX" in Parameter ID column and in Parameter Value column put "X".

Scenario 10 :
We have an issue here where by the system is calculating the tax for an invoice with a wrong tax base amount. How do i change the tax base amount? I get the tax rates from VERTEX and they are showing right. Where does the system pull this tax base amount for an Invoice and how can I change it.

Solution :
Kindly check this:
spro - financial accounting - f.a global setting - with holding setting - extended with holding setting -- calculation -- with holding tax type .

Check your withholding tax type, go in it and check the setting.

SAP FICO Sample FAQs II

2009-01-09T19:30:00.000+05:30

1. Since the line item display takes up additional system resources, you should only use it if there is no other way of looking at the line items. So, you should not activate the line item display for the following accounts (Note: we can have more than one correct sentence. Please select the sentences you think they are correct):

a) [ ] P+L Statement.
b) [ ] Reconciliation.
c) [ ] Revenue.
d) [ ] Material Stock.
e) [ ] Tax.

2. Consider the following statements:

2.1. Accounts with open item management must have line item display activated.
2.2. You can activate or deactivate open item management everytime, even if the account hasnÂ’t a zero balance.
2.3. You can select both local and foreign currencies as account currency.
2.4. If the account is the local currency, the account can only be posted to this currency.
2.5. When using the Â“Only Balances in Local CurrencyÂ” indicator in the master data record, transaction figures are only managed for amounts translated into local currency.

Which of the above statements are true (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?
a) [ ] 2.1.
b) [ ] 2.2.
c) [ ] 2.3.
d) [ ] 2.4.
e) [ ] 2.5.

3. True or false?

3.1. The “Only Balances in Local Currency” indicator must not be set in reconciliation accounts for customers or vendors.
a) [ ] True. b) [ ] False.

3.2. The “Only Balances in Local Currency” indicator is usually set in balance sheet accounts that are not managed in foreign currencies and not managed on an open item basis.
a) [ ] True. b) [ ] False.

3.3. Accounts with a foreign currency as an account currency can be posted to any currency.
a) [ ] True. b) [ ] False.

3.4. You can use a group chart of accounts for internal purposes.
a) [ ] True. b) [ ] False.

3.5. The usage of a financial statement version for the group chart of accounts is optional.
a) [ ] True. b) [ ] False.

4. What is the disadvantage of using the group chart of accounts (Please choose the correct sentence)?

a) [ ] Because changes to existing G/L Accounts are effective as soon as they have been saved and could have extensive consequences.
b) [ ] Because accounts with the account currency as local currency can only be posted to this local currency.
c) [ ] Because the company codes use different operational chart of accounts, you cannot carry out cross-company code controlling.
d) [ ] Because the group chart of accounts must be assigned to each operational chart of accounts.
e) [ ] Because you must enter the group account number in the chart of acounts segment of the operational account.

5. Consider the following statements:

5.1. You cannot use the country chart of accounts if you desire to use the cross-company code controlling.
5.2. The disadvantage of using country chart of accounts is the accounting clerks who may be familiar with the country chart of accounts first have to get used to using the operational chart of accounts.
5.3. Reconciliation accounts are updated on a daily basis.

Which of them are false (Please choose the correct sentence)?

a) [ ] 5.1 and 5.2.
b) [ ] 5.1 and 5.3.
c) [ ] 5.2 and 5.3.
d) [ ] all of them.
e) [ ] none of them.

6. Which are the segments of the SD view of the customer account master data (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Client.
b) [ ] Company Code.
c) [ ] Controlling Area.
d) [ ] Sales Area.
e) [ ] Purchasing Organization.

7. Which are the segments of the MM view of the customer account master data (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Client.
b) [ ] Company Code.
c) [ ] Controlling Area.
d) [ ] Sales Area.
e) [ ] Purchasing Organization.

8. What is the segment that makes complete both customer and vendor accounts (Please choose the correct sentence)?

a) [ ] Client.
b) [ ] Company Code.
c) [ ] Controlling Area.
d) [ ] Sales Area.
e) [ ] Purchasing Organization.

9. What characteristics are configured as standard for every customer/vendor account (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Line Item Display.
b) [ ] Company Code.
c) [ ] Currency.
d) [ ] Open Item Management.
e) [ ] Purchasing Organization.

10. Consider the following statements:

10.1. Number ranges for customer/vendor accounts can overlap.
10.2. An one-time account is a special customer/vendor master record which a company rarely do business.
10.3. The account group is used to control the fields displayed in the master record.
10.4. If you enter an alternative payer, the amount to clear the open items due in the account is paid by the alternative payer.
10.5. One number range can only be assigned to one account group.

Which of the above statements are true (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] 10.1.
b) [ ] 10.2.
c) [ ] 10.3.
d) [ ] 10.4.
e) [ ] 10.5.

11. True or false?

11.1. For every bank that is used in the system (for example, as a house bank or as a customer/vendor bank) you have to create a bank master record.
a) [ ] True. b) [ ] False.

11.2. Banks that are used by your company are defined as house banks.a) [ ] True. b) [ ] False.

11.3. You cannot create bank master data when entering bank information in the customer or vendor master record.
a) [ ] True. b) [ ] False.

11.4. Bank Account and G/L Account are the same master data object.
a) [ ] True. b) [ ] False.

11.5. Customers that use the lockbox function can create a batch input session that automatically updates customer banking information in the master record.
a) [ ] True. b) [ ] False.

12. Consider the following statements:

12.1. The system can assign the document numbers or the user can assign
the number during document entry.
12.1. A business transaction creates only one document.
12.3. Document types are defined at company code level.
12.4. Number ranges for document numbers and account types defined for postings are defined by the document types.
12.5. Document types also define whether invoices are posted with the net procedure.

Choose the correct option:

a) [ ] 12.1, 12.4 and 12.5 are correct.
b) [ ] 12.2, 12.4 and 12.5 are correct.
c) [ ] 12.3, 12.4 and 12.5 are correct.
d) [ ] 12.1, 12.3 and 12.4 are correct.
e) [ ] 12.1, 12.2 and 12.5 are correct.

13. What do the posting keys specify (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Whether the line item is connected to a payment transaction or not.
b) [ ] Whether the posting is sales-relevant and the sales figure of the account is to be updated by the transaction, for example, by the posting of a customer invoice.
c) [ ] Whether the line items contain “credit” or “debit” values.
d) [ ] Whether the line items are valid for a business transaction.
e) [ ] Whether the accounts are allowed for posting.

14. Consider the following statements:

14.1. A company code must be assigned to a posting period variant to have the control for posting periods.
14.2.‘+’ symbol represents all account types in the posting period customizing screen.
14.3. The account interval in the posting period customizing screen can be both G/L and subledger accounts.
14.4. The maximum amounts are defined per company code in “tolerance groups”.
14.5. It is not possible to assign tolerance groups to user logon ID’s.

Choose the correct option:

a) [ ] 14.1, 14.4 and 14.5 are correct.
b) [ ] 14.2, 14.4 and 14.5 are correct.
c) [ ] 14.3, 14.4 and 14.5 are correct.
d) [ ] 14.1, 14.2 and 14.4 are correct.
e) [ ] 14.1, 14.2 and 14.5 are correct.

15. What fields of a FI Document Header section can be changed after a document has already been posted (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Fiscal Year.
b) [ ] Reference Number.
c) [ ] Text fields.
d) [ ] Header text.
e) [ ] Posting date.

16. About the change control, what conditions below are applicable (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

16.1. The posting period is already closed.
16.2. The line item is not yet cleared.
16.3. The document is a credit memo for an invoice.
16.4. The document is not a credit memo from a down payment.
16.5. The line item is either a debit in a customer account or a credit in a vendor account.

a) [ ] 16.1.
b) [ ] 16.2.
c) [ ] 16.3.
d) [ ] 16.4.
e) [ ] 16.5.

17. What are the prerequisites to enable negative postings (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] You have to define reversal reasons for negative reversal.
b) [ ] You have to ensure company code permits negative postings.
c) [ ] You have to define the document type that explicitly allows negative postings.
d) [ ] You have to use cleared items.
e) [ ] You have to reset cleared items.

18. What is the purpose of the terms of payment (Please choose the correct sentence)?

a) [ ] Calculate a cash discount and invoice due date.
b) [ ] Calculate the tax amounts.
c) [ ] Enable the cross-company code transactions.
d) [ ] Define the baseline date.
e) [ ] Calculate only the required conditions for SD invoices.

19. Consider the following statements:

19.1. Terms of payments are copied from invoice to credit memos when they are linked to.
19.2. Inserting a Â“VÂ” in the invoice reference field during document entry means the terms of payment are activated in the
non-invoice-related credit memos.
19.3. The account type field in terms of payment basic data screen should be defined separately, to prevent any done change in the term of payment.
19.4. The system cannot define the splitment of an installment payment, at least you define it in the terms of payment.
19.5. The day limits define the dates of the cash discount periods.

Which of the statements above is false (Please choose the correct sentence)?

a) [ ] 19.1.
b) [ ] 19.2.
c) [ ] 19.3.
d) [ ] 19.4.
e) [ ] 19.5.

20. True or false?
20.1. SAP supports tax on sales and purchases, US sales tax, additional taxes and withholding tax as tax systems for different countries.
a) [ ] True. b) [ ] False.
20.2. Only national level of taxation is allowed in the R/3 system.
a) [ ] True. b) [ ] False.
20.3. A tax calculation procedure is assigned to every company code for carrying out tax calculations.
a) [ ] True. b) [ ] False.
20.4.A jurisdiction code is a combination of the codes of tax authorities that tax movements of goods and use their own tax rates.
a) [ ] True. b) [ ] False.
20.5. If you desire to post manual tax postings, you have to flag the “Post Automatically Only” field of the account master record.
a) [ ] True. b) [ ] False.

SAP FICO Sample FAQs I

2009-01-09T19:29:00.000+05:30

1. About evolution in the world of business, we can affirmate that (Please choose the correct sentence):

a) [ ] The internet revolution could turn available to companies the use of ERP functionality.
b) [ ] The next generation of Â“new dimensionÂ” products appeared taking functionality out of the company, to bring value through extending the Internet Revolution.
c) [ ] The internet has driven to a collaborative environment where value is created through collaboration within business comunities.
d) [ ] In the first the companies were looking at Cost reduction and efficiency through integration of business comunities.

2. About the definition of ERP and e-business functionalities, we can say that (Note: we can have more than one correct sentence. Please select the sentences you think they are correct):

a) [ ] ERP offers enterprise centric functionality (general ledger, payroll, order entry) to integrate core, internal processes.
b) [ ] ERP is mySAP Financials and mySAP HR.
c) [ ] ERP is SAP R/3, while e-business is mySAP.com.
d) [ ] About Business Model, ERP can be considered as enterprise centric and e-business, as extended and collaborative.
e) [ ] About Architecture, ERP can be considered as an integrated system and e-business, as an integrated system and an open integration platform.
f) [ ] About Processes, ERP can have them integrated, core within enterprises and collaborative, beyond company boundaries.

3. What is a SAP Business Object (Please choose the correct sentence)?

a) [ ] It is all the transaction data generated via transactions.
b) [ ] It is the instancied class of the Class Builder.
c) [ ] It is composed of tables that are related in a business context, including the related appplication programs and it is maintained in the Class Repository.
d) [ ] It is the representation of a central business object in the real world, such as an employee, sales order, purchase requisition, invoice and so on.
e) [ ] It is a sequence of dialog steps that are consistent in a business context and that belong together logically.

4. About BAPI (Business Application Programming Interface), what is true (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] It is a well-defined interface providing access to processes and data of business application systems.
b) [ ] BAPIs offer a stable, standardized interface for integrating third-party applications and components in the Business Framework.
c) [ ] A BAPI is assigned to one and only one business object.
d) [ ] In the R/3 Enterprise version (4.7) we can use BAPI to create an internal order inside a customized ABAP program.
e) [ ] A business object in the Business Object Repository (BOR) can have many methods from which one or several are implemented as BAPIs.

5. What can we say about ALE (Application Link Enabling, Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Business processes cannot be distributed using ALE.
b) [ ] The ALE concept is related to an enterprise structure with areas that have central tasks and areas with tasks that are decentralized.
c) [ ] The applications are integrated via a central database.
d) [ ] The applications are integrated via the message exchange.
e) [ ] The ALE concept supports the implementation and operation of distributed SAP applications.

6. A company code is:

a) [ ] an independent accounting entity (the smallest organization element for which a complete self-contained set of accounts can be drawn up).
b) [ ] an organizational unit in an enterprise that represents a closed system used for cost accounting purposes.
c) [ ] an organizational unit that provides an additional evaluation level for the purpose of segment reporting, for example.
d) [ ] a dependent accounting entity, according to Fiscal Year.
e) [ ] the highest level in the R/3 system hierarchy.

7. Consider the following sentences:

7.1. The variant principle is a three-step method used in R/3 to assign special properties to one or more R/3 objects.
7.2. One of the disadvantages to use variants is that it can't deal with the maintenance of properties, which are common among several business objects.
7.3. For using the variant principle, you must define the variant, populate it with values and assign it to the R/3 objects.
7.4. This principle is used for Fiscal Years, Posting Periods and so on.

Which of them is false?
a) [ ] 7.1 and 7.2.
b) [ ] 7.1 and 7.3.
c) [ ] 7.1.
d) [ ] 7.2.
e) [ ] 7.3.

8. Consider the following sentences:

8.1. A fiscal year has to be defined by means of separating business transactions into different periods.
8.2. Special periods are used for postings, which are related to the process of the year-end closing. In total, 16 special periods can be used.
8.3. The Fiscal Year variant only defines the amount of periods and their start and finish dates.
8.4. The Fiscal Year is defined as a variant, which is assigned to the chart of accounts.

Which of them are true?

a) [ ] 8.1 and 8.2.
b) [ ] 8.1 and 8.3.
c) [ ] 8.2 and 8.3.
d) [ ] 8.2 and 8.4.
e) [ ] 8.3 and 8.4.

9. What is an independent fiscal year variant (Please choose the correct sentence)?

a) [ ] It is a variant which the postings periods are only equal to the months of the year.
b) [ ] It is a variant which you can define different number of periods, according to the year.
c) [ ] It is a variant which each own fiscal year uses the same number of periods, and the postings periods always start and end at the same day of the year.
d) [ ] It is a variant which allows the use of different number of posting periods.
e) [ ] It is a variant not normally used because of its particularity.

10. Consider the following statements about currencies concepts:

10.1. The currency code identifies each currrency that will be used into R/3 system.
10.2. You have to define all the worldÂ’s currency into R/3 system
10.3. Exchange rate types distinguishes the exchange rates to be considered for various purposes, such as valuation, translation, conversion, planning, etc.

Which of them is true (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] 10.1.
b) [ ] 10.2.
c) [ ] 10.3.
d) [ ] none of them.
e) [ ] all of them.

11. Consider the following sentences:

11.1. A base currency can be assigned to an exchange rate type.
11.2. To deal with exchange rate spreads, two very efficient combinations of the exchange rate tools are using a base currency for the average rate (M) and using the exchange rate spreads to calculate the buying and selling rates (B and G).
11.3. A base currency can be used for an average, a buying or a selling rate.
11.4. The relations between currencies have to be maintained per exchange rate type and currency pair in the translation factors.

Which of these combinations is true?

a) [ ] 11.1, 11.3 and 11.4.
b) [ ] 11.1, 11.2 and 11.4.
c) [ ] 11.2, 11.3 and 11.4.
d) [ ] 11.1, 11.2 and 11.3.
e) [ ] 11.1, 11.2, 11.3 and 11.4.

12. Consider the following sentences about the direct quotation:

12.1. It is also known as price notation.
12.2. The currency value is expressed in units of the foreign currency per unit of local currency.
12.3. For direct quotation, the prefix to indicate the rate is Â“/Â”.

What is the correct option?

a) [ ] 12.1.
b) [ ] 12.2.
c) [ ] 12.3.
d) [ ] none of them.
e) [ ] all of them.

13. Consider the following sentences about the indirect quotation:

13.1. It is also known as volume notation.
13.2. The currency value is expressed in the local currency per unit of foreign currency.
13.3. For indirect quotation, there is no prefix to difference between direct quotation.

What is the correct option?

a) [ ] all of them.
b) [ ] none of them.
c) [ ] 12.3.
d) [ ] 12.2.
e) [ ] 12.1.

14. What of these alternatives are considered master data (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Chart of Accounts.
b) [ ] G/L Accounts.
c) [ ] Vendor.
d) [ ] Customer.
e) [ ] Asset.

15. What can we define into the chart of accounts customizing transaction (OB13 transaction, Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] Description.
b) [ ] Maintenance language.
c) [ ] Length of the company code.
d) [ ] Length of the G/L account number.
e) [ ] Blocking / unblocking chart of accounts.

16. Consider the following sentences about the chart of accounts segment:

16.1. It contains the Company Code, Account number and the field status group.
16.2. Whenever you need to enter information for a company code for an account number, you have to type again the information related to chart of accounts segment.
16.3. Texts can be displayed using the program Â“Account assignment manualÂ”(RFSKTH00).
16.4. Key words facilitate the search for account numbers.

Which of these combinations are false (Note: we can have more than one correct sentence. Please select the sentences you think they are correct)?

a) [ ] 16.1.
b) [ ] 16.2.
c) [ ] 16.3.
d) [ ] 16.4.
e) [ ] none of them.

17. True or false?

17.1. Every company code that needs to use an account from the assigned chart of accounts has to create its own company code segment.
a) [ ] True b) [ ] False

17.2. For P+L statement accounts, the balance is carried forward to the same account.
a) [ ] True b) [ ] False

17.3. In the chart of accounts segment, it is necessary to indicate whether the account will be a balance sheet or a profit+loss statement account.
a) [ ] True b) [ ] False

17.4. Number intervals for G/L account master records can overlap.
a) [ ] True b) [ ] False

17.5. It is not possible to influence the appearance of an account’s master data.
a) [ ] True b) [ ] False

18. Consider the following sentences about field status:

18.1. Fields which are _____________ can be ____________.
18.2. Fields which have an entry that ________________ can be set to
_________ only (even in change mode).

Which of the options below matches the blank spaces of those sentences?

a) [ ] used/supressed for 18.1; must be changed/display for 18.2.
b) [ ] not used/supressed for 18.1; must be changed/display for 18.2.
c) [ ] not used/optional for 18.1; should not be changed/supressed for 18.2.
d) [ ] not used/supressed for 18.1; should not be changed /display for 18.2.
e) [ ] used/optional for 18.1; must be changed/display for 18.2.

19. Consider the following sentences about field status:

19.1. Fields which _____________ can be made ____________.
19.2. Fields that can be entered, but are not required, can be set to _________ entry.

Which of the options below matches the blank spaces of those sentences?

a) [ ] must not have an entry/optional for 19.1; suppresed for 19.2.
b) [ ] must have an entry/supressed for 19.1; suppresed for 19.2.
c) [ ] must have an entry/optional for 19.1; optional for 19.2.
d) [ ] must have an entry/required for 19.1; optional for 19.2.
e) [ ] must not have an entry/required for 19.1; optional for 19.2.

20. Consider the following sentences:

20.1. Reconciliation accounts are general ledger accounts assigned to the business partner master records to record all transactions in the sub-ledger.
20.2. For accounts without line item display, the most important data from the posted line items is stored in a special index table.
20.3. The account currency must be in the local currency.
20.4. Items in accounts with open item management means the G/L accounts should have a offsetting posting for a given business transaction.

Which of these are true (Please choose the correct sentence)?

a) [ ] 20.1 and 20.3.
b) [ ] 20.2 and 20.4.
c) [ ] 20.1 and 20.2.
d) [ ] 20.2 and 20.3.
e) [ ] 20.1 and 20.4.

Answers:
1. C
2. A, C, D, E.
3. D
4. A, B, C, D, E.
5. B, D, E.
6. A

Item Â“BÂ” is the definition of controlling area.
Item Â“CÂ” is the definition of business area.
Item Â“DÂ” is not any definition.
Item Â“EÂ” is the definition of client.

7. D
In fact, the main advantage of using variants is that it is easier to
maintain properties, which are common among several business objects.

8. B
9. C
10. A, C.
Most of the world’s currencies are already defined into R/3 system.

11. B
Be careful: A base currency can only be used for an average rate, not for a selling or a buying rate.

12. A
13. E
14. B, C, D, E.
A chart of accounts is a variant, which contains the structure and the basic information about general ledger accounts.

15. A, B, D, E.
16. A, B.
17. True or false:

17.1. True.
17.2. False. For P+L statement accounts the balance is carried forward to a retained earnings account and the P+L statement account is set to zero.
17.3. True.
17.4. True.
17.5. False. It is possible to influence the appearance of an account’s master data using the field status.

18. D
19. D
20. E

SAP FICO Technical Interview Questions II

2009-01-09T19:28:00.002+05:30

Questions are answer best of my knowledge, if I am wrong, please correct me..anyone…………

1. How can be or in what way baseline date is important in Automatic Payment Program run?

The Baseline date is used to calculate the due date by taking into account the payment terms. On the APP, the baseline date helps to pick the relevant invoices for payment. During the APP run when invoices are pulled into the run, the system checks the ‘Next Payment Date’ before picking the invoices to be paid.

2. Please tell me the procurement cycle how it works?

Procurement cycle – a sales order is placed on a requirement made by a customer, after which it is passed on to create a purchase order (this could either happen based on the requirements on the SO, or a planned SO). the value flow gets passed on to FI at the time of goods movement. In the case of SD, the impact on FI happens only at the time of billing.

3. Difference between Depreciation ,Accumulated Depreciation and APC?
What is APC?

Depreciation – a decrease in the value of an asset due to wear and tear
Accumulated Depreciation – the total amount of depreciation calculated on a particular asset.
APC – refers to Asset transactions other than depreciation

4. What is GR/IR?What journal entries we should pass for this?

The GR/IR – the goods receipt/Invoice Receipt account is used to post to whenever goods that are not yet invoiced have been received or when invoices arrive b4 the the delivery of goods.

During the time between the invoice being created and delivery of goods, there can be a timing difference, in order to accommodate this timing difference, a GR/IR account is maintained temporarily to record the flow .

5. What are the accounting entries take place in MM and SD?

Value from MM to FI is defined in OBYC…. on the material master the flow of values are assigned on the Costing, acctg, etc tabs where the system helps to post the necessary stock values into the appropriate GL accounts. helps to determine, the GL accounts updated when there is a movement of goods.

SD-FI - VKOA

6. Can we assign one Controlling area to two different Company Codes (but the company codes having different
fiscal years/different currencies

Company code should have same financial year, may have different currencies.

You can assign 2 or more company codes to one controlling area as long as the chart of accounts are same. Furthermore, if you have different fiscal year variant in the company code, then make sure that the number of period remain the same.

7. While posting transaction, can we give cost centre / production order at time.

Yes it is posiiable , but in such situation cost centre will be real and production order is stastical.

If you assign both cost center and Prd Order then since Prod. Order are real co object, Cost center entry would be statistical.

8. Which Master data uploads will be done?

The question is not very clear. If you are talking about CO Master data. Then Cost center need to be uploaded. You can use Data Transfer Workbench or write abap for it.

9. Can we run Payment Programe giving ( Hdfc vendor detailes ) City bank in Payment run programe?

Yes can be possible , this can resolved through ranking order and bank optimization in FBZP.

You use use further selection in proposal paramater, if you would like to filter the open item based on the city

10. What does document header control?

Field status.

11. After entering a document can you delete the entry? Can you change the document?
Which fields’ can/not is changed?

Document header cannont be changed, after posting the document you cannot change. only if you want to change the document the reseversal entry.

12. What is a special GL transaction?

The transaction other than A/P and A/R is called the special g/l transaction for ex: Bills of exchange, Interest payable , aqusition

13. How do you reverse cleared documents?

By doing reversal posting.

14. What is base line date? Why is that used? Can this be changed?

For paymentterms it is used. base line date is the due date.

15. How many statistical objects can be selected in when you post an FI document?
Where CCtr, PCtr, OM are active?

Only two.

SAP FICO Technical Interview Questions

2009-01-09T19:28:00.001+05:30

1. Tell me about FI Organizational structure?
Ans: Client
|
Operating Concern
|
Controlling area1 Controlling Area 2
|
Co. Code 1 Co. Code 2
|
Bus area 1 Bus area2 Bus Area3 Bus Area 4

2. How many Normal and Special periods will be there in fiscal year, why do u use special periods?
Ans: 12 Normal posting period and 4 special periods are in the fiscal year which can be used for posting tax and audit adjustments to a closed fiscal year.

3.Where do you open and close periods?
Ans: PPV is used to open and close the periods based on a/c types considering GL Accounts. Tr. Code. OB52.

4.What do you enter in Company code Global settings?
Ans: 4 digit Alphanumeric key.
Name of the company
City
Country
Currency
Language
Address

5.What is document type, and what does it control? Examples.
Ans: Document type is nothing vouchers containing line items. Several business transac! tions can be identified within a particular document type.
It controls the document number ranges.
It controls the Header part of document
IT controls the line item level of the document
Helps filing of physical document

6. What is posting key and what does it control?
Ans: These are special classification keys. Two character numerical key it controls the entry of line items.
Posting key determines Account type, Debit/credit posting, Field status of transaction.

7. What is field status group, what does it control?
Ans: FSG is mandatory field in ! GL Creation. You use this field to define which fields are displayed when you post business transactions to a G/L account.
A field may have one of the following statuses.
- Suppressed
- Display
- Optional
- Required

8. What is chart of account and how many charts of accounts can be assigned to a company?
Ans: Chart of account is a list of all G/L accounts used by one or several company codes.

For each G/L account, the chart of accounts contains the account number, account name, and the information that controls how an account functions and how a G/L account is created in a Company code.

You have to assign a chart of accounts to each company code. This chart of accounts is the Operating chart of accounts and is used for the daily postings in this company code.

You have the following options when using multiple company codes.
You can use the same chart of accounts for all company codes

If the company codes all have the same requirements for the chart of accounts set up, assign all of the individual company codes to the same chart of accounts. This could be the case if all company codes are in the same country.

In addition to the operating chart of accounts, you can use two additional charts of accounts If the individual company codes need different charts of accounts, you can assign up to two charts of accounts in addition to the operating chart of accounts. This could be the case if company codes lie in multiple countries.

The use of different charts of accounts has no effect on the balance sheet and profit and loss statement. When creating the balance sheet or the profit and loss statement, you can choose whether to balance the co! mpany codes which use different charts of accounts together or separately.

9. What does definition of a chart of account contains?
Ans: chart of account key
Name
Maintenance language
Length of the GL Account Number
Controlling Integration
Group chart of accounts (Consolidation)
Block Indicator

10. Can one COA be assigned to several companies?
Ans: yes. One COA can be assigned to several companies.

11) What is account group and what does it control?
Ans: Account group determines which fields you can configure on the G/L master record. It is necessary to have at least two one for B/S and another one for P&L a/c.
It controls the Number ranges of GL A/C.
The status of fields of the master record of GL belongs to company code area.

12) What is reconciliation account; can you directly enter documents in that a/c?
Ans: When you p! ost items to a subsidiary ledger, the system automatically posts the same data to the general ledger. Each subsidiary ledger has one or more reconciliation accounts in the general ledger.
We can’t use reconciliation account for direct postings.

13) How do you control field status of GL master records and from where do you control!
Ans: Field status variant is maintained all FSGs.

14) What are the segments of GL master record?
Ans:
- COA Segment
A/C group
Nature of account
Short text
GL a/c long text
Trading partner
Group Account Number
- Company code segment
Account currency
Tax
Reconciliation a/c for a/c type
OIM,LID,FSG.

15) What does Field status group assigned to a GL master record controls?
Ans: It controls the account assignments that are made to the account. Specifically the field status group controls whether postings to cost centers, internal orders, profitability segments and so on are required, not allowed (suppressed), or optional.

16) What is Country and operational chart of account? Why do you use group chart of account?
Ans: Operational chart of account – Day to day activities It is mandatory.
Country COA – It’s used for legal specific requirement of each country. It’s additional and optional.
Group COA used for consolidation of Company codes. This is for group consolidation purpose.

17) What are all the segments in a Customer/Vendor master record?
Ans: Segments in Customer Segments in Vendor
- General Data segment General data segment
- Company code segment Company code segment
- Sales area segment Purchasing organization Segment

18) What is open line item management? What do you mean by clearing open line items?
Ans: Open item management is further reconciliation function. OIM allows you to display the open and cleared items and amounts in an account. OIM should be used if an offsetting entry is made for every line item posted in the account. The a/c is reconciled and cleared against another account. Ex. Salary clearing account and GR/IR Clearing account.

19) What is residual payment and part payment?
Ans: Residual payment it clears original invoice with incoming amount and create new line item for remaining outstanding amount.
Partial payment it leaves the original invoice amount and creates new
line item for incoming amount.

20) What is internal and external number ranges?
Ans: Internal Number Ranges: Doc. No will be provided by the system automatically in serial order allotting the next available progressive number. The number must be in numerical.
External Number ranges: Doc. No will be given manually by the end user. System will not lock no automatically in this case. User can pick the number randomly. Number may be an alpha numeric.

SAP FICO Interview Questions

2009-01-09T19:27:00.000+05:30

What is APC?

APC stands for Acquisition and Production costs. Acquisition means any asset which you may acquire/ purchase externally. It includes invoice price and other related exp. Associated with it like customs, octroi, freight which you add and arrive at total cost of acquisition for capitalisation of the asset.For ex Say a computer. The total cost which you incurr for the acquisition of the computer including installation will be your APC

Production cost means any asset which is created internally within the organisation. This is normally created by means of AUC and you go on adding cost to the AUC as and when you incurr exp. for the same.For ex. say addition to the office building. Therefore APC incudes any external acquisition or internal construction of exp. which needs to be capitalised.

In OADB under 01 deprn area Acquisition & prod Cost tick is activated. *-- Marazban D. Dalal

This is umapathy, I have intereview tomorrow, if anybody have taken interview with any company, kindly let me know what the questions they will be asking, how will be the interview. How the questions will be on configuration, implementation side and other questions plz.. share with me.

Pl. prepare yourself on the following broad lines:

Implementation exp.:
Brief about the project you did: w.r.t. the main activity of the client, How many plants they had, What modules were implemented, Who were the implementers, What’s the implementation team size, How many were in your module team, What’s your role in the project with respect to the activities you partook in the project, The Enterprise Structure with regard to the no. of Company Codes, any Business Areas or Profit Centers defined, Cost Centers defined, What’s the period of the project, When did they Go-Live?, Any issues you’d solved during ‘Support’ phase?

Questions on conceptual understanding:
a) SAP R/3 definition and 3-Tier Architecture
b) ‘Real time integration’ advantage of SAP
c) ASAP methodology
d) Solution Manager
e) Client / Company / Company Code / Business Area
f) Business Area vs Profit Center Approach
g) How effective will be the Financial Statements generated through Business Areas
h) With Holding Taxes vs Extended WHT
i) Field Status Concepts (G/L master fields controlled through Account Group and Document entry through Field Status Group set in the G/L master)
j) Special G/L transactions
k) Open item management
l) Reconciliation Accounts
m) Subsidiary Ledgers
n) Sort key
o) Negative Postings Allowed
p) Special periods
q) Only balances in local currency
r) Important Posting keys for G/L, A/R, A/P, AA, Stock Entries
s) Assessment vs Distribution
t) Org. Structure for FI
u) Org. Structure for CO
v) Product Costing: How the values flow in the system

Configuration:
a) Extended With Holding Taxes configuration steps – right from creation of WH Tax Types, Codes to Annual Return
b) FI-MM Integration (OBYC configuration with particular reference to Off-Setting entries)
c) FI-SD integration
d) Down Payments transactions
e) Interest – Balances / Arrears
f) Asset Accounting: Asset Class, Main Asset, Sub-Asset, Group Asset, Dep. Areas, Dep. Key, Transaction No.s (100- External acquisition, 210 – Retirement with Revenue, etc.), Imp. Transaction Codes.

General questions:
a) Educational Background
b) What influenced you to go in for SAP career?
c) Functional Career
d) Present earnings vs Expected pay
e) Inclination to relocate

Sample Account Assignment in G/L Account FICO General Ledger

2009-01-02T14:58:00.001+05:30

Where do we specify the sample account in FS00. I created a sample account for all expense accounts to use a particular field status group. Now I want to specify that sample account while creating g/l accounts. how do I do that?

We define Sample account at OB15 and the path is SAP Ref:
IMG\Financial Accounting\GLAccounting\GLAccounts\MasterRecords\Preparations\Additional Activities\Sample Accounts

Step1: Maintain List of Rules types

In this step you just create a code for your Sample Account

Create a New Entry
XXXX Sample account for Pleasecontact1 then save

Step 2: Define Data Tranfer Rules FSK2

In this step you define the data tranfer rule i.e., whether it can be editable or only display etc after a Master recored is created with Sample Account.

Selects the fields that you want to transfer (check boxes)and can be changed and can't be changed etc., then save.

Step 3: Assign Company Code to Rule Type

In this step you will assign your sample account to your company code.

Just select your company and select your Sample account and assing then save.

Step 4: Create Sample Account. FSM1

Now create Sample Account same as you create at FS00, then Save.

Now Sample account is created. Now you can find Sample account field in FS00 (if you assign it company code it won't be displayed) enter Sample account no, and press enter all the fiels that you have selected in Step 2 will be copied (transferred) accrding the the rule (checkboxes) you have selected there.

At Tcode FS00

At FS00 you can see/Edit/Create a GL Master Record which is maintained by the Company Code. Where as Sample Account is not GL Master Record but it is a set of settings/rules which are easily available to create a GL Master Record (understand this point clearly) This sample account does not hold your transaction data nor you can edit or view at FS00.

To use your Sample Account:
1. Go to FS00, give a GL account no (other than Sample account no ofcourse). Select create
2. Then check all fields, whether any field is filled like Currency, Open Item Management, etc *for your confirmation* (obviously every field is empty)
3. Now enter Sample Account no in Sample Account field and give Account Group. press Enter. U will get a message that "Data from changed Sample account was accepted", check data.
4. Now chek all fields again. Now u will find some fields filled with values which you have defined in Data Transfer Rules while creating Sample Account.

This is the purpose of Sample account.

What is Debit note and Credit note? FICO General Ledger

2009-01-02T14:57:00.002+05:30

Debit Memo - It is a sales document used in complaints processing to request a debit memo for a customer. If the prices calculated for the customer were too low, for example, calculated with the wrong scaled prices, you can create a debit memo request. The debit memo request can be blocked so that it can be checked. When it has been approved, you can remove the block. It is like a standard order. The system uses the debit memo request to create a debit memo.

Credit Memo - A transaction that reduces Amounts Receivable from a customer is a credit memo. For eg. The customer could return damaged goods. A debit memo is a transaction that reduces Amounts Payable to a vendor because, you send damaged goods back to your vendor.

Credit memo request is a sales document used in complaints processing to request a credit memo for a customer. If the price calculated for the customer is too high, for example, because the wrong scale prices were used or a discount was forgotten, you can create a credit memo request. The credit memo request is blocked for further processing so that it can be checked. If the request is approved, you can remove the block. The system uses the credit memo request to create a credit memo.

As mentioned above, creating a credit or debit memo request enables you to create credit or debit memos based on a complaint. For this first create a sales document with the order type for a credit or debit memo request. You can create the debit or credit memo requests in the following ways:
– Without reference to an order
– With reference to an existing order
Here you enter which order the complaint refers to.
– With reference to an invoice
Here you enter which invoice the complaint refers to.
In all cases, you specify the value or quantity that should be in the credit or debit memo

You can block the credit or debit memo request from being billed in Customizing. Go to Sales -> Sales Documents -> Sales document header -> Define sales document type and select the billing block field in the billing section. This request can later be reviewed along with similar ones, - if necessary, by another department. The request for a credit or debit memo can then be approved or rejected.

To create Credit / Debit Memo request:
- Use the same procedure that you use for Creating Sales Orders i.d T Code VA01
- Give Order Type as CR for Credit Memo and DR for Debit Memo reuest

While creating the request you have to enter Customer Number, Reason for the request. and Material and its quantity. Once the credit or debit memo request is released you can create credit or debit memo. The credit memo request will be automatically blocked for checking with Billing Block 08 (to check credit memo) & 09 (to check debit memo) for the sales order type “CR” .

If it is not so you can customize the block for credit memo requests in Customizing for SD when you define the order type Sales and Distribution -> Sales -> Sales Documents -> Sales Document Header -> Define sales document types. The release of block is allowed to be removed only by the people who are authorized for it. If the amount is within acceptable limit the block is automatically released otherwise all the people assigned to this job receive a work item in their integrated inbox for release.

If the complaint is not automatically blocked by the settings in Customizing, you can set a delivery or billing block manually.
- Logistics -> Sales and distribution -> Sales.
- Choose Order -> Change.
- Enter the number of the sales document, or use a matchcode to search for it.
- Choose Enter.
- If all the items have been blocked, choose Select all.
- If only some items should be blocked, select the corresponding items.
- Choose Edit -> Fast change of... -> Delivery block or Billing block.
- Enter the delivery or billing block for the header or individual items.
- Choose Copy.
- The system copies (or deletes) the delivery or billing block in all the selected items.
- Save your document.

Various Postings To The FICO GL Account Postings

2009-01-02T14:57:00.001+05:30

During various postings, the GL account postings will be taken place as follows:

For Domestic Procurement of Raw Material
During GR
Material Stock Dr.
GR/IR clearing Cr.
During Excise Invoice Credit
Cenvat Account Dr.
Cenvat Clearing Cr.
During Invoice Verification
Cenvat Clearing Dr.
GR/IR Clearing Dr.
Vendor Payable Cr.

For Domestic proceurement of Capital Goods
During GR
Material Stock Dr.
GR/IR clearing Cr.
During Excise Invoice Credit
Cenvat Account Dr. (50%)
Cenvat On-hold Dr. (50%)
Cenvat Clearing Cr.
During Invoice Verification
Cenvat Clearing Dr.
GR/IR Clearing Dr.
Vendor Payable Cr

Subsequent of Capital Goods
Cenvat Account Dr. (50%)
Cenvat On-hold Cr. (50%)

For Import Procurement of Raw Material
During Customs Duty Clearing invoice
Custom Clearing Dr.
Custom Payable Cr.
During GR
Material Stock Dr.
GR/IR clearing Cr.
During Excise Invoice Credit
Cenvat Account Dr.
Custom Clearing Cr.
During Invoice Verification
GR/IR Clearing Dr.
Vendor Payable Cr.

For Excise Duty Credit of Raw Material without PO

Cenvat Account Dr.
Cenvat Clearing Cr.

For Excise Duty Reversal through Excise JV

Cenvat Clearing Dr.
Cenvat Account Cr.

During Excise Invoice Creation
Cenvat Suspense Account Dr.

Cenvat payable Cr.

For TR6C Challan
PLA Account Dr.
PLA on hold Account Cr.

During Fortnightly Utilization
Cenvat payable Dr.
Cenvat Account Cr.
PLA Account Cr.

Difference between Posting Key and Field Status Variant FICO General Ledger

2009-01-02T14:56:00.002+05:30

What is the use of Field Status Variant. Why it is required?

What is the difference between "Posting Key Variant and Field Status Variant". Why both the things are required to define as both control the fields. What specific fields are controlled this fields.

'Posting Key Variant ' Controls- fields of Posting Key and 'Field Status Variant' controls fields of G/L Account.Fields of G/L Account which are controlled by FSV can see in T.Code OBC4 and Fields of Posting Keys in SPRO-FAGS-Document- Line Item. Both can controls common fields, then SAP applies 'SDRO' rule.

SDRO rule. The fields can be Suppressed, Displayed, Required, Optional.

Posting is key controls
- which type of accounts can be posted to
- whether the line item is debit or credit
- and the field status of the document line item

Where as FSG (group into Field status Variant) controls only the the document line item for that account.

There are only three field status options during document entry:
- Suppressed
- Required
- Optional

If both Posting key and FSV has the same field as Required and optional, system uses the link rules, takes the one which has the highest priority(in this case required).

But in case of Master record Field status which is controlled by Account Group, there are 4 options of field status:
- Suppressed
- Display
- Required
- Optional

Account group defines:
a. length of gl account number
b. no. ranges of the gl account numbers
c. field status of the GL account master data in the company code segment.(which fields to appear when you create a gl account) (to control...double click on your GL account group in Screen transaction code OBD4)

Posting key defines:
a. whether the line item is a debit or credit
b. to which type of account the amount should be posted to(ex: when you use posting key 40, you will be able to post to gl accounts. When you use Posting key 01, you will be only able to post to customer account.
c. document screen layout during posting of a document. (which fields to appear in a document...double click on the posting key and select field status and make the entries as required /optional etc)

Field status group defines:
Document screen layout during posting of a document. (which fields to appear in a document...double click on the field status group and select fields and make the entries as required /optional etc)

LOGIC: you assign field status variant to the company code, FSV is a bundle of field status groups.

ex: in FSG G001 you have made the text as required entry...you assigned the field status group g001 to cash account..so when you use cash account and try to post a document it will definitely prompt you to enter the text (text made as required.)

Both FSG and PK control the same feilds in a document.There is no dominance between FSG and Posting keys..but we should know the allowed combinations....

If text is made required in PK and suppressed in FSG..the system will issue a error msg..Rules for PK...and FSG....is set incorrectly for SGTXT field.

Permissable combinations:

Pk R/S O/S R/o R S O

FSG S/R S/O o/r R S O

Result e SD RD NP NP NP

R = required
s = suppressed
e = error
SD = Suppressed dominates
Rd = required dominates
np = no problem.

What is Hold and Parking of Document? FICO General Ledger

2009-01-02T14:56:00.001+05:30

Hold Document: It is for short term and is used when tranaction Dr or Cr is uncertained and generally its is used for external purpose. eg: Advance from potential customer

Parking Document: Its is for longer period generally used for internal purpose. eg: Advance made for employes.

What is the main purpose of this document. Why we are using this one to in FI? How it is useful?

Parking documents is used when we need to get any clarification regarding some account.

We can temporarily park or store this document till we get it cleared or approved.

Then we can post it.

Remember.... parking does not update the accounts....... it just stores the document..... whereas posting will update the accounts....( for example.... the reducing/increasing of the account balances).

The TC for Parking Documents is F-02 -> enter the required details ->go to the menu (at top ) ->Document-> Park.

To post a parked document : FBV0-> go to the menu Document-> Post.

Other TCs used pertaining to Parking of Documents are :

FV50 : Post / Delete : Single Screen Transaction
FBV2 : Change
FBV3 : Display
FBV4 : Change Header
FBV5 : Display Changes
FBV6 : Refuse

F-63 Park Document - Only transfer amounts in document curr. in invoice

In F-63, there is a checkbox "Only transfer amnts in document curr. invoice", may I know what is the purpose of this checkbox & under what circumstances we will use this checkbox.

"Only transfer amounts in document curr. in invoice"

If we sets this indicator it translates the doc. currency into local currency at the time of parked document.

If we not set this indicator it translates the doc. currency into local currency when posting of document.

Eg: We are parking a document with doc. currency in USD @40- the next day we are posted that document then it is @42- the system takes the exchange rate from the header which was specified in the parked document @40- only. If we not set this indicator it will take at the time of posting of document @42-

Using the Lock Box Files in FICO General Ledger

2009-01-02T14:55:00.002+05:30

I was trying to learn & experiment with using the lock box. However, I don't have any sample files that I can upload and see if it works. Does anyone have any sample bank files and any material that I can use. It would really help me undestand the procedure.

Lockbox is a process provided by a bank where the customer remits his payment to a PO Box at your bank, the bank deposits the check in your account and enters the remittance data from the customer. Then the bank sends the data to you electronically for you to import and apply in SAP-AR.

The structure that the bank uses is usually one of two formats. BAI will provide you the customer information and the check amount but no invoice remittance data. Usually cheaper and works well for a business where customers are paying only one invoice at a time.

BAI-2 offers remittance data but the bank charges more for the service because they have to enter more info.

Look at structures FLB** to see the transfer data.

When the bank sends the customer payment data you use Treasury function FLB2 to import and then process the payments. This process attempts to determine where to apply the payment and will post directly against an invoice, an account to a customer or if it can't even determine the customer it posts into a clearing account (configured) to be resolved.

Configuration for Special Purpose FICO General Ledger

2009-01-02T14:55:00.001+05:30

SAP FI Question:
Why do we use special purpose ledger?
What are the configurations we need to make?

We are using the Special Purpose Ledger for statutory reporting or mangement reporting purpose. It also help us in doing single entry, adjstment posting like income tax deperication.

Steps for cofig.
- Define Table Group
Financial Accounting -> Special Purpose Ledger -> Basic Settings -> Tables -> Definition -> Define Table Group

- Maintain Field Movement
GCF2
IMG Menu Path :
Financial Accounting -> Special Purpose Ledger -> Basic Settings -> Master Data -> Maintain Field Movements

- Maintain Ledger for statutory ledger
GCL2
IMG Menu Path :
Financial Accounting -> Special Purpose Ledger -> Basic Settings -> Master Data -> Maintain Ledgers -> Copy Ledger
Assign Co Code
Assign Activities

- Define Versions
GCW1
IMG Menu Path :
Financial Accounting -> Special Purpose Ledger -> Periodic Processing -> Currency Translation -> Define Versions

- Set Up Exchange Rate Type
OC47
IMG Menu Path :
Financial Accounting -> Special Purpose Ledger ® Periodic Processing -> Currency Translation -> Set Up Exchange Rate Type

- Create Number ranges
GC04
IMG Menu Path :
Financial Accounting -> Special Purpose Ledger -> Actual Posting -> Number Ranges -> Maintain Local Number Ranges

- Create Currency Translation document type
GCBX
IMG Menu Path :
Financial Accounting -> Special Purpose Ledger -> Actual Posting -> Maintain Valid Document Type

- Create Posting period variant
GCP1
IMG Menu Path :
Financial Accounting -> Special Purpose Ledger -> Actual Posting -> Posting Period -> Maintain Local Posting Period

What is "Real Time" Integration? FICO General Ledger

2009-01-02T14:54:00.002+05:30

What is "real time integration" advantage of SAP?

What is the Config for Integration entry? How these entries get formulated in backend?

Real time integration is nothing but the data posting to all the affected areas instantly when an activity is performed. For E.g. When you do a FI-SD integration, when a PGI is posted, the following entry is affected :

1. Cost of Goods Sold Dr 100
To Inventory Account Cr 100

Here the Cost of Goods Sold is an FI entry and Inventory Account related to MM but both of them gets affected immediately when you post a PGI in SD.

The updation of these entries when PGI is done is called Real Time Integration. The affect is shown in all FI, MM and SD modules once you save the entry.

The configuration for the below entry is done in OBYC

1. Cost of Goods Sold Dr 100 (T-Key GBB)
To Inventory Account Cr 100 (T-Key BSX)

The automatic entries are posted to inventory accounts through T-keys to which GL accounts are assigned. These T-keys are assigned to movement types in MM. Please refer to T-code OMWN and OMWB for proper understanding.

Document flow confusion in FI General Ledger

2009-01-02T14:54:00.001+05:30

I have a problem understanding basic things like how a document flows in the Sap system. When posting a customer invoice the subledger will be debited with that amount, now my confusion is will the same amount be posted to the G/L only or the very same amount will also be posted to the reconciliation general ledger - making 3 postings or The recon acc is the G/L . I don't see 3 postings happening because then 2 debits will be Posted against one debit -please clarify me on this.

Also the different between the G/L, Special ledgers and the recon acc is not clear to me.

Customer and Vendor accounts are maintained in a subledger. Posting to these accounts will also be posted to the A/R and A/P reconciliation accounts. All Reconciliation accouints are GL accounts.

All G/L accounts are not reconciliation accounts.

Why is this done?

In large businesses, there will be hundreds/thousands of customers/vendors. All these are personalaccounts (there are three types of accounts: nominal, personal and real). These personal accounts are grouped in to sub-ledgers and any posting to them is reconciled to the G/L
via the reconciliation accounts.

Prakash

For fulfilling completing the double entry system accounting the Reconciliation accounts i.e., Accounts Receivable and Accounts Payable are used. All the Vendors are grouped under Acounts Payable & Customers are grouped under Accounts Receivable. And also always any time the balance in reconciliation account shows as zero.

Ex: 1) Vendors transaction:
For Invoice posting:
Inventory A/c Dr
To Vendor A/c................Accounts Payable A/c (Reconciliation Ledger)
(In SAP since we are linking in the G/L Master Accounts Payable with the Reconciliation Accounts type setting as Vendors. Hence, with one entry 3 Accounts are automatically updated)

Accounts Payable is Liability & Inventory is Current Assets.
For Payment to Vendor:
Vendor A/c Dr.....Accounts Payable A/c
To Bank/ Cash A/c

Ex:2) Customer Transaction:
Sales Invoice Posting:
Customer A/c Dr...Accounts Receivable A/c (Reconciliation A/c)
To Sales A/c

Receipt Posting:
Bank A/c Dr
To Customer A/c...........Accounts Receivable A/c

In Normal Accounting the Reconciliation Accounts are called as Control Accounts and we pass 2 entries for each transaction i.e., Sale, as following:
1) Customer A/c Dr (Sales Ledger / Accounts Receivable A/c)
To Sales A/c (General Ledger)
2) Accounts Receivable A/c Dr (General Ledger)
To Customer A/c (Sales Ledger Adjustment A/c)

Hence, any time the Control A/c balance is zero.

I hope I am clear and now your confusion problem gets resolved.

Ashok

These are basic accounting differentiation for different types of accoutns. This is a basic accounting concept and is not specifically mentioned anywhere in SAP terminology.

Personal accounts:

Accounts in the name of individuals, organizations etc.
For example, Company A A/c, XYZ limited co A/C, Suresh A/C, Indian Bank A/C etc

Real Accounts:

These are accounts related to assets, both real and tangible.
example, furniture a/c, machinery a/c, accounts receivables a/c etc

Nominal Accounts:

These are related to incomes/expenditures and profit/losses.
for example, sales A/c, salary a/c etc

I hope this clears your doubts

Step-by-Step Procedure for Customizing an Electronic Bank Reconciliation Statement FICO General Ledger

2009-01-02T14:53:00.000+05:30

To set up Electronic Bank Statements (EBS)

Processing in SAP for most customers in North America.

1. Create House Bank and Account ID (FI12)

2. Setup EDI Partner Profile for FINSTA Message Type (WE20)

3. Configure Global Settings for EBS (IMG)
- Create Account Symbols
- Assign Accounts to Account Symbols
- Create Keys for Posting Rules
- Define Posting Rules
- Create Transaction Types
- Assign External Transaction Types to Posting Rules
- Assign Bank Accounts to Transaction Types

4. Define Search String for EBS(Optional)
- Search String Definition
- Search String Use

5. Define Program and Variant Selection

Additional information is also available in the SAP Library under:
Financial Accounting > Bank Accounting (FI-BL) > Electronic Bank Statement >
Electronic Account Statement Customizing.

SAP FI Tips by: Ramesh

Bank Reconcilliation Statement

The following are the steps for BRS:

Create Bank Master Data - This can be created through T.Code FI01 or you can also create the house bank through IMG/FA/Bank accounting/Bank account

2. Define House Bank

3. Set up Bank selection payment programe- IMG/FA/ARAP/BT/AUTOIP/PM/Bank selection for payment prg.

a. setup all co codes for payment transaction - Customer and vendors

b.setup paying co codes for payment transactions

c.setup payment method per country

d.setup payment method per co code for payment transaction

e.setup bank determination for payment transaction

Please go for Cheque mangement using T code FCHI (IMG/FA/ARAP/BT/OP/AutoOp/PaymentMedia/CheckManagement) and for void reasons FCHV. You can create Bank Reconcilliation statement by TC FF67 (SAP/AC/Treasury/CashManagement/Incomings/ManualBankStatement) . Don't forget to keep the opening Balance as zero. Use FBEA for post process.

All the steps together will lead to (FF67) Bank reconciliation statement.

How to Configure FICO Reconciliation General Ledger

2009-01-02T14:52:00.002+05:30

In Co, we create Recon accts to keep Fi gl in balance with CO. Not all transactions affect FI gls, best example of it is internal order settlements, they use secondary cost elements and does not affect your G/l accts. To update FI side of it we maintain recon accts. These are primarily for cross company, cross functional and cross business area transactions.

The number of recon accts to be defined is dependant on various factors, like how your management wants to see the reports.. whether they want to classify the cost based on CO object class or by Co types etc..

However the basic config you got to follow is:

1. Activate Recon accts (if you have created CO area newly, it would be active).
use T.code: KALA

2. Assignment of Recon document type to the Controlling area.
T.code: OKKP

3. Creating clearing accts (that you want to us! e for reconciliation. During FI-Co recon.. inter company clearing accounts will be automatically credited or debited and now you need to create offset acct which will show up in P&l acct).
Acct determination set up thru T.code: OBYA

4. Maintain accts for Automatic Recon posting.
T.code OBYB

5. Assign Number ranges to Recon activity.
Tcode OK13 *-- Radha Krishna

Without creating of reconciliation account, can you create vendor? What is the use of reconciliation?

Customer and vendor accounts are sub ledger GL's. We will have to create two reconciliation GLs in viz. Reconciliation GL for Customer and Vendor in chart of accounts.

After, while creating customer and vendor master records, we have to mention respective reconciliation GL in their company code segment details. This recon a/c will show you the net balances in GL for customer and vendor a/cs.

Without creating Vendor you can still create individual GL for each customer and vendor , but then
1) Your list of GL's in chart of account will be very lengthy.
2) Duplication of work as SD/ MM people are also required to create their own list.
3) Cross company code consolidation will not be possible as the chart of accounts will be different.
4) Very difficult to keep track of individual customer/ vendor a/cs.
5) Not advisable even in real time accounting system i.e. manual book keeping.

Change Reconciliation Account of Customer Master FICO General Ledger

2009-01-02T14:52:00.001+05:30

There is no problem to change the account number in the vendor or customer master data, that is :

All Document Items that were created in the old account will be posted in the same old account when you have a payment posting, compensations, etc.

All document created after the change will be posted in the new account as well as the payment postings, compensations and others.

The system will separate the postings in accordance with the moment at the documents were created.

You can do a test in the development client before you do the change in the production.

For example :-

You can create a new reconciliation account because you want the G/L accounts to separate out sales. Just switched the setting in Customer Master and off you go. SAP will recognized the old account for the old postings and used the new account for any new postings.

Here is the official SAP help on the subject:-

You should run balance sheet adjustment program after any reconciliation account change.

The system performs any adjustments required due to the change of reconciliation accounts or G/L accounts. The items from the old reconciliation accounts are allocated to the new accounts.

Since you cannot post to the reconciliation accounts directly, the postings are made to temporary adjustment accounts.

These adjustment accounts should be displayed along with the relevant reconciliation account in the balance sheet. The postings are then reversed after the balance sheet has been created.

The program for sorting the payables and receivables makes the necessary adjustments automatically. This means that you have to define the adjustment account numbers and the posting keys for these postings in the system.

If you purchase and install the FI-LC Consolidation application and have bought up a previous customer or vendor (thus also taking on his/her payables and receivables), please refer to the note in the report documentation on changed reconciliation accounts. To define the account numbers, select the activity Define adjustment accounts for changed reconciliation accounts in the Accounts Receivable and Accounts Payable Implementation Guide.

You should only run this program if your new reconciliation account is classified differently from the original in your FS. e.g.. AR to Intercompany accounts. It will just reclassify the existing balance. The line items will not be transferred. If not then no need to run the program at all.

What is GL At Company Level and Chart of Accounts FICO General Ledger

2009-01-02T14:51:00.002+05:30

Please explain what is meant by general ledger at company code level and chart of accounts level?

General Ledger has two segments i.e.,

1. Chart of Accounts Data (T.Code= FSPO)and
2. Company Code Data (T.Code =FSSO)

GL account master records are divided into two areas to that company code with the same chart of account can use the same GL account. The chart of account area contains the data valid for all company codes, such as Account Number.

The Company code specific area contains data that may vary from one company code to another, such as the currency in which the account may be posted.

Lets, suppose there are not segment both the segments are combined, at that time it will become difficult to copy the Company Code data because the fields may vary in company code. for example Currency, though you have same Chart of Account Data.

Because, GL Accounts has two segments, it will be easy to copy Chart of Accounts data from A company code which matches your requirement and Company Code data of B Company code and you can create a separate chart of account in C company code.

To copy Chart of account data and Company code data seperately, see Alternative method of creating GL Master in IMG screen.

Cost Elements not created for General Ledger Accounts

2009-01-02T14:51:00.001+05:30

How can I find out the GL accounts of Profit & Loss type for which Cost Elements have not been created?
Is there a standard report to throw these exceptions?
What is the best control to ensure that cost element is created for all expense accounts in GL?

Well, the first thing that comes to mind is just download the GL Accounts, download Cost Elements and do a quick VLookup in Excel. That will tell you. That'll take you about 5 minutes or so.

You could try this respective transactions:
OKB2;
OKB3; and
SM35

To prevent creating of GL P&L items without creating the cost elements on 4.6 / 4.7 there is an option to allow the automatic creation of Cost Elements whenever a G/L account is created in a Company Code. i.e. It does not create when an account is created at the Chart of Accounts Level, only when it is created in a Company Code.

To do this;
// Financial Accounting // General ledger Accounting // G/L Accounts // Master Records // Preparations // Edit Chart of Accounts List // Select the Chart of Accounts then;
Integration // Controlling Integration // then I'll let you guess.

Also, you need to specify within controlling which account ranges should be created under which Cost Element Category;
// Controlling // Cost Element Accounting // Master Data // Cost Elements // Automatic Creation of Primary and Secondary Cost Elements // *.*

If this was configured, you could also create a batch file now that would catch up with any cost elements not yet created.

Chart of Account FICO General Ledger

2009-01-02T14:49:00.000+05:30

It defines the structure of G/L accounts. It is a list of G/L accounts used by one or more company codes. In that Chart of account you have to specify the length of G/L accounts.

In SAP all the entries are document oriented. so from the balance sheet of any entry you can identify the root of an entry. so it's like a flow chart in computer terms.

There are threee types of Chart of Account are there.

1.Operative Chart of Accounts
2.Group of Chart of Accounts
3.Country Chart of Accounts.

1.Operative Chart of Accounts is a Chart of Account you use for the company code.

2.For different chart of accounts(operative COA) for different company code, you can group th

e chart of account into one chart of account for internal reporting, but cross company code controlling is not possible, because of different chart of account for different company code.

3.For different country you can have different reporting system. so for different company code you can have different company code, but can have same Operative Chart of account, so cross company code controlling is possible.

Tips by : Jayaraman

What is the difference between standard chart of accounts and the operating chart of accounts? What is the difference between Corporate group chart of accounts, Operating chart of accounts and Group chart of accounts?

To summarise, here is the COA setup in SAP:-

1. Operative chart of account - It is the main chart of account assigned to each company code in OBY6.

2. Group chart of accounts - This is structured in accordance with requirements pertaining to Consolidation

3. Country-specific charts of accounts - These are structured in accordance with legal requirements of the country in question.

Standard COA is a sample COAs provided by SAP. like INT, CAUS etc. You can use them as your operative COA or can create your own operative COA from these standard COA.

Corporate Group COA is same as Group COA.

Assets and Liabilities Closing Tcodes

2008-11-23T16:16:00.000+05:30

1. Process Depreciation Run
Accounting -> Financial accounting -> Fixed assets -> Periodic processing -> Depreciation run -> Execute - AFAB

2. Process Investment Grant
Accounting -> Financial accounting -> Fixed assets -> Periodic processing -> Investment grant
- AR11

3. Process Revaluation
Accounting -> Financial accounting -> Fixed assets -> Periodic processing -> Revaluation for the balance sheet -> Post revaluation - AR29

4. AA Fiscal Year Change
Accounting -> Financial accounting -> Fixed assets -> Periodic processing -> Fiscal year change - AJRW

5. AA Fiscal Year Close – Account Reconciliation
Accounting -> Financial accounting -> Fixed assets -> Periodic processing -> Year-end closing -> Account reconciliation - ABST2

6. AA Fiscal Year Close
Accounting -> Financial accounting -> Fixed assets -> Periodic processing -> Year-end closing -> Execute - AJAB

7. Produce Asset History Sheet
Accounting -> Financial accounting -> Fixed assets -> Info system -> Reports on Asset Accounting -> Balance Sheet Explanations -> International -> Asset History Sheet

Accounting -> Financial accounting -> Fixed assets -> Info system -> Reports on Asset Accounting -> Balance Sheet Explanations -> Country Specifics - various

8. Produce GR/IR Balance Report
Logistics -> Materials Management -> Inventory Management -> Environment -> Balances Display -> List of GR/IR Bals. - MB5S

9. Maintain GR/IR Clearing Account
Logistics -> Materials Management -> Invoice Verification -> Invoice Verification -> Further processing -> Maintain GR/IR acct - MR11

10. Material Revaluations – Price Changes (manual)
Logistics -> Materials Management -> Valuation -> Valuation -> Price Determination -> Change price - MR21

11. Material Revaluations – Debit/Credit Material
Logistics -> Materials Management -> Valuation -> Valuation -> Price Determination -> Debit/cred. material - MR22

12. Product Costing Material Price Change
Accounting -> Controlling -> Product Cost Controlling -> Product Cost Planning -> Material Costing -> Price Update - CK24

13. Material Ledger Closing
Logistics -> Materials Management -> Valuation -> Actual Costing/Material Ledger -> Periodic material valuation -> Post closing - CKMI

14. Materials Management Closing
Logistics -> Materials Management -> Material Master -> Other -> Close period - MMPV

15. Materials Management Closing – Control Posting to Prior Period
Logistics -> Materials Management -> Material Master -> Other -> Allow posting to previous period - MMRV

16. Lowest Value Determination – Market Prices
Logistics -> Materials Management -> Valuation -> Valuation -> Bal. sheet valuation -> Determ. lowest values -> Market prices - MRN0

17. Lowest Value Determination – Range of Coverage
Logistics -> Materials Management -> Valuation -> Valuation -> Bal. sheet valuation -> Determ. lowest values -> Range of coverage - MRN1

18. Lowest Value Determination – Movement Rate
Logistics -> Materials Management -> Valuation -> Valuation -> Bal. sheet valuation -> Determ. lowest values -> Movement rate - MRN2

19. Lowest Value Determination – Loss-Free Valuation
Logistics -> Materials Management -> Valuation -> Valuation -> Bal. sheet valuation -> Determ. lowest values -> Loss-free valuation - MRN3

20. LIFO Valuation
Logistics -> Materials Management -> Valuation -> Valuation -> Bal. sheet valuation -> LIFO Valuation - Various

21. FIFO Valuation
Logistics -> Materials Management -> Valuation -> Valuation -> Bal. sheet valuation -> FIFO Valuation - Various

22. Physical Inventory Processing
Logistics -> Materials Management -> Physical Inventory - Various

23. Analyze GR/IR Clearing Accounts and Display Acquisition Tax
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Regroup -> GR/IR clearing - F.19

24. Define Adjustment Accounts for GR/IR Clearing
IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Regrouping -> Define Adjustment Accounts for GR/IR Clearing - OBYP

25. Print Balance Confirmation
Accounting -> Financial accounting -> A/P or A/R -> Periodic processing -> Closing -> Check/count -> Balance confirmation: Print

Accounting -> Financial accounting -> A/P or A/R -> Periodic processing -> Print correspondence -> Balance confirmation -> Print letters - F.17

26. Configure Balance Confirmation
Accounting -> Financial accounting -> A/P or A/R -> Periodic processing -> Closing -> Check/count ->…

Accounting -> Financial accounting -> A/P or A/R -> Periodic processing -> Print correspondence -> Balance confirmation - F.1B, F.1A

27. Post Individual Value Adjustment
Accounting -> Financial accounting -> Accounts receivable -> Document entry -> Other -> Intern. trans. posting -> Without clearing - F-21

28. Define Account Determination for Flat-Rate Individual Value Adjustment
IMG -> Financial Accounting -> Accounts Receivable and Accounts Payable -> Business Transactions -> Closing -> Valuate -> Valuations -> Define Accounts OBB0

29. Configure Flat-Rate Individual Value Adjustment
IMG -> Financial Accounting -> Accounts Receivable and Accounts Payable -> Business Transactions -> Closing -> Valuate -> Valuations ->… SPRO

30. Calculate Flat-Rate Individual Value Adjustment
Accounting -> Financial accounting -> Accounts receivable -> Periodic processing -> Closing -> Valuate -> Further valuations - F107

31. Writing-Off Doubtful Receivables
Accounting -> Financial accounting -> Accounts receivable -> Document entry -> Other -> Intern. trans. psting -> With clearing - F-30

32. Customizing Exchange Rates
IMG -> General Settings -> Currencies - Various

33. Maintaining Exchange Rates
Accounting -> Financial accounting -> General ledger -> Environment -> Current settings -> Enter exchange rates - OB08

34. Customizing Valuation Methods
IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Valuating -> Foreign Currency Valuation -> Define Valuation Methods - OB59

35. Foreign Currency Open Item Valuation
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing>>Valuate -> Valuation of Open Items in Foreign Currency - F.05

36. Account Determination for Exchange Rate Differences
IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Valuating -> Foreign Currency Valuation -> Prepare automatic postings for foreign currency valuation - OBA1

37. Regroup Receivables and Payables
Accounting -> Financial accounting -> A/P or A/R -> Periodic processing -> Closing -> Regroup -> Receivables/ Payables - F101

38. Account Determination for Regrouping Receivables and Payables
IMG -> Financial Accounting -> Accounts Receivable and Accounts Payable -> Business Transactions -> Closing -> Regrouping - OBBV, OBBW, OBBX

39. Revalue Foreign Currency G/L Account Balances
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Valuate -> Foreign Currency Valuation of Inventory - F.06

40. Posting Accruals/Deferrals
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Valuate -> Enter Accrual/Deferral Doc. - FBS1

41. Posting Accrual/Deferral Reversal
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Valuate -> Reverse Accrual/Deferral Document - F.81

42. Generate Recurring Entry Posting
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Recurring Entries -> Execute - F.14

Profit and Loss Closing FICO Tcodes

2008-11-23T16:15:00.002+05:30

1. Capital Investment Projects – Settle Order to AUC
Accounting -> Investment management -> Internal orders -> Period-end closing -> Single functions -> Settlement ->… Various

2. Capital Investment Projects – Settle AUC to asset in service
Accounting -> Investment management -> Fixed assets -> Postings -> Cap. asset u. const. -> Settle AIBU

3. PP/CO Period-End Closing
Logistics -> Production -> Production Control -> Period-end closing ->…

Accounting -> Controlling -> Product Cost Controlling -> Cost Object Controlling -> Product Cost by Order -> Period-End Closing -> Single Functions ->… Various

4. Internal Order Period-End Closing
Accounting -> Controlling -> Internal Orders -> Period-end closing -> Single functions ->… Various

5. Cost Center Accounting Period-End Closing
Accounting -> Controlling -> Cost Center Accounting -> Period-end closing -> Single functions ->… Various

6. Profitability Analysis Period-End Closing
Accounting -> Controlling -> Profitability Analysis -> Actual Postings -> Cost Center Costs/Process Costs ->… KEU5, KEG5, CPAE

7. Lock Controlling Transactions
Accounting -> Controlling -> Cost Center Accounting -> Environment -> Period lock -> Change OKP1

8. Reconciliation Ledger
Accounting -> Controlling -> Cost Element Accounting -> Actual postings -> Reconciliation withFI KALC

9. Reconciliation Ledger Follow Up Postings
Accounting -> Controlling -> Cost Element Accounting -> Environment -> Reconciliation ledger -> Follow up posting KAL1

10. Reconciliation Ledger Configuration
IMG -> Controlling -> Overhead Cost Controlling -> Cost and Revenue Element Accounting -> Reconciliation Ledger Various

11. Post payroll information to accounting
Human Resources -> Payroll -> (Country-specific) PC00_ M99_ CIPE

12. Configure Payroll for posting to accounting
IMG -> Payroll -> Payroll: (country-specific) Various Customizing Technical, Organizational and Documentary Steps

13. Define fiscal year variants
IMG -> Financial Accounting -> Financial Accounting Global Settings -> Fiscal Year -> Maintain Fiscal Year Variant (Maintain Shortened Fisc. Year) OB29

14. Allocate fiscal year variant to a company code
IMG -> Financial Accounting -> Financial Accounting Global Settings -> Fiscal Year -> Assign Company Code to a Fiscal Year Variant OB37

15. Define Variants for Open Posting Periods
IMG -> Financial Accounting -> Financial Accounting Global Settings -> Document -> Posting Periods -> Define Variants for Open Posting Periods OBBO

16. Allocate Posting Period Variant to Company Code
IMG -> Financial Accounting -> Financial Accounting Global Settings -> Document -> Posting Periods -> Assign Variants to Company Code OBBP

17. Open and Close Posting Periods
Accounting -> Financial accounting -> General ledger -> Environment -> Current settings -> Open and Close Posting Periods OB52

18. Carry Forward Balance to New Fiscal Year
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Carry Forward -> Balances F.16

19. Define Retained Earning account
IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Carrying Forward -> Define Retained Rarnings Account OB53

20. Schedule Manager
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Schedule Manager SCMA

21. Subsequent Business Area/Profit Center Adjustment – Calculate
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Regroup -> Balance Sheet Readjustment -> Calculate F.5D

22. Subsequent Business Area/Profit Center Adjustment – Post
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Regroup -> Balance Sheet Readjustment -> Post F.5E

23. Transfer B/S Items to Profit Center Accounting
Accounting -> Enterprise Controlling -> Profit Center Accounting -> Actual Postings -> Period-End Closing -> Transfer Payables/Receivables 1KEK

24. PCA Balance Carried Forward
Accounting -> Enterprise Controlling -> Profit Center Accounting -> Actual Postings -> Period-End Closing -> Carrying Forward of Balances 2KES

25. Profit and Loss Adjustment
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Regroup -> Profit and Loss Adjustment F.50

26. Run Compact Document Journal
Accounting -> Financial accounting -> General ledger -> Information system -> General Ledger Reports -> Document -> General -> Compact Document Journal

27. Create Balance Audit Work Files
IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Documenting -> Define Accumulated Work Files for Balance Audit Trail OBBQ

28. Run Monthly Balance Audit Trail for Open Item Accounts
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> Open item accounts -> Open Item Account Balance Audit Trail from the Document File

29. Run Monthly Balance Audit Trail for Other Accounts
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> All accounts -> General Ledger from the Document File

30. Create Extract for Accumulated Open Item Balance Audit Trail
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> Open item accounts -> From balance audit trail -> Extract for Accumulated Open Item Audit Trail

31. Run Accumulated Open Item Balance Audit Trail
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> Open item accounts -> From balance audit trail -> Accts Detailed Listing from Open Item Account Accumulated Audit Trail

32. Create Extract for Accumulated Balance Audit Trail for Other Accounts
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> All accounts -> From balance audit trail -> Extract for the Accumulated Historical Balance Audit Trail

33. Run Accumulated Balance Audit Trail for Other Accounts
Accounting -> Financial accounting -> General ledger -> Periodic processing -> Closing -> Document -> Balance audit trail -> All accounts -> From balance audit trail -> Account Details from Historical Accumulated Balance Audit Trail

The Financial Statement Closing Tcodes

2008-11-23T16:15:00.001+05:30

1. Maintain Financial Statement Versions

IMG -> Financial Accounting -> General Ledger Accounting -> Business Transactions -> Closing -> Documenting -> Define Financial Statement Versions - OB58

2. Execute a Balance Sheet (RFBILA00)

Information Systems -> Accounting -> Financial Accounting -> General ledger -> Information System-> Balance Sheet

Accounting -> Financial accounting -> General ledger -> Information system -> General LedgerReports -> Balance Sheet/Profit and Loss Statement/Cash Flow -> General -> Actual/Actual Comparisons -> Balance Sheet/P+L - F.01

3. Execute a Balance Sheet Drill Down Report

Accounting -> Financial accounting -> General ledger -> Information system -> General LedgerReports -> Balance Sheet/Profit and Loss Statement/Cash Flow -> General - Various

4. Execute a Cost-of-Sales Profit and Loss Report

Accounting -> Financial accounting -> Special Purpose Ledger -> Tools -> Report Painter -> Report -> Display -> Library 0F1, Report 0F-GUV1 -> Display -> Execute - GRR3

Useful Reports Tcode in Financial Accounting

2008-11-23T16:14:00.000+05:30

GENERAL LEDGER

Information Systems

1.  Structured Account Balances (Balance Sheet & P&L Account  in FS Version Format)           

                                                      S_ALR_87012279
2.  GL Account Balances (Totals & Balances )             S_ALR_87012301
3.  GL Line Items                                        S_ALR_87012282
4.  Statements for GL Accounts, Customers & Vendors      S_ALR_87012332
5.  Document Journal                                     S_ALR_87012287
6.  Compact Document Journal                             S_ALR_87012289
7.  Line Item Journal                                    S_ALR_87012291
8.  Display of Changed Documents                         S_ALR_87012293
9.  Invoice Numbers assigned Twice                       S_ALR_87012341
10. Gaps in Document Number Assignments                  S_ALR_87012342
11. Posting Totals Document Type wise                    S_ALR_87012344
12. Recurring Entry Documents                            S_ALR_87012346

Master Data

13. Chart of Accounts                                    S_AL:R_87012326
14. GL Account List                                      S_AL:R_87012328
15. Display Changes to GL Accounts                       S_ALR_87012308
16. Financial Statement Version                          FSE2

CASH & BANK REPORTS

1. Check Information List                                FCH6
2. Check Register                                        FCHN
3. Check Number Ranges                                   S_P99_41000102


TAX REPORTS & REGISTERS

1. List of Internally generated Excise Invoices          J1I7

2. Capital Goods Transfer of Credit                      J2I8                       
3. List of GRs without Excise Invoice                    J1IGR

4. List of SubContract Challans                          J1IFR

5. CENVAT Register                                       J2I9
(Monthly Return under Rule 57AE of the Central excise Rules from
which Monthly Return under Rule 7 of the CENVAT Credit Rules 2001)

6. Registers : RG 23A/C Part I &II , RG1, PLA            J1I5,J2I5,J2I6

ACCOUNTS RECEIVABLE

Information Systems

1. Bill Holdings (Bill of Exchange Receivable List  with ALV facility)
                                                      S-ALR_87009987
2. Customer Balances in Local Currency                   S_ALR_87012172
3. Customer Line Items                                   S_ALR_87012197
4. Due Dates Analysis for Open Items                     S_ALR_87012168
5. List of Customer Open Items                           S_ALR_87012173
6. Customer Evaluation with Open Item Sorted List        S_ALR_87012176
7. Customer Payment History                              S_ALR_87012177
8. Customer Open Item Analysis (Overdue Items Balance)   S_ALR_87012178
9. List of Customer Cleared Line Items                   S_ALR_87012198
10.List of Down Payments open at key date                S_ALR_87012199
11. Debit & Credit Notes Register – Monthly              S_ALR_87012287
12. Customer wise Sales                                  S_ALR_87012186                       

ACCOUNTS PAYABLE

(Note : Similar Reports available for A/R are available for A/P also)

1. Vendor Balances                                       S_ALR_87012082
2. Vendor Debit/Credit Memo Register                     S_ALR_87012287

Is there a Report displaying Master data, that is a list of vendors showing name, address, payment
method, etc ( everything about vendor). Is their any report like that and what's the table name to display
all vendor master data too.

Go to this menu:
Financial Accounting -> Accounts Payable -> Information System -> Reports for AP accounting -> Master Data.

How to get Report of Withholding Tax along with Vendor Name. What is the T-Code or Path for this report?

You can get the withholding tax report for vendor by using these t.codes:
S_P00_07000134 - Generic Withholding Tax Reporting
S_PL0_09000447 - Withholding tax report for the vendor

Which reports we can use for the receivables to be checked on daily basis?

Go to SAP Easy Access main menu.
Go To Accounting -> FI Acc -> customer(receivables) -> information system -> reports .
Here you can get all the standard reports for receivables.

FI Transaction Code List II

2008-11-23T16:13:00.001+05:30

FG99    Flexible G/L: Report Selection
FGI0    Execute Report
FGI1    Create Report
FGI2    Change Report
FGI3    Display Report
FGI4    Create Form
FGI5    Change Form
FGI6    Display Form
FGIB    Background Processing
FGIC    Maintain Currency Translation Type
FGIK    Maintain Key Figures
FGIM    Report Monitor
FGIO    Transport Reports
FGIP    Transport Forms
FGIQ    Import Reports from Client 000
FGIR    Import Forms from Client 000
FGIT    Translation Tool - Drilldown Report.
FGIV    Maintain Global Variable
FGIX    Reorganize Drilldown Reports
FGIY    Reorganize Report Data
FGIZ    Reorganize Forms
FGM0    Special Purpose Ledger Menu
FGRP    Report Painter
FGRW    Report Writer Menu
FI01    Create Bank
FI02    Change Bank
FI03    Display Bank
FI04    Display Bank Changes
FI06    Mark Bank for Deletion
FI07    Change Current Number Range Number
FI12    Change House Banks/Bank Accounts
FI12CORE   Change House Banks/Bank Accounts
FI13    Display House Banks/Bank Accounts
FIBB    Bank chain determination
FIBC    Scenarios for Bank Chain Determin.
FIBD    Allocation client
FIBF    Maintenance transaction BTE
FIBHS   Display bank chains for house banks
FIBHU   Maintain bank chains for house banks
FIBL1   Control Origin Indicator
FIBL2   Assign Origin
FIBL3   Group of House Bank Accounts
FIBPS   Display bank chians for partners
FIBPU   Maintain bank chains for partner
FIBTS   Dis. bank chains for acct carry over
FIBTU   Main. bank chains for acctCarry over
FIHC    Create Inhouse Cash Center
FILAUF_WF_CUST  Store Order: Workflow Customizing
FILE    Cross-Client File Names/Paths
FILINV_WF_CUST  Store Inventory:Workflow Customizing
FINA    Branch to Financial Accounting
FINF    Info System Events
FINP    Info System Processes
FITP_RESPO      Contact Partner Responsibilities
FITP_SETTINGS   Settings for Travel Planning
FITP_SETTINGS_TREE      Tree Maintenance Current Settings
FITVFELD        Tree
FJA1    Inflation Adjustment of G/L Accounts
FJA2    Reset Transaction Data G/L Acc.Infl.
FJA3    Balance Sheet/P&L with Inflation
FJA4    Infl. Adjustment of Open Items (FC)
FJA5    Infl. Adj. of Open Receivables (LC)
FJA6    Infl. Adj. of Open Payables (LC)
FJEE    Exercise Subscription Right
FK01    Create Vendor (Accounting)
FK02    Change Vendor (Accounting)
FK02CORE   Maintain vendor
FK03    Display Vendor (Accounting)
FK04    Vendor Changes (Accounting)
FK05    Block Vendor (Accounting)
FK06    Mark Vendor for Deletion (Acctng)
FK08    Confirm Vendor Individually (Acctng)
FK09    Confirm Vendor List (Accounting)
FK10    Vendor Account Balance
FK10N   Vendor Balance Display
FK10NA  Vendor Balance Display
FK15    Transfer vendor changes: receive
FK16    Transfer vendor changes: receive
FKI0    Execute Report
FKI1    Create Report
FKI2    Change Report
FKI3    Display Report
FKI4    Create Form
FKI5    Change Form
FKI6    Display Form
FKIB    Background Processing
FKIC    Maintain Currency Translation Type
FKIK    Maintain Key Figures
FKIM    Report Monitor
FKIO    Transport Reports
FKIP    Transport Forms
FKIQ    Import Reports from Client 000
FKIR    Import Forms from Client 000
FKIT    Translation Tool - Drilldown Report.
FKIV    Maintain Global Variable
FKIX    Reorganize Drilldown Reports
FKIY    Reorganize Report Data
FKIZ    Reorganize Forms
FKMN
FKMT    FI Acct Assignment Model Management
FLB1    Postprocessing Lockbox Data
FLB2    Import Lockbox File
FLBP    Post Lockbox Data
FLCV    Create/Edit Document Template WF
FM+0    Display FM Main Role Definition
FM+1    Maintain FM Main Role Definition
FM+2    Display FM Amount Groups
FM+3    Maintain FM Amount Groups
FM+4    Display FM Budget Line Groups
FM+5    Maintain FM Budget Line Groups
FM+6    Display FM Document Classes
FM+7    Maintain FM Document Classes
FM+8    Display FM Activity Categories
FM+9    Maintain FM Activity Categories
FM+A    Display Doc.Class->Doc.Cat. Assgmt
FM+B    Maintain Doc.Clase->Doc.Cat.Assgmt
FM03    Display FM Document
FM21    Change Original Budget
FM22    Display Original Budget
FM25    Change Supplement
FM26    Display Supplement
FM27    Change Return
FM28    Transfer Budget
FM29    Display Return
FM2D    Display Funds Center Hierarchy
FM2E    Change Budget Document
FM2F    Display Budget Document
FM2G    Funds Center Hierarchy
FM2H    Maintain Funds Center Hierarchy
FM2I    Create Funds Center
FM2S    Display Funds Center
FM2T    Change Releases
FM2U    Change Funds Center
FM2V    Display Releases
FM3D    Display Commitment Item Hierarchy
FM3G    Commitment Item Hierarchy
FM3H    Maintain Commitment Item Hierarchy
FM3I    Create Commitment Item
FM3N    Commitment Items for G/L Accounts
FM3S    Display Commitment Item
FM3U    Change Commitment Item
FM48    Change Financial Budget: Initial Scn
FM48_1  PS-CM: Create Planning Layout
FM48_2  PS-CM: Change Planning Layout
FM48_3  PS-CM: Display Planning Layout
FM49    Display Financial Budget: Init.Scrn
FM4G    Budget Structure Element Hierarchy
FM5I    Create Fund
FM5S    Display Fund
FM5U    Change Fund
FM5_DEL    Delete fund preselection
FM5_DISP   Display fund preselection
FM5_SEL    Preselection Fund
FM6I    Create Application of Funds
FM6S    Display Application of Funds
FM6U    Change Application of Funds
FM71    Maintain Cover Pools
FM72    Assign FM Acct Asst to Cover Pool
FM78    Charact.Groups for Cover Pools
FM79    Grouping Chars for Cover Pool
FM7A    Display Cover Eligibility Rules
FM7I    Create Attributes for FM Acct Asst
FM7P    Maintain Cover Eligibility Rules
FM7S    Display Cover Eligibility Rules
FM7U    Maintain Cover Eligibility Rules
FM9B    Copy Budget Version
FM9C    Plan Data Transfer from CO
FM9D    Lock Budget Version
FM9E    Unlock Budget Version
FM9F    Delete Budget Version
FM9G    Roll Up Supplement
FM9H    Roll up Original Budget
FM9I    Roll Up Return
FM9J    Roll Up Releases
FM9K    Change Budget Structure
FM9L    Display Budget Structure
FM9M    Delete Budget Structure
FM9N    Generate Budget Object
FM9P    Reconstruct Budget Distrbtd Values
FM9Q    Total Up Budget
FM9W    Adjust Funds Management Budget
FMA1    Matching: Totals and Balances (CBM)
FMA2    Matching: CBM Line Items and Totals
FMA3    Matching: FI Line Items (CBM)
FMA4    Matching: FI Bank Line Items (CBM)
FMAA    Matching: Line Items and Totals (FM)
FMAB    Matching: FI FM Line Items
FMAC    Leveling: FM Commitment Line Items
FMAD    Leveling: FI-FM Totals Records
FMAE    Display Change Documents
FMAF    Level Line Items and Totals Items
FMB0    CO Document Transfer
FMB1    Display Security Prices-Collect.
FMBI    Use Revenues to Increase Expend.Bdgt
FMBUD005   FIFM Budget Data Export
FMBUD006   FIFM Budget Data Import
FMBV    Activate Availability Control
FMC2    Customizing in Day-to-Day Business
FMCB    Reassignment: Document Selection
FMCC    Reassignment: FM-CO Assignment
FMCD    Reassignment: Delete Work List
FMCG    Reassignment: Overall Assignment
FMCN    Reassignment: Supplement.Acct Assgt
FMCR    Reassignment: Display Work List
FMCT    Reassignment: Transfer
FMD1    Change Carryforward Rules
FMD2    Display Carryforward Rules
FMDM    Monitor Closing Operations
FMDS    Copy Carryforward Rules
FMDT    Display Carryforward Rules
FME1    Import Forms from Client 000
FME2    Import Reports from Client 000
FME3    Transport Forms
FME4    Transport Reports
FME5    Reorganize Forms
FME6    Reorganize Drilldown Reports
FME7    Reorganize Report Data
FME8    Maintain Batch Variants
FME9    Translation Tool - Drilldown
FMEB    Structure Report Backgrnd Processing
FMEH    SAP-EIS: Hierarchy Maintenance
FMEK    FMCA: Create Drilldown Report
FMEL    FMCA: Change Drilldown Report
FMEM    FMCA: Display Drilldown Report
FMEN    FMCA: Create Form
FMEO    FMCA: Change Form
FMEP    FMCA: Display Form
FMEQ    FMCA: Run Drilldown Report
FMER    FMCA: Drilldown Tool Test Monitor
FMEURO1 Create Euro FM Area
FMEURO2 Refresh Euro Master Data
FMEURO3 Display Euro FM Areas
FMEURO4 Deactivate Euro FM Areas
FMEV    Maintain Global Variable
FMF0    Payment Selection
FMF1    Revenue Transfer
FMG1    FM: Create Commitment Item Group
FMG2    FM: Change Commitment Item Group
FMG3    FM: Display Commitment Item Group
FMG4    FM: Delete Commitment Item Group
FMG5    Generate BS Objects fr.Cmmt Item Grp
FMHC    Check Bdgt Structure Elements in HR
FMHG    Generate Bdgt Struc Elements in HR
FMHGG   Generate BS Elements f. Several Fnds
FMHH    Master Data Check
FMHIST  Apportion Document in FM
FMHV    Budget Memo Texts
FMIA    Display Rules for Revs.Incr.Budget
FMIB    Increase Budget by Revenues
FMIC    Generate Additional Budget Incr.Data
FMIL    Delete Rules for Revs Incr. Budget
FMIP    Maintain Rules for Revs.Incr.Budget
FMIS    Display Rules for Revs.Incr.Budget
FMIU    Maintain Rules for Revs.Incr.Budget
FMJ1    Fiscal Year Close: Select Commitment
FMJ1_TR Settlement: Select Commitment
FMJ2    Fiscal Year Close: Carr.Fwd Commts
FMJ2_TR Settlement: Transfer Commitment
FMJ3    Reverse Commitments Carryforward
FMJA    Budget Fiscal Year Close: Prepare
FMJA_TR Budget Settlement: Prepare
FMJB    Determine Budget Year-End Closing
FMJB_TR Budget Settlement: Determine
FMJC    Budget Fiscal-Year Close: Carry Fwd
FMJC_TR Budget Settlement: Transfer
FMJD    Reverse Fiscal Year Close: Budget
FMLD    Ledger Deletion
FMLF    Classify Movement Types
FMN0    Subsequent Posting of FI Documents
FMN1    Subsequent Posting of MM Documents
FMN2    Subsequent Posting of Billing Docs
FMN3    Transfer Purchase Req. Documents
FMN4    Transfer Purchase Order Documents
FMN5    Transfer Funds Reservation Documents
FMN8    Simulation Lists Debit Position
FMN8_OLD   Simulation Lists Debit Position
FMN9    Posted Debit Position List
FMN9_OLD   Posted Debit Position List
FMNA    Display CBA Rules
FMNP    Maintain CBA Rules
FMNR    Assign SN-BUSTL to CBA
FMNS    Display CBA Rules
FMNU    Maintain CBA Rules
FMP0    Maintain Financial Budget
FMP1    Display Financial Budget
FMP2    Delete Financial Budget Version
FMR0    Reconstruct Parked Documents
FMR1    Actual/Commitment Report
FMR2    Actual/Commitment per Company Code
FMR3    Plan/Actual/Commitment Report
FMR4    Plan/Commitment Report w.Hierarchy
FMR5A   12 Period Forecast: Actual and Plan
FMR6A   Three Period Display: Plan/Actual
FMRA    Access Report Tree
FMRB    Access Report Tree
FMRE_ARCH    Archive Earmarked Funds
FMRE_EWU01   Earmarked Funds: Euro Preprocessing
FMRE_EWU02   Earmarked Funds: Euro Postprocessing
FMRE_SERLK   Close Earmarked Funds
FMRP18  Clear Subsequent Postings
FMSS    Display Status Assignment
FMSU    Change Assigned Status
FMU0    Display Funds Reservation Doc.Types
FMU1    Maintain Funds Reservation Doc.Types
FMU2    Display Funds Reservtn Fld Variants
FMU3    Maintain Funds Resvtn Field Variants
FMU4    Display Funds Reservation Fld Groups
FMU5    Maintain Funds Reservatn Fld Groups
FMU6    Display Funds Reservtn Field Selctn
FMU7    Maintain Funds Resvtn Field Selctn
FMU8    Display Template Type for Fds Resvtn
FMU9    Maintain Template Type for Fds Resvn
FMUA    Dispay Fds Res.Template Type Fields
FMUB    Maintain Fds Res.Template Type Flds
FMUC    Display Funds Res. Reference Type
FMUD    Maintain Funds Res.Reference Type
FMUE    Display Funds Res.Ref.Type Fields
FMUF    Maintaine Fds Rsvtn Ref.Type Fields
FMUG    Display Reasons for Decision
FMUH    Maintain Reasons for Decisions
FMUI    Display Groups for Workflow Fields
FMUJ    Maintain Groups for Workflow Fields
FMUK    Display Fields in Groups for WF
FMUL    Maintain Fields in Groups for WF
FMUM    Display Field Selctn ->Variant/Group
FMUN    Display Field Seln->Variant/Group
FMUV    Funds Resvtn Field Status Var.Asst
FMV1    Create Forecast of Revenue
FMV2    Change Forecast of Revenue
FMV3    Display Forecast of Revenue
FMV4    Approve Forecast of Revenue
FMV5    Change FM Acct Asst in Fcst of Rev.
FMV6    Reduce Forecast of Revenue Manually
FMVI    Create Summarization Item
FMVO    Fund Balance Carryforward
FMVS    Display Summarization Item
FMVT    Carry Forward Fund Balance
FMVU    Change Summarization Item
FMW1    Create Funds Blocking
FMW2    Change Funds Blocking
FMW3    Display Funds Blocking
FMW4    Approve Funds Blocking
FMW5    Change FM Acct Asst in Funds Blkg
FMWA    Create Funds Transfer
FMWAZ   Payment Transfer
FMWB    Change Funds Transfer
FMWC    Display Funds Transfer
FMWD    Approve Funds Transfer
FMWE    Change FM Acct Asst in Funds Trsfr
FMX1    Create Funds Reservation
FMX2    Change Funds Reservation
FMX3    Display Funds Reservation
FMX4    Approve Funds Reservation
FMX5    Change FM Acct Asst in Funds Resvn
FMX6    Funds Reservation: Manual Reduction
FMY1    Create Funds Commitment
FMY2    Change Funds Commitment
FMY3    Display Funds Precommitment
FMY4    Approve Funds Precommitment
FMY5    Change FM Acct Asst in Funds Prcmmt
FMY6    Reduce Funds Precommitment Manually
FMZ1    Create Funds Commitment
FMZ2    Change Funds Commitment
FMZ3    Display Funds Commitment
FMZ4    Approve Funds Commitment
FMZ5    Change FM Acct Asst in Funds Commt
FMZ6    Reduce Funds Commitment Manually
FMZBVT  Carry Forward Balance
FMZZ    Revalue Funds Commitments
FM_DL07    Delete Worklist
FM_DLFI    Deletes FI Documnts Transferred from
FM_DLFM    Deletes all FM Data (fast)
FM_DLOI    Deletes Cmmts Transferred from FM
FM_EURO_M  Parameter maintenance for euro conv.
FM_RC06    Reconcile FI Paymts-> FM Totals Itms
FM_RC07    Reconcile FI Paymts-> FM Line Items
FM_RC08    Reconcile FM Paymts -> FM Line Items
FM_RC11    Select Old Payments
FM_S123    GR/IR: Post OIs to FM Again
FM_S201    Post Payments on Account to FIFM
FM_SD07    Display Worklist
FN-1    No.range: FVVD_RANL (Loan number)
FN-4    Number range maintenance: FVVD_PNNR
FN-5    Number range maintenance: FVVD_SNBNR
FN-6    Number range maintenance: FVVD_RPNR
FN09    Create Borrower's Note Order
FN11    Change borrower's note order
FN12    Display borrower's note order
FN13    Delete borrower's note order
FN15    Create borrower's note contract
FN16    Change borrower's note contract
FN17    Display borrower's note contract
FN18    Payoff borrower's note contract
FN19    Reverse borrower's note contract
FN1A    Create other loan contract
FN1V    Create other loan contract
FN20    Create borrower's note offer
FN21    Change borrower's note offer
FN22    Display borrower's note offer
FN23    Delete borrower's note offer
FN24    Activate borrower's note offer
FN2A    Change other loan application
FN2V    Change other loan contract
FN30    Create policy interested party
FN31    Change policy interested party
FN32    Display policy interested party
FN33    Delete policy interested party
FN34    Policy interested party in applic.
FN35    Policy interested party in contract
FN37    Loan Reversal Chain
FN3A    Display other loan application
FN3V    Display other loan contract
FN40    Create other loan interested party
FN41    Change other loan interested party
FN42    Display other loan interested party
FN43    Delete other loan interested party
FN44    Other loan interest.party in applic.
FN45    Other loan interested prty in cntrct
FN4A    Delete other loan application
FN4V    Delete other loan contract
FN5A    Other loan application in contract
FN5V    Payoff other loan contract
FN61    Create collateral value
FN62    Change collateral value
FN63    Display collateral value
FN70    List 25
FN72    List 54
FN80    Enter manual debit position
FN81    Change manual debit position
FN82    Display manual debit position
FN83    Create waiver
FN84    Change waiver
FN85    Display waiver
FN86    Enter debit position depreciation
FN87    Change debit position depreciation
FN88    Display debit position depreciation
FN8A    Manual Entry: Unsched. Repayment
FN8B    Manual Entry: Other Bus. Operations
FN8C    Manual Entry: Charges
FN8D    Post Planned Records
FNA0    Policy application in contract
FNA1    Create mortgage application
FNA2    Change mortgage application
FNA3    Display mortgage application
FNA4    Complete mortgage application
FNA5    Mortgage application in contract
FNA6    Create policy application
FNA7    Change policy application
FNA8    Display policy application
FNA9    Delete policy application
FNAA    Reactivate deleted mortgage applic.
FNAB    Reactivate deleted mortg. int.party
FNAC    Reactivate deleted mortgage contract
FNAD    Reactivate deleted policy applicat.
FNAE    Reactivate deleted policy contract
FNAG    Reactivate deleted other loan applic
FNAH    Reactivate del. other loan int.party
FNAI    Reactivate deleted other loan cntrct
FNAK    Select file character
FNAL    Reactivate deleted BNL contract
FNAM    Reactivate deleted policy contract
FNASL   Loans: Account Analysis
FNB1    Transfer to a Loan
FNB2    Transfer from a Loan
FNB3    Document Reversal - Loans
FNB8    BAV Information
FNB9    BAV transfer
FNBD    Loans-Automatic bal.sheet transfer
FNBG    Guarantee charges list
FNBU    DARWIN- Loans accounting menu
FNCD    Transfer Customizing for Dunning
FNCW1   Maintain Standard Role
FNCW2   Transaction Release: Adjust Workflow
FNDD    Convert Dunning Data in Dunn.History
FNEN    Create Loan
FNENALG   Create General Loan
FNENHYP   Create Mortgage Loan
FNENPOL   Create Policy Loan
FNENSSD   Create Borrower's Note Loan
FNF1    Rollover: Create file
FNF2    Rollover: Change file
FNF3    Rollover: Display file
FNF4    Rollover: Fill file
FNF9    Rollover: Evaluations
FNFO    ISIS: Create file
FNFP    ISIS: Change file
FNFQ    ISIS: Display file
FNFR    ISIS: Fill file
FNFT    Rollover: File evaluation
FNFU    Rollover: Update file
FNG2    Total Loan Commitment
FNG3    Total Commitment
FNI0
FNI1    Create mortgage application
FNI2    Change mortgage application
FNI3    Display mortgage application
FNI4    Delete mortgage application
FNI5    Mortgage application to offer
FNI6    Mortgage application in contract
FNIA    Create interested party
FNIB    Change interested party
FNIC    Display interested party
FNID    Delete interested party
FNIE    Reactivate interested party
FNIH    Decision-making
FNIJ    Create credit standing
FNIK    Change credit standing
FNIL    Display credit standing
FNIN    Create collateral value
FNIO    Change collateral value
FNIP    Display collateral value
FNK0    Multimillion Loan Display (GBA14)
FNK1    Loans to Managers (GBA15)
FNKO    Cond.types - Cond.groups allocation
FNL1    Rollover: Create Main File
FNL2    Rollover: Change Main File
FNL3    Rollover: Displ. Main File Structure
FNL4    New business
FNL5    New business
FNL6    New business
FNM1    Automatic Posting
FNM1S   Automatic Posting - Single
FNM2    Balance sheet transfer
FNM3    Loans reversal module
FNM4    Undisclosed assignment
FNM5    Automatic debit position simulation
FNM6    Post dunning charges/int.on arrears
FNM7    Loan reversal chain
FNMA    Partner data: Settings menu
FNMD    Submenu General Loans
FNME    Loans management menu
FNMEC   Loans Management Menu
FNMH    Loans management menu
FNMI    Loans information system
FNMO    Loans Menu Policy Loans
FNMP    Rollover
FNMS    Loans Menu Borrower's Notes
FNN4    Display general file
FNN5    Edit general file
FNN6    Display general main file
FNN7    Edit general main file
FNN8    Display general main file
FNN9    Edit general overall file
FNO1    Create Object
FNO2    Change Object
FNO3    Display Object
FNO5    Create collateral
FNO6    Change collateral
FNO7    Display collateral
FNO8    Create Objects from File
FNO9    Create Collateral from File
FNP0    Edit rollover manually
FNP4    Rollover: Display file
FNP5    Rollover: Edit File
FNP6    Rollover: Display main file
FNP7    Rollover: Edit main file
FNP8    Rollover: Display overall file
FNP9    Rollover: Edit overall file
FNQ2    New Business Statistics
FNQ3    Postprocessing IP rejection
FNQ4    Customer Inc. Payment Postprocessing
FNQ5    Transact.type - Acct determinat.adj.
FNQ6    Compare Flow Type/Account Determin.
FNQ7    Generate flow type
FNQ8    Automatic Clearing for Overpayments
FNQ9    Int. adjustment run
FNQF    Swiss interest adjustment run
FNQG    Swiss special interest run
FNR0    Loans: Posting Journal
FNR6    Insur.prtfolio trends - NEW
FNR7    Totals and Balance List
FNR8    Account statement
FNR9    Planning list
FNRA    Other accruals/deferrals
FNRB    Memo record update
FNRC    Accruals/deferrals reset
FNRD    Display incoming payments
FNRE    Reverse incoming payments
FNRI    Portfolio Analysis Discount/Premium
FNRS    Reversal Accrual/Deferral
FNS1    Collateral number range
FNS4    Cust. list parameters for loan order
FNS6    Installation parameter lists
FNS7    Loan Portfolio Trend Customizing
FNSA    Foreign currency valuation
FNSB    Master data summary
FNSL    Balance reconciliation list
FNT0    Loan correspondence (Switzerland)
FNT1    Autom. deadline monitoring
FNT2    Copy text modules to client
FNUB    Treasury transfer
FNV0    Payoff policy contract
FNV1    Create mortgage contract
FNV2    Change mortgage contract
FNV3    Display mortgage contract
FNV4    Delete mortgage contract
FNV5    Payoff mortgage contract
FNV6    Create policy contract
FNV7    Change policy contract
FNV8    Display policy contract
FNV9    Delete policy contract
FNVA    Create paid off contracts
FNVCOMPRESSION  Loans: Document Data Summarization
FNVD    Disburse Contract
FNVI    Loans: General Overview
FNVM    Change Contract
FNVR    Reactivate Contract
FNVS    Display Contract
FNVW    Waive Contract
FNWF    WF Loans Release: List of Work Items
FNWF_REP   Release Workflow: Synchronization
FNWO    Loans: Fast Processing
FNWS    Housing statistics
FNX1    Rollover: Create Table
FNX2    Rollover: Change Table
FNX3    Rollover: Display Table
FNX6    Rollover: Delete Table
FNX7    Rollover: Deactivate Table
FNX8    Rollover: Print Table
FNXD    TR-EDT: Documentation
FNXG    List of Bus. Partners Transferred
FNXU    List of Imported Loans
FNY1    New Business: Create Table
FNY2    New Business: Change Table
FNY3    New Business: Display Table
FNY6    New Business: Delete Table
FNY7    New Business: Deactivate Table
FNY8    New Business: Print Table
FNZ0    Rejections report
FNZ1    Postprocessing payment transactions
FNZA    Account Determination Customizing
FN_1    Table maint. transferred loans
FN_2    Table maintenance transf. partner
FN_UPD_FELDAUSW   Update Program for Field Selection

FI Transaction Code List I

2008-11-23T16:12:00.000+05:30

How to reverse a cleared documents?
The following procedure is to be followed to reverse the cleared document.
1. Reset the cleared document and reverse the document.
Path # Accounting --> financial Accounting --> C/L --> Document--> Reset Cleared items - T. code : FBRA
In this screen select resetting and reverse radio button and give the reversal reason. : 01 and save the settings.
*-- Maddipati

F-01    Enter Sample Document
F-02    Enter G/L Account Posting
F-03    Clear G/L Account
F-04    Post with Clearing
F-05    Post Foreign Currency Valuation
F-06    Post Incoming Payments
F-07    Post Outgoing Payments
F-18    Payment with Printout
F-19    Reverse Statistical Posting
F-20    Reverse Bill Liability
F-21    Enter Transfer Posting
F-22    Enter Customer Invoice
F-23    Return Bill of Exchange Pmt Request
F-25    Reverse Check/Bill of Exch.
F-26    Incoming Payments Fast Entry
F-27    Enter Customer Credit Memo
F-28    Post Incoming Payments
F-29    Post Customer Down Payment
F-30    Post with Clearing
F-31    Post Outgoing Payments
F-32    Clear Customer
F-33    Post Bill of Exchange Usage
F-34    Post Collection
F-35    Post Forfaiting
F-36    Bill of Exchange Payment
F-37    Customer Down Payment Request
F-38    Enter Statistical Posting
F-39    Clear Customer Down Payment
F-40    Bill of Exchange Payment
F-41    Enter Vendor Credit Memo
F-42    Enter Transfer Posting
F-43    Enter Vendor Invoice
F-44    Clear Vendor
F-46    Reverse Refinancing Acceptance
F-47    Down Payment Request
F-48    Post Vendor Down Payment
F-49    Customer Noted Item
F-51    Post with Clearing
F-52    Post Incoming Payments
F-53    Post Outgoing Payments
F-54    Clear Vendor Down Payment
F-55    Enter Statistical Posting
F-56    Reverse Statistical Posting
F-57    Vendor Noted Item
F-58    Payment with Printout
F-59    Payment Request
F-60    Maintain Table: Posting Periods
F-62    Maintain Table: Exchange Rates
F-63    Park Vendor Invoice
F-64    Park Customer Invoice
F-65    Preliminary Posting
F-66    Park Vendor Credit Memo
F-67    Park Customer Credit Memo
F-90    Acquisition from purchase w. vendor
F-91    Asset acquis. to clearing account
F-92    Asset Retire. frm Sale w/ Customer
F.01    ABAP/4 Report: Balance Sheet
F.02    Compact Journal
F.03    Reconciliation
F.04    G/L: Create Foreign Trade Report
F.05    Foreign Currency Val.: Open Items
F.06    Foreign Currency Valuation:G/L Assts
F.07    G/L: Balance Carried Forward
F.08    G/L: Account Balances
F.09    G/L: Account List
F.0A    G/L: FTR Report on Disk
F.0B    G/L: Create Z2 to Z4
F.10    G/L: Chart of Accounts
F.11    G/L: General Ledger from Doc.File
F.12    Advance Tax Return
F.13    ABAP/4 Report: Automatic Clearing
F.14    ABAP/4 Report: Recurring Entries
F.15    ABAP/4 Report: List Recurr.Entries
F.16    ABAP/4 Report: G/L Bal.Carried Fwd
F.17    ABAP/4 Report: Cust.Bal.Confirmation
F.18    ABAP/4 Report: Vend.Bal.Confirmation
F.19    G/L: Goods/Invoice Received Clearing
F.1A    Customer/Vendor Statistics
F.1B    Head Office and Branch Index
F.20    A/R: Account List
F.21    A/R: Open Items
F.22    A/R: Open Item Sorted List
F.23    A/R: Account Balances
F.24    A/R: Interest for Days Overdue
F.25    Bill of Exchange List
F.26    A/R: Balance Interest Calculation
F.27    A/R: Periodic Account Statements
F.28    Customers: Reset Credit Limit
F.29    A/R: Set Up Info System 1
F.2A    Calc.cust.int.on arr.: Post (w/o OI)
F.2B    Calc.cust.int.on arr.: Post(with OI)
F.2C    Calc.cust.int.on arr.: w/o postings
F.2D    Customrs: FI-SD mast.data comparison
F.2E    Reconciliation Btwn Affiliated Comps
F.2F    Management Acct Group Reconciliation
F.2G    Create Account Group Reconcil. G/L
F.30    A/R: Evaluate Info System
F.31    Credit Management - Overview
F.32    Credit Management - Missing Data
F.33    Credit Management - Brief Overview
F.34    Credit Management - Mass Change
F.35    Credit Master Sheet
F.36    Adv.Ret.on Sls/Pur.Form Printout(DE)
F.37    Adv.rept.tx sls/purch.form print (BE
F.38    Transfer Posting of Deferred Tax
F.39    C FI Maint. table T042Z (BillExcTyp)
F.40    A/P: Account List
F.41    A/P: Open Items
F.42    A/P: Account Balances
F.44    A/P: Balance Interest Calculation
F.45    A/P: Set Up Info System 1
F.46    A/P: Evaluate Info System
F.47    Vendors: calc.of interest on arrears
F.48    Vendors: FI-MM mast.data comparison
F.4A    Calc.vend.int.on arr.: Post (w/o OI)
F.4B    Calc.vend.int.on arr.: Post(with OI)
F.4C    Calc.vend.int.on arr.: w/o postings
F.50    G/L: Profitability Segment Adjustmnt
F.51    G/L: Open Items
F.52    G/L: Acct Bal.Interest Calculation
F.53    G/L: Account Assignment Manual
F.54    G/L: Structured Account Balances
F.56    Delete Recurring Document
F.57    G/L: Delete Sample Documents
F.58    OI Bal.Audit Trail: fr.Document File
F.59    Accum.Clas.Aud.Trail: Create Extract
F.5A    Accum.Clas.Aud.Trail: Eval.Extract
F.5B    Accum.OI Aud.Trail: Create Extract
F.5C    Accum.OI Audit Trail: Display Extr.
F.5D    G/L: Update Bal. Sheet Adjustment
F.5E    G/L: Post Balance Sheet Adjustment
F.5F    G/L: Balance Sheet Adjustment Log
F.5G    G/L: Subseq.Adjustment(BA/PC) Sp.ErA
F.5I    G/L: Adv.Rep.f.Tx on Sls/Purch.w.Jur
F.61    Correspondence: Print Requests
F.62    Correspondence: Print Int.Documents
F.63    Correspondence: Delete Requests
F.64    Correspondence: Maintain Requests
F.65    Correspondence: Print Letters (Cust)
F.66    Correspondence: Print Letters (Vend)
F.70    Bill/Exchange Pmnt Request Dunning
F.71    DME with Disk: B/Excha. Presentation
F.75    Extended Bill/Exchange Information
F.77    C FI Maintain Table T045D
F.78    C FI Maintain Table T045B
F.79    C FI Maintain Table T045G
F.80    Mass Reversal of Documents
F.81    Reverse Posting for Accr./Defer.Docs
F.90    C FI Maintain Table T045F
F.91    C FI Maintain Table T045L
F.92    C FI Maintain T012K (Bill/Exch.)
F.93    Maintain Bill Liability and Rem.Risk
F.97    General Ledger: Report Selection
F.98    Vendors: Report Selection
F.99    Customers: Report Selection
F/LA    Create Pricing Report
F/LB    Change pricing reports
F/LC    Display pricing reports
F/LD    Execute pricing reports
F00     SAPoffice: Short Message
F000    Accounting
F010    ABAP/4 Reporting: Fiscal Year Change
F01N    Debit position RA single reversal
F01O    Vacancy RU single reversal
F01P    Accruals/deferrals single reversal
F01Q    Debit position MC single reversal
F01R    MC settlement single reversal
F01S    Reverse Periodic Posting
F01T    Reverse Acc./Def. General Contract
F040    Reorganization
F041    Bank Master Data Archiving
F042    G/L Accounts Archiving
F043    Customer Archiving
F044    Vendor Archiving
F045    Document Archiving
F046    Transaction Figures Archiving
F101    ABAP/4 Reporting: Balance Sheet Adj.
F103    ABAP/4 Reporting: Transfer Receivbls
F104    ABAP/4 Reporting: Receivbls Provisn
F107    FI Valuation Run
F110    Parameters for Automatic Payment
F111    Parameters for Payment of PRequest
F13E    ABAP/4 Report: Automatic Clearing
F150    Dunning Run
F48A    Document Archiving
F53A    Archiving of G/L Accounts
F53V    Management of G/L Account Archives
F56A    Customer Archiving
F58A    Archiving of Vendors
F61A    Bank archiving
F64A    Transaction Figure Archiving
F66A    Archiving of Bank Data Storage
F8+0    Display FI Main Role Definition
F8+1    Maintain FI Main Role Definition
F8+2    Display FI Amount Groups
F8+3    Maintain FI Amount Groups
F8B4    C FI Maintain Table TBKDC
F8B6N   C FI Maintain Table TBKPV
F8BC    C FI Maintain Table TBKFK
F8BF    C FI Maintain Table T042Y
F8BG    Maintain Global Data for F111
F8BH    Inconsistencies T042I and T042Y
F8BJ    Maintain Clearing Accts (Rec.Bank)
F8BK    Maintain ALE-Compatible Pmnt Methods
F8BM    Maintain numb.range: Payment request
F8BN    Corr.Acctg Documents Payment Block
F8BO    Payment request archiving
F8BR    Levels for Payment Requests
F8BS    Detail display of payment requests
F8BT    Display Payment Requests
F8BU    Create payment runs automatically
F8BV    Reversal of Bank-to-Bank Transfers
F8BW    Reset Cleared Items: Payt Requests
F8BZ    F111 Customizing
F8XX    Payment Request No. Ranges KI3-F8BM
FA39    Call up report with report variant
FAKA    Config.: Show Display Format
FAKP    Config.: Maintain Display Format
FAR1    S FI-ARI Maint. table T061A
FARA    S FI-ARI Maint. table T061P/Q
FARB    C FI-ARI Maint. table T061R
FARI    AR Interface: Third-party applicatns
FARY    Table T061S
FARZ    Table T061V
FAX1    BC sample SAP DE 2.1
FAX2    BC sample 2 SAP DE 2.1
FB00    Accounting Editing Options
FB01    Post Document
FB02    Change Document
FB03    Display Document
FB03Z   Display Document/Payment Usage
FB04    Document Changes
FB05    Post with Clearing
FB05_OLD Post with clearing
FB07    Control Totals
FB08    Reverse Document
FB09    Change Line Items
FB10    Invoice/Credit Fast Entry
FB11    Post Held Document
FB12    Request from Correspondence
FB13    Release for Payments
FB1D    Clear Customer
FB1K    Clear Vendor
FB1S    Clear G/L Account
FB21    Enter Statistical Posting
FB22    Reverse Statistical Posting
FB31    Enter Noted Item
FB41    Post Tax Payable
FB50    G/L Acct Pstg: Single Screen Trans.
FB60    Enter Incoming Invoices
FB65    Enter Incoming Credit Memos
FB70    Enter Outgoing Invoices
FB75    Enter Outgoing Credit Memos
FB99    Check if Documents can be Archived
FBA1    Customer Down Payment Request
FBA2    Post Customer Down Payment
FBA3    Clear Customer Down Payment
FBA6    Vendor Down Payment Request
FBA7    Post Vendor Down Payment
FBA7_OLD Post Vendor Down Payment
FBA8     Clear Vendor Down Payment
FBA8_OLD Clear Vendor Down Payment
FBB1    Post Foreign Currency Valn
FBBA    Display Acct Determination Config.
FBBP    Maintain Acct Determination Config.
FBCJ    Cash Journal
FBCJC0  C FI Maintain Tables TCJ_C_JOURNALS
FBCJC1  Cash Journal Document Number Range
FBCJC2  C FI Maint. Tables TCJ_TRANSACTIONS
FBCJC3  C FI Maintain Tables TCJ_PRINT
FBCOPY  Copy Function Module
FBD1    Enter Recurring Entry
FBD2    Change Recurring Entry
FBD3    Display Recurring Entry
FBD4    Display Recurring Entry Changes
FBD5    Realize Recurring Entry
FBD9    Enter Recurring Entry
FBDF    Menu Banque de France
FBE1    Create Payment Advice
FBE2    Change Payment Advice
FBE3    Display Payment Advice
FBE6    Delete Payment Advice
FBE7    Add to Payment Advice Account
FBF1    C80 Reporting Minus Sp.G/L Ind.
FBF2    Financial Transactions
FBF3    Control Report
FBF4    Download Documents
FBF5    Reports Minus Vendor Accounts
FBF6    Document Changes
FBF7    C80 Reports Minus Sp.G/L Ind.
FBF8    C84 Reports
FBFT    Customizing BDF
FBIPU   Maintain bank chains for partner
FBKA    Display Accounting Configuration
FBKF    FBKP/Carry Out Function (Internal)
FBKP    Maintain Accounting Configuration
FBL1    Display Vendor Line Items
FBL1N   Vendor Line Items
FBL2    Change Vendor Line Items
FBL2N   Vendor Line Items
FBL3    Display G/L Account Line Items
FBL3N   G/L Account Line Items
FBL4    Change G/L Account Line Items
FBL4N   G/L Account Line Items
FBL5    Display Customer Line Items
FBL5N   Customer Line Items
FBL6    Change Customer Line Items
FBL6N   Customer Line Items
FBM1    Enter Sample Document
FBM2    Change Sample Document
FBM3    Display Sample Document
FBM4    Display Sample Document Changes
FBMA    Display Dunning Procedure
FBME    Banks
FBMP    Maintain Dunning Procedure
FBN1    Accounting Document Number Ranges
FBN2    Number Range Maintenance: FI_PYORD
FBP1    Enter Payment Request
FBR1    Post with Reference Document
FBR2    Post Document
FBRA    Reset Cleared Items
FBRC    Reset Cleared Items (Payment Cards)
FBS1    Enter Accrual/Deferral Doc.
FBTA    Display Text Determin.Configuration
FBTP    Maintain Text Determin.Configuration
FBU2    Change Intercompany Document
FBU3    Display Intercompany Document
FBU8    Reverse Cross-Company Code Document
FBV0    Post Parked Document
FBV1    Park Document
FBV2    Change Parked Document
FBV3    Display Parked Document
FBV4    Change Parked Document (Header)
FBV5    Document Changes of Parked Documents
FBV6    Parked Document $
FBVB    Post Parked Document
FBW1    Enter Bill of Exchange Pmnt Request
FBW2    Post Bill of Exch.acc.to Pmt Request
FBW3    Post Bill of Exchange Usage
FBW4    Reverse Bill Liability
FBW5    Customer Check/Bill of Exchange
FBW6    Vendor Check/Bill of Exchange
FBW7    Bank file to file system (for FBWD)
FBW8    File to Bank (for Transaction FBWD)
FBW9    C FI Maintain Table T045DTA
FBWA    C FI Maintain Table T046a
FBWD    Returned Bills of Exchange Payable
FBWD2   Parameter Transaction for FBWD
FBWE    Bill/Exch.Presentatn - International
FBWQ    C FI Maintain Table T045T
FBWR    C FI Maintain Table T045W
FBWS    C FI Maintain Table T046s
FBZ0    Display/Edit Payment Proposal
FBZ1    Post Incoming Payments
FBZ2    Post Outgoing Payments
FBZ3    Incoming Payments Fast Entry
FBZ4    Payment with Printout
FBZ5    Print Check For Payment Document
FBZ8    Display Payment Run
FBZA    Display Pmnt Program Configuration
FBZG    Failed Customer Payments
FBZP    Maintain Pmnt Program Configuration
FC10    Financial Statements Comparison
FC11    Data Extract for FI Transfer
FC80    Document C80
FC82    Document C82
FCAA    Check Archiving
FCC1    Payment Cards: Settlement
FCC2    Payment Cards: Repeat Settlement
FCC3    Payment Cards: Delete Logs
FCC4    Payment Cards: Display Logs
FCCR    Payment Card Evaluations
FCH1    Display Check Information
FCH2    Display Payment Document Checks
FCH3    Void Checks
FCH4    Renumber Checks
FCH5    Create Check Information
FCH6    Change Check Information/Cash Check
FCH7    Reprint Check
FCH8    Reverse Check Payment
FCH9    Void Issued Check
FCHA    Check archiving
FCHB    Check retrieval
FCHD    Delete Payment Run Check Information
FCHE    Delete Voided Checks
FCHF    Delete Manual Checks
FCHG    Delete cashing/extract data
FCHI    Check Lots
FCHK    Check Tracing Initial Menu
FCHN    Check Register
FCHR    Online Cashed Checks
FCHT    Change check/payment allocation
FCHU    Create Reference for Check
FCHV    C FI Maintain Table TVOID
FCHX    Check Extract - Creation
FCIWCU  BW Customizing for CS
FCIWD00 Download InfoObject text
FCIWD10 Download InfoObject hierarchies
FCKR    International cashed checks
FCMM    C FI Preparations for consolidation
FCMN    FI Initial Consolidation Menu
FCV1    Create A/R Summary
FCV2    Delete A/R Summary
FCV3    Early Warning List
FC_BW_BEX       Business Explorer Analyser
FC_BW_RSA1      BW Administrator Workbench
FC_BW_RSZDELETE Delete BW Query Objects
FC_BW_RSZV      Maintain BW Variables
FD-1    Number range maintenance: FVVD_RANL
FD01    Create Customer (Accounting)
FD02    Change Customer (Accounting)
FD02CORE Maintain customer
FD03    Display Customer (Accounting)
FD04    Customer Changes (Accounting)
FD05    Block Customer (Accounting)
FD06    Mark Customer for Deletion (Acctng)
FD08    Confirm Customer Individually(Actng)
FD09    Confirm Customer List (Accounting)
FD10    Customer Account Balance
FD10N   Customer Balance Display
FD10NA  Customer Bal. Display with Worklist
FD11    Customer Account Analysis
FD15    Transfer customer changes: send
FD16    Transfer customer changes: receive
FD24    Credit Limit Changes
FD32    Change Customer Credit Management
FD33    Display Customer Credit Management
FD37    Credit Management Mass Change
FDCU    Loans customizing menu
FDFD    Cash Management Implementation Tool
FDI0    Execute Report
FDI1    Create Report
FDI2    Change Report
FDI3    Display Report
FDI4    Create Form
FDI5    Change Form
FDI6    Display Form
FDIB    Background Processing
FDIC    Maintain Currency Translation Type
FDIK    Maintain Key Figures
FDIM    Report Monitor
FDIO    Transport Reports
FDIP    Transport Forms
FDIQ    Import Reports from Client 000
FDIR    Import Forms from Client 000
FDIT    Translation Tool - Drilldown Report
FDIV    Maintain Global Variable
FDIX    Reorganize Drilldown Reports
FDIY    Reorganize Report Data
FDIZ    Reorganize Forms
FDK43   Credit Management - Master Data List
FDMN
FDOO    Borrower's notes order overview
FDTA    TemSe/REGUT Data Administration
FDTT    Treasury Data Medium Administration
FEBA    Postprocess Electronic Bank Statmt
FEBC    Generate Multicash format
FEBMSG  Display Internet Messages
FEBOAS  Request Account Statement via OFX
FEBOFX  OFX Functions
FEBP    Post Electronic Bank Statement
FEBSTS  Search String Search Simulation
FESR    Importing of POR File (Switzerland)
FEUB    Adjust VIBEPP after EURO conversion
FEUI    Real Estate Implementation Guide
FF$3    Send planning data to central system
FF$4    Retrieve planning data
FF$5    Retrieve transmission results
FF$6    Check settings
FF$7    Check all external systems
FF$A    Maintain TR-CM subsystems
FF$B    Convert Planning Group
FF$C    Convert planning level
FF$D    Convert business areas
FF$L    Display transmission information
FF$S    Display transmission information
FF$X    Configure the central TR-CM system
FF-1    Outstanding Checks
FF-2    Outstanding Bills of Exchange
FF-3    Cash Management Summary Records
FF-4    CMF Data In Accounting Documents
FF-5    CMF Records fr.Materials Management
FF-6    CMF Records from Sales
FF-7    Forecast Item Journal
FF-8    Payment Advice Journal
FF-9    Journal
FF.1    Standard G/L Account Interest Scale
FF.3    G/L Account Cashed Checks
FF.4    Vendor Cashed Checks
FF.5    Import Electronic Bank Statement
FF.6    Display Electronic Bank Statement
FF.7    Payment Advice Comparison
FF.8    Print Payment Orders
FF.9    Post Payment Orders
FF.D    Generate payt req. from advices
FF/1    Compare Bank Terms
FF/2    Compare value date
FF/3    Archive advices from bank statements
FF/4    Import electronic check deposit list
FF/5    Post electronic check deposit list
FF/6    Deposit/loan mgmt analysis/posting
FF/7    Deposit/loan management int accruals
FF/8    Import Bank Statement into Cash Mgmt
FF/9    Compare Advices with Bank Statement
FF63    Create Planning Memo Record
FF65    List of Cash Management Memo Records
FF67    Manual Bank Statement
FF68    Manual Check Deposit Transaction
FF6A    Edit Cash Mgmt Pos Payment Advices
FF6B    Edit liquidity forecast planned item
FF70    Cash Mgmt Posit./Liquidity Forecast
FF71    Cash Position
FF72    Liquidity forecast
FF73    Cash Concentration
FF74    Use Program to Access Cash Concntn
FF7A    Cash Position
FF7B    Liquidity forecast
FF:1    Maintain exchange rates
FFB4    Import electronic check deposit list
FFB5    Post electronic check deposit list
FFL_OLD Display Transmission Information
FFS_OLD Display Transmission Information
FFTL    Telephone list
FFW1    Wire Authorization
FFWR    Post Payment Requests from Advice
FFWR_REQUESTS   Create Payment Requests from Advice
FF_1    Standard G/L Account Interest Scale
FF_3    G/L Account Cashed Checks
FF_4    Vendor Cashed Checks
FF_5    Import Electronic Bank Statement
FF_6    Display Electronic Bank Statement

Important Tcodes for FI GL AR AP Asset

2008-11-23T16:10:00.000+05:30

T Codes Details
Financial Accounting
SPRO    Enter IMG
OX02    Company Code - Create, Check, Delete
OX03    Create Business Area
OKBD    Functional Areas
OB45    Create Credit Control Area
OB29    Maintain Fiscal Year Variant
OB37    Assign Co. Code to Fiscal Year Variant
OB13    Creation of Chart of Account (CoA)
OBY7    Copy Chart of Account (CoA)
OBY9    Transport Chart of Account
OBD4    Define Account Group
OBY2    Copy GL Accounts from the Chart to Co. Code
OB53    Define Retained Earnings
OB58    Maintain Financial Statement Versions
OBC4    Maintain Field Status Variant
OBBO    Define Posting Period Variant
OBA7    Define Document Type & Number Ranges
OB41    Maintain Posting Keys
OBA4    Create Tolerance Groups
FBN1    Create GL Number Ranges
OBL1    Automatic Posting Documentation
FBKP    Automatic Account Assignment
OBYC    MM Automatic Account Assignment
OBY6    Enter Global Parameters
FS00    Creation of GL Master Records
(F-02)  Posting of GL Transactions
(FB03)  Display of GL Document
(FS10N) Display of GL Accounts
OB46    Define Interest Calculation Types
OBD3    Define Vendor Account Group
(XK01)  Creation of Vendor Master
(F-43)  Purchase Invoice Posting
(FK10N) Display Vendor Account
F112    Define House Bank
OBB8    Maintain Terms of Payment (ToP)
OBD2    Creation of Customer Account Group
OBA3    Customer Tolerance Groups
(XD01)  Creation of Customer Master
(FD10N) Display Customer Account
(F-28)  Incoming Payment Posting
OB61    Define Dunning Area
EC08    Copy Reference Chart of Depreciation (CoD)
OADB    Define Depreciation Area
OAOB    Assign Chart of Depreciation to Co. Code
OAOA    Define Asset Class
AO90    Assignment of Account in Asset Class
OAY2    Determination of Depreciation Area in Asset Class
(AS01)  Creation of Asset Master
(AS11)  Creation of Sub Asset
(F-90)  Asset Purchase Posting
(AFAB)  Depreciation Run
(F-92)  Asset Sale Posting
(AW01N) Asset Explorer

Explain the difference between INVOICE and BILLING in SAP.

Both are same in SD point of view.
- In SD terminology we call as Billing Document and
- In FI terminology we call as INVOICE.
- In MM again only INVOICE will be there for Vendors.

Invoice is document indicating to delivery goods and Billing is a receipt of payment.

If we receive the goods from vendors that is called bill if we give the goods to customer that is called invoice.

Bill means we have to pay the amount against bill invoice means we have to receive the amount against invoice.

Invoice is for both : Vendor Invoice and Customer Invoice.

Billing Tcodes:
- VF01 create billing document. The delivery order comes up auto.
- VF02 the billing doc comes up auto . View the accounting enteries

Invoice Tcodes:
- FB60 Create invoice with respect to rawmaterial and ta

Banking Transaction Financial Accounting Entries

2008-09-12T12:50:00.001+05:30

Settlement Of Tour Advances Domestic/Foreign
1) Settlement of advance will be done by the Accounts Department based on the Travel Expense Statement submitted by the employee, which is approved by the Concerned Department Head.

2) Expenses Account DR
Cash/Bank Account DR (if, refund)
Employee Advance Account CR
Cash/Bank Sub ledger Account CR (if, payable)

3) Banking Operations - Maintenance Of Bank Master

4) A House Bank is a combination of a Bank and a Branch. Account id is the account number. A house bank can have multiple account IDs.. There could be a main account as also payable account, which will be defined as separate account ids. General Ledger accounts have to be created for each combination of a house bank and account ID. The bank master details are to be provided by HZL.

5) General Ledger accounts have to be created for each account ID in the house bank. Bank Account Master data will be maintained by the Finance Department centrally.

6) Each house bank and account ID combination shall have one main general ledger account and several sub accounts mainly based on broad transaction types. These sub accounts are necessary to facilitate automatic bank reconciliation process in R/3 system.

Bank Accounting
7) The accounting entries will be generated automatically according to the posting rules attached to the Transaction type. The following accounting entry is passed by the system in respect of cheque deposit on account of collection from domestic customers.

Bank cheque deposit account Debit
Customer account Credit

8) In this case, a bank sub account is selected based on the transaction code entered by the user. The customer account is cleared i.e. invoice is cleared against the receipt. In respect of any other deposits, the relevant accounts to be credited will depend on the nature of transaction.

9) Payment against bills for collection. Based on the bank advices falling due on a particular day one payment advice is made debiting the vendors and crediting bank.

Cheque Deposit - Customer Receipts
10) All cheques received from customers shall be accounted at the point of receipt. The entry posted shall be

Bank Sub account Dr
Customer Account Cr

Cheque Deposit - Other Than Customer Receipts
11) All other receipts will be accounted through the Incoming Payment Transaction of the Accounts Receivables module.

Cheque Bouncing – Other Than Customer Receipts

12) Based on the information of cheque bounced from the Bank, the accounts Department will pass accounting entries for the cheque that have been bounced. The procedure to handle bouncing of a cheque has been discussed under the following

13) Reset the clearing document – If the document has been cleared i.e. an open outstanding item has been cleared against an incoming receipt, then the clearing document has to be reset to its original status of open item. This process is known as reset of cleared document.

14) Reverse the entry passed for cheque deposited earlier – Once the document has been reset it will be reversed. The following accounting entry will be passed.
FI Customer DR
Bank cheque deposit account CR

15) In case of cheques being damaged while printing, the concerned cheques no. has to be voided and the payment will be rerun.

Bank Reconciliation
16) The Bank reconciliation process is based on the entries passed through the Bank sub account and main account. The process is dependent on the Bank Statement received from the Bank that will be entered into SAP. Accounting rules are to be defined for each transaction type and posting rule for posting accounting entries as per bank statement. Bank statements to be uploaded into SAP.

17) Bank Main account balance is the actual balance as per the bank statement whereas the Bank sub accounts denote the reconciliation items. These sub accounts show those entries, which will flow from the sub account which are not cleared in the bank statement.

18) Adding or subtracting the Bank sub accounts will help in preparing the Bank reconciliation statement.

19) The following scenarios would explain the reconciliation process:
- Cheque received from customer
- Cheque issued to vendors
- Cheque received from Other than Customers
- Direct Debits in Bank Statement
- Direct Credits in Bank Statement
- Fund Transfer between Bank Accounts

Cheque Received From Customer
20) Accounting entry at the time of cheque deposit entry
Bank Cheque deposit account Debit
Customer Credit

21) Accounting entry after cheque has been cleared in the Bank statement Main Bank account
Debit Bank
Cheque deposit account Credit

22) The clearing criteria for updating the bank main account and bank sub account will be amount and document number which will be captured in the allocation field of the bank sub account. The items, which have not been cleared in the bank statement, will remain open in the bank sub account and will form part of the bank reconciliation statement.

Cheque Issued To Vendors
23) Accounting entry at the time of cheque issue
Vendor account Debit
Bank cheque payment account Credit

24) Accounting entry after cheque has been presented in the Bank
Bank cheque payment account Debit
Main Bank account Credit

25) The clearing criteria used for updating vendor account and Bank cheque payment account will be amount and cheque number. The cheques presented to the bank and are cleared are transferred to the bank main account. The remaining cheque issued will form part of the bank reconciliation statement.

Direct Debit In Bank
26) Direct debit instructions will be given to the bank for example, LC payments or certain bank charges are directly debited in the Bank Statement. In this case accounting entry is passed only after the entry is passed in the bank statement.
Vendor / Expense Account Debit
Bank clearing account Credit

Direct Credit In Bank
27) Customer receipts are sometimes directly credited in Bank. E.g. export receipts. In this scenario accounting entry is passed only at the time of bank statement entry. The following accounting entry is passed
Bank clearing account Debit
Customer account Credit
Main Bank A/c Debit
Bank Clearing A/c Credit

Bank Fixed Deposits
28) HZL has a practice of converting any amount above Rs. 1 crore in its Main bank account, to a fixed deposit subject to a minimum of Rs. 1.01 crores. The FDR number can be filled in one of the fields available in the accounting document.

Cheque Management / Cheque Printing Cum Advice
29) The function of cheque management will enable printing of cheque through SAP. Cheque series will be defined for a combination of a Company code and Bank Account. Cheque numbering will be sequential order.

30) Cheque series for automatic payment has to be in sequential order. Cheque printing facility will be available for the bank account.

Cash Management / Liquidity Analysis
31) The day-to-day treasury process in a company includes a number of transactions. This includes determining the current liquidity using bank account balances (cash position), determining open receivables and liabilities (liquidity forecast), manually entering planned cash flows (payment advice notes), through to clearing bank accounts, that is, collecting multiple bank account balances on one target account.

32) The main objective is to ensure liquidity for all due payment obligations. It is also important to control and monitor effectively the incoming and outgoing cash flows.

33) This section shows you the overall liquidity status of your company by displaying together the cash position and the liquidity forecast. The cash position is used in Cash Management to show the value-date-dependent bank accounts and bank clearing accounts, as well as the planned cash flows (payment advice notes). The liquidity forecast comprises the incoming and outgoing cash flows, as well as the planned items on the sub-ledger accounts.

allsap Reversal Entry In Accounting FICO Account Posting

2008-09-12T12:49:00.000+05:30

Why do we pass reversal enteries?

At times some incorrect documents might have been entered in the systems.

If you have entered an incorrect document, you can reverse it. Note that R/3 can reverse a document only if the following conditions are met:

- Contains no cleared items
- Contains only vendor, customer, or G/L line items
- Was posted within the FI system
- Contains only valid values, such as business areas, cost centers, and tax codes

Ordinarily, you post a reversing document in the same period you posted the original document. The period of the original document must be open to post a reversing document. If the period is not open, you can overwrite the posting date field with a date in an open period, such as the current period.

Reversal can be done individually - FB08 or Mass F.80.

If the document to be reveresed contain cleared items, then cleared item must be reset before the reversal of document.

Vendor Invoice Verification Accounting Entries FICO Account Posting allsap-live

2008-09-12T12:48:00.000+05:30

VENDOR INVOICE VERIFICATION

The detail process related to invoice verification is documented in Materials Management Document.
On receipt of vendor bill the following entry will be passed:

GR/IR Account DR
Freight Clearing Account DR
Cenvat Clearing Account DR
Vendor Account CR

Invoice Verification for Foreign Vendor
On receipt of vendor bill the following entry will be passed:

GR/IR Account DR
Vendor Account CR

Invoice Verification for Custom vendor
On receipt of Vendor bill the follo wing entry will be passed:
1) RG 23A/RG 23C Part 2 A/c (CVD) A/c DR
Cenvat Clearing A/c CR
2) G/R I/R A/c DR
Cenvat Clearing A/c DR
Vendor A/c CR
3) Cost of Material A/c DR
Vendor A/c (Customs) CR

Invoice Verification for Freight / Clearing Agent
Cost of Material A/c DR
Vendor A/c (Clearing Agent) CR

Invoice Verification for Octroi Expenses
Cost of Material DR
Vendor A/c (Octroi) CR

TDS (Work Contract Tax) for Service Orders shall be calculated and deducted accordingly.
The following entry will be passed on bill passing:

Expenses Account DR
Vendor Account CR
TDS Account CR

The material shall be returned to the vendor using the
Return to vendor movement type in SAP
Creating a Return PO

These transactions will be processed in the MM module.
The accounting entries will be :

Returns after GRN
GR/IR A/c Dr
Stock A/c Cr

The accounting in respect of debit / credit memos for FI vendors, the process will be similar to that of invoice processing. The accounting entries will be:
On issue of debit note
Vendor Account DR
Expenses Account CR

In respect of import vendor - capital goods exchange differences are to be accounted manually through a Journal Voucher for capitalization.
Exchange rate differences will be accounted at HO. An example of the accounting entry in this case shall be:
Invoice entry @ 40 INR: 1 USD

Asset / Expense A/c DR 100
Vendor A/c CR 100

Payment Entry @ 41 INR: 1 USD
Vendor A/c DR 100
Bank A/c CR 110
Exchange rate loss Capital A/c DR 10

Asset A/c DR 10
Exchange rate loss Capital A/c CR 10

A new G/L account shall be created for the special G/L transactions.
The accounting entry for making the down payment shall be:
Advance to supplier account Debit
Bank A/c Credit

When the invoice is booked the following entry is passed
GR/IR account Debit
Vendor account Credit
Clearing of Invoice against Down Payment
Vendor A/c Debit
Vendor down payment account Credit

Wherever, TDS is applicable, the TDS will be deducted at the time of down-payment to the vendor.
Down Payment for Capital (tangible) Assets

Down payment to vendors for capital acquisitions is to be reported separately in the Balance Sheet under the head Capital Work in Progress. Hence down payment for capital goods would be tracked through a separate special general ledger indicator.

The procedure to be followed is:
Definition of alternative reconciliation accounts for Accounts Payable for posting down payments made for Capital assets
Clearing the down payment in Accounts Payable with the closing invoice.
A new G/L account shall be created for the special G/L transactions.
The accounting entry for making the down payment shall be:

Vendor Advance for Capital Goods Account Debit
Bank A/c Credit
When the invoice is booked the following entry is passed
Asset A/c / Asset WIP Debit
Vendor A/c Credit
Clearing of Invoice against Down Payment
Vendor A/c Debit
Vendor Advance for Capital Goods Account Credit

The Following are the TDS Rates (to be confirmed with the recent changes)
Particulars Tax Rate Surcharge Rate Total
Contractors – 194 C 2% 5% 2.10%
Advertising – 194 C 1% 5% 1.05%
Prof. Fees – 194 J 5% 5% 5.25%
Rent – Others – 194 I 15% 5% 15.75%
Rent – Company – 194 I 20% 5% 21%
Commission – 194H 5% 5% 5.25%
Interest - Others – 194 A 10% 5% 10.50%
Interest – Company – 194 A 20% 5% 21%
Special Concessional Tax
Works Contract Tax

SECURITY DEPOSITS /EARNEST MONEY DEPOSIT RECEIVED FROM VENDORS
Bank A/c DR
Security Deposit Vendor CR

EMD to give the age so as to enable the same to be transferred to unclaimed EMD account.
PAYMENT OF TOUR ADVANCE DOMESTIC TOURS

Employee Advances will be paid by the Accounts Department unit wise based on the requisition or recommendation of the respective departmental head.
Employee Travel Advance A/c DR
Cash / Bank Account CR

Sales and Distribution Accounting Entries FICO Account Posting allsap-live

2008-09-12T12:47:00.000+05:30

INVOICE GENERATION
Invoices will be generated at the Smelters and stock points. The accounting entries for the sale of goods despatched will flow from the Sales invoice generated in SAP Sales and Distribution module. The following entries shall be passed
Customer Account Dr
Revenue Cr
Excise Duty Payable Cr
Sales Tax Payable (local or central) Cr

Note: As mentioned above in the FI document, which is created in the background, the SD invoice number shall be captured. However as per the current accounting procedure the accounting entry passed is as follows :-
Customer Account Dr
Revenue Cr
Excise Duty Billed Cr
Sales Tax Payable (local or central) Cr

Excise duty paid a/c Dr
Excise duty payable a/c Cr

EXPORT SALES
There have been very few export transactions in the past. SAP system will be designed to handle export business. Exports are mainly from the mines and will be handled at the mines, however the documentation part will be taken care at the Head Office. The accounting entry is:
Customer Account Dr
Revenue (Exports) Cr

The realisation of export sales will be directly credited to the bank. The accounting entries will be as follow:
Bank Dr
Customer Cr
Exchange Fluctuation Dr/ Cr

The accounting entries will be:
Rebates/Discounts Dr
Customer Cr

DEBIT MEMOS
Debit Memos shall be issued in case of price difference, sale tax difference and interest on usance period and overdue payments.

The accounting entries for two possible scenarios are as follows:
Price Undercharged:
Customer Account Dr.
Revenue Cr.
Sales tax payable Cr.
Sales tax undercharged
Customer Account Dr.
Sales tax adjustment Cr.

Interest on delayed payments/usance period and other charges
Customer Account Dr.
Interest Others Cr.

In case of HZL a complete retirement or a partial retirement of asset is done. The system uses the asset retirement date to determine the amount to be charged off for each depreciation area. The existing accounting policy is to provide depreciation for the full quarter in which the asset is sold/discarded, recommended that the depreciation be provided from the date of acquisition on prorata basis .

Accounting entry for sale of Asset to customers:
Customer Account Dr
Asset Sale Cr
Accumulated Depreciation Dr
Loss on Sale (if applicable) Dr
Asset Sale account Dr
Asset account Cr
Profit on sale (if applicable) Cr

Note: In case of any Sales Tax /Excise duty applicable for this transaction, SAP will calculate the Sales Tax/Excise Duty based on the Tax Code selected the entry is posted to the GL Account (Sales Tax Payable)

Accounting entry for sale without a customer:
Accumulated Depreciation Dr
Loss on Sale (if applicable) Dr
Asset Sale account Dr
Asset account Cr
Profit on sale (if applicable) Cr

Accounting entry for scrap
Accumulated Depreciation Dr
Loss on Sale of Assets Dr
Asset account Cr

SALE OF SCRAP
The sale of scrap (non-stock) shall be mapped as a direct manual FI entry. The customer will be created as a FI customer. No Logistics module will be involved in the process.

A FI Invoice will be prepared for the sale of scrap with the following entries:
Customer Dr
Sale of Scrap Cr
Excise Duty Payable Cr

ADVANCES FROM CUSTOMERS
Advances are received from the customers against delivery. These advances will be recorded in a special general ledger account. The accounting entry for the same will be:
Bank Account Dr
Advance Customer Payments Cr

These advances will be later on adjusted against the invoices raised on the customers. Advances can be adjusted against more than one invoice at the time of clearing of the invoices against advances.

Adjustment of Advances
Customer Account Cr
Advance Customer Payments Dr

A financial document would be created for each Bank Guarantee received and this document number will be referred to in the Sales Order which would then monitor the value and the validity of the of the Bank Guarantee instrument wise while doing the billing.The letter of credit /Bank guarantee given will be recorded as a noted item.

Accounting Entry for Goods receipt
Stock/Inventory account Dr
GR/IR account Cr
Freight clearing account Cr

Accounting Entry on invoice verification of supplier
GR/IR Dr
Vendor account Cr

Accounting Entry on invoice verification of freight vendor
Freight clearing account Dr
Freight Vendor account Cr

GOODS RECEIPT
Based on the Purchase order and the Quantity actually received Goods Receipts (GR) will be done. Based on the GR done the following accounting entry will be passed in the Financial Accounts
RM/PM Stock Account Dr
GR/IR Account Cr
Freight Clearing Account Cr

EXCISE INVOICE VERIFICATION
On receipt of the excise invoice cum gate pass the following entry will be passed
RG 23 A / RG 23 C Part 2 Account Dr
Cenvat Clearing Account Cr

Inventory Accounting Entries FICO Account Posting allsap-live

2008-09-12T12:46:00.002+05:30

All the Inventory transactions will look for the valuation class and the corresponding G.L. Accounts and post
the values in the G.L accounts.

For Example: during Goods Receipt

Stock Account - Dr
G/R I/R Account - Cr
Freight Clearing account - Cr
Other expenses payable - Cr

During Invoice Verification

G/R I/R Account - Dr
Vendor - Cr

When the Goods are issued to the Production Order the following transactions takes place:

Consumption of Raw Materials - Dr
Stock A/c - Cr

When the Goods are received from the Production Order the following transactions takes place:

Inventory A/c - Dr
Cost of Goods Produced - Cr
Price difference - Dr/Cr
(depending on the difference between standard cost and actual cost)

When the Goods are dispatched to customer through delivery the following transactions takes place:

Cost of Goods Sold - Dr
Inventory A/c - Cr

When the Goods are issued to a Cost Center or charged off against expenses the following transactions takes place:

Repairs and Maintenance - Dr
Inventory A/c - Cr

When the Goods are stock transferred from one plant to another, the following transactions takes place:

Stock A/c - Dr (Receiving location)
Stock A/c - Cr (Sending location)
Price difference - Dr/Cr
(due to any difference between the standard costs between the two locations)

When the stocks are revalued, the following transactions takes place:

Stock A/c - Dr/Cr
Inventory Revaluation A/c - Cr / Dr

When the Work in Progress is calculated the following transaction takes place:

Work in Progress A/c - Dr
Change WIP A/c - Cr

Physical verification /shortages and excesses : Shortages/excesses on authorizations shall be adjusted using the physical inventory count transaction.

Important Tables in SAP FICO AA allsap-live

2008-09-12T12:46:00.001+05:30

FI-AA-AA (AA)    Asset Accounting: Basic Functions – Master Data
             
ANKA             Asset Classes: General Data             ANLKL
ANKP             Asset Classes: Fld Cont Dpndnt on Chart ANLKL / AFAPL
              of Depreciation
ANKT             Asset Classes: Description              SPRAS / ANLKL
ANKV             Asset Classes: Insurance Types          ANLKL / VRSLFD
ANLA             Asset Master Record Segment             BUKRS / ANLN1 / ANLN2
ANLB             Depreciation Terms                      BUKRS / ANLN1 / ANLN2 / AFABE
                                                      / BDATU
ANLT             Asset Texts                             SPRAS / BUKRS / ANLN1 / ANLN2

ANLU             Asset Master Record User Fields         .INCLUDE /  BUKRS / ANLN1 /  ANLN2
ANLW             Insurable Values (Year Dependent)       BUKRS / ANLN1 / ANLN2 / VRSLFD /
                                                      GJAHR
ANLX             Asset Master Record Segment             BUKRS / ANLN1 / ANLN2
ANLZ             Time Dependent Asset Allocations        BUKRS / ANLN1 / ANLN2 / BDATU

FI-AA-AA (AA2)   Asset Accounting: Basic Functions – Master Data 2.0
             
ANAR             Asset Types                             ANLAR
ANAT             Asset Type Text                         SPRAS / ANLAR
FI-AA-AA (AB)    Asset Accounting: Basic Functions –
              Asset Accounting
ANEK             Document Header Asset Posting           BUKRS / ANLN1 / ANLN2 / GJAHR /
                                                      LNRAN
ANEP             Asset Line Items                        BUKRS / ANLN1 / ANLN2 / GJAHR /
                                                      LNRAN / AFABE
ANEV             Asset Downpymt Settlement               BUKRS / ANLN1 / ANLN2 / GJAHR /
                                                      LNRANS
ANKB             Asset Class: Depreciation Area          ANLKL / AFAPL / AFABE / BDATU
ANLC             Asset value Fields                      BUKRS / ANLN1 / ANLN2 / GJAHR /
                                                      AFABE
ANLH             Main Asset Number                       BUKRS / ANLN1
ANLP             Asset Periodic Values                   BUKRS / GJAHR / PERAF / AFBNR /
                                                      ANLN1 / ANLN2 / AFABER

FI-SL-VSR (GVAL) Special Purpose Ledger: Validation, Substitution and Rules
             
GB03             Validation / Substitution User          VALUSER
GB92             Substitutions                           SUBSTID
GB93             Validation                              VALID

Important Tables in SAP FICO CO

2008-09-12T12:44:00.000+05:30

Controlling

Table Name           Description                       Important Fields

AUSP                 Characteristic Values             MANDT / OBJEK / ATINN / ATZHL

CO-KBAS              Overhead Cost Controlling
A132                 Price per Cost Center             MANDT / KAPPL / KSCHL / KOKRS
A136                 Price per Controlling Area        MANDT / KAPPL / KSCHL / KOKRS
A137                 Price per Country / Region        MANDT / KAPPL / KSCHL / KOKRS
COSC                 CO Objects: Assignment of Origina MANDT / OBJNR / SCTYP / VERSN
CSSK                 Cost Center / Cost Element        MANDT / VERSN / KOKRS / GJAHR
CSSL                 Cost Center / Activity Type       MANDT / KOKRS / KOSTL / LSTAR
KAPS                 CO Period Locks                   MANDT / KOKRS / GJAHR / VERSN

CO-KBASCORE          Overhead Cost Controlling: General Services
CSKA                 Cost Elements (Data Dependent on  MANDT / KTOPL / KSTAR
CSKB                 Cost Elements (Data Dependent on  MANDT / KOKRS / KSTAR / DATBI
CSKS                 Cost Center Master Data           MANDT / KOKRS / KOSTL / DATBI
CSLA                 Activity Master                   MANDT / KOKRS / LSTAR / DATBI

CO-OM (KACC)         Overhead Cost Controlling
COBK                 CO Object: Document Header        MANDT / KOKRS / BELNR
COEJ                 CO Object: Line Items (by Fiscal  MANDT / KOKRS / BELNR / BUZEI
COEJL                CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEJR                CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEJT                CO Object: Line Items for Prices  MANDT / KOKRS / BELNR / BUZEI
COEP                 CO Object: Line Items (by Period) MANDT / KOKRS / BELNR / BUZEI
COEPL                CO Object: Line Items for Activit MANDT / KOKRS / BELNR / BUZEI
COEPR                CO Object: Line Items for SKF (by MANDT / KOKRS / BELNR / BUZEI
COEPT                CO Object: Line Items for Prices  MANDT / KOKRS / BELNR / BUZEI
COKA                 CO Object: Control Data for Cost  MANDT / OBJNR / GJAHR / KSTAR
COKL                 CO Object: Control Data for Activ MANDT / LEDNR / OBJNR / GJAHR
COKP                 CO Object: Control Data for Prima MANDT / LEDNR / OBJNR / GJAHR
COKR                 CO Object: Control Data for Stati MANDT / LEDNR / OBJNR / GJAHR
COKS                 CO Object: Control Data for Secon MANDT / LEDNR / OBJNR / GJAHR

CO-OM-CEL (KKAL)     Cost Element Accounting (Reconciliation Ledger)
COFI01               Object Table for Reconciliation L MANDT / OBJNR
COFI02               Transaction Dependent Fields for  MANDT / OBJNR
COFIP                Single Plan Items for Reconciliat RCLNT / GL_SIRID
COFIS                Actual Line Items for Reconciliat RCLNT / GL_SIRID

CO-OM-CCA            Cost Center Accounting (Cost Accounting Planning RK-S) – What is RK-S
A138                 Price per Company Code            MANDT / KAPPL / KSCHL / KOKRS
A139                 Price per Profit Center           MANDT / KAPPL / KSCHL / KOKRS

CO-OM-OPA (KABR)     Overhead Orders: Application Development R/3 Cost Accounting Settlement
AUAA                 Settlement Document: Receiver Seg MANDT / BELNR / LFDNR
AUAB                 Settlement Document: Distribution MANDT / BELNR / BUREG / LFDNR
AUAI                 Settlement Rules per Depreciation MANDT / BELNR / LFDNR / AFABE
AUAK                 Document Header for Settlement    MANDT / BELNR
AUAO                 Document Segment: CO Objects to b MANDT / BELNR / LFDNR
AUAV                 Document Segment: Transactions    MANDT / BELNR / LFDNR
COBRA                Settlement Rule for Order Settlem MANDT / OBJNR
COBRB                Distribution Rules Settlement Rul MANDT / OBJNR / BUREG / LFDNR

CO-OM-OPA (KAUF)     Overhead Orders: Cost Accounting Orders
AUFK                 Order Master Data                 MANDT / AUFNR
AUFLAY0              Enttity Table: Order Layouts      MANDT / LAYOUT

EC-PCA (KE1)         Profit Center Accounting
CEPC                 Profit Center Master Data Table   MANDT / PRCTR / DATBI / KOKRS
CEPCT                Texts for Profit Center Master Da MANDT / SPRAS / PRCTR / DATBI
CEPC_BUKRS           Assignment of Profit Center to a  MANDT / KOKRS / PRCTR / BUKRS
GLPCA                EC-PCA: Actual Line Items         RCLNT / GL_SIRID
GLPCC                EC-PCA: Transaction Attributes    MANDT / OBJNR
GLPCO                EC-PCA: Object Table for Account  MANDT / OBJNR
GLPCP                EC-PCA: Plan Line Items           RCLNT / GL_SIRID

EC-PCA BS (KE1C)     PCA Basic Settings: Customizing for Profit Center Accounting
A141                 Dependent on Material and Receive MANDT / KAPPL / KSCHL / KOKRS
A142                 Dependent on Material             MANDT / KAPPL / KSCHL / WERKS
A143                 Dependent on Material Group       MANDT / KAPPL /

Important Tables in SAP FI allsap-live

2008-09-12T12:43:00.001+05:30

Financial Accounting

Table Name           Description                           Important Fields

Financial Accounting

FBAS             Financial Accounting “Basis”
BKPF             Accounting Document Header              BUKRS / BELNR / GJAHR
BSEG             Accounting Document Segment             BUKRS / BELNR / GJAHR / BUZEI
BSIP             Index for Vendor Validation of Double   BUKRS / LIFNR / WAERS / BLDAT /
              Documents                               XBLNR / WRBTR / BELNR / GJAHR / BUZEI
BVOR             Inter Company Posting Procedure         BVORG / BUKRS / GJAHR / BELNR
EBKPF            Accounting Document Header (docs from   GLSBK / BELNR / GJHAR / GLEBK
              External Systems)
FRUN             Run Date of a Program                   PRGID
KLPA             Customer / Vendor Linking               NKULI / NBUKR / NKOAR / PNTYP
                                                      / VKULI / VBUKR / VKOAR

KNB4             Customer Payment History                KUNNR / BUKRS
KNB5             Customer Master Dunning Data            KUNNR / BUKRS / MABER
KNBK             Customer Master Bank Details            KUNNR / BANKS / BANKL / BANKN
KNC1             Customer Master Transaction Figures     KUNNR / BUKRS / GJHAR
KNC3             Customer Master Special GL Transactions KUNNR / BUKRS / GJAHR / SHBKZ
              Figures
LFB5             Vendor Master Dunning Data              LIFNR / BUKRS / MABER
LFBK             Vendor Master Bank Details              LIFNR / BANKS / BANKL / BANKN
LFC1             Vendor Master Transaction Figures       LIFNR / BUKRS / GJHAR
LFC3             Vendor Master Special GL Transactions   LIFNR / BUKRS / GJHAR / SHBKZ
              Figures
VBKPF            Document Header for Document Parking    AUSBK / BUKRS / BELNR / GJHAR

FBASCORE         Financial Accounting General Services “Basis”

KNB1             Customer Master (Company Code)          KUNNR / BUKRS
LFA1             Vendor Master (General Section)         LIFNR
LFB1             Vendor Master (company Code Section)    LIFNR / BUKRS
SKA1             G/L Account Master (Chart of Accounts)  KTOPL / SAKNR
SKAT             G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR
              Description)
MAHNS            Accounts Blocked by Dunning Selection   KOART / BUKRS / KONKO / MABER
MHNK             Dunning Data (Account Entries)          LAUFD / LAUFI / KOART / BUKRS /
                                                      KUNNR / LIFNR / CPDKY / SKNRZE /
                                                      SMABER / SMAHSK / BUSAB

FI-GL-GL (FBS)   General Ledger Accounting: Basic Functions- G/L Accounts

SKAS             G/L Account Master (Chart of Accounts – SPRAS / KTOPL / SAKNR / SCHLW
              Key Word list)
SKB1             G/L Account Master (Company Code)       BUKRS / SAKNR
FI-GL-GL (FBSC)  General Ledger Accounting: Basic
              Functions - R/3 Customizing for G/L Accounts
FIGLREP          Settings for G/L Posting Reports        MANDT
TSAKR            Create G/L account with reference       BUKRS / SAKNR
FI-GL-GL (FFE)   General Ledger Accounting: Basic
              Functions - Fast Data Entry
KOMU             Account Assignment Templates for G/L    KMNAM / KMZEI
              Account items

FI-AR-AR (FBD)   Accounts Receivable: Basic Functions - Customers
             
KNKA             Customer Master Credit Management :     KUNNR
              Central Data
KNKK             Customer Master Credit Management :     KUNNR / KKBER
              Control Area Data
KNKKF1           Credit Management : FI Status data      LOGSYS / KUNNR / KKBER / REGUL
RFRR             Accounting Data – A/R and A/P           RELID / SRTFD / SRTF2
              Information System

FI-BL-PT         Bank Accounting: Payment (BFIBL_CHECK_D)  Transactions – General Sections

PAYR             Payment Medium File                     ZBUKR / HBKID / HKTID / RZAWE /
                                                      CHECT
PCEC             Pre-numbered Check                      ZBUKR / HBKID / HKTID / STAPL

FI-BL-PT-AP(FMZA)Bank Accounting: Payment Transactions – Automatic Payments
             
F111G            Global Settings for Payment Program for MANDT
              Payment Requests
FDZA             Cash Management Line Items in Payment   KEYNO
              Requests
PAYRQ            Payment Requests                        KEYNO

What is the table name for G/L Master data, when we create centrally (T.Code - FS00)?

As far as general ledger master data is concerned, the following tables are involved :

Table name : SKB1 : G/L Account Master ( Company Code)
Fields:
BUKRS : Company Code
SAKNR : G/L Account

Table name : SKA1 : G/L Account Master ( Chart of Accounts )
Fields:
KTOPL : Char of Accounts
SAKNR : G/L Account

Table name : SKAT : G/L Account Master Record ( Chart of Accounts : Description )
Fields:
SPRAS : Language
KTOPL : Char of Accounts
SAKNR : G/L Account

Employee Trip in SAP FICO

2008-08-09T11:36:00.000+05:30

Definition

An employee trip is a business trip taken by an employee. A business trip is an employee’s change of location, including the trip to and from another location, due to a temporary external activity.

Use

The employee trip is used for planning, account assignments and accounting of the trip costs incurred as a result of an external activity.

Structure

An employee trip is made up of trip facts , trip costs assignment specifications, trip accounting results, a trip transfer amount and a trip status .

The trip facts are the documentary or Travel Accounting-relevant information regarding a trip.

Trip costs assignments can be specified for an employee trip or for individual trip facts.

The travel accounting results and the trip transfer amount are created by Travel Accounting from the trip facts.

The trip status represents the processing stage of a trip, which determines whether or not certain travel-specific business processes are permitted.

Integration

A business trip can be caused, for example, by Personnel Development (HR) or Shift Planning (HR). You can forward the accounting results produced by Travel Accounting for proper posting to Financial Accounting (FI) and to Payroll Accounting (HR) for tax calculation.

You can reimburse the trip transfer amounts to the employee via Financial Accounting (FI), Payroll Accounting (HR), or via data medium exchange.

You can forward the trip costs assignment specifications for internal cost accounting to Controlling (CO) or for cash budget management to Funds Management (FM).

Refer to

Trip Facts

Trip Costs Assignment Specifications

Travel Accounting

Trip Status

The Overall Process of Travel Management in SAP FICO

2008-08-09T11:32:00.005+05:30

Purpose

With the R/3 Travel Management application component, you can perform all of the business processes involved with a business trip efficiently and reliably in one single process. The goal of this process is the complete and integrated administration of travel expenses from travel planning to correct taxation in Payroll Accounting (HR), correct posting in Financial Accounting (FI), and clearing in Controlling (CO) or Funds Management (FM) according to the allocation-by-cause principle.

Within the process, using the Travel Planning component, you can plan business trips quickly and easily, record the basic trip facts and book travel services. After the trips have been taken, using the Travel Accounting component, you can supplement the remaining trip facts, account the trip costs and transfer the accounting results to Financial Accounting, Controlling, Funds Management, and, for possible calculation of taxes, to Payroll Accounting for further processing. As a result of the integration of all of these process segments in one single process, which is extensively controlled and logged by the R/3 System, the overall processing of business trips is significantly streamlined, reducing costs.

Process Flow

The overall process can last a relatively long time, with the actual trip representing the focal point of this process. The Travel Management process can be carried out with or without integration of Travel Planning in Travel Accounting.

Travel Management with Travel Planning (components Travel Planning and Travel Accounting)	Travel Management without Travel Planning (component Travel Accounting only)
You recognize that a trip must be taken.	You recognize that a trip must be taken.
Component Travel Planning: You plan the trip in the R/3 System and record the necessary trip facts.	You plan the trip on paper and submit the trip facts to an external travel service provider (a travel agency that you have chosen). The travel agency is responsible for booking the travel services.
Component Travel Planning: You book the travel services from Travel Management via a global distribution system (currently AMADEUS). The R/3 System creates individual receipts in the trip on the basis of this booking.	Component Travel Accounting: You can then record these trip facts in the R/3 System.
External Service Provider: The travel agency that you have chosen issues the tickets.	External Service Provider: The travel agency issues the tickets.
The trip takes place.	The trip takes place.
Component Travel Accounting: You record the remaining trip facts in the R/3 System.	Component Travel Accounting: You record the remaining trip facts in the R/3 System.
The system accounts the trip.	The system accounts the trip.
You issue trip statements to the employee.	You issue trip statements to the employee.
The system transfers the accounting results to Financial Accounting, Controlling, Funds Management and, possibly, Payroll Accounting.	The system transfers the accounting results to Financial Accounting, Controlling, Funds Management and, possibly, Payroll Accounting.
The system effects payment of the transfer amounts to the employee.	The system effects payment of the transfer amounts to the employee.

The Overall Process of Travel Management with Travel Planning

Result

A single, complete record of the facts of a business trip has been made in the R/3 System. The R/3 System has accounted the trip costs incurred as a result of the trip and forwarded them for further processing in Financial Accounting, Controlling, Funds Management and, if necessary, Payroll Accounting.

Choose Travel Accounting in SAP FICO

2008-08-09T11:32:00.003+05:30

Use

There are two options for calling Travel Accounting from the initial SAP R/3 screen.

Procedure for Financial Accounting

Choose Accounting ® Financial accounting ® Travel management ® Accounting.

The Travel accounting screen appears.

Procedure for Human Resources

Choose Human resources ® Travel management ® Accounting.

The Travel accounting screen appears.

Choose Travel Planning in SAP FICO

2008-08-09T11:32:00.001+05:30

Use

There are two options for calling Travel Planning from the initial SAP R/3 screen.

For more information, see Travel Planning in the R/3 Library.

Procedure for Financial Accounting

Choose Accounting ® Financial accounting ® Travel management ® Planning.

The Travel planning screen appears.

Procedure for Human Resources

Choose Human resources ® Travel management ® Planning.

The Travel planning screen appears.

Change Employee Trip in SAP FICO

2008-08-09T11:31:00.002+05:30

Use

As a rule, you have to add to the trip facts after completing a trip. As a part of the approval procedure, the expenses department or a superior may ask you to change your trip facts. Changes made to an employee trip signify changes in the trip facts. Using the Change trip function, you can modify an employee trip if you have the necessary authorization.

Integration

You can only change an employee trip by using a trip entry scenario.

Prerequisites

To change an employee trip, you need special authorization. This authorization can only be assigned through Customizing for Travel Management.

Features

Changing an employee trip includes:

Changing trip facts that have already been recorded
Deleting trip facts that have already been recorded
Adding new trip facts

You can not use this function for mass processing.

Refer to

Change Trip (Travel Manager)

Change Weekly Report

Create Employee Trip in SAP FICO

2008-08-09T11:31:00.001+05:30

Use

The main goal of Travel Management is the accounting and reimbursement of travel expenses. First, you have to record the trip facts in the R/3 System so the system can determine and calculate the trip costs. All of the trip facts for a business trip are saved in the database under an employee trip. Using the function Create employee trip, you can create a new employee trip.

Integration

You can only create an employee trip by using an entry scenario.

Prerequisites

To create an employee trip for someone, you must first maintain the personnel master data for this person. Especially, a trip costs assignment guideline must exist.

Activities

Each employee trip is uniquely defined by the personnel number and a trip number. First you enter the relevant personnel number. Depending on the system settings, either you (external number assignment) or the system (internal number assignment) assigns the trip number. Then you record the trip facts and save the employee trip. You can not use this function for mass processing.

Refer to

Entry Scenario: Create Trip

Entry Scenario: Travel Manager

Entry Scenario: Travel Calendar

Entry Scenario: Weekly Report

Entry Scenario: Trip Advance

Display Employee Trip in SAP FICO

2008-08-09T11:30:00.002+05:30

Use

You want to view the facts of an employee trip without making any changes. Using the function Display employee trip, you can display but not change employee trips.

Integration

You can only display an employee trip by using a trip entry scenario.

Features

You can view all of the facts for an employee trip that can be entered in dialog. You can not change these trip facts. You do not have to save the employee trip to exit the function. You can not use this function for mass processing.

Refer to

Display Trip (Travel Manager)

Display Weekly Report

Copy Employee Trip in SAP FICO

2008-08-09T11:30:00.001+05:30

Use

If you, for example, travel regularly once every two weeks to the same customer or plant, except for the trip duration, the trip facts are practically identical. Or, if a group of employees takes the same business trip, the trip facts are almost identical here, too. In such cases, it is easier to copy the employee trip. You can use this function to copy employee trips.

Integration

You can only copy an employee trip via a trip entry scenario.

Features

You can copy employee trips for a single personnel number. Using this function, it is easy to copy trips that you take repeatedly. After you have copied the employee trip, you have to adapt all trip data to correspond with the trip duration. You cannot save the employee trip in the database until you have done so. This function is intended for all organizational forms of trip facts recording.

You can copy employee trips from one personnel number to another to quickly record group trips. This function is intended for central trip facts recording.

You can not use this function for mass processing.

Refer to

Copy Trip (Travel Manager)

Print Employee Trip in SAP FICO

2008-08-09T11:29:00.004+05:30

Use

You can view the accounting results for an employee trip in the system at any time. The system uses the standard form to display them. You can print the standard form for an employee trip using this function.

Integration

You can only print an employee trip by using a trip entry scenario.

Prerequisites

You have to approve and account the employee trip first.

Features

The function can only print employee trips that have at least the trip status "approved, accounted". Only one employee trip can be printed at a time. You can not use this function for mass processing.

Refer to

Print Trip via Travel Manager

Print Weekly Report

Employee Trip Deletion in SAP FICO

2008-08-09T11:29:00.003+05:30

Use

Not every trip that is planned is actually taken. Nonetheless, an employee trip that was created by the system in Travel Planning, exists in the database. Under certain conditions, it is possible for you to delete such employee trips from the database using this function.

Integration

You can only delete an employee trip by using a trip entry scenario.

You can not use this function to delete employee trips that have already been posted. You can only cancel such employee trips to reverse accounting results.

Prerequisites

You can only delete employee trips that fulfill the following conditions:

The employee trip does not contain any paid advances.
The employee trip does not contain any paid receipts.
The employee trip does not contain a travel plan variant that you have used to book travel services.

Features

The function deletes the current version of an employee trip in the database. In the process, the system deletes all trip facts for this version.

If you have not yet transferred an employee trip to accounting, the system deletes, in addition to all trip facts, also all travel plans and travel plan variants for this employee trip.

If you have already transferred an employee trip to accounting, the system deletes only the latest version of this employee trip. Earlier versions of the employee trip are not deleted from the database. In this way, the system guarantees that trips that have already been posted are available for revision in accordance with statutory requirements.

You can not use this function for mass processing.

Display Employee Trip Corrections in SAP FICO

2008-08-09T11:29:00.001+05:30

Use

After you have posted an employee trip to financial accounting, you can still make changes. For quick, central reapproval, you only have to check the corrections. You can use this function to display the corrections that have been made to an employee trip.

Integration

You can only display the corrections to an employee trip via a trip entry scenario.

Features

The system displays all trip corrections. It shows you a direct comparison of the old value and the new value. Changes are only recorded as corrections if they take place after posting of accounting results. You can not use this function for mass processing.

Refer to

Display Corrections via Travel Manager

Display Corrections via Weekly Report

Simulation of Accounting of Employee Trip in SAP FICO

2008-08-09T11:28:00.003+05:30

Use

When planning trips and checking and approving travel requests and business trips that have already been taken, it is helpful to know the travel expenses to be expected. The exact travel expenses for an employee trip can not be determined until after travel accounting has been performed. But travel accounting can not take place until after approval. To obtain an overview of the expected costs for a trip before that, you can use this function to simulate accounting of an employee trip.

Integration

You can only simulate accounting of an employee trip by using a trip entry scenario.

Features

On the basis of the trip facts, the system determines the accounting results. It displays the trip facts and the transfer amount for the employee trip via the standard form. The system does not save the accounting results in the database. You can not use this function for mass processing.

Refer to

Simulate Travel Accounting via Travel Manager

Simulate Travel Accounting via Weekly Report

Employee Trip Approval in SAP FICO

2008-08-09T11:28:00.001+05:30

Use

The system can only account employee trips that you have approved for accounting. To approve employee trips, you have two options:

Approval of exactly one individual trip via a

trip entry scenario

Approval of one or more trips via

Approval

Integration

If you only want to approve one employee trip via a trip entry scenario, you can start simulation of accounting of the employee trip first. This gives you an overview of the trip costs to be expected.

Showing posts with label Employee Trip. Show all posts Employee Trip Accounting in SAP FICO

2008-08-09T11:27:00.000+05:30

Use

The actual travel expenses for an employee trip are determined by the system in Travel Accounting. To account employee trips, you have two options:

Accounting of exactly one individual trip via a

trip entry scenario

Accounting of one or more trips via

travel accounting

Prerequisites

You have to approve the employee trips first.

Features

On the basis of the trip facts, the system determines the accounting results. It displays the trip facts and the transfer amount for the employee trip via the standard form. Unlike in simulated accounting of an employee trip, the system saves the accounting results that are determined in the database.

Loading of Commodity Codes and Import Code in SAP MM

2008-08-05T20:05:00.001+05:30

Numbers

Use

This function copies commodity codes [Ext.] into the SAP System from external files available

from the customs authorities. It saves you the time required to manually enter these codes in the

system.

Integration

Once they have been loaded into the SAP System, the codes and their descriptions can be used

throughout the system. For example, you can match them with materials in material master

records and print them in foreign trade documents.

The system stores goods numbers and their descriptions in tables T604 and T604T (Foreign

Trade: Commodity Code / Import Code Numbers).

Prerequisites

Before the function can transfer the codes into R/3, you need to:

• Make sure that the file containing the codes and their descriptions is in ASCII format

• Know the structure of the file from which the system will copy the codes – which columns

the codes, the text descriptions and the units of measure (if available) occupy.

Features

You do not have to load all codes into your system. If you want, you can load only the chapters

relevant to your business.

You can overwrite all of the system’s existing codes or add only the new codes.

For example, suppose the system contains the codes 100 and 101 and the set of

codes you want to load contains codes 100, 101, and 102. You can do one of the

following:

• Load only the new code, 102, and ignore codes 100 and 101

• Load the new code and overwrite the existing information for codes 100 and

101

You can load commodity codes and import code numbers from the Foreign Trade

Data Service Cockpit.

Loading Commodity Codes and Import Code Numbers in SAP MM

2008-08-05T20:04:00.002+05:30

Use

This procedure describes how to load an external file containing commodity codes or import code

numbers for use in your system.

Prerequisites

• The external file must be in ASCII format

• You need to know the structure of the file – which columns (positions) the codes, the text

descriptions and the units of measure occupy.

Procedure

1. You access this function from the Foreign Trade Data Service Cockpit.

2. Choose the appropriate tab – European Union, Japan or Other – in the Load/Compare

section of the Data Service Cockpit. Choose the Load commodity code button next to the

Commodity code field to display the selection criteria screen.

3. Enter the selection criteria and the file specifications.

Entries in the following fields are mandatory:

– Country key

– File name

– Drive

– Subdirectory

– Initial position goods number

– Final position goods number

– Initial position goods text

– Final position goods text

See the field help (F1) for detailed information about each of the fields in this procedure.

You can determine the actual positions of the columns for the data record structure

entries by opening the ASCII file and counting the spaces used for the digits and the

text characters. For this you need to identify the beginning and end positions of the

codes, their texts and units of measure (when applicable) and enter them in the

corresponding fields.

For example, for a commodity code file with the contents "12345678 Sample text"

(with no unit of measure), you should make the following entries in the data record

structure section:

Data Record Structure

Field	Entry
Initial pos. goods no.	1
Final pos. goods no.	8
Initial pos. goods text	10
Final pos. goods text	21

If there is no unit of measure (optional entry), the last position for the goods text can be a

number that is much greater than the actual final position for the goods text (for example,

200).

4. If you want to use this set of codes as the basis for maintaining the codes in the system,

select Carry out preparations and enter an identification code in the Key for upload field. You

will need this key to access this set of codes during maintenance.

5. If you are installing codes from floppy disks or several files

– For the first disk or file, select First data carrier

– For additional disks or files, select Further data carriers

6. Execute the function.

Results

The system uploads the file contents to the SAP System.

Potential Errors

When you execute this report, the system issues an error message if

• The values for the beginning and end positions overlap

• You enter an incorrect length for a commodity code or import code

number

• The length for the codes has not been maintained for the country you

enter on the selection screen.

You assign commodity code and import code lengths for each country in

Table T609S in Customizing (see Sales → Foreign Trade/Customs →

Basic Data for Foreign Trade → Length of commodity Codes/Import

Code Numbers).

Comparison of Commodity Code Numbers in SAP MM

2008-08-05T20:04:00.001+05:30

Use

This function allows you to maintain the lists of commodity codes (for example, US Schedule B

codes) and import code numbers (for example, Harmonized Tariff Schedule codes) in the

system.

Periodically, some codes become obsolete with the customs authorities. This function identifies

obsolete codes by comparing codes currently in the system with the set of codes designated by a

keyword you enter. (See the graphic below.) This designated set of codes could be, for example,

the most recent set of commodity codes you received from the customs authorities and loaded

into R/3. From the comparison, the system creates a list of the codes that are not in the

designated set. You then have the option of deleting the listed codes.

Commodity codes Commodity codes Commodity codes

Currently listed in the selected for

in the system most recent set deletion

100

101

102

103

104

100

101

103

102

104

Prerequisites

To use this function, you must know the keyword assigned to the set of codes on which you want

to base the comparison. (When you load a set of commodity codes or import code numbers, you

can print the key you assigned to the set and keep it on file.) The system uses that keyword to

retrieve the set of codes from its database.

Displaying Commodity Codes and Import Code in SAP MM

2008-08-05T20:03:00.000+05:30

Use

This function displays descriptions of commodity codes and import code numbers that meet

criteria you define.

Prerequisites

The codes must be loaded into the system before you can search them. For more on loading

codes, see Loading of Commodity Codes and Import Code Numbers

The resulting list of codes is grouped by chapter and section. To display the chapter and section

titles in the list, maintain the following tables in Customizing for Sales and Distribution → Foreign

Trade:

• Basic Data for Foreign Trade → Sections with regard to customs law

• Basic Data for Foreign Trade → Assign chapters to a section

You can compare commodity codes and import code numbers from the Foreign>

Trade Data Service Area. See Foreign Trade Data Service Cockpit

SAP SD Sample Certification Questions in Sales Order Processing

2008-08-05T20:02:00.002+05:30

To take the SAP SD certification, contact your local or regional SAP Education training center at this url :

http://www.sap.com/services/education/index.epx

Caution: more than one answer may be correct.
Please mark ALL correct answers.

Question:
Which statements concerning goods issue are true?

A Goods issue reduces requirements in materials planning
B Goods issue posts value changes to the stock account in inventory accounting
C Goods issue posts value changes to the stock account in asset accounting
D Goods issue posts value changes to the tax account
E Goods issue reduces warehouse stocks

Question:
Which of the following statements about billing are correct?

A. Invoice dates for creating invoices at certain times are maintained in the calendar.
B. You cannot carry out pricing again during billing.
C. A transaction-specific requirement, such as "deliveries must be combined in a collective invoice" can be set to control
billing.
D. If there are several payers for one delivery, only one billing document is created for each player.

Question:
How is the schedule line determined?

A. Item category and document type
B. Item category group and strategy group on the material master record
C. Item category and MRP type on the material master record
D. MRP Type and shipping point

Question:
When processing a billing due list, you have the following options:

A. The invoicing run can be started as a simulation run.
B. For performance reasons, the invoicing run via billing due list processing can only be carried out in batch.
C. The invoice run can be carried out for delivery-related and order-related billing documents simultaneously.
D. Order-related billing documents and delivery-related billing documents must always be created separately.

Question:
How does the SAP system enable you to check the reason for documents not being combined in a billing document?

A. Using the Spilt analysis function in the environment menu of the billing document.
B. Control of the document flow.
C. Control of the billing log.

Question:
How is the schedule line determined?

A. Item category and document type.
B. Item category group and strategy group on the material master record.
C. Item category and MRP type on the material master record.
D. MRP Type and shipping point.

Question: Cutover strategy
Q: Please explain cut over strategy procedure? Will the system golive 100% at the same time and cut the legacy system or will it be like 20% first day and 50% next day like that ?

A: Cutover strategy depends upon how the organizations design their data load strategies. Normally, you decide the sequence of Data loads for Configuration settings, Master data, Transaction data which follows whom and then you make a copy of the system as a Production system a day before and after checking the successful data loads, you go-live 100% or partial again depending upon organizational setup and policies.

My SAP SD Certification Experience

2008-08-05T20:02:00.001+05:30

Let me share my certification experience with you. Keep following things in mind when preparing for the exam:

1. Prepare as per the weightage per topics given in the syllabus.

2. Be very confident on sure shot questions from the topics like:
All determination rules - plant, material, pricing procedure, picking location, route, shipping point, tax, item category, account
determination etc. One question on effect of PGI.
35 to 40 % questions will come from control tables like sales doc types, item category , copy control , delivery doc. , del. Item cat. , billing docs , schedule lines etc .

So try and mug up all the imp. Control fields .Your preparation level should be such that once you close your eye and think of TAN or OR you should be able to see all the fields in your mind .

These above, are sure to shot and you cannot afford to do mistakes in this sections.

3. Go through the screens, transaction level screens like sales order, delivery, billing, delivery list, billing due list, even standard reports etc. and check what is possible and what is not possible at each docs. What is defined at header and what is at item Go through the menu path of each docs and check what all is possible and from where it is coming. For example packing proposal and account determination analysis is possible at sales order.

4. Go through all the masters like customer, cust- material, material, > condition records for price, output, etc. Check what is defined at what level, what all is possible etc.

5. Check entire IMG - SD related, it will help you to understand what is defined at what level etc.

6. In exam be very careful with the sap English, particularly with the words like can, only, always, except. Read question very carefully. Sap statements in the exam will be always confusing, so think logically and holistically before exam.

7. Don't take any chance in preparation but always sticks to core basics, they will not ask configuration, but they will ask you what is possible and what is not and where it is defined.

8. Last but not least have confidence, how much a guy who have studied for 5 weeks is suppose to know that standard will be asked . Prepare well you will definitely succeed.

SAP PM Certification - Plant Maintenance Certification

2008-08-05T20:01:00.002+05:30

To find out the latest certification topics or where to attend your SAP PM Certification course at your country, refer to the SAP Education site: http://www.sap.com/services/education/index.epx

The certification test for becoming an application consultant for the SAP Plant Maintenance area is intended to provide candidates with the opportunity of proving that they have a fundamental knowledge of this particular area of the PM component as well as that they are able to apply this knowledge within a project environment.

The examination questions are based on the functionality and features of the SAP PM. The possible topics covers are:

1. Organizational Units and Master Data in Plant Maintenance

Organizational Units

- Maintenance Plant and Planning Plant
- Work Centers
- Storage Locations

Functional Locations

- Structure Indicator
- Reference Location and Functional Location
- Creation Options
- Data Transfer

Equipment

- Installation/Dismantling at Functional Locations
- Equipment Hierarchy
- Change Documentation
- Equipment Category

Material and Serial Numbers

- Serial Number Profile
- Goods Movement and Warehouse Stock
- Valuation Batches

Bills of Material (BOM)

- Assemblies
- BOM Categories
- Item Categories
- Change Documentation

Additional Functions

- Configuration
- Classification
- Measuring Points and Counters
- Partners and Addresses
- Document Link
- Status Management
- Permits and Warranties
- Data Transfer

2. Maintenance Processing

Breakdown Maintenance

Preventive Maintenance Processing

- Notification Types
- Objects and Object Information
- Catalogs and Catalog Profiles
- List Viewer for Notifications and Orders
- Order Type
- Object List
- Operation List
- Relationships
- Material List
- Availability Check
- Order Release and Printing
- Material Withdrawal
- Completion Confirmation in Time
- Technical Completion Confirmation
- Technical Completion
- Action Log and Document Flow

Processing External Services

- External Services as Individual Purchase Order
- External Services with External Work Centers
- External Services with Service Entry Sheets

Processing Refurbishment Tasks

- Valuation Type and Valuation Category in the Material Master
- Refurbishment Without Serial Numbers
- Refurbishment with Serial Numbers
- Inventory Management and Controlling

Processing Maintenance Projects

- Planning and Executing Maintenance Projects
- Completion, Settlement, and Monitoring of Maintenance Projects

CATS - Cross-Application Time Sheets

- Data Entry Profile
- Data Entry Sheet
- Data Transfer

Capacity Planning

- Scheduling
- Work Center and Available Capacity
- Capacity Leveling
- Employee Assignment

3. Controlling Functions in Plant Maintenance

Plant Maintenance in the Organizational Structures of Accounting

- Budget Planning and Monitoring
- Cost Estimation
- Planned/Actual Cost Determination
- Order Settlement
- Logistics Information System (LIS)
- Plant Maintenance Information System (PMIS)
- Enhancement Options

4. Preventive Maintenance

Task List Management

- Task List Types
- Profile and User Fields
- Component Assignment
- Task List and Order

Single Cycle Plan

- Structure
- Scheduling Indicator
- Deadline Monitoring

Strategy Plan

- Maintenance Strategy
- Task List and Maintenance Strategy

Performance-Based Maintenance Planning

- Counters and Measurement Documents
- Maintenance Plan Scheduling

Maintenance Planning with Several Counters

- Cycle Sets
- Link Type

My SAP PM Certification Experience

2008-08-05T20:01:00.001+05:30

Please note that questions can be very different to what I had in Australia.

In my exam, we did not need to remember menu paths however there were a number questions on config settings...but to pass, they do need a deep understanding of PM functionality and how it all fits together. It will also help a lot if they have a good understanding of how a maintenance business works and been working in maintenance for a few years.

We had questions and up to 4-5 sub questions for each question (not all of them though). The exam has a time limit of 3 hours and the fee is non refundable if you fail..

From what I know, there are many different exam questions in the question bank. I really don't remember specific questions, just the type of questions. My advice is;

1. Attend all the SAP courses. SAP said there is nothing in the exam that is not in the courses.

2. Practice as often as you can in a DEV client, configuring things and seeing how they work, running transactions etc.

3. Practice with a friend, try and find difficult questions to ask each other and work out together how things work. Make a competition of it.

4. Open the PM menu path then open every transaction in it, read the help for each transaction ... even if you think you know it.

5. Understand the relationship between sap objects, such as costs and orders, overheads and costs, qualifications and orders, permits and tech objects etc.

6. Read the questions very, very, VERY carefully. They can be a little ambiguous (by design, to see if you know your subject).

7. One type of question they use is, 3 very similiar statements, but only one is right. Read carefully and think about it.

8. Try not to get too nervous and uptight before the exam. I did a little bit and it took a while to realise I actually knew the answers and it wasn't as hard as I first thought.

9. If you know SAP PM very well and read the questions carefully, you will find it fairly easy.

10. Have a look on Amazon books, there are a range of books supposedly giving sample questions for SAP certification exams, there may be one for PM by now.

As a note, When they give the exam, everyone gets a different exam and it is done electronically. It stops on the stroke of 3 hours, no extensions.

Phases of a SAP Project (ASAP)

2008-08-04T13:38:00.001+05:30

Phase I: Project Preparation

Decision makers define clearly Project objectives and an effective decision making process.
Define Project organization and Roles.
Implementation scope is finalized
System Landscape and technical requirements are finalized
Infrastructure (Hardware/Interfaces)
High level Strategies for client
Archiving strategy
Issues of Data bases
Other issues like
Unanticipated tasks
Normal tasks that can not be completed
External factors that need to be dealt with

Phase II: Blue Print Phase

Scope of R/3 implementation is defined.
Business blue print is created.o Tools used for this is ASAP Implementation assistant
Question and Answer Data
Base (Q&A dB) Business Process Master List (BPML)
R/3 Structure
Modules Business Navigator and External Modeling tools?
Project Management (Activities like…)
Conducting Status Meeting for Project Meeting
Conducting Steering committee meetings
Addresses the issues like Organizational Change Management
Other Activities Like
Project Team Training
Developing the system environmento Defining Org Structure
Define Business Process

Phase III: Realization Phase

Configuring the R/3 System
Defining the Authorizations in R/3
Defining the work flow
Creating Use Documentation
System manager procedures
Developing the System Test plans
Define the Service level Commitment
Establishing the System Administration function
Setting up the Quality Assurance environment

Phase IV: Testing and Final Preparation

Testing, user Training, System management and Cutover activities
Test Plan has the activities of:
Testing the conversion procedures and programs
Total Interface programso Volume and Stress testing
Final User acceptance testingo Developing a Final Go-Live strategy
Redirection to Go-Live? Preparation of End-user documentation
Training for the End Users
Technical environment installation on Production system and testing
Transfer of Legacy data and preparation plan for Go-Live

Phase V: GO-Live Phase

Production support facilities are carried out
Validations of Business process and their configuration
Follow up training for End Users
Sign–Off.

Accelerated SAP Introduction

2008-08-04T13:37:00.000+05:30

Enterprise application software has to cover a broad spectrum of functionality, yet be configured flexibly enough to meet specific requirements, which can vary enormously. SAP’s answers to this challenge are AcceleratedSAP and the R/3 Business Engineer, providing a comprehensive solution for implementing R/3 quickly, easily, and according to your own needs even during productive operation.

Born out of the need to cost effectively configure R/3 to order, AcceleratedSAP and the Business R/3 Engineer support custom configuration of R/3. You can tailor the R/3 components, functions and organizational structures to your needs, hiding and/or deactivating those functions that are not required.

Fig. 1: The R/3 Business Engineer Complements ASAP

AcceleratedSAP (ASAP) is SAP's standard implementation methodology. It contains the Roadmap, a step-by-step guide that incorporates experience from many years of implementing R/3. Along with that, AcceleratedSAP contains a multitude of tools, accelerators and useful information to assist all team members in implementing R/3. Quality checks are incorporated at the end of each phase to easily monitor deliverables and critical success factors. ASAP is delivered as a PC-based package, so that - if required - an implementation project can begin prior to having an R/3 System installed.

The R/3 Business Engineer contains a set of configuration and implementation tools which enable you or your consultants to define and configure R/3 and also to adapt an existing configuration to new needs or changed circumstances. The Business Engineer is resident to R/3.

So that its customers can implement R/3 as quickly as possible, SAP has standardized the implementation procedure, simplified the way functions are presented and reduced the technical complexity of implementation.

AcceleratedSAP and the Business Engineer help you configure R/3 according to your own needs using proven, industry-specific business scenarios and processes. Whether implementing new processes in your enterprise or restructuring old ones, R/3 can release the full potential of change for you. AcceleratedSAP and the Business Engineer help you determine which of R/3’s proven processes are most suited to your business, and then help you configure to meet your specific needs. The benefit is obvious: Restructuring enterprise processes in the R/3 System leads to a rapid and efficient production startup, meaning a faster return on investment.

By simplifying configuration, ASAP and the Business Engineer make the power of R/3 more accessible, helping companies to lower their dependence on expensive specialists or outside consultants. The user-friendliness of ASAP and the Business Engineer make them particularly suitable for the following groups:

Business professionals who need to discuss, prototype and design their business blueprint (enterprise model)
IS departments of large enterprises who need to customize R/3 applications more efficiently and more rapidly
Small and medium-sized companies previously wary of implementing R/3 because of the perceived scale of such projects
Consultants and SAP partners looking for an efficient way of offering their customers configure-to-order or wishing to develop R/3-based solutions for niche markets

Together, AcceleratedSAP and the Business Engineer empower you to manage cost, time and quality without compromising on implementation requirements. Some of the features offered are:

 Reduced implementation times and faster return on investment through structured planning and preconfiguration

Intuitive understanding of the wide range of functions offered by R/3

Process optimization using proven scenarios, processes and value chains, illustrating clearly the software’s capabilities and offering practical help when you configure the R/3 System.

 High quality installations through comprehensive procedural guidelines

 Optimizing business processes using SAP Business Workflow, via process monitoring and automation of procedures

Continuous, dynamic adjustment and optimization of R/3 applications

The capability to copy configured areas, for example, by transferring existing settings to new organizational units.

AcceleratedSAP and the Business Engineer are designed for openness and new platforms, using HTML-based documentation. Compatibility with many third-party modeling tools and software packages, for example, Microsoft Excel, is ensured.

Available Tools

Embarking on an implementation project requires a lot of careful thought beforehand. You need to think about what you want to accomplish, the optimum sequence, and the business cases that are best suited to your needs. But SAP has already done a lot of the thinking for you and packaged its findings in the following tools. They are then described in more detail in the following chapters organized according to the corresponding AcceleratedSAP phases.

AcceleratedSAP (ASAP): A comprehensive solution for the introduction of the R/3 System in your enterprise. ASAP and most of its tools can be used independently of an R/3 installation.

The tools available for AcceleratedSAP are:

The Project Estimator, an internal SAP tool which enables SAP consultants to accurately gauge the required resources, the costs and the time frame of implementation. The Project Estimator takes into account the project scope and several project and risk factors.
The Concept Check Tool, a tool enabling you to carry out quality checks on the project preparation, technical infrastructure and R/3 configuration settings. This is done mainly during the first two implementation phases of the R/3 project. In this way you are alerted to potential data volume and configuration conflicts that could lead to performance issues if not addressed.
The Implementation Assistant: The ASAP navigation tool that accompanies you through the five phases of implementation down to the task level. It includes a description and a detailed "how-to" for each task in the Roadmap. Along with that, many tools, templates and documents are hyperlinked to the task. The Implementation Assistant contains the following elements:

ASAP Implementation Roadmap

and Project Plan. The Roadmap contains the five phases, from which you can drill down into work packages, activities and tasks. The Project Plan contains three components, a budget plan, a resource plan and a work plan. These are explained in more detail in the next chapter.

The ASAP Roadmap is the successor of the R/3-based Procedure Model, which was used until Rel. 3.1 in R/3 implementation projects.

Knowledge Corner

, containing tips and tricks for configuration from consultants, detailed documentation on SAP’s implementation services, information on technical tools, as well as simplification guidebooks and R/3 Customizing wizards.

Question and Answer Database (Q&Adb).

Using the R/3 Reference Model structure, the Q&Adb is used to assist in gathering requirements for business processes, conversions, reports, interfaces, enhancements and authorizations. The database provides useful questionnaires to help you define the process needs and also serves as a repository for all this information. Since it is a database, it allows for flexible reporting. The business requirements generated from the Q&Adb are collectively known as the Business Blueprint.

Business Process Master List

, to manage configuration, testing and the creation of end user documentation. The Business Process Master List is linked to pre-written Business Process Procedures (BPPs), detailled end-user documentation for R/3 transactions.

Issues Database

: supporting project management, this database supports the entering, monitoring and managing of issues that come up during the project.

R/3 Business Engineer:

The implementation tools for the high-quality configuration of the R/3 System are:

R/3 Reference Model: Comprehensive graphical process flows describing the R/3 functionality from different points of view. It contains scenarios, processes and functions, as well as components. The R/3 Reference Model can be viewed using SAP's Business Navigator and the Business Navigator Web, or using third-party modeling tools available from modeling partners.

Implementation Guide

(IMG): Used to configure all system parameters for the business processes in R/3. It contains project management functionality and a menu-driven view of all R/3 Customizing activities. Every activity can be documented in detail, and responsibilities and statuses can be assigned.

Preconfigured systems:

Preconfigured US and Canadian clients: Provides a head start on baseline configuration. It includes a preconfigured US/Canadian chart of accounts, print forms, account determination, units of measure, etc. The predefined test sequences that are included can be a starting point for integration testing.
Preconfigured industry systems: A number of complete preconfigured clients consisting of an industry-specific model and preconfigured business processes for the needs of a particular industry in R/3 are available. For more information on preconfigured systems, see the description of Phase 2, Business Blueprint or the information on the IDES System in this chapter.

Continuous Business Engineering

In today’s fast-moving, ever-changing business climate, companies are in a constant state of flux and their mission-critical applications must adapt and evolve at the same speed. If software cannot grow with the needs of a company, the company will quickly find itself in a straightjacket.

Furthermore, an ERP application needs to let you move forward fast, knowing that you can roll back changes without downtime.

An enterprise's organizational structure and the corresponding R/3 implementation created using the Business Engineer are not "set in concrete", they can be modified at any time. Examples of possible changes, which can be made rapidly include the following:

Addition or removal of entities within the organization structure (for example, business units, production plants, warehouses, etc.)
Introduction of new staff, promotion, reallocation of work tasks, and maintenance of authorization profiles

Changes to the reporting or cost/profit center structure

New and concurrent currencies

Accommodation of changed legal requirements (for example, new tax rates, new employment legislation)

Activation or deactivation of R/3 functions

Optimization of business processes

Support for new and multiple versions of R/3

In addition, SAP offers a range of services if you want support for some of these changes, for example, conversion services to support mergers and acquisitions. Standard Euro services are a further example of the available services.

AcceleratedSAP and R/3 Business Engineer take the hassle out of implementation procedures and change management. Modifications can be made at any time, and the compatibility of changes can be verified with other configuration decisions, thus supporting their smooth, trouble-free introduction into the productive system.