SAP FICO Online Tutorial, Reports, Fixed Assets and more.

How to Refresh SAP screen after certain action using SAP ABAP?

2011-12-31T03:31:00.000-08:00

I have a screen with a table in it (generated with the screen painter) that shows records from a database table. The screen also has a button, which shows a popup when it's clicked. The popup has a form to add a record to the database table.
When the form is submitted the record is added to the database, but when the popup is closed, the screen that shows the database records isn't refreshed. The new record isn't shown. Any ideas how I could make the table refresh? Simply calling the screen again doesn't seem to work..
Answer:

You have to make sure that the data that you want to display is actually in the internal table that is displayed by the screen.

You can reread the database table or
append the line generated by the pop-up form to the internal table (If the line types aren't identical you will have to move the fields to a similar structure first).

If the internal table has all the data, but it still does not display in the table control, make sure that the field in the table control that has the number of lines is updated to reflect the extra line.

How to Change parameter name on screen in SAP ABAP?

2011-12-30T03:30:00.000-08:00

I'm trying to replace the parameter name when it is showed in the screen. Any ideas how this is done? For example when I have:

PARAMETERS pa_age TYPE age_type DEFAULT '18'.

It shows pa_age on the screen. I want to change it to How old are you? or something. Any ideas?
Answer:
Via menu Goto->Text Elements->Selection Text.

SAP ABAP Issue:how to make select option with todays date as default?

2011-12-29T03:28:00.000-08:00

I'm trying to show todays date as the default value in a select date.

INITIALIZATION.
select-OPTIONS: so_date FOR sy-datlo.

START-OF-SELECTION.
so_date-sign = 'I'.
so_date-option = 'BT'.
so_date-low = sy-datum.
so_date-high = sy-datum.
APPEND so_date.

This isn't working though. Any ideas?
Answer:

You must set the value before START-OF_SELECTION:

select-OPTIONS: so_date FOR sy-datlo.

INITIALIZATION.
  so_date-sign = 'I'.
  so_date-option = 'EQ'.
  so_date-low = sy-datum.
  CLEAR so_date-high.
  APPEND so_date.

Did you try the easy version:

select-OPTIONS: so_date FOR sy-datlo default SY-DATUM.

I think it should work (can't test is actual).

SAP Certification questions on Project Implementation Tools

2011-12-28T22:55:00.000-08:00

1. What is the IMG?

2. What is a project IMG?

SAP ABAP Issue: Where we can find the authority objects?

2011-12-28T03:26:00.000-08:00

Any ideas where I can find a list of existing authority objects? I'm looking for the 'default' ones like S_CARRID.
Answer:
Transaction SU21. The S_CARRID object is located inside the BC_C object class.

SAP Certification questions on SAP Overview

2011-12-27T22:55:00.000-08:00

1. Explain the structure of the client/server framework.

SAP ABAP cProjects replication and Set task-level WBS

2011-12-27T03:21:00.000-08:00

When creating a project in cProjects I am using BADI BADI DPR_FIN_GECCO_ATTR to manipulate the external WBS ID that is created in SAP PS.
SAP accepts the ID that I pass for the Phase level, but for the Task level SAP appends a string "/TTO" to the end of my WBS ID. Any idea why this happens and how I can get rid of it. The "/TTO" violates or masking structure in PS?

constants: lc_phase_id_ps type char30 value 'DPR_TV_PROJECT_ELEMENT_ID_PS',
           lc_task_id_co  type char30 value 'DPR_TV_PROJECT_ELEMENT_ID_CO'.

field-symbols:  type dpr_ts_project_ext,
                type dpr_ts_project_int,
                  type dpr_ts_phase_ext,
                  type dpr_ts_phase_int,
                   type dpr_ts_task_ext,
                   type dpr_ts_task_int,
                 type dpr_ts_iaom_object_attribute.

case ir_common->get_object_type( ).
  when cl_dpr_co=>sc_ot_project.
    "not doing anything with this data yet
    assign ir_project_ext->* to .
    assign ir_project_int->* to .  

  when cl_dpr_co=>sc_ot_phase.
    assign ir_attributes_ext->* to .
    assign ir_attributes_int->* to .
    read table ct_attributes assigning 
      with key data_element = lc_phase_id_ps.
    if sy-subrc = 0.
      -value = -phase_id.  "something like Z/001-001
    endif.

  when cl_dpr_co=>sc_ot_task.
    assign ir_attributes_ext->* to .
    assign ir_attributes_int->* to .
    read table ct_attributes assigning 
      with key data_element = lc_task_id_co.
    if sy-subrc = 0.
      -value = -search_field.  "something like Z/001-001-001
      "sometime after this badi call it is changed to Z/001-001-001/TTO
    endif.
endcase.

Answer:

I have found the spot where SAP changes the WBS:
In Class CL_IM_CPRO_PROJECT_LABEL method IF_EX_GCC_PS_PROJECT_LABEL~GET_WBS_ELEMENT there is the following logic:

if lv_object_type_co ne 'DPO'.
  read table attributes_of_ext_obj
       into ls_attribute
       with key data_element = 'DPR_TV_PROJECT_ELEMENT_ID_CO'.
  if sy-subrc = 0.
    if lv_object_type_co eq 'TTO' or     "Aufgabe            "H860739
       lv_object_type_co eq 'ITO'.       "Checklistenpunkt   "H860739
      concatenate ls_attribute-value                         "H860739 
                  lv_object_type_co                          "H860739
                  into ls_value.         "<<==Here it is     "H860739
      wbs_element = ls_value.                                "H860739
    else.                                                    "H860739
      wbs_element = ls_attribute-value.
    endif.                                                   "H860739
  else.
    message e013(iaom_cprojects)
      with 'DPR_TV_PROJECT_ELEMENT_ID_CO'
      raising error_occurred.
  endif.
  "...
  "... Code removed
endif.

SAP ABAP Issue: modal-dialog-box not working

2011-12-26T03:26:00.000-08:00

I'm trying to call a screen as a popup. The screen type is set to Modal dialog box and I'm able to call the screen, but unable to close it. Nothing happens when I click on the little cross. The next screen is set to 0.
The screen I'm calling as a popup, doesn't contain any buttons, not any hard coded ones anyway. Any ideas what I'm doing wrong?
I'd also like the screen it returns to, to be refreshed (so it loads the PBO again). How do I do that?

EDIT

MODULE werkende_knoppen_subscreen INPUT.
  CASE ok_code.
    WHEN 'X'.
      LEAVE TO SCREEN 0.
  ENDCASE.
ENDMODULE.

Answer:

You should be checking for the 'EXIT' (or, in your case for the custom close button, 'X') user command in the PAI part of your popup. For example:

MODULE user_command_0010 INPUT.
  ok = sy-ucomm.
  CLEAR sy-ucomm.
  CASE ok.
    WHEN 'EXIT' OR 'X'.
      LEAVE TO SCREEN 0.
  ENDCASE.
ENDMODULE.

SAP ABAP Issue: Is there a any way to find the customizing request number for a given record at a maintenance view?

2011-12-26T03:24:00.000-08:00

In ABAP we can check the latest workbench request assigned to a given code from Utilities->Versions->Version Management menu.
Is there any similar feature to check which is the customizing request for a given record at a maintenance view (SM30) ?
ps. of course, considering that the transparent table for that given record have the delivery class E, or C, that needs the customizing request to allow the user to insert or remove the record.

Answer:

The table entries are transported as R3TR TABU or R3TR VDAT entries, while maintained via SM30. You can find these using function "Search for Objects in Request/Task", which you can find in transactions SE03 or SE09 (as described by Esti). - This way you can find all requests and tasks, which contain any entry from the table or view.
Alternatively you can look directly into DB table to find particular record directly.
You can do it following way:

start transaction SE16
enter the table name E071K
field OBJNAME is your table
field TABKEY contains the key of the record
execute the selection
field TRKORR then contains the request or task you are looking for...

Keep in mind that client-dependent tables start with client, and the key is concatenation of all the fields and it can contain * (star).
Example: for instance the record for company code DE01 in client 055 in table T001 has the tabkey value

055DE01

For table T001E, to transport all the entries of company code DE01 it would be then

055DE01*

SAP ABAP Cost centre and work order report issue

2011-12-26T03:18:00.000-08:00

Im very new to abap and i was assigned to do a report on all work orders related to a cost center.Can any sap guru explain how are cost center related to work orders with the related tables.Thank you in advance.

Answer:

I will teach you how to fish, but I will not feed you.
Basically a report like this will be simple in terms of ABAP skill, that is until your asked to do something more than just pick out work orders based on Cost Center.
Internal Orders or Work Orders are all Cost Center related. Each work order created has an assigned cost center and can be found in the following tables and structure.
COEP Controlling Object: Line Items by period. This will have your Order number, item and also Cost Center.
COEJ Controlling Object: Line Items by year. This will have the same by Year.
This is a start. You can also use t-code IW39 to pull up a Work Order. Then place the cursor on the field you have in question and hit F1, then in the dialog box choose the Technical Content Icon (Wrench/Hammer). That will bring you to the technical description of the field and will have table name etc...
Happy fishing, come back with more questions after you have had a chance to look at what I gave you. Also, give us some more info on your configuration.. Do you run PM?

SAP Internal Order Configuration steps

2011-12-19T22:54:00.000-08:00

Define Order types


Define Model orders


Maintain Allocation structure


Maintain Settlement profile


Maintain number range for settlement documents

SAP Product Costing Configuration steps

2011-12-18T22:52:00.000-08:00

Configuring the Costing sheet for calculating overhead


Configuring the Cost component structure


Configuring the costing variant


Configuration for mixed costing


Configuration for joint product


Configuration for Work in Process calculation


Configuration for Variance calculation


Configuration for settlement of variance


Configuration for Product cost by period - product cost collector and setting up of variance calculation


Configuration for Product cost by sales order

SAP Profit Center Configuration

2011-12-17T22:51:00.000-08:00

Maintain the profit center settings for Controlling area


Creation of dummy profit center


Creation of Standard hierarchy and creation of profit center master


Configuring the transfer price settings


Profit center planning configuration


Configuring Distribution and Assessment cycle


Configuring the 3KEH table (Balance sheet and profit and loss accounts)

SAP Profitability Analysis Configuration

2011-12-16T22:52:00.000-08:00

Creating Characteristics and value fields


Configuring the Operating concern


Copying an Operating concern from an existing operating concern


Maintain Characteristic values, defining characteristics hierarchy


Defining Characteristic derivation


Defining keys for accessing material cost estimate and assigning costing key to characteristics


Planning configuration


Maintaining value field groups


Configuration for value flow from SD to PA


Configuration for value flow form FI to PA


Configuration for settlement of Product costing variance to PA


Creation of Profitability report


Transporting customizing settings

SAP Cost Center Configuration

2011-12-15T22:51:00.000-08:00

Configuring the Controlling area


Maintaining versions in Controlling area


Configuring multiple valuation approaches/ Transfer prices


Cost element accounting set up


Reconciliation ledger configuration


Setting Cost center Hierarchy, cost center master data, activity types


Cost center planning which includes creating planner profile, creating planning layout


Configuring various cycles such as Distribution. Assessment, Indirect Activity allocation


Configuring Splitting structure


Configuring Automatic account assignment (OKB9)

SAP Special Purpose Ledger configuration

2011-12-14T22:50:00.000-08:00

Define Table Group


Maintain Fiscal Year Variant


Maintain Ledgers


Maintain Local Posting Periods


Maintain Actual Versions


Maintain Valid Document types


Maintain local number ranges


Perform Diagnosis


Entering an FI-SL document


Define Libraries


Define Report Painter Reports

SAP Asset Configuration (based on New GL)

2011-12-13T22:49:00.000-08:00

    With the introduction of SAP New GL there is no longer a need to maintain different GL codes for different depreciation areas. The only requirement is to maintain for each reporting 2 additional depreciation areas i.e. one real depreciation area and second derived depreciation
     Configure Depreciation as above


     Assign target ledger group to the respective depreciation areas


     Wizard to set up Parallel Valuation.

SAP Asset Configuration

2011-12-12T22:49:00.000-08:00

Copying Chart of Depreciation


Define Asset Classes


Configuring account determination for Assets (Integration of Asset with GL)


Deactivate Asset class for Chart of depreciation


Configuring posting of depreciation


Configuring the depreciation key


Configuring asset classes for group assets


Define/Assign Settlement profile


Legacy Asset data transfer

SAP AR & AP configuration

2011-12-11T22:48:00.000-08:00

Define Account Groups for Customers and Vendors


Define Accounting clerk


Delete Customer and Vendor Master data


Configuring Payment terms


Configuring various automatic account determination


Defining Tolerances


Configuring Automatic Payment Program


Special GL configuration for down payments from customer and vendors


Configure regrouping of Customers & vendors per remaining terms of receivables & payables


Dunning


Configuring calculation of Interest on arrears

SAP Bank Configuration

2011-12-10T22:47:00.000-08:00

Define House Banks


Electronic and Manual Bank statement configuration


Check Deposit configuration


Configuring Cash Journal

SAP Cost of Sales Accounting configuration

2011-12-09T22:47:00.000-08:00

Cost of Sales accounting needs to be implemented in a manner which makes it more powerful to reconcile the FI and CO module and enable to do a fast close of month end activities.

This functionality needs to be implemented to find out balance on the following:-

	Process/Production orders not settled.
	Networks/WBS not settled
	Internal orders not settled.
	Plant Maintenance orders not settled.

SAP Actual Costing & Material Ledger Configuration steps

2011-12-08T22:54:00.001-08:00

Configuring Material Ledger for Plants


Configuring dynamic price changes


Defining and assigning the material ledger update structure to plants


Configuration of Actual costing and activation of actual cost component split


Production start up activities in Material Ledger

SAP New GL configuration

2011-12-08T22:47:00.000-08:00

Define Ledgers for GL


Define Currencies for Leading Ledger


Define and Activate Non-Leading Ledger


Assign Scenarios and Customer Fields to Ledgers


Define Ledger Group


Activate New GL Accounting


Define Accounting principles and assign to ledger groups


Define Variants for Real-time integration and assign to company code


Define document number ranges for GL view (posting only to specific Ledger)


Define document types for posting only to non leading ledgers


Configuring document splitting


Assigning Default profit center to accounts


Define Worklist for exchange rate entry


Assign Exchange rate to worklist


Configuring Assessment and distribution in New GL


Deactivate update of Classic GL

SAP GL configuration

2011-12-08T22:46:00.000-08:00

Company Code configuration

Standard Line item text configuration

Complete GL configuration, defining chart of accounts, defining retained earnings account

Validation & Substitution

Parallel currencies configuration

Taxes on Sales Purchase configuration

GL Automatic clearing configuration

Foreign currency valuation configuration

GR/IR Regrouping configuration

Financial Statement version configuration (Creating Balance sheet and Profit and Loss account)

FI - MM account determination configuration

FI - SD account determination configuration

SAP ABAP Smartform Print Problem

2011-12-08T22:44:00.001-08:00

I am facing a strange issue while printing a smartform at the user location. There is a black box covering the entire lower portion of the page.In the smartform a window is placed at this position. When I delete the window and print it, the output is fine. I have checked the option of window shading color as well âs whatever color/no color I give, it doesn't make any difference.

This happens only in a certain type of printer at the user's location ând everywhere else its fine.

Please give some pointers âs is this a printer fault or can something be changed in the smartform to solve this problem?

Ans : I think smart forms are some how printer specific, It is not a must that if tested on one printer it will work perfectly well on the other. I always face similar problems with logos coming upside down on some printers or being very faint etc.
so its usually a printer problem. Try changing the drivers of that printer especially to a lower version and see.
Your hardware team can help if not conversant

SAP FICO VIDEO TRAINING TUTORIALS 0021 TASK 1 GENERAL LEDGER MASTER CREATION ECC6

2011-11-03T20:33:00.000-07:00

SAP FICO VIDEO TRAINING TUTORIALS 0009 MAINTAIN FISCAL YEAR VARIANT ECC6

2011-11-02T20:31:00.000-07:00

SAP FICO VIDEO TRAINING TUTORIALS 0030 OPTION-2 MONTH END PROVISIONS ECC6

2011-11-01T20:28:00.000-07:00

SAP FICO VIDEO TRAINING TUTORIALS 0001 COMPANY CREATION

2011-10-31T20:31:00.000-07:00

sap fico tutorial

2011-10-31T20:26:00.001-07:00

Balance sheet valuation

2011-09-30T08:39:00.000-07:00

Balance sheet valuation:
You can valuate stocks for the balance sheet in two ways: Lowest value
determination according to current market prices (RMNIWE00) and lowest value
determination according to rate of movement/range of coverage (RMNIWE10/20).
You can use both methods separately (single-level procedure) or in combination
(multi-level procedure).

standard procedure for posting procurement transactions in Financial Accounting

2011-09-29T08:38:00.000-07:00

The three-step reconciliation is the standard procedure for posting procurement
transactions in Financial Accounting. The procedure involves the following three
steps:
Purchase order
This is carried out exclusively in MM. No data is posted in Financial
Accounting.
Goods receipt
To update the inventory, a material document is created in MM. At the same
time, a document is created in FI, which is used to post the value of the
goods to the material stock account or the consumption account (debit) and
to the goods receipt/invoice receipt account (credit).
Invoice receipt
The vendor invoice is posted in MM and a document is created in FI at the
same time. This FI document contains the invoice amount that is posted to
the goods receipt/invoice receipt account (debit) and to the vendor account
(credit).
The last two steps can be completed in reverse order, depending on the order in
which the goods and the invoice are received.
The goods receipt/invoice receipt account ensures that goods were received for
each invoice and vice versa.

Cycle counting method:

2011-09-28T08:37:00.000-07:00

Cycle counting method: This also involves a physical inventory count.
The material stocks are counted at regular intervals during the fiscal year.
The interval or cycle in which a material is counted depends on the cycle
counting indicator set for the material.

Periodic inventory method:

2011-09-27T08:36:00.000-07:00

Periodic inventory method: All stocks are physically counted on the
balance sheet key date. Every material has to be counted on this date. During
the count, the entire warehouse is blocked from any material movements.

Continuous inventory method

2011-09-26T08:36:00.000-07:00

Continuous inventory method: Stocks are counted throughout the entire
fiscal year. Every material has to be physically counted at least once during
the course of the year.

Fixed Assets FICO Certification Example

2011-09-25T08:33:00.000-07:00

Business Example
In preparation for year-end closing, you need to review the closing activities for
Asset Accounting.
For month-end closing, you need to execute a depreciation posting run to record
depreciation expenses for the current period and to post the results to the general
ledger.

Task 1:
Carry out the following task.
1. Execute the Fiscal Year Change program for your company code AC## IN
TEST MODE only. Check the documentation that is displayed.
Hint: If the Limitation online message appears, choose Yes
to continue processing.

Task 2:
Process an unplanned depreciation run for the current period in your company
code. Check the effects of this closing process on your financial statements from
the general ledger.
1. Use the report variant VAR## that you created earlier to check the financial
statements (RFBILA00) before posting depreciation. At this point in time,
you will see the asset acquisition value only.
2. In a second session, execute an unplanned depreciation posting run for your
company code AC## for the current period. Execute the update run (deselect
the Test Run indicator). Use printer LP01.
Hint: Remember that you have to execute a depreciation posting run
in the background. Choose Immediate Processing.
Now take a look at the log and the documents for the depreciation run in
your company code AC## for the current period.
4. You use the Asset Explorer to check the depreciation (under Posted Values)
for the depreciation areas 01 (book depreciation) and 20 (cost accounting
depreciation).
5. Return to your original session to recreate the financial statements. Now
you will see the depreciation posting in the balance sheet (accumulated
depreciation) and in the P&L (ordinary depreciation).

Task 3:
Answer the following questions about year-end closing activities in Asset
Accounting.
1. Name the year-end activity that has to be performed within FI-AA in order
to be able to post to asset accounts in the new fiscal year. When should
this activity be performed?
2. Name the checks that are performed before the previous year is closed with
the year-end closing program in Asset Accounting.

Task 1:
Carry out the following task.
1. Execute the Fiscal Year Change program for your company code AC## IN
TEST MODE only. Check the documentation that is displayed.
Hint: If the Limitation online message appears, choose Yes
to continue processing.
a) Carry out the fiscal year change in test mode
Menu path for fiscal year change:
Accounting → Financial Accounting → Fixed Assets → Periodic
Processing → Fiscal Year Change
Enter the following data:
Company code(s): AC##
New Fiscal Year: Current year + 1
Test Run: Set indicator
Execute the report.
Hint: If the Limitation online message appears, choose
Yes to continue processing.
Once you have checked the report, return to the main menu.

