SQLPLUS to connect to SAP ORACLE . Forgot SAP password

Sqlplus / nolog

connect sapr3/sap ?? connet system/manager

Connect or co sapr3/sap nnet system / manager

desc sapr3.usr02;Desc sapr3.usr02;

delete from sapr3.usr02 where mandt = ‘420’ and bname = ‘sap*’;

Delete from sapr3.usr02 w here mandt =’420 ‘and bname =’ sap * ‘;
??sqlplus : sqlplus /nolog

sqlplus : sqlplus / nolog
Connect /as sysdbaConnect / as sysdba

IDES Developer access key workarond

A) Open Program LSKEYF00 . Search for Jump and put break points before and after

ID ‘CUSTID’ FIELD ‘1234567890’

b) In Another session start creating a new Z or Y program. At each break set sy-subrc eq 0.


c) In this new program. Create program to open any program in editor mode.

Report zfreeabap .

DATA: BEGIN OF int_tab OCCURS 500,


END OF int_tab.

PARAMETERS: p_prog LIKE sy-repid .


clear int_tab .

READ REPORT p_prog INTO int_tab.


INSERT REPORT p_prog FROM int_tab.

d) Save and generate . Set -sy-subrc eq 0 at break points.

e) Run the Program with parameters LSKEYF00 to edit it. Add line sy-subrc eq 0 before and after the call ‘GET_DEVELOPER_KEY’.

From a Cn source


SAF FI Frequently Asked Questions

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

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

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



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

You can used transaction ‘OBCL’.

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



Require GR & IV report

Is there any report on GR pending for IV?

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


transaction MB5S can


Retained Profit Account

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

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



ACH payment configuration Automatic Clearing House

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

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



Locking of Planning Data in Profit Center Accounting


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



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

You can used report “RFKABL00”.

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

(depending on your SAP version of course)



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

Try using program RFEBKA00 to upload the two files.

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


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

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

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

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


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

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

Tr code for Defining bank : FI12.

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

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

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

i. Movement types:

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

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

ii. Valuation class

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

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

The valuation class makes it possible to:

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

iii. Transaction/Event Key

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

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

iv. Material Type

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

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

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

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

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

6.Maximum no. of dunning levels are created?

Ans: 9 levels maximum.

7.In how many ways APP is configured?

Tr Code: FBZP

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

Account Assignment Model:

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

Recurring Entries:

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

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

Sample Documents:

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

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

special purpose ledger?

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

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

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

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

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

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

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

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

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

User Exits in FICO.

R/3 provides 3 “customization spots” to enhance FI/CO features without modifying the standard code. collectively referred to as “user exits,” two of the three have different names.

a) SAP Enhancements are used to expand the standard functionality within SAP. Enhancements use function modules and are called from the standard SAP code. Enhancements were new in release 3.0.

b)The Open FI Interfaces or Business Transaction Events are also used to expand the standard functionality within SAP. These events are defined in the IMG. Business Transaction Events were new in release 4.0. They are not available for all modules and are not called on all integrated transactions into FI as of release 4.5B. This will change with each release and should be retested.

c)The older User Exits in FI/CO are “Z” programs that are defined in table T80D for client-dependent user exits, and in table T80I for client-independent user exits. These are also used to expand the standard functionality within the FI/CO modules. These User Exits have been available since the early releases of SAP. All of these FI/CO User Exits are listed in this document in the Configuring User Exits (Older). The list is included because these User Exits are not a part of the Enhancements or Business Transaction Events and do not have an Info System for searching.



· Standard SAP functionality can be enhanced without modification to the standard code.

· Upgrades do not erase the functionality and it does not have to be re-transported or re-entered into the system. The enhancements should be thoroughly tested when upgrading to ensure the system will still work as implemented.

Configuring SAP Enhancements


Basic Steps in Configuring an Enhancement

· Find the appropriate Enhancement.

· Enter the ABAP code in the “Z” program within the function module.

· Create a project.

· Add the Enhancement to the project.

· Activate the project.


Example Business Scenario for Enhancements

Company A has a requirement to validate all customer master records created with a U.S. address. The U.S. entity reports on the industry field on the customer master. This is only a U.S. requirement and should not be required for the other countries, so the field status would not work. To accomplish this requirement, Company A will need to set up an Enhancement for the customer master transaction. The necessary steps are detailed below with screenprints. This example was configured in a 4.6C system.


Detailed Steps

1. Tools ABAP Workbench Utilities Enhancements Definition Utilities List Enhancements


2. Do not execute this without any parameters! There are too many Enhancements and it will probably time out. You’re searching for a customer master exit. Enter *mast* in the short text (see Figure 1). You’ll start there. Searching for an exit can be tricky, so make sure you try several things before giving up.

3. Execute the search.


Figure 1. Start Your Search for a Master Exit Here


4. Look through the list until you find the Enhancement for User exits: Customer Master Data.


5. Double-click on the enhancement SAPMF02D. This will take you to the details of the Enhancement and list the function modules included in the Enhancement.

6. To continue, double-click on the function module EXIT_SAPMF02D_001

7. This will take you to the source code for the function module. Click on the Import tab to review the tables/fields that are available for the Enhancement (see Figure 2).




Figure 2. The Tables That Are Available for the Enhancement


8. To view the tables/fields that can be changed in the function module, click on the Export and Changing tabs. For this function module, these tabs are empty because you can only validate data. You cannot change any fields in this enhancement.

