Information: How to find tables for a Customizing object/Configuration Node
1. Select the configuration node in SPRO
2. Go to menu option edit >display IMG activity
3. Select tab Maint. Object
4. In the assigned objects table you would find a view or cluster name
5. If it's a view (type V)
- Use SE11 to open the view and check the "table/join conditions" tab
to find the tables
7. If it's a cluster (type C)
8. Go to se54 - click "Edit Cluster", Enter the cluster name and display
9. Go to "object structure" node to find the related views
10. Open the views in SE11 to find the tables.
Sunday, September 20, 2009
Thursday, September 17, 2009
Information:Foreign Currency Valuation with Multiple Ledgers
Information: Foreign Currency Valuation with Multiple Ledger
The new Foreign currency valuation program. FAGL_FC_VALUATION uses the ledger group assigned to the valuation area to determine the ledger(s) from which balance is to be read for valuation. If the ledger group assigned to the valuation area contains only a single ledger, this ledger is used for the selection of the balances. If more than one ledger is contained in the ledger group assigned to the valuation area, each ledger is valuated individually
However, The postings for the valuation of balances are made using the ledger group that has the same name as the ledger being valuated. For example, if ledger group Z1 is assigned to the valuation area, which contains ledgers 0L and ledger L1, the balances of ledger 0L are valuated and the valuation program makes the postings using ledger group 0L and balances of ledger L1 are also valuated and the program makes postings with ledger group L1
In the above scenario, if ledger group L1 contain ledgers L1 and Z1, foreign currency valuation postings would be made to both the ledgers L1 and Z1 based on the balances in ledger L1
More details availble in the following SAP Note
983847 - Foreign Currency Valuation: Balances in NEW G/L
The new Foreign currency valuation program. FAGL_FC_VALUATION uses the ledger group assigned to the valuation area to determine the ledger(s) from which balance is to be read for valuation. If the ledger group assigned to the valuation area contains only a single ledger, this ledger is used for the selection of the balances. If more than one ledger is contained in the ledger group assigned to the valuation area, each ledger is valuated individually
However, The postings for the valuation of balances are made using the ledger group that has the same name as the ledger being valuated. For example, if ledger group Z1 is assigned to the valuation area, which contains ledgers 0L and ledger L1, the balances of ledger 0L are valuated and the valuation program makes the postings using ledger group 0L and balances of ledger L1 are also valuated and the program makes postings with ledger group L1
In the above scenario, if ledger group L1 contain ledgers L1 and Z1, foreign currency valuation postings would be made to both the ledgers L1 and Z1 based on the balances in ledger L1
More details availble in the following SAP Note
983847 - Foreign Currency Valuation: Balances in NEW G/L
Friday, August 14, 2009
Information: Convert tcode FSE2 (Financial Statement Maintenance) to Current Settings
Requirement: Transaction Code FSE2- Maintain Financial Statements Versions is a configuration item by default and you need to convert it to current settings or a user transaction.
Solution:
The procedure to convert FSE2 from an IMG activity to a user transaction/current setting is outlined in SAP Note#200674- Fin.Statement Vrsn: Maintenance in production clients. This note cannot be applied using transaction SNOTE and the following manual activities need to be performed.
1. Change the SPRO settings for view V_T011 using SOBJ as outlined in SAP Note#135028 - Transfer IMG activity to Current Settings.
2. Further, Message FE-146, also needs to converted to an Information or Warning message, using OBA5 as outlined in SAP Note#109577 - Changing FS version although client not changeable.
The above activities may differ depending upon the SAP release.
Solution:
The procedure to convert FSE2 from an IMG activity to a user transaction/current setting is outlined in SAP Note#200674- Fin.Statement Vrsn: Maintenance in production clients. This note cannot be applied using transaction SNOTE and the following manual activities need to be performed.
1. Change the SPRO settings for view V_T011 using SOBJ as outlined in SAP Note#135028 - Transfer IMG activity to Current Settings.
2. Further, Message FE-146, also needs to converted to an Information or Warning message, using OBA5 as outlined in SAP Note#109577 - Changing FS version although client not changeable.
The above activities may differ depending upon the SAP release.
Thursday, July 9, 2009
Issue/Solution: Issuer details for paying company code XX01 are missing
Issue:
While generating a payment medium using the payment medium workbench (with t-code F110 or FBPM) the user get the following error message: "Issuer details for paying company code XX01 are missing"
Solution:
The issuer details need to be maintained through transaction FBZP in the node "Payment Method in Company Code".
Select the relevant company code and payment method combination and add text to the tab "Drawer on the form" in the Form Data.
The details to be filled varies depending upon the payment medium format in use
for example : White using MT103 SWIFT format the following details would be required
Field 1 - Name 1
Field 2 - Name 2
Field 3 - Address 1
Field 4 - Address 2
While generating a payment medium using the payment medium workbench (with t-code F110 or FBPM) the user get the following error message: "Issuer details for paying company code XX01 are missing"
Solution:
The issuer details need to be maintained through transaction FBZP in the node "Payment Method in Company Code".
Select the relevant company code and payment method combination and add text to the tab "Drawer on the form" in the Form Data.
The details to be filled varies depending upon the payment medium format in use
for example : White using MT103 SWIFT format the following details would be required
Field 1 - Name 1
Field 2 - Name 2
Field 3 - Address 1
Field 4 - Address 2
Friday, June 19, 2009
Issue/Solution: COPA Performance Improvement using Summarization Levels
Issue:
Very long processing time or frequent TIME_OUT errors while execution of COPA reports (KE30) or assessment cycles.
Solution:
1. Activate CO-PA log (T-Code KEDZ, Program: RKE_PROT_EVALUATE)
Purpose:
Any COPA report/cycle execution or data access from COPA tables would be recorded in the log after this activation. This allows SAP to analyze the CO-PA usage pattern /access information based on which automated summarization levels could be created to improve COPA performance.
Execution Steps:
Execute t-code KEDZ
2. Collect CO-PA log data for a few weeks or months. (T-Code KE30, KEU2, etc)
This will be done automatically by the system when COPA reports or assessment cycles are executed.
For quick resolution in reports with poor performance, you may choose to execute all COPA reports /cycles, for which performance improvement is required to update the log data.
3. Create Summarization levels proposal (T-Code: KEDVP, Program: RKETRERU)
Purpose:
In this step, the system would read the access log information as recorded in step 2 and present a proposal to create summarization levels according to the database access patterns identified in the COPA log.
Execution steps:
Execute t-code KEDVP
Note: The analysis can take quite a long time. If the program aborts during dialog processing, due to run time being exceeded, restart the program in background processing. To display the result when the program has completed, choose Display last proposal.
4. Build Summarization levels (T-Code: KEDU)
Purpose: Large volume of data available in COPA tables is organized into various summarization levels using this transaction, which allows for quick data access at the summary levels for various reports and cycle executions instead of the high time and system consuming process of direct data retrieval from COPA tables.
Execution Steps
Execute t-code KEDU
Status of the background job scheduled in step 4 can be using t-code SM37 with job name “RKETRER
6. Schedule a Daily Background Job to refresh summarization level data (T-Code: KEDU/SM36)
Purpose: The summarization levels created above would hold only the data available in COPA tables as on 30 minutes before the build process. To update the summary tables with the latest transaction data, summarization level refresh process needs to be executed daily.
Execution Steps:
Execute t-code KEDU
- Report for which performance improvement is sought must be configured to use the summarization levels in the report option field for presummarized data
- Population of initial summarization level , could be a very time consuming job and hence it may require to be executed into multiple parts with different executions for different summarization levels.
- Do not execute t-code KEDV while trying to execute a background job for summarization level population using KEDU.
Very long processing time or frequent TIME_OUT errors while execution of COPA reports (KE30) or assessment cycles.
Solution:
1. Activate CO-PA log (T-Code KEDZ, Program: RKE_PROT_EVALUATE)
Purpose:
Any COPA report/cycle execution or data access from COPA tables would be recorded in the log after this activation. This allows SAP to analyze the CO-PA usage pattern /access information based on which automated summarization levels could be created to improve COPA performance.
Execution Steps:
Execute t-code KEDZ
- Enter the Operating Concern (PI02) and click “Activate” (Ctrl+F1)
2. Collect CO-PA log data for a few weeks or months. (T-Code KE30, KEU2, etc)
This will be done automatically by the system when COPA reports or assessment cycles are executed.
For quick resolution in reports with poor performance, you may choose to execute all COPA reports /cycles, for which performance improvement is required to update the log data.
3. Create Summarization levels proposal (T-Code: KEDVP, Program: RKETRERU)
Purpose:
In this step, the system would read the access log information as recorded in step 2 and present a proposal to create summarization levels according to the database access patterns identified in the COPA log.
Execution steps:
Execute t-code KEDVP
- Enter Operating Concern
- Select COPA Type (Costing Based /Account Based)
- Select the type of proposal to be created
-Enhancement: Existing summarization levels are taken into account during optimization, and only additional summarization levels are proposed
- Replacement: With this type of proposal, all existing summarization levels are ignored. The proposed summarization levels replace the existing levels. Even replacement proposal does not delete any existing summarization levels. However existing levels can be manually deleted using T-Code KEDV - Select the period (select maximum period for which log data is available) for which logged COPA transaction data should be considered to create the proposal.
- Click “Create Levels” button to accept the summarization level proposal displayed
Note: The analysis can take quite a long time. If the program aborts during dialog processing, due to run time being exceeded, restart the program in background processing. To display the result when the program has completed, choose Display last proposal.
4. Build Summarization levels (T-Code: KEDU)
Purpose: Large volume of data available in COPA tables is organized into various summarization levels using this transaction, which allows for quick data access at the summary levels for various reports and cycle executions instead of the high time and system consuming process of direct data retrieval from COPA tables.
Execution Steps
Execute t-code KEDU
- Enter Operating Concern
- Choose type of Profitability analysis (Costing/Account)
- Select “Build new Levels”
- Execute in background mode only using menu option Program > Execute in Background (F9)
- Click “Immediate”
- Click “Save”
Status of the background job scheduled in step 4 can be using t-code SM37 with job name “RKETRER
6. Schedule a Daily Background Job to refresh summarization level data (T-Code: KEDU/SM36)
Purpose: The summarization levels created above would hold only the data available in COPA tables as on 30 minutes before the build process. To update the summary tables with the latest transaction data, summarization level refresh process needs to be executed daily.
Execution Steps:
Execute t-code KEDU
- Enter Operating Concern
- Choose type of Profitability analysis (Costing/Account)
- Select “Refresh”
- Save as a variant “COPA Summarization Refresh”
- Click “Job Wizard” button
- Click Continue
- Enter a descriptive job name (example: COPA summarization refresh) and priority, leave the target server blank and click “continue”
- Select “ABAP Program Step” and click “Continue”
- Enter ABAP program name as “RKETRERU” and choose variant “COPA Summarization Refresh” and click “Continue”
- Do not select add additional steps and click “Continue”
- Select option “Date/Time” and click “Continue”
- Enter a scheduled start date and time (non- business hour) , Check “Periodic” and click “Continue”
- Select “Daily” and click “Continue”
- Click “Complete”
- Report for which performance improvement is sought must be configured to use the summarization levels in the report option field for presummarized data
- Population of initial summarization level , could be a very time consuming job and hence it may require to be executed into multiple parts with different executions for different summarization levels.
- Do not execute t-code KEDV while trying to execute a background job for summarization level population using KEDU.
Subscribe to:
Posts (Atom)