Task 2:
Process an unplanned depreciation run for the current period in your company
code. Check the effects of this closing process on your financial statements from
the general ledger.
1. Use the report variant VAR## that you created earlier to check the financial
statements (RFBILA00) before posting depreciation. At this point in time,
you will see the asset acquisition value only.
a) Call up the report (RFBILA00)
Menu path for report:
Information Systems → Accounting → Financial Accounting →
General Ledger → Balance Sheet
Select a variant:
Goto → Variants → Get... . Enter VAR##.
Choose Execute to select the variant.
Execute the report.
After you have checked the report, return to the Balance Sheet/P+L
Statement screen.

In a second session, execute an unplanned depreciation posting run for your
company code AC## for the current period. Execute the update run (deselect
the Test Run indicator). Use printer LP01.
Hint: Remember that you have to execute a depreciation posting run
in the background. Choose Immediate Processing.
a) Execute an unplanned depreciation posting run
Hint: Remember that you must execute a depreciation posting
run in the background.
Choose Immediate Processing.
Menu path to create a new session:
System Create Session
Menu path for the depreciation program:
Accounting → Financial Accounting → Fixed Assets → Periodic
Processing → Depreciation Run → Execute
Enter the following data:
Company Code: AC##
Fiscal Year: Current year
Posting Period: Current period
Select Unplanned Posting Run. Deselect the Test Run indicator.
Choose Program → Execute in Background.
Enter LP01 as the output device.
Choose Enter.
Choose start time: Immediate.
Save.

Now take a look at the log and the documents for the depreciation run in
your company code AC## for the current period.
a) Menu path for the log:
Accounting → Financial Accounting → Fixed Assets → Periodic
Processing → Depreciation Run → Display Log
Enter the following data:
Company Code: AC##
Fiscal Year: Current fiscal year
Posting period: Current period
Set the List Assets indicator.
When the assets have been listed, double-click on Document Number
to branch to the accounting document (documents in Accounting).
Take a look at the accounting document and then go back to the main
Asset Accounting menu.
4. You use the Asset Explorer to check the depreciation (under Posted Values)
for the depreciation areas 01 (book depreciation) and 20 (cost accounting
depreciation).
a) Menu path for the Asset Explorer:
Accounting → Financial Accounting → Fixed Assets → Asset →
Asset Explorer
Enter the following data:
Company Code: AC##
Asset: TACMACH##
Fiscal year: Current fiscal year
For this asset, choose the depreciation area 01 book depreciation and
go to the Posted Values tab page to display the depreciation amounts.
Repeat this step for depreciation area 20, cost accounting depreciation.
5. Return to your original session to recreate the financial statements. Now
you will see the depreciation posting in the balance sheet (accumulated
depreciation) and in the P&L (ordinary depreciation).
a) Create financial statements (RFBILA00)
Execute the report again from the Balance Sheet/P+L Statement screen.