9. Return to the Source Code tab.

10. Scroll down until you see the Include statement in the program. The “Z” program listed after the Include is where your code will be written (see Figure 3).




Figure 3. Your Program Will Begin After the Include Statement


11. Double-click on the Include. You will be prompted to create the include. Click on Yes to create.

12. At this point you will be prompted to enter a development class and to create a transport request. If you do not know which development class to use, please contact your technical team.

13. Enter the following ABAP code into the program (Figure 4):


* User exit to ensure that all US customers have a group key

* entered on the customer master.


if i_kna1-land1 = ‘US’ and

i_kna1-brsch = ‘ ‘.

message e001(F2).




Figure 4. The ABAP Code You Need to Enter


14. Note that the table name matches the table name in the import tab tables.

15. In this example you are using the standard message class F2 with message number 001. Normally, you will create your own message within your own message class. All customer message classes must begin with a “Z” and are created in transaction SE91.

16. Save the program.

17. The next step is to create the project. Go to transaction code CMOD or follow menu path: Tools ABAP Workbench Utilities Enhancements Project Management.

18. Enter the project name; begin the name with a “Z.”

19. Click on the Create button.




Figure 5. Click on Create After You Type in the Project Name


20. Enter in a description for the project.

21. Click on the Enhancement Assignments button.

22. You will be prompted to save the enhancement. Click on Yes.

23. At this point you will be asked for a development class and to create a transport for the project. You may use the same one created when adding the ABAP code to the function module.

24. Enter the name of the enhancement SAPMF02D (see Figure 6).




Figure 6. Enter the Name of the Enhancement Here


25. Save the project.

26. Back out of the enhancement assignment.

27. Activate the project by hitting the Activate button.


The SAP Enhancement is ready to be tested! Try creating a customer with U.S. as the country and a blank group key. Be sure to test one with a group key to make sure the message is not displayed in error as well.



Configuring User Exits (Older)

Basic Steps in Configuring an User Exit

· Create a “Z” program for the User Exits and enter the necessary ABAP code.

· Enter the new program name into table T80D.

· Configure the application to call the User Exit.


List of User Exits

· Variable Field Movements

· Substitutions in FI, CO, PCA

· Validations in FI, CO, PCA

· Rollups in SPL

· Fixed Field Movements in SPL

· Cost Center Summarization on Detail Screen

· Sets Formula Variables


Example Business Scenario for User Exits


Company A would like to add a “Z” field in the Special Purpose Ledger to capture a Business Unit field for reporting. They have used all the standard SAP fields such as Business Area and Profit Center. The field will only be used for reporting and is only needed in the Special Purpose Ledger. You created a special ledger table (ZZSPL1) with field Z_BUNIT and need to populate this field based on a combination of G/L account, fund and functional area.


To accomplish this requirement, Company A will use the Variable Field Movement User Exit. To make maintenance easier, table ZZBUSUNIT was created with the G/L account, fund and functional area fields as key fields, and the business unit field as a non-key field. You generated the table maintenance so the table could be updated using transaction SM30. SAP users update the business unit determination rules in table ZZBUSUNIT by entering the G/L account, fund and functional area, and then the business unit that combination should be posting to. The User Exit will read table ZZBUSUNIT using the G/L account, fund and functional area from the posting transaction and determine the business unit. The steps for using the user exit are detailed below. This example was created on a 4.6C system.


1. Copy the delivered template User Exit program RGIVU000_TEMPLATE into a “Z” program. Follow menu path Tools ABAP Workbench Development ABAP Editor (transaction code SE38). In early releases, the delivered program was RGIVU000.

2. You will be prompted for a development class and a transport. Please check with the technical team for the correct development class.

3. At the initial ABAP Editor screen, enter your new “Z” program name, select the Source Code button and click on Change (see Figure 13).



Figure 13. To Enter Your New Code, Select Source Code and Click on the Change Button


4. Enter the following code in the User Exit (Figure 14):



to_field = ‘CORP’. “Set a default business unit.


* read table zzbusunit to determine the business unit field.

select single z_bunit from zzbusunit into to_field

where hkont = accit_glx-hkont and

geber = accit_glx-geber and

fkber = accit_glx-fkber.





Figure 14. Enter Your New Code at This Screen.


5. Activate the program by clicking on the Activate button.

6. Change the configuration in the User Exit table to point to your new “Z” program.

7. Follow the IMG menu path: Financial Accounting Special Purpose Ledger Basic Settings User Exits Maintain Client Specific User Exits.

8. The entry to maintain is application area GIMV: Variable Field Movement. Enter your “Z” program (see Figure 15).




Figure 15. Enter Your “Z” Program in the Application Area GIMV: Variable Field Movement


9. Save the changes.

10. The final configuration step is to assign the User Exit in the variable field movement for your special ledger table. In the IMG: Financial Accounting à Special Purpose Ledger à Basic Settings à Master Data à Maintain Field Movements. Field movements control how the fields in a special ledger table are populated. They can be populated straight from other fields in a posting or through User Exits.



Figure 16. After You Assign the Business Unit Field and the G/L Account, the Exit Field Should Contain U01.


11. Assign the business unit field as a receiver and the G/L account as the sender. The Exit field should contain U01 (see Figure 16).

12. The User Exit number U01 calls User Exit E01_MVC form in the “Z” program.

13. Save the field movement.

14. You are ready to test your User Exit!