Task 3:
Answer the following questions about year-end closing activities in Asset
Accounting.
1. Name the year-end activity that has to be performed within FI-AA in order
to be able to post to asset accounts in the new fiscal year. When should
this activity be performed?
a) Questions on the year-end closing activities in Asset Accounting
Name the year-end activity that has to be performed within FI-AA in
order to be able to post to asset accounts in the new fiscal year. When
should this activity be performed?
The fiscal year change program displays fields for entering a new
annual value for each asset. The earliest you can start this program
is in the last posting period of the 'old' year.
2. Name the checks that are performed before the previous year is closed with
the year-end closing program in Asset Accounting.
a) The check report for year-end closing checks:
Whether all the assets accrued in the fiscal year have been
activated.
Whether the fiscal year change has been completed for all assets
Whether depreciation was fully posted
Whether errors exist (such as an incorrectly defined depreciation
key for the depreciation calculation)
Whether the asset balances from depreciation areas for periodic
posting have been posted in full to the general ledger.

FICO Certification topics

2011-09-24T08:29:00.000-07:00

Identify where in the system you execute the financial statement program
Describe the purpose of the financial statement version
Create, change, and display financial statement versions
Create financial statements using a drilldown report

Fixed and Current Assets FICO Certification material

2011-09-23T08:30:00.000-07:00

Outline the impact of posting book and tax depreciation within Asset
Accounting on periodic closing activities within General Ledger Accounting.
Explain how the physical inventory procedure can lead to a G/L posting
Describe the monthly maintenance of the GR/IR clearing account in MM
Carry out the analysis of the GR/IR account for year-end closing
Identify the various year-end valuation methods for work in process and for
material that is procured internally and externally

Drilldown Reporting Solutions

2011-09-22T08:28:00.000-07:00

Create a new session.
1. Create financial statements using the Actual/Actual Comparison for Year
drilldown report. Run the report for your company code AC## and the
current fiscal year. Use the financial statement version that you created
(FS##). Within the output list of the report, drill down to the line items
which make up the account Salaries.
a) Call up drilldown report
Menu path to create a new session:
System → Create Session
Menu path for the report: Accounting → Financial Accounting →
General Ledger → Information System → General Ledger Reports →
Balance Sheet/ Profit and Loss Statement / Cash Flow → General →
Actual/Actual Comparisons→ Actual/Actual Comparison for Year
Enter the following data:
Company Code: AC##
FIS Annual Rep.Struc: FS##
Fiscal Year: Current year
Execute the report.
Expand the profit and loss statement by clicking the + to the left of
the Profit and loss statement line.
Continue to expand the following:
+ Staff costs
+ Wages and salaries
+ Salaries
+ Salaries
→ Salaries
Place the cursor on the selected row in the column for the current
fiscal year.
Choose Goto → Line Items
Check the line items for this account.
(Optional) Display the line items by double-clicking them. In the
document display, choose the Document Overview icon to view the
other line items for this document.

Drilldown Reporting

2011-09-21T08:27:00.000-07:00

Business Example
The cross-application drilldown reporting function can also be used to create
financial statements. You will run a delivered balance sheet/profit and loss report
to explore the features provided by this reporting tool.

Task:
Create a new session.
1. Create financial statements using the Actual/Actual Comparison for Year
drilldown report. Run the report for your company code AC## and the
current fiscal year. Use the financial statement version that you created
(FS##). Within the output list of the report, drill down to the line items
which make up the account Salaries.

Creating Financial Statements Task 3

2011-09-20T08:26:00.000-07:00

Carry out the following task.
1. Create financial statements (report RFBILA00) for company code AC## for
the current period to test your new financial statement version FS##. Also,
create a report variant to simplify reporting in subsequent exercises. Assign
the variant name VAR## and the description CoCode AC## current period.
a) Test financial statements (RFBILA00) and create variant
Menu path for report:
Information Systems → Accounting → Financial Accounting →
General Ledger → Balance Sheet
Enter the following data:
Company code: AC##
Tab page: Further Selections
Financial Statement Version:FS##
Reporting year: Current year
Reporting Periods: From current period to current period
Choose Goto → Variants → Save As Variant...
Enter the following data:
Variant name: VAR##
Description: CoCode AC## current period
Save.
Execute the report.

Creating Financial Statements Task 2 step3

2011-09-19T08:24:00.000-07:00

Reassign your financial statement items under “Staff costs” by moving your
new item 3063000 to the end.
a) Reassign items
On the Change Financial Statement Version screen:
Place your cursor on item 3063000.
Choose Edit → Select +/-
(Item is highlighted)
Place the cursor on the target item, 3062000.
Choose Edit → Reassign +/-
Confirm the “Same Level” setting.
Choose Enter.
(Item is moved)
Save.
C

Creating Financial Statements Task 2 step2

2011-09-18T08:24:00.000-07:00

Check whether all the G/L accounts in your chart of accounts and company
code have been correctly assigned to the financial statement items in your
financial statement version.
a) Check the assignment of accounts
Choose Fin. Statement Items.
Choose Structure → Check.
Enter your company code (AC##) and set only the Nonassigned
Accounts Fr.Chart of Accts From Company Code indicator.
Choose Enter.
Once you have finished viewing the unassigned accounts, choose Enter
to close the dialog box and continue with the next exercise.
DO NOT EXIT THIS SCREEN
3. Create your own profit and loss item 3063000, Employee Training and
Education, under the “Staff costs” item.
a) Create profit and loss statement items
On the Change Financial Statement Version screen:
Drill down by clicking the folder to the left of the item “Profit and
loss statement”.
Place your cursor on the “Staff costs” item and choose Create Items.
Enter 3063000 as the item number and “Employee Training and
Education” as the description.
Choose Enter to add the new item to the structure.
DO NOT EXIT THIS SCREEN
4. Assign the account 476400, Training costs, to the new item “Employee
Training and Education”. The account will appear in this item whether it
has a debit or credit balance.
a) Assign account
On the Change Financial Statement Version screen:
Place the cursor on the “Employee Training and Education” item and
choose Assign Accounts.
Enter 476400 in the 'From act' column and set both the debit balance
(D) and credit (C) balance indicators.
Choose Enter.
DO NOT EXIT THIS SCREEN

Creating Financial Statements Task 2

2011-09-17T08:23:00.000-07:00

Task 2:
Create your own financial statement version FS## by copying and modifying an
existing version.
1. Copy the financial statement version INT to create your own version FS##
and add as a description Financial Statement Version ##. Use the language
of the country where the course is taking place as the maintenance language.
a) Create the financial statement version
Copy financial statement version INT.
Menu path to configure financial statement version:
Tools → Customizing → IMG → Execute Project → SAP Reference
IMG → Financial Accounting → General Ledger Accounting →
Business Transactions → Closing → Document → Define Financial
Statement Versions
Select the row for financial statement version INT.
Edit → Copy as
Enter the key FS## and the name Financial Statement Version ##.
Choose Enter.
Save.
Double-click the financial statement version you have just created
(FS##) to check the maintenance language.
If necessary, change this to the language of the country in which the
course is being held.
Save.
DO NOT EXIT THIS SCREEN

Creating Financial Statements

2011-09-16T08:22:00.001-07:00

Task 1:
Carry out the following task.
1. Create financial statements (report RFBILA00) for your company code
AC## for the current period and fiscal year. Use the existing financial
statement version INT and the ALV tree control list output.
a) Create the financial statements (RFBILA00)
Menu path for report:
Information Systems → Accounting → Financial Accounting →
General Ledger → Balance Sheet
Enter the following data:
Company code: AC##
Tab page: Further selections
Financial statement version: INT
Reporting year: Current year
Reporting periods: From current period to current period
List output: ALV Tree Control
Execute the report.

SAP FICO Real Time Interview Questions

2010-03-17T22:50:00.000-07:00

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

G/L Account Master Records

2008-09-25T22:47:00.000-07:00

Business transactions are posted to accounts and are managed via accounts. You must create a master record for each account you need. It contains information that controls the entry of business transactions in an account and the processing of data.

The G/L accounts record the business transactions in totals form. In the standard system, all business transactions that are posted to G/L accounts are updated in the general ledger. Additionally, you can define further ledgers which are also posted to. For this, you must use the Special Purpose Ledger system. Information on additional ledgers can be found in FI-SL Special Purpose Ledger.

The following sections contain basic information on G/L account master data as well as explanations of the settings that you make in Customizing. More detailed information on how to make these settings can be found in the General Ledger Accounting Implementation Guide. You can also find out how to create, display, change, delete, or lock general ledger master data.

FI General Ledger Accounting

2008-09-25T22:42:00.000-07:00

The central task of G/L accounting is to provide a comprehensive picture for external accounting and accounts. Recording all business transactions (primary postings as well as settlements from internal accounting) in a software system that is fully integrated with all the other operational areas of a company ensures that the accounting data is always complete and accurate.

The SAP FI General Ledger has the following features:

Free choice of level: corporate group or company
Automatic and simultaneous posting of all sub-ledger items in the appropriate general ledger accounts (reconciliation accounts)
Simultaneous updating of general ledger and cost accounting areas
Real-time evaluation of and reporting on current accounting data, in the form of account displays, financial statements with different financial statement versions and additional analyses.

Essentially, the general ledger serves as a complete record of all business transactions. It is the centralized, up-to-date reference for the rendering of accounts. Actual individual transactions can be checked at any time in realtime processing by displaying the original documents, line items, and transaction figures at various levels such as:

Account
Journals
Summary/balance transaction figures
Balance sheet/profit and loss evaluations

SAP Transaction Code For Recurring Tasks: Print Labels

2008-02-29T03:37:00.003-08:00

PBAK SAPMPAP0 Recurring Tasks: Print Labels

SAP Transaction Code For Recruitment info system

2008-02-29T03:37:00.001-08:00

PBAJ SAPMPAP0 Recruitment info system

FI, Vendor Master Data Archiving: Proposal List

2008-02-26T22:15:00.001-08:00

Tick the General Master Records to let the system check whether record can be archived.

Tick FI data

Tick Detail log

The rest Untick to let the system check all the FI and MM links.

Do not archived if there are still open items.

Description
Program SAPF058V allows you to automatically set archivable vendor master data for archiving. The same checks are carried out as with archiving.

Firstly a proposal list is issued. You can set and save the archive flag in this list.

If the program is started in the background, the archive flag is set automatically for all archivable data.

Archiving itself is only permitted for master records where the archiving flag is set. If a proposed archivable data record is to actually be archived, the archiving flag must be set.

You can restrict the quantity of master records to be checked by selecting :
- Vendor numbers
- Minimum number of days in the system
- Company codes, if FI data is to be considered
- Purchasing organization, if MM data is to be considered

System criteria (see below)
Requirement
Program modes
The program can be run in three different modes:

1. Only general data is set for archiving (A segments)
2. Only application-specific data is set for archiving (B segments)
3. General and application-specific data is set for archiving
Check whether data can be archived

Mode 1: The A segments selected must be set for archiving, and no dependencies to B segments may exist. For example, no company code data may exist for a vendor if the general data is to be archived.

Mode 2: The application-specific data must satisfy the relevant application criteria:

FI: Company code data is archivable if no special G/L figures or transaction figures and no open
or cleared items exist. In addition, the archive flag must be set at company code level.

MM: Purchasing organization data is archivable if the archive flag is set at this level.

Mode 3: The A or B segments selected must be set for archiving. The A and B segments of a record are deleted if the archive flag is set in the A segment. The B segment only of a record is deleted if the archive flag is set in the B segment (in this case, the A segment is only copied to the archive). In addition, the application-specific data must also satisfy the criteria from mode 2.

The A segments are archived if all of the dependent B segments are archived and the vendor is not referred to anywhere else. If this is not the case, the A segments are copied into the archive.

For all modes: Vendors cannot be archived if they are referred to on a general/company code level from other vendors (for example, financial address or alternative payee). This check can be deselected however (use the field "FI link validation off") if you know that all the vendors that refer to the first vendor are to be archived in this or a following run.

Output
According to the selection, a list of the general and/or application- specific data that can be archived is output. You can change and save the archive flags in the list.

If "Vendors that cannot be archvd" is set on the selection screen, the non-archivable data is also listed with the reason that it could not be archived.

A warning may be issued for the general data: In this case, the A segment record was not deleted from the database, instead, it was copied to the new archive. This can lead to different versions of the a vendor in the database and the archive and must be noted for future reloads. Usually, a warning or an error in the general data can be explained in more detail with the help of the
application-specific details.

If the archive flags are saved from the first list, or if the program is started in the background, a second list is output. All of the successful and failed updates of the archive flags are listed here.

Other
If you are starting this program for the first time and you want to carry our the FI link validation (standard setting), you have to start program SAPF047 first, in order to generate the validation information (table KLPA).

Deactivation of Depreciation

2008-02-26T22:14:00.001-08:00

Deactivation of Depreciation

We have a scenario wherein Fixed Asset is no longer in Use but not yet retired.

We require that the system should stop calculating Depreciation from the date/month from which the Asset is not in Use.

Is there any setting for that.

In the time-dependent screen of the asset master record, there is an option for asset shutdowns. Create a new interval and mark the asset for shutdown. If you don't have this setting, otherwise select this option from spro.

You can avoid depreciation on asset by putting the standard depreciation key of '0000', but be sure before you put it because once you put it I dont think it can be changed to the earlier state.

How should I change legacy asset accumulated depreciation?

2008-02-26T22:13:00.002-08:00

How should I change legacy asset accumulated depreciation?

Due to inconsistencies between GL and AA Accumulated Depreciation, you tried using transaction AS92 but the field Accum Deprecitaion is in Gray (display only).

It give a message Transfer Date XX.XX.XXXX is earlier than the last day of previous year

Check the transfer date in the IMG. Legacy data transfer is normally performed at the end of a previous fiscal year or within a current year. For example: if the trasfer date is set to 6/30/2001 and I'm in fiscal year 2003 [fiscal year 2002 is already closed], I will get the same message " Transfer date is earlier than last day of previous year - the previous year meaning 06/30/2003 and transfer date set 06/30/2001. Check to ensure that you want to transfer at the end of a fiscal year. If not, you have to change the trasfer date which is already set-up in the system. Once the transfer date is corrected, the accumulated depreciation field is open for changes.

In this case the transfer date is on 31/8/02. Last day of previous financial year is 30/01/02. Current depreciation has been posted to this asset (from 30/9/02 onwards) but I need to change the accum depreciation on 31/8/02.

I have encountered this problem before. These are the steps that I did:

(1) Always assume AA figure is correct as AA is very controlled system and sub-ledger. Should whatever posted in AA will be posted to G/L. But in G/L , we can always do the adjustments.

(2) Compare program RAGITT01 (click posted depr.) and RFBILA00. Check for accumulated depreciation accounts.

Then, do the adjsutments below:

(3) TCode ABF1

DR/CR Accumulated depr
(Transaction code: 500)
DR/CR Depr. expense
(Cost center needed)

The DR/CR is depending on whether the accum. should be increase/ decrease.

Is there a quick way to change items previously expensed to a cost center into a fixed asset?

2008-02-26T22:13:00.001-08:00

Is there a quick way to change items previously expensed to a cost center into a fixed asset?

First create asset master record thru' AS01 with the necessary cost center. Then go to TCode F-02

DR Asset number
(Transaction type: 100)
CR Expense acct
(Cost center)

When the posting involves expense acct, system will prompt for cost center that need to be charged.Therefore, for this case you can reverse back the cost center in-charge before. So the cost center assigned in asset master record will be charged during running the periodic processing.

Fiscal year and controlling area

2008-02-26T22:12:00.000-08:00

Fiscal year and controlling area

Can I have a company code with fiscal year january to december and another company code with fiscal year april to march in the same controlling area?

If so, does the period "mapping" happen automatically?

As per Sap standards, if one has to assign more than one company code to a controlling area, then for all the company codes should have the same fiscal year and the same chart of accounts.

One cannot assign more than one company code to a controlling area with different fiscal year.

How do you set a default cost center and/or internal order per business area through OKB9?

2008-02-26T22:11:00.002-08:00

How do you set a default cost center and/or internal order per business area through OKB9?

On 4.6x and above enter the cocd and account and select the account assignment detail field as 2 (Business area is mandatory).

Select the line you just entered and click on the left side of your screen "detail per business area/valuation area".

Can EBS post to a cost center and income statement G/L Account?

2008-02-26T22:11:00.001-08:00

I am trying to post directly to a cost center instead of using a clearing acct. The clearing acct is determined via user exit and acct modifier.

How would I post directly to a cost center?

Please see OSS note 494777 and 155596 for explanation of the function exit_rfebbu10_001 (enhancement FEB00001) for EBS processing... You might also want to reference OSS note 0124655 that describes supported functions of the EBS...

We use a custom "Z" table (this data is treated as transportable configuration) that contains our cost center values for posting to P&L accounts processed in EBS... this table supplies the values in the user-exit (above)...

Recurring invoices

2008-02-26T22:10:00.001-08:00

Recurring invoices

Is there a functionality for posting recurring AP invoices? Like a process that could run daily and post invoices with certain parameters? What configuration steps need to be undertaken?

Use FBD1 to create the recurring document and F.14 to run the recurring entry program.

OBC1 is likely the only config required...this is used to set up the run schedules.

Is there a way to use this daily? it looks like that it for monthly process (in FBD1 you specify one date per month to be run at).

If you config the run schedule to be daily it will run on a daily basis ...take a look at OBC2...

After setting up the process, will it automatically generate Batch Input session daily, or one per month on the specified date, or it has to be triggered by the F.14 transaction by a user?

You can get the basis guy to help you. They can define jobs to schedule to run F.14 daily. If you have the required authorization, you can do it with transaction SM37WIZ, F.14 is tied to program 'SAPF120'.

Cancel a proforma Invoice

2008-02-26T22:09:00.002-08:00

Several users created proforma invoices referenced to a sales order. Now we need to delete the order but because a subsequent document (proforma invoice) exist, we cannot delete the sales order. Does anyone know how to get around it?

If you want to cancel a proforma invoice, goto Tcode VF02, enter your proforma invoice number.

Click on the menu (1st menu item).

Then confirm.

After you confirm the proforma invoice, the status of the proforma invoice will become Cancelled.

Substitution in Accounting Document

2008-02-26T22:09:00.001-08:00

I have configured the automatic payment processing. But I am faced with a problem in that I want the cheque number that is created, in the assignment (allocation) field of the payment document so that I can use it in Bank Reco and clearing.

I think I can used Substitution rules.

Substitution rules can be written for any fi doc getting created.
The Creation of rules are very user friendly.
In IMG path is financial accounting global setting - documents - line items - define substitutions

OSS notes Substitutions/Validations 42615 and 100261 and 20637 are helpful.

Sap Help documentation is available. But substitution is fairly easy. Just go as per the steps and you will get it.

I do not know how you are going to get the check number from. I tried to see whether it is available in any table but couldn't find it.

RFCHKU00
This is a readymade program available from 4.0c onwards to copy
check number in assignment /ref. field.

Transaction : MR11 - GR IR Clearing Account Maintenance

2008-02-26T22:08:00.001-08:00

You use GR/IR account maintenance if you have open items on the GR/IR account that you do not expect to be able to clear against a GR/IR in the future. E.g. you have a GR-entry on the account and you know that an invoice will never be booked for the purchase order.

It is a good transaction to clear the Gr/IR balance. It puts a debit/credit to the original account assignment which makes the adjustments a lot easier.

It can be problematic when the PO relates to stores stock as it can make the closing store value go to zero which then in turn gives you problems with costs to work Orders. It also can be a problem if the account assignment has been subsequently closed.

Best advice is to run MR11 as often as possible, at least monthly.

What is Controlling Area and Cost Center?

2008-02-26T22:07:00.000-08:00

What Controlling is all about?

Controlling precedes CCA

The controlling area is the highest organizational level within CO. It must exist before Cost Center Accounting (CCA) can be used. A controlling area will be created on a one-to-one basis with the company code created in FI. This does not facilitate cross-company code accounting in CO. In order to facilitate cross-company code accounting, more than one company code is usually assigned to the controlling area.

Note the difference between cross-company code accounting and intercompany accounting.

Cross-company code accounting involves the allocation of costs across cost centers (or responsibility centers) existing in different company codes within CO. Intercompany accounting involves the recording of intercompany receivables and
payables in FI.

There are several factors considered when determining whether one or more controlling areas will be used. The major factors considered are whether cross-company code accounting is desired, and whether more than one chart of accounts is needed at the controlling area level. In addition, currency issues may also be considered.

Step 1 : Create Controlling Area:

Menu Path
IMG:Controlling > General Controlling > Organization >
Maintain Controlling Area T-Code : OKKP

On the "Choose Activity" pop-up window select the activity "Maintain Controlling Area" by double clicking on the corresponding line.

On the Change View Basic data: Overview screen: Click on the button.

On the "New Entries: Details of Added Entries" screen: Click on the button

On the resulting Pop-up, enter your Company Code
Hit to return to the main screen.

Note that the selection of this option has brought in a large number of Company default values to the input screen.
·CoCd -> CO area choose "Controlling area same as company code" from the pull-downmenu (click on the little icon at the very end of the row).

·CCtr std. Hierarchy STD_01 (say)
Hit to have SAP check the entry.
A pop-up box will come up with Standard Hierarchy STD_01 does not exist. Should system STD_01 be created as a standard hierarchy

Click to have the hierarchy created.

Click on the button to complete the transaction and return to the previous screen

On the Change View Basic data: Overview screen:

Select the line containing the newly create CO area

Double click on the "Activate components/control indicators" line (in the window on your right)

On the Change View Activate components/ control indicators

Details screen, enter:
Click on the button
· Fiscal year from Current year
· Cost Centers Component active (choose from the pull-down menu)
Other components will be activated in later exercises
· Select "Cost objects" by clicking on the check box
· Select "All currencies" by clicking on the check box (it may already be checked by default).
[Enables Controlling for all currencies]
· Select "Variances" by clicking on the check box

Click on the icon to complete the transaction

Click on the button to return to the previous screen

Note: You are also able to set Cost Center Accounting active and specify the respective settings through the following menu path: IMG > Controlling > Cost Center Accounting > Activate Cost

Center Accounting in Controlling Area.

On the Change View Basic data Overview screen:
Double click on the "Assignment of company code(s)" line (in the window on your right)
Click on icon.
Enter your company code or select it from the pull-down menu and hit . The system adds the

company name
Verify that the correct company code is pulled into the table.
Click to complete the transaction.
Go back to the IMG.

Step : 2 : Maintain Number Ranges

In CO, number ranges can be assigned to groups. This makes the process of creating number ranges more efficient by allowing several types of transactions to use the same number range.

IMG:Controlling > General Controlling > Organization > Maintain Number Ranges for Controlling

Documents T-Code : KANK

Now you need to define the Number Ranges for transaction group Useg values should for the FOUR groups for which number ranges will be assigned:

Text for Group Name From To Current
Number Number Number
Planning Transaction
Actual Transactions
Periodic Postings
Interface

On the Number Ranges for CO Document screen, enter:
·Controlling Area your controlling area
Click on the button

On the Maintain Number Range Groups screen:
Scroll down and ensure that all available CO transactions are listed as Not assigned

Use the Menu Path: Group > Insert
On the Insert Group Pop-up window:
Enter the data for a Group from the Data parameters table above
Hit after filling the data fields in the Pop-Up
Repeat this block of instructions until all FOUR groups have numbers assigned

Now Assign transaction types to each Group

To complete this , the following values should be used for the FOUR groups for which transactions types are to be assigned:

Planning Actual Transaction Periodic Interface
Transaction Transaction Posting
On the Maintain Number Range Groups screen:
Move to the area of Not assigned transactions
Double click on a targeted transaction to be selected. It will change color once selected.
Select all of the transactions to be assigned to a given group.
Move to the area listing the Groups.
Click on the box for the group to which the transactions are to be assigned.
Click on the icon on the toolbar to make the assignment.

Repeat this block of instructions until all FOUR groups have had their transactions assigned.
Click on the icon to complete the transaction and exit.

After the above go to Cost center Accounting

What's a Cost Center ?
They are buckets where costs can be captured ie an organizational unit wherein it defines the location of cost incurrence.

Now you go to Master Data and create the following :

1. Cost Center Hierarchies:
>Standard Hierarchy
Menu Path:Accounting > Controlling > Cost Center Accounting > Master Data > Standard Hierarchy >

Change
>Functional Cost Center Group

2.Cost Centers
>For Production, Process, and Non-Production etc
Menu Path:Accounting > Controlling > Cost Center Accounting > Master Data > Cost Center >

Individual Processing > Create
Menu Path:Accounting > Controlling > Cost Center Accounting > Master Data > Cost Center Group > Create

3.Primary Cost Elements:
>By definition, must correspond to previously established G/L expense accounts.
Primary cost elements in CO mirror P&L accounts set up in the FI module (general ledger). They are used as the vehicle to transfer costs from the FI module into CO. If there is no primary cost element set up for a specific P&L account on the general ledger, the costs will not flow to CO.

For this reason, in practice, all P&L accounts on the general ledger are usually set up as primary cost elements in CO.

IMG:Controlling > Cost Element Accounting > Master Data > Cost Elements > Automatic Creation of Primary and Secondary Cost Elements > Make Default Settings

4.Secondary Cost Elements:
>Primary for allocation
Secondary cost elements do not necessarily mirror G/L accounts created in FI. They are created and used solely in the CO module to facilitate the movement of costs within CO (allocation, settement, etc.).
Menu Path:Accounting > Controlling > Cost Center Accounting > Master Data > Cost Element > Individual Processing > Create Secondary

5.Activity Types:
Activity types represent cost drivers in CO. They can be used as a basis for cost allocations within the CO module.

Menu Path:Accounting > Controlling > Cost Center Accounting > Master Data > Activity Type > Individual Processing > Create

See Activity groups also

6.Statistical Key Figures:
> say Number of employees
> Square meters if you want to allocate say floor space

Statistical key figures represent static data in the CO module. They can be used as a basis for moving costs in CO (allocations, etc.) when actual data or activity type data is not available or too difficult to obtain.

Menu Path:Accounting > Controlling > Cost Centers > Master Data > Stat. Key Figures > Individual Processing > Create
see Statistical Key figure groups also.

Settting up the FI Validations

2008-02-24T09:45:00.002-08:00

Settting up the FI Validations

You can use additional validation to supplement the existing SAP logic to fit you into your businness needs.

For e.g. to allow postings from company code 0001 to business area AA only.

GGB0 - To maintain the validations

Validation - Enter a validation name e.g. VBUS

Applicaion Area - SAP module e.g. FI

Calling Point - Dependent upon the application area that is selected.

0001 - Document Header - validate enteries at document header, e.g BKPF table

0002 - Line Items - check line item entris within a document, e.g. BSEG table

0003 - Complete Document - check settings for the whole documents.

e.g. Validation step 001
Allowed company code '0001' to post to business area AA only. 'FI00' checks that line item is from FI.
If checks failed, the error message number 14 is displayed to stop the transaction.

Prerequisite
$BUKRS = '0001' AND
$GLVOR = 'FI00'

Check
$GSBER = 'AA'

Message
Type E No. 14 - Business Area not allowed for company 0001
Output fields 1 - BSEG - GSBER 2 - BSEG - BUKRS
3 - 4

OB28 - Define Validations for Posting

CC CallPnt Validation Description Activtn Level
0001 2 VBUS Business Area Validation 1

Activtn Level - 0 - Not Active 1 - Activated 2 - Activated for all except batch input

GGB4 - Manage the activation of all validations in the SAP system.

Guide for Testing SAP Financial

2008-02-24T09:45:00.001-08:00

TESTING

Unit Testing
When you test every single document is called unit testing.

String Testing
One transaction full activity is called string testing . For example Vendor invoice, goods received and vendor payment.

Integration Testing
It is purely with other modules and we have to check whether the FI testing is working with other related modules or not.

Regression Testing
Testing for whole database. Bring all the data into another server and do the testing is called regression.

UAT
When we test any particular document with the user and if it is ok immediately we have to take the signature on the document, which is signed off and can be forwarded to the immediate boss. There are some steps to be followed when we go for user acceptance testing.

Transaction – Script Writing – Expected Results – Compare with Actual Results

TPR (Transaction Problem Reporting)
While doing the user acceptance testing if we get any problems then there are some methodologies to be followed according to the company’s policy and normally as a tester we always need to write on Test Script itself.

Key Features
Understanding the business scenarios
Organization Structure to incorporate the tune of the script.
Preparation of test scripts
Execute and record results to see if it is fine before going to approval.
Make changes to your test script if required.

What is Test Script (Scenario Testing)
Header Data
Step in Process
Transaction Code / Program (FB60)
Menu Path
Description
Field Data and actions to complete
Expected Results
Actual Results
TPR
Closing Period
F.19 Clearing GR/IR Account
F.13 Adjustments GR/IR Account

Using of these above two accounts will help us in clearing the balances and adjustments to those respective clearing accounts so that the GR/IR account will be zero balance and the balances will appear in respective reconciliation accounts accordingly the balances will be carried forwarded to next fiscal year.

GR/IR Clears the following Documents
GL Document
Customer Documents
Vendor Documents
Assignment Field is important in any document (ZUONR), Amount (DMBTR)

Foreign Currency Valuation
Lowest Value Method, If we are in loss then only we will account for it.

GL Accounts which are important in Testing
Enjoy Transaction - FB50
Normal Transaction - FB01
Document Parking - FV50
Post with Clearing - F-04
Incoming Payment - F-06
Outgoing Payment - F-07

Document Related
Reset Cleared Items - FBRA
Parking Document Posting - FBVO
Reversal Documents - F-14
Company Code Clearing A/C
(Trial Balance purposes) reversal - (FBUB)

Clearing Account
Partial clearing Invoice - 100 - Open Item
Paid - 70 - Open Item
Balance - 30

In Partial Clearing you can see 100 and 70 are cleared line items and 30 as balance and if it is in Residual you can only 30 as balance as it creates new line item and you can’t see the other cleared line items.

As no company will use residual clearing as it affects on ageing reports.

Open Items in Foreign Currency in all Modules GL/AP/AR - F.05
Master Data

Company Code
Currency
Only Balances in local currencies
Reconciliation Account Type

Year End Scripts
Re Grouping Receivables / Payables - (F101)

Bad Debts Provisions – Scripts
We assume that the customer has not paid at the end of the year you doubt whether this receivable will ever be paid. So you make a transfer posting for the receivables to an account for individual value adjustments using special GL Indicator E and Transaction Code F-21

Carry forward Balances
Sub Ledgers and General Ledger balances to be forwarded to next Fiscal Year

Accounts Payables
Vendor Down Payments
Invoice
Parking
Reversal
Outgoing Payments
Automatic Clearing
Manual Clearing
Advance (Down Payment)
Post with Clearing
Post without Clearing
Reset Clearing
Carry forward
Regrouping
Foreign Currency Valuations

Accounts Receivables
Customer Down Payments
Invoice
Parking
Reversal
Incoming Payments
Manual Clearing
Advance (Down Payment)
Post with Clearing
Post without Clearing
Reset Clearing
Carry forward
Regrouping
Foreign Currency Valuations

SAP Transaction Code(TCode) For Advance Tax Return

2008-02-03T12:40:00.001-08:00

F.12 SAPMS38M Advance Tax Return

SAP Transaction Code(TCode) For G/L: General Ledger from Doc.File

2008-02-03T12:39:00.000-08:00

F.11 SAPMS38M G/L: General Ledger from Doc.File

SAP Transaction Code(TCode) For G/L: Chart of Accounts

2008-02-03T12:38:00.002-08:00

F.10 SAPMS38M G/L: Chart of Accounts

GR/IR Clearance Account in SAP system

2008-02-03T12:38:00.001-08:00

GI/IR clearing account is value based or quantity based?

Please find details for the GR/IR Clearance account in SAP system:

GR/IR Clearing Account Maintenance

Quantity differences between goods receipt and invoice receipt for a purchase order result in a balance on the GR/IR clearing account.

- If the quantity invoiced is larger than the quantity received, the system then expects further goods receipts for this purchase order to clear the balance.

- If the quantity received is larger than the quantity invoiced, the system then expects further invoices for this purchase order to clear the balance.

You can also clear differences for delivery costs. If no more goods or invoices are to be received, you must clear the balance manually. This can be done in different ways:

- You can return the extra goods to the vendor.

- You can cancel the invoice and post a corrected invoice or a credit memo for the surplus posted quantity.

- You can clear the GR/IR clearing account manually.

Maintaining the GR/IR Clearing Account

The GR/IR clearing account is usually cleared at the end of a period or fiscal year for that order items that no further goods receipts or invoices are expected for.

1. Choose Logistics -> Materials Management -> Logistics Invoice Verification -> GR/IR Account Maintenance -> Maintain GR/IR Clearing Account.

The GR/IR Account Maintenance screen appears.

2. Enter data as required on this screen in the Document header data frame.

3. In the Selection frame, you choose various selection criteria for the transactions for which you want to post the differences are available for the following selection fields. You maintain them in the user master.

4. Choose the processing type:
- Automatic clearance
- The Automatic clearance function is intended for processing in the background.
Choose Program -> Execute in background.
- Prepare list
- Choose Execute.
- The selection screen appears.

5. On the selection screen, the individual purchase order items that have quantity variances and match your selection are now listed. Select the order items that you want to clear.

6. Clear the GR/IR clearing account for the selected purchase orders by choosing List -> Post clearing.

Account Maintenance Document

Document that displays the quantities of the debit or credit of a material in GR/IR clearing account maintenance.

If you clear quantity differences between the goods receipt and invoice receipt for a purchase order using account maintenance, the system produces an account maintenance document.

You can branch from the account maintenance document to the following accounting documents, assuming that they exist:
- Accounting document
- Profit center document
- Special ledger document
- Material ledger document

SAP Step By Step and What is Credit Limit Check

2008-02-03T12:28:00.001-08:00

By Allabaqsh

Follow these steps:

1. Go to IMG - enterprise structure - definition - financial accounting - define credit control area.

2. Assignment of company code to credit control area & sales area to credit control area.

3. Go to OVAK select ur sales document type and in the check credit column choose from A B or C. D is for automatic credit control for which you have to maintain the credit group and risk categories.

4. In FD32 you select your customer and click on STATUS icon and press enter. here u maintain the credit amount allowed. but this is done by the Finance people.

5. Now when you create the sales order and if the amount exceeds the credit limit then u will get the message as you maintained in the TC OVAK. Normally the system starts doing credit checks from the second sales.
order.

What are the different types of credit checks?

By Sunilmadho

Credit Check can be :
1) Simple Credit Check
2) Automatic Credit Control

Automatic Credit Control can be at various levels :
1) Order
2) Delivery
3) Goods Issue

Automatic Credit Check is of many types :
1) Static
2) Dynamic
3) MaximumDocument Value
4) Maximum Open Items in percentage
5) Oldest Open Item in number of days
6) Crtitical fields change
7) Highest dunning level, etc.
You can create more.

Credit Check happens only in SD module, never in FI. Because the stage of the check is in the sales cycle, which exists in SD. FI guys will check the credit master sheets of the customer, the MIS, the analysis etc, review the credit limits of customers. But the check will happen only in SD, while creating order, delivery or doing the goods issue.

SAP Transaction Code(TCode) For Export Objects to cFolders

2008-02-01T05:47:00.003-08:00

CFE02 CFX_BI_BOM_EXPO Export Objects to cFolders

SAP Transaction Code(TCode) For Export Documents to cFolders

2008-02-01T05:47:00.001-08:00

CFE01 CFX_BI_TAB_TO_C Export Documents to cFolders

SAP FI/CO Certification Sample Questions

2008-01-28T05:13:00.000-08:00

Caution: more than one answer may be correct.
Please mark ALL correct answers.

Question:
Which of the following statements are correct?

A More than one chart of accounts can be created for each client
B The chart of accounts contains all the G/L accounts, vendor accounts and customer accounts
C More than one company code can be allocated to the same chart of accounts
D The chart of accounts controls all the customising settings in the R/3 system
E All accounts within a chart of accounts must have the same tax code

Question:
What status reports does Cash Management and forecasting include?

A. Cash management position
B. Liquidity forecast
C. Credit limit report
D. G/L account balances
E. Bill holdings

Question:
Which of the following are clearing procedures in accounts receivable?

A. Incoming payment
B. Down payment request
C. Credit memo
D. Transfer posting

Question:
When creating an Overhead Cost Order, the first order information which must be entered is:

A. Order status
B. Order type
C. Settlement type
D. Curreny
E. Classification code

Question:
When creating an Overhead Cost Order, the settlement rule must be entered in the control data.
Which settlement receivers are available for internal orders?

A. Cost center
B. Orders
C. General ledger accounts
D. Asset
E. Vendor

Question:
In Controlling, a distinction is made between master data, planning, actual data and the information system.
Which of the following master data belongs to Controlling?

A. G/L account
B. Work center
C. Cost center
D. Activity type
E. Supplier

Question:
Withing Overhead Cost Controlling activities are calculated. A Sender/Receiver relationship exists. However, not all Sender/Receiver combinations are allowed.
Which of the following combinations make business sense?

A. Sender. Cost Center, Order, Project
Receiver. Cost Center, Order, Project
B. Sender. Order
Receiver. Cost Center, Project
C Sender. Cost Center
Receiver. Cost Center, Order, Project, Cost Object

Question:
Period closing activities are also performed in Controlling. This is dependent on certain prerequisites. Which of the following are MINIMUM criteria before it makes sense to carry out period closing?

A. The posting period has been closed.
B. Materials have been withdrawn.
C. Personnel costs have been incurred.
D. Overhead has been incurred.
E. An order was closed.

SAP Financials

2008-01-28T05:10:00.001-08:00

SAP Financials

It is a service that provides predictable financing. Being able to predict overall IT cost can help companies simply their budget. Other benefits of SAP Financials can include competitive finance rates, optimized cash flow and accelerated ROI. This service covers the entire SAP solution from hardware to implementation. this service give the entire information of the Company.

MySAP ERP Financials - New General Ledger

With the release of mySAP ERP, SAP introduced the New General Ledger (GL). The New GL contains a number of useful features including multiple ledger reporting and document splitting with all resulting data contained within the one module. The New GL also facilitates a faster closing process. In this online session, you will gain an understanding of the new features on offer and options for implementation.

Migrating to the New General Ledger in sap

2008-01-28T05:09:00.001-08:00

Migrating to the New General Ledger: A Three-Phase Approach

By selecting the option to upgrade to SAP’s new mySAP ERP General Ledger (G/L) structure, you must understand this is a full-blownconsulting project, and it should be treated as such.

MySAP ERP 2005 comes with several new tools to help you migrate your financial records from the classic G/L structure to the new mySAP ERP G/L functionality. I’ll describe those tools and how they are used within the three-phase upgrade project you will need to execute. The migration tools, found in the 2005 IMG, consist of work lists, a migration plan, splitting simulation tools, and result reporting. The sidebar, “Upgrade Options,” has more information on your upgrade options by release.

When migrating to the new mySAP ERP G/L, keep in mind this important fact: The migration process is not just a plug-and-play modification that you can complete over a short period of time. This project requires several different project phases. Each phase — data migration, testing procedures, and final data certification — requires extensive planning, data verification, and final approval prior to beginning the next phase or completing the project.

SAP FICO minimal configuration for MM posting

2008-01-28T05:05:00.000-08:00

There are many SAP Material Management (MM) learners who face the problem in their MM configuration learning process that they can’t post any MM document, even if their MM configuration has been done correctly. It is because they have lack of knowledge in configuring Financial & Controlling (FICO) module as they have never learned it specifically. It can be very frustrating to solve that problem. To help your learning process, we provide a collection of videos that show how to configure SAP FICO module to allow MM module posting. Learning process has never been this easy before.

Belajar SAP FI-CO (Financial dan Controlling)

2008-01-28T05:04:00.001-08:00

Di dunia accounting, systems pelaporan pada dasarnya dibedakan menjadi 2 bagian besar; management accounting dan financial accounting. Dua-dua nya mempunyai objective yang berbeda dan cara pengukuran dan standard yang berbeda.
Management accounting (controlling) itu deal dengan systems performance, pengukuran seberapa efektif suatu systems. Standardnya ditentukan sendiri oleh user, terserah bagaimana user menghitung dan men-set up standardnya, bisa berbeda2 antara satu company dengan company yang lain.

Sedangkan financial accounting, adalah systems pelaporan keuangan yang nantinya akan diberikan kepada pihak ketiga. Kalo di sini, standardnya udah di tentukan, jadi bakalan sama cara penghitungannya di semua company.
Financial accounting sebagai alat komunikasi antar data keuangan/aktivitas perusahaan dengan pihak-pihak yang berkepentingan dengan data-data/aktivitas tersebut. Setiap perusahaan mempunyai Financial report yang bertujuan menyediakan informasi yang menyangkut posisi, keuangan, kinerja serta perubahan posisi keuangan suatu perusahaan yang bermanfaat bagi sejumlah besar pengguna informasi dalam pengambilan keputusan secara ekonomi. Financial report harus disiapkan secara periodik untuk pihak-pihak yang berkepentingan antara lain, masyarakat dan pemerintah, pemasok dan kreditur, pemilik, manajer perusahaan, investor, pelanggan dan karyawan.Kreditur menggunakan data keuangan untuk mengevaluasi kemampuan perusahaan dalam membayar kembali hutang dan bunganya. Pemilik perusahaan menggunakan data keuangan perusahaan untuk menaksir kondisi keuangan perusahaan dan memutuskan apakah sahamnya dijual atau ditahan. Sedangkan manajemen perusahaan memperhatikan dan memenuhi segala peraturan penyusunan laporan keuangan.

Sistem aplikasi SAP terdiri dari sejumlah modul yang terintegrasi penuh, dan menjangkau seluruh aspek dalam manajemen bisnis. Sistem SAP dikembangkan untuk memenuhi kebutuhan yang meningkat dari organisasi komersial maupun non-komersial yang menginginkan tercapainya efektivitas dan efisiensi dalam berorganisasi.

Modul-modul Financial dan Controlling yang terdapat didalam SAP sbb:
1. FI-Financial Accounting, Software bisnis SAP ditujukan untuk menyediakan pengukuran secara kontinu terhadap profitabilitas perusahaan. Modul FI juga mengukur kinerja keuangan perusahaan, berdasarkan pada data transaksi intenal maupun eksternal.Modul FI menyediakan dokumen keuangan yang mampu melacak (mengaudit) setiap angka yang terdapat dalam suatu laporan keuangan hingga ke data transaksi awalnya.
2. CO-Controlling, Fungsi dari modul CO adalah untuk mendukung empat kegiatan operasional: Pengendalian capital investment, Pengendalian aktivitas keuangan perusahaan, memonitor dan merencanakan pembayaran, Pengendalian pendanaan terhadap procurement, pengadaan dan penggunaan dana di setiap area, Pengendalian biaya dan profit berdasarkan semua aktivitas perusahaan
3. IM-Investment Management, Fungsi dari modul IM ini overlapping dengan fungsi yang dijalankan oleh modul TR, namun modul IM lebih spesifik ditujukan untuk menganalisis kebijakan investasi jangka panjang dan fixed assets dari perusahaan dan membantu manajemen dalam membuat keputusan.
4. EC-Enterprise Controlling, Tujuan dari modul EC adalah untuk memberikan akses bagi Enterprise Controller kepada Information Warehouse mengenai hal-hal berikut: Kondisi keuangan perusahaan- Hasil dari perencanaan dan pengendalian perusahaan, Investasi, Maintenance dari aset perusahaan, Akuisisi dan pengembangan SDM perusahaan, Kondisi pasar yang berkaitan dengan pengambilan keputusan, seperti ukuran pasar, market share, competitor performance, Faktor-faktor struktural dari proses bisnis, seperti struktur produksi, struktur biaya, financial accounting dan profitability analysis.
5.TR-Treasury, Modul TR berfungsi untuk mengintegrasikan antara cash management dan cash forecasting dengan aktivitas logistik dan transaksi keuangan.

Karena pentingnya fungsi dari financial accounting dan controlling tersebut di atas maka kami pandang perlu untuk mengadakan pelatihan SAP FI-CO yang murah dan dapat dijangkau bahkan pelatihan akan diadakan secara online.

How to became FI-CO Consultant Expert in 3 months

2008-01-28T05:03:00.001-08:00

Banyak yang bertanya, berapa lama untuk menjadi consultant expert,
selalu saya bilang antara 3 sampai 6 bulan apabila anda punya
kesempatan dan kemauan.
saya ambil contoh, kenapa perusahaan menetapkan masa percobaan
selama 3 bulan? dan semua karyawan baru pasti akan berusaha segiat-
giatnya untuk bisa lolos masa 3 bulan tersebut. Kalau dalam 3 bulan
kok masih belum ngerti juga, berarti memang kesempatan yang
diberikan salah orang. :)
tapi kalau terlihat ada progress, maka biasanya di perpanjang sampai
6 bulan. Jadi inget dulu waktu pertama kali kerja di Starko, masa
percobaan sudah lewat tapi surat pengangkatan tak kunjung turun,
ternyata saya dalam 3 bulan pertama menjadi karyawan telaDan dan
juga menjadi karyawan telaTan :)

Kesempatan itu ada dua sementara kemauan cuma ada satu. kesempatan
mendapatkan ilmu dan kesempatan mengaplikasikannya. sedangkan
kemauan yah cuma kemauan untuk belajar. saya belum temuin orang yang
ngga punya kemauan untuk mengaplikasikan ilmunya alias mau
nganggur..hehehe

Nah, bagaimana untuk menjadi FI-CO COnsultant Expert dalam 3 bulan.
Berikut ini langkah-langkah yang harus ditempuh untuk dapat menjadi
FI-CO Consultant Expert

Month 1
Step 1 : Watch SAP Computer Based Training Video SAP
System Management - System Administration Basic & SAP System
Management - System Administration Basic Advanced User + CCMS
Step 2 : Study And Practice The Training Manual (9 set)
Step 3 : Watch SAP Computer Based Training Video Shipping
Clerk, SOP and Structure OP
Step 4 : Study And Practice The Training Manual AA, AP,
AR, CO-CCA, CO-IO, COPA, CO-PC and GL

Month 2
Step 5 : Walk Through SAP Q&A Material
Step 6 : Browse Configuration Quick Notes
Step 7 : Study The SAP Real-Life Blueprint Documentation
(AA, AP, AR, CO dan GL)

Month 3
Step 8 : Study The FI/CO Popular Interview Questions And
Answers
Step 9 : Tips To Behave Like An Experienced Consultant In
The Job With Other Consultants
Step 10 : Repeat All The Above Steps For Once
Step 11 : Now Consider Yourself As An Experienced SAP
Consultant And Start Applying For A SAP Job Using Our SAP FI/CO
Sample Resume!

Jadi, jangan lewatkan kesempatan emas untuk register "Watch SAP
Computer Based Training Video SAP System Management - System
Administration Basic & SAP System Management - System Administration
Basic" pada hari Jumat ini, karena itu Step 1 untuk menjadi Expert
di module SAP apa saja.

Nah, kemarin ada yang merasa dirinya "belum apa-apa", nih saya kasih
kisi-kisi Step 9... dua saja yah ..yang ada relevansinya dengan
tulisan saya ini.

"If you are struggling in FI module in front of others just tell
them you have been so busy with CO module for quite sometime that
you forget some of the FI module functions. If you are struggling in
CO module instead, tell them the other way around. This is a very
valid reason in SAP workplace which are even used by senior
consultants"

"Talk about the limitations on previous versions of SAP like 4.6c
and 3.0. This will give an impression that you have been in the
industry for quite sometime working with older versions of SAP. One
popular limitation in 3.0 is the menu style which is not the tree
view. It is like the conventional menu which appears on top of the
screen."

Nah sekarang kesempatan pertama sudah ada di depan mata, tinggal
kemauan anda untuk mau belajar yang harus di "cari".

Belajar SAP FI-CO (Financial dan Controlling)

2008-01-28T05:02:00.001-08:00

Belajar SAP FI-CO (Financial dan Controlling)

2008-01-28T05:01:00.000-08:00

What is SAP IDES ?

2008-01-28T04:58:00.000-08:00

SAP IDES is a normal R/3 but with lots of DEMO data.

The system that contains several sample companies typifying relevant business processes. It is simple to use and has a variety of master and transaction data, and is used for demos, online/classroom training, and presentations. Potential customers use IDES to trial and test software via Internet.

SAP IDES – the "Internet Demonstration and Evaluation System" in the R/3 System, represents a model company. It consists of an international group with subsidiaries in several countries. IDES contains application data for various business scenarios that can be run in the SAP System. The business processes in the IDES system are designed to reflect real-life business requirements, and have access to many realistic characteristics. IDES uses easy-to-follow business scenarios to show you the comprehensive functions of the R/3 System. The focal point of IDES, however, is not the functionality itself, but the business processes and their integration.

IDES not only covers the Logistics area, but also Financials, and Human Resources. It demonstrates how the R/3 System is able to support practically all types of industries, from discrete production through to process industries, from engineering-to-order to repetitive manufacturing. However, IDES is not a sector-oriented model company. The individual processes are based on practice-oriented data for sectors such as Retailing or Banking. The IDES group manufactures products as diverse as elevators, motorcycles, and paints.

IDES is managed by SAP just as any regular business enterprise. SAP regularly updates the IDES data (master data, transaction data, and customizing). IDES also carry out period-end closing and plan with different time-horizons. Transaction data are generated to ensure that the information systems in all areas have access to realistic evaluation data. IDES are constantly implementing new, interesting business scenarios to highlight the very latest functions available in the R/3 System. New functions are represented and documented by IDES scenarios.

Above all, IDES shows you the possibilities of the integrated applications in the SAP System. IDES cover all aspects of a business enterprise, including Human Resources, Financial Accounting, Product Cost Planning, Overhead Management, Profitability Analysis, Planning, Sales and Distribution, Materials Management, Production, and much, much more. IDES have also integrated document administration and third-party CAD systems within the IDES system. This means that you can call up and display external documents, or access CAD drawings.

IDES shows you how the R/3 System supports production processes, the supply chain, and the efficient usage of global resources. Or perhaps you would like to increase your understanding of just-in-time-production or the integration of the electronic KANBAN system in an MRP II environment? IDES provides the ideal way to learn about areas such as Product Cost Controlling, Activity-Based Costing, or integrated Service Management and Plant Maintenance. How to manage high inflation is just one of the ever-growing number of IDES business scenarios that you can choose from.

SAP CO Module Other Configuration

2008-01-27T06:34:00.001-08:00

Other configuration

After the Controlling Area, Number Ranges, and Plan Versions have been defined and maintained, then settings for the other components in the CO(Controlling) Module should be maintained. (Cost Center Accounting, Cost Element Accounting, Activity-Based Costing, Internal Orders, Product Cost Controlling, Profitability Analysis, and Profit Center Accounting. )

The Account Assignment Logic allows configuration for Validation and Substitution Rules whose purpose is to check certain input values as defined by the User.

More specifically, Validations allow for business transactions to either post or not post documents based on the criteria defined in the validation rule. Certain input conditions are checked as defined by the User and if those conditions are met then the document(s) are updated and/or posted in the system. If the condition is not met, then an error message is generated to the User with a brief explanation of the error. These messages are defined in Configuration and can be identified as a warning, error, or a note. You also have the option to deactivate messages.

Substitutions on the other hand, checks input values and replaces the values with another value if the criteria as defined is met.

Maintaining Currency and Valuation Profiles allows for the definition of valuation approaches to be used in accounting components . These valuation profiles are checked in the system when activated in the Controlling Area. Certain rules apply if there is a need to maintain the currency and valuation profiles: (1) Company Code Currency must be assigned to a legal valuation approach, (2) Valuation approaches must also be maintain in the material ledger, and (3) Profit Center valuations can only be maintained if you are using Profit Center Accounting.

The CO(Controlling)Module has multiple configuration steps that must be followed for complete implementation of this module. Each sub-component of the CO (Controlling) Module has it’s level of configuration requirements. Once you have defined your business needs in the Controlling Area, a determination can be made as to what should be configured and what you do not need.

We hope you have enjoyed reading this tutorial.

SAP CO Module Number Ranges

2008-01-27T06:33:00.001-08:00

Number ranges

Configuration in the CO (Controlling) Modules requires maintenance of number ranges for documents generated from business transactions. A systems’ generated document number is assigned for every CO (Controlling) posting. These numbers are sequential and are required to be assigned to number range groups. The number range groups consists of two number intervals, one for internal document numbering and one for external document numbering. The SAP R/3 system keeps track of those document numbers that are externally generated and fed to SAP via batches and User manual input, otherwise, the system generates the next internally assigned document number for the transaction posted.

As previously stated when defining the Controlling Area, you have the ability to copy the Standard SAP Controlling Area “0001” which already has the number ranges defined eliminating the need for maintenance of number ranges. Keep in mind that you also have the flexibility to change number ranges and number range groups to meet your business needs. As a caution, never overlap number intervals in a group . For example, if you decide to assign number range interval 10000000 thru 199999999 to the number range group “05”, you can not assign it to number range group “06”. Number ranges should never be transported for data consistency purposes, therefore create these manually in each system.

Within the CO (Controlling) Module, you can configure Plan Versions. Maintaining Plan Versions allows for set-up of planning assumptions and determination of plan rates for allocation and plan activity purposes. The SAP Standard Version “000” is created for a five year fiscal year plan. It is recommended that the standard version be utilized for your plan/actual comparisons if you do not require multiple plan versions. SAP always allows the flexibility to create additional Plan versions by coping the Standard Version “000” and changing certain fields as required. There is also the option of defining and creating a totally new Plan Version.

SAP CO Module Configuration

2008-01-27T06:32:00.002-08:00

Primary configuration considerations

There are several configuration steps that must be considered when implementing the CO (Controlling) Module. Creating the Controlling area is one of the first steps in the CO (Controlling) configuration process. SAP has provided standard controlling areas and company codes which can be utilized as a basis for creating your company’s Controlling Area. The SAP Standard for Controlling Area is “0001” and for company code is “0001”.

It is recommended that these be used as a basis to create the Controlling Area or Company Code that you would like to define . Certain defaults setting such as number ranges have already been set-up in the standard SAP settings, thereby eliminating the need to redo this configuration requirement. Through the SAP Configuration process, you can create a copy of the Standard Controlling Area and Company Code, then update the other fields as needed including the four character alpha numeric field which identifies these areas. (You may want to change the controlling area from “0001” to “A001” and the Company Code from “0001” to “ AA01” as an example.)

Keep in mind that Company Codes are assigned to Controlling Areas and affect the COA (Chart of Accounts), the Fiscal Year Variants, and Currency set-ups. Cost Center hierarchy and Reconciliation ledger settings are also include in the Controlling Area set-up.

The Control Indicator activates and deactivates certain functions in the Controlling Area. The Controlling Area can also be used for cross-company code business transactions. To enable this function the Controlling Area must be assigned to all company codes used for cross-company code accounting.

SAP CO Module Introduction

2008-01-27T06:32:00.001-08:00

Introduction

The SAP CO (Controlling) Module provides supporting information to Management for the purpose of planning, reporting, as well as monitoring the operations of their business. Management decision-making can be achieved with the level of information provided by this module.

Some of the components of the CO(Controlling) Module are as follows:

· Cost Element Accounting

· Cost Center Accounting

· Internal Orders

· Activity-Based Costing ( ABC)

· Product Cost Controlling

· Profitability Analysis

· Profit Center Accounting

The Cost Element Accounting component provides information which includes the costs and revenue for an organization. These postings are automatically updated from FI (Financial Accounting) to CO (Controlling). The cost elements are the basis for cost accounting and enables the User the ability to display costs for each of the accounts that have been assigned to the cost element. Examples of accounts that can be assigned are Cost Centers, Internal Orders, WBS(work breakdown structures).

Cost Center Accounting provides information on the costs incurred by your business. Within SAP, you have the ability to assign Cost Centers to departments and /or Managers responsible for certain areas of the business as well as functional areas within your organization. Cost Centers can be created for such functional areas as Marketing, Purchasing, Human Resources, Finance, Facilities, Information Systems, Administrative Support, Legal, Shipping/Receiving, or even Quality.

Some of the benefits of Cost Center Accounting : (1) Managers can set Budget /Cost Center targets; (2) Cost Center visibility of functional departments/areas of your business; (3) Planning ; (4) Availability of Cost allocation methods; and (5) Assessments/Distribution of costs to other cost objects.

Internal Orders provide a means of tracking costs of a specific job , service, or task. Internal Orders are used as a method to collect those costs and business transactions related to the task. This level of monitoring can be very detailed but allows management the ability to review Internal Order activity for better-decision making purposes.

Activity-Based Costing allows a better definition of the source of costs to the process driving the cost. Activity-Based Costing enhances Cost Center Accounting in that it allows for a process-oriented and cross-functional view of your cost centers. It can also be used with Product Costing and Profitability Analysis.

Product Cost Controlling allows management the ability to analyze their product costs and to make decisions on the optimal price(s) to market their products. It is within this module of CO (Controlling) that planned, actual and target values are analyzed. Sub-components of the module are:

· Product Cost Planning which includes Material Costing( Cost estimates with Quantity structure, Cost estimates without quantity structure, Master data for Mixed Cost Estimates, Production lot Cost Estimates) , Price Updates, and Reference and Simulation Costing.

· Cost Object Controlling includes Product Cost by Period, Product Cost by Order, Product Costs by Sales Orders, Intangible Goods and Services, and CRM Service Processes.

· Actual Costing/Material Ledger includes Periodic Material valuation, Actual Costing, and Price Changes.

Profitability Analysis allows Management the ability to review information with respect to the company’s profit or contribution margin by business segment. Profitability Analysis can be obtained by the following methods:

· Account-Based Analysis which uses an account-based valuation approach. In this analysis, cost and revenue element accounts are used. These accounts can be reconciled with FI(Financial Accounting).

· Cost-Based Analysis uses a costing based valuation approach as defined by the User.

Profit Center Accounting provides visibility of an organization’s profit and losses by profit center. The methods which can be utilized for EC-PCA (Profit Center Accounting) are period accounting or by the cost-of-sales approach. Profit Centers can be set-up to identify product lines, divisions, geographical regions, offices, production sites or by functions. Profit Centers are used for Internal Control purposes enabling management the ability to review areas of responsibility within their organization. The difference between a Cost Center and a Profit Center is that the Cost Center represents individual costs incurred during a given period and Profit Centers contain the balances of costs and revenues.

SAP FI Module Integration Points

2008-01-27T06:31:00.001-08:00

What are some of the integration points of the FI module?

SAP is marketed as a fully integrated system, therefore knowing some of the integration points enables the Users to better understand the Modules.

· Organization units are not only defined in FI(Financial Accounting) but also in other SAP Modules. The SD( Sales & Distribution) Module requires the set-up of Sales Organizations, Distribution Channels and Divisions ; Purchasing requires purchasing organizations, plants, and storage locations; and CO (Controlling) requires a Controlling area to be defined.

· To transfer data between FI(Financial Accounting) and CO (controlling) as well as other modules, a Company Code must be assigned to each of the Modules.

· Business Areas must be entered when generating business transactions if you would like visibility of those transactions impacting a certain BA(Business Area). You can also update your Master Records to include BA(Business Area) for example Cost Center.

· Document postings are automatically posted in the year and periods that you created in the Fiscal Year variant set-ups based on the month, start and end dates to which postings are allowed within a given period as defined.

· There are several integration points in SAP, the above lists a few .

We hope you have enjoyed reading this tutorial.

SAP FI Module More Configuration

2008-01-27T06:30:00.001-08:00

More FI configuration considerations:

Business Area, COA, GL, Fiscal year and Currencies

Business Area is optional and is equivalent to a specific area of responsibility within your company or business segment. BA (Business Area) also allows for internal and external reporting.

Another configuration requirement for set-up in SAP are the Basic settings consisting of the following:

Chart of Accounts(COA)

Fiscal Year Variants.

Currencies

The COA(Chart of Accounts) lists all General Ledger accounts that are used by the organization. It is assigned in configuration to each company code and allows for daily General Ledger postings.

The General Ledger accounts are made up of such data as account number, company code, a description of the account , classification of whether the account is a P & L Statement Account or a Balance Sheet Account.

Control data of the GL Account is where currency is specified, Tax category (posting without tax allowed) , marking the account as a reconciliation account ( e.g. Customer, Asset, Vendors, Accounts Receivable) or not.

Marking the G/L Account as a “reconciliation” account allows for postings to an Asset Account ( for example) as well as automatic update to the G/L Account.

Configuration prevents direct postings to reconciliation accounts thereby assisting in maintaining integrity of the data.

This allows reconciliation between the sub-ledger and general ledger to always be guaranteed.

Within the General Ledger control data , you can also designate whether line item display is possible in the account. The system then stores an entry per line in an index table which links back to the account. (Display of line item details are then available for reporting purposes ,etc.)

Open Item Indicators can be set on the G/L Account allowing for better management of open items. Examples include: Bank Clearing Accounts, GR/IR Clearing Accounts, Payroll, etc.

Fiscal Year configuration is a must and can be defined to meet your company’s reporting periods whether Fiscal (any period combination that is not calendar) or Calendar( Jan-Dec).

Posting Periods are defined and assigned to the Fiscal Year.

Within the periods you specify start dates and finished dates.

SAP allows for 12 posting periods along with specially defined periods that can be used for year-end financial closing.

Currencies are another basic configuration setting requirement which defines your company’s legal means of payment by country.

It is recommended that all Currency set-ups in SAP follow the ISO Standards.

The ISO Standards ensure Global conformity across businesses worldwide utilizing SAP.

SAP FI Module Configuration

2008-01-27T06:29:00.000-08:00

Primary configuration considerations:

Client, company and company code

Once a business has decided to use the SAP FI(Financial Accounting) Module, there are several Configurations prerequisite steps that must be completed.Determining the organizational structure is one of the first steps in setting up the business functions in SAP as well as your reporting requirements.

The Organizational structure is created by defining the organizational units consisting of the following:

Client

Company

Company Code

Business Area

A Client is the highest unit within an SAP system and contains Master records and Tables. Data entered at this level are valid for all company code data and organizational structures allowing for data consistency. User access and authorizations are assigned to each client created. Users must specify which client they are working in at the point of logon to the SAP system.

A Company is the unit to which your financial statements are created and can have one to many company codes assigned to it. A company is equivalent to your legal business organization. Consolidated financial statements are based on the company’s financial statements. Companies are defined in configuration and assigned to company codes. Each company code must use the same COA( Chart of Accounts) and Fiscal Year. Also note that local currency for the company can be different.

Company Codes are the smallest unit within your organizational structure and is used for internal and external reporting purposes. Company Codes are not optional within SAP and are required to be defined. Financial transactions are viewed at the company code level. Company Codes can be created for any business organization whether national or international. It is recommended that once a Company Code has been defined in Configuration with all the required settings then other company codes later created should be copied from the existing company code. You can then make changes as needed. This reduces repetitive input of information that does not change from company code to company code as well as eliminate the possibility of missed data input.

When defining company codes, the following key areas must be updated:

Company Code Key- identifies the company code and consists of four alpha-numeric characters. Master data and business transactions are created by this key.

Company Code Name- identifies the name of the business organization within your organizational structure.

Address- identifies the street address, city, state, zip code for the company code created. This information is also used on correspondence and reports.

Country- identifies the country to which your business is based. Country codes within SAP are based on ISO Standards.

Country currency- identifies the local currency for the company code that you have defined.

Language- identifies the language to be used for you company code and is also used for text in your documents. SAP unlike other applications, offers over thirty languages including EN( English) , ES (Spanish), FR (French), DE (German), EL (Greek), IT(Italian), AR( Arabic), ZH (Chinese) , SV (Swedish) , and JA (Japanese) to name a few.

SAP FI Module Introduction

2008-01-27T06:27:00.000-08:00

Introduction

The SAP FI Module has the capability of meeting all the accounting and financial needs of an organization. It is within this module that Financial Managers as well as other Managers within your business can review the financial position of the company in real time as compared to legacy systems which often times require overnight updates before financial statements can be generated and run for management review.

The real-time functionality of the SAP modules allows for better decision making and strategic planning. The FI (Financial Accounting) Module integrates with other SAP Modules such as MM (Materials Management), PP (Production Planning), SD(Sales and Distribution), PM (Plant Maintenance),and PS (Project Systems).

The FI Module also integrates with HR(Human Resources) which includes PM(Personnel Management), Time Management, Travel Management, Payroll.Document transactions occurring within the specific modules generate account postings via account determination tables.

The FI (Financial Accounting) Module components.

The FI Module comprises several sub-modules as follows:

Accounts Receivables

Accounts Payable

Asset Accounting

Bank Accounting

Consolidation

Funds Management

General Ledger

Special Purpose Ledger

Travel Management

Accounts Receivables records all account postings generated as a result of Customer sales activity.

These postings are automatically updated in the General Ledger . It is within the Accounts

Receivables Module that you can monitor aging of the receivables and generate customer analysis. The Accounts Receivable Module also integrates with the General ledger, Sales and Distribution, and Cash Management Modules.

Accounts Payable records account postings generated as a result of Vendor purchasing activity. Automatic postings are generated in the General Ledger as well. Payment programs within SAP enables the payment of payable documents by check, EDI, or transfers.

Asset Accounting is utilized for managing your company’s Fixed Assets. SAP allows you to categorize assets and to set values for depreciation calculations in each asset class.

Bank Accounting allows for management of bank transactions in the system including cash management.

Consolidation enables the combining of financial statements for multiple entities within an organization. These statements provide an overview of the financial position of the company as a whole.

Funds Management allows management to set budgets for revenues and expenses within your company as well as track these to the area of responsibility.

General Ledger is fully integrated with the other SAP Modules. It is within the General Ledger that all accounting postings are recorded. These postings are displayed in real-time providing up-to-date visibility of the financial accounts.

Special Purpose Ledger is used to define ledgers for reporting purposes. Data can be gathered from internal and external applications.

Travel Management provides management of all travel activities including booking trips and handling of expenses associated with travel.

SAP Finance Tables(FICO Tables)

2008-01-25T08:42:00.001-08:00

AGKO Cleared Accounts

ANAR Asset Types

ANAT Asset type text

ANEK Document Header Asset Posting

ANEP Asset Line Items

ANEV Asset downpymt settlement

ANKT Asset classes- Description

ANLA Asset Master Record Segment

ANLB Depreciation terms

ANLC Asset Value Fields

ANLH Main asset number

AT02T Transaction Activity Category- Description

AT02A Transaction Code for Menu TIMN

AT10 Transaction type

AT10T Name of Transaction Type

BKDF Document Header Supplement for Recurring Entry

BKORM Accounting Correspondence Requests

BKPF Accounting Document Header

BLPK Document log header

BLPP Document log item

BLPR Document Log Index and Planned Order (Backflush)

BNKA Bank master record

BP000 Business Partner Master (General Data)

BPBK Doc.Header Controlling Obj.

BPEG Line Item Total Values Controlling Obj.

BPEJ Line Item Annual Values Controlling Obj.

BPEP Line Item Period Values Controlling Obj.

BPGE Totals Record for Total Value Controlling obj.

BPJA Totals Record for Annual Total Controlling Obj.

BSAD Accounting- Secondary Index for Customers (Cleared Items)

BSAK Accounting- Secondary Index for Vendors (Cleared Items)

BSAS Accounting- Secondary Index for G/L Accounts (Cleared Items)

BSEC One-Time Account Data Document Segment

BSEG Accounting Document Segment

BSID Accounting- Secondary Index for Customers

BSIK Accounting- Secondary Index for Vendors

BSIM Secondary Index, Documents for Material

BSIS Accounting- Secondary Index for G/L Accounts

CEPC Profit Center Master Data Table

CEPCT Texts for Profit Center Master Data

COBRA Settlement Rule for Order Settlement

COBRB Distribution Rules Settlement Rule Order Settlement

COKA CO Object- Control Data for Cost Elements

COSP CO Object- Cost Totals for External Postings

COSS CO Object- Cost Totals for Internal Postings

CRCO Assignment of Work Center to Cost Center

CSKA Cost Elements (Data Dependent on Chart of Accounts)

CSKB Cost Elements (Data Dependent on Controlling Area)

CSLA Activity master

FEBEP Electronic Bank Statement Line Items

FPLA Billing Plan

FPLT Billing Plan- Dates

GLPCT EC-PCA- Totals Table

KNA1 General Data in Customer Master

KOMK Pricing Communication Header

MAHNV Management Records for the Dunning Program

REGUT TemSe - Administration Data

SKA1 G/L Account Master (Chart of Accounts)

SKAT G/L Account Master Record (Chart of Accounts- Description)

SKB1 G/L account master (company code)

T003T Document Type Texts

T007S Tax Code Names

T087J Text

TAPRFT Text tab. for investment profile

TKA01 Controlling Areas

TKA09 Basic Settings for Versions

TKVS CO Versions

TZB0T Flow types text table

TZPAT Financial Assets Management product type texts

VBSEGS Document Segment for G/L Accounts Document Parking

VTBFHA Transaction

VTBFHAPO Transaction Flow

VTBFHAZU Transaction Activity

VTBFINKO Transaction Condition

VTIDERI Master Data Listed Options and Futures

VTIFHA Underlying transaction

VTIFHAPO Underlying transaction flows

VTIFHAZU Underlying transaction status table

VTIOF Options Additional Data

VWPANLA Asset master for securities

SAP Transaction Code(TCode) For AA Asset Status Reconciliation

2008-01-24T04:32:00.005-08:00

EWA9 EWURA001 AA Asset Status Reconciliation

SAP Transaction Code(TCode) For AA Balances Reconciliation

2008-01-24T04:32:00.003-08:00

EWA8 EWURA001 AA Balances Reconciliation

SAP Transaction Code(TCode) For AA Totals Record Reconciliation

2008-01-24T04:32:00.001-08:00

EWA7 EWURA001 AA Totals Record Reconciliation

SAP Transaction Code(TCode) For Reconcil. of critical FI-AA documts

2008-01-24T04:31:00.004-08:00

EWA3 RAEWUC0P Reconcil. of critical FI-AA documts

SAP Transaction Code(TCode) For FI-AA: Asset before&after compariso

2008-01-24T04:31:00.003-08:00

EWA2 RAEWAS0B FI-AA: Asset before&after compariso

SAP Transaction Code(TCode) For FI-AA: Analysis of assets w/errors

2008-01-24T04:31:00.001-08:00

EWA1 RAT08401 FI-AA: Analysis of assets w/errors

SAP Transaction Code(TCode) For EMU Conv: RE Load CO Objects

2008-01-24T04:30:00.001-08:00

EWA0 EWUCOOLI EMU Conv: RE Load CO Objects

Free Download SAP BASIS R3_System_Landscape.pdf

2008-01-20T23:08:00.000-08:00

R3_System_Landscape.pdf

Free Download SAP BASIS Profile_parameters.pdf

2008-01-20T23:06:00.000-08:00

R3_system_administration_basics.pdf

Free Download SAP BASIS R3_System_Administration.pdf

2008-01-20T23:05:00.000-08:00

R3_System_Administration.pdf

Free Download SAP BASIS R3_Basis_Component.pdf

2008-01-20T23:03:00.000-08:00

R3_Basis_Component.pdf

	Validation & Substitution
	Parallel currencies configuration
	Taxes on Sales Purchase configuration
	GL Automatic clearing configuration
	Foreign currency valuation configuration
	GR/IR Regrouping configuration
	Financial Statement version configuration (Creating Balance sheet and Profit and Loss account)
	FI - MM account determination configuration
	FI - SD account determination configuration