- SAP Best Practices (Baseline) for Philippines
- Tips and Tricks
- SAP Links
- 20 Things You Need To Learn About SAP Financial Accounting
- 20 Things You Need To Learn About SAP Controlling
- 20 Things You Need To Learn About SAP Authorization
- 20 Things You Need To Learn About SAP Sales and Distribution
- How to Pass SAP Certification for Financial Accounting ECC 6 EHP 4
- How to Pass SAP Certification for Management Accounting ECC 6 EHP 6
This blog is not affiliated in any ways to SAP AG or any of its subsidiaries. This is created mainly to share related SAP Financial knowledge and exchange ideas with all SAP enthusiast.
Monday, April 21, 2014
My SAP Financials Blog Topics
Below are the topics that are soon to be published in this blogsite:
Monday, November 11, 2013
How to Download Spool in SP02 as PDF
Procedure
1. Go to SA38 then execute RSTXPDFT4 program.
2. Enter Spool number found in SP02.
3. Tick Download PDF file.
4. Enter Directory and PDF File Name.
5. Click Execute.
1. Go to SA38 then execute RSTXPDFT4 program.
2. Enter Spool number found in SP02.
3. Tick Download PDF file.
4. Enter Directory and PDF File Name.
5. Click Execute.
Thursday, November 7, 2013
How to Define Sensitive Fields for Vendors (S_ALR_87003179)
Use
Changing an existing master data for vendors / customers such as bank data can lead to fraud if not properly monitored. For example, if the person authorized to edit master data can change the details without confirmation, he/she may change the bank account of the vendor to his/her own bank account which can be left unnoticed. Upon execution of the automatic payment, the fraudulent bank account is debited instead of that of the vendor. Even if this can be detected through executing the report for master data changes, this can a little too late to prevent the fraud.
To set a preventive over detective control for these master data changes, we can define sensitive fields in SAP that can automatically block a vendor invoice for payment until such change has been confirmed by an authorized person. This is to say that when a person changes a sensitive field in the vendor master, another person should confirm this change.
Here are the steps on how you can define sensitive fields for vendor master:
Procedure
CONFIGURATION
1. On IMG menu, go to Financial Accounting (New) > Accounts Receivable and Accounts Payable > Vendor Accounts > Master Data > Preparations for Creating Vendor Master Data > Define Sensitive Fields for Dual Control (S_ALR_87003179).
2. On the Change View "Sensitive Fields": Overview, click New Entries.
3. Under Field Name, enter the table plus the technical field name or use F4 to find the available fields that you can set as sensitive
4. Click Save.

CHANGE VENDOR MASTER DATA - FK02

AUTOMATIC PAYMENT RUN - F110
CONFIRM CRITICAL VENDOR CHANGES - FK09
Changing an existing master data for vendors / customers such as bank data can lead to fraud if not properly monitored. For example, if the person authorized to edit master data can change the details without confirmation, he/she may change the bank account of the vendor to his/her own bank account which can be left unnoticed. Upon execution of the automatic payment, the fraudulent bank account is debited instead of that of the vendor. Even if this can be detected through executing the report for master data changes, this can a little too late to prevent the fraud.
To set a preventive over detective control for these master data changes, we can define sensitive fields in SAP that can automatically block a vendor invoice for payment until such change has been confirmed by an authorized person. This is to say that when a person changes a sensitive field in the vendor master, another person should confirm this change.
Here are the steps on how you can define sensitive fields for vendor master:
Procedure
CONFIGURATION
1. On IMG menu, go to Financial Accounting (New) > Accounts Receivable and Accounts Payable > Vendor Accounts > Master Data > Preparations for Creating Vendor Master Data > Define Sensitive Fields for Dual Control (S_ALR_87003179).
2. On the Change View "Sensitive Fields": Overview, click New Entries.
3. Under Field Name, enter the table plus the technical field name or use F4 to find the available fields that you can set as sensitive
4. Click Save.

CHANGE VENDOR MASTER DATA - FK02

AUTOMATIC PAYMENT RUN - F110
CONFIRM CRITICAL VENDOR CHANGES - FK09
How to Create or Modify SAPSCRIPT Form
I've created a Journal Voucher form from a standard Internal Document form (YB_F140_INT_DOCU). I will share how this is done once I've finalized the document.
Here is a sneak peek :-)
How to Transform Standard Internal Document Form Without Creating a Customized Form or Customized Program in a Day
Standard Form

Transaction Codes to Remember
SE71 - Form Painter
OB96 - Assign Forms to Program
OB78 - Allocate Program for Automatic Correspondence
S_ALR_87003354 - Determine Call Up Function for Correspondence Type
F.61 - Print Correspondence As per Request
F.62 - Print Correspondence for Internal Documents
Here is a sneak peek :-)
How to Transform Standard Internal Document Form Without Creating a Customized Form or Customized Program in a Day
Standard Form
Enhanced / Modified Form

Transaction Codes to Remember
SE71 - Form Painter
OB96 - Assign Forms to Program
OB78 - Allocate Program for Automatic Correspondence
S_ALR_87003354 - Determine Call Up Function for Correspondence Type
F.61 - Print Correspondence As per Request
F.62 - Print Correspondence for Internal Documents
Tuesday, November 5, 2013
How to Set Up Reason Code in Accounts Receivable (OBBE)
Use
Reason Code in A/R is one of the best way to distinguish partial payment over residual payment method. Setting reason code to justify why a certain invoice is underpaid or overpaid can help you analyze the transaction and assign the correct G/L to the difference. With this, you can also automatically set the description or text that will appear on the line item.
Procedure
1. On the IMG menu, go to Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Incoming Payments > Incoming Payments Global Settings > Overpayment/Underpayment > Define Reason Codes (OBBE).
2. Enter Company Code.
3. Choose New Entries.
4. Enter the following:
5. Click Save.
Reason Code in A/R is one of the best way to distinguish partial payment over residual payment method. Setting reason code to justify why a certain invoice is underpaid or overpaid can help you analyze the transaction and assign the correct G/L to the difference. With this, you can also automatically set the description or text that will appear on the line item.
Procedure
1. On the IMG menu, go to Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Incoming Payments > Incoming Payments Global Settings > Overpayment/Underpayment > Define Reason Codes (OBBE).
2. Enter Company Code.
3. Choose New Entries.
4. Enter the following:
- Reason Key
- Short Text
- Long Text - This portion appears on the Line Item Text field.
5. Click Save.
Sunday, November 3, 2013
How to Set Clearing Text for All Open Items Selected for Clearing
Use
During open items clearing, either for customer, vendor or general ledger, we can set the clearing text for all selected open items to ensure that the text portion of the line item is not left blank for reporting purposes. Instead of typing the same text for all this items individually, we can simply set one clearing text that will be applied to all of these items.
For the purpose of this illustration, we will use Incoming Payment Processing transaction or F-28.
Procedure
1. Go to Incoming Payment Processing (F-28) and input the necessary data until you reached the open items selection screen.
2. Select the items to be cleared.
3. On the Menu Bar, go to Edit > Clearing Text or simply click Ctrl+F2.
During open items clearing, either for customer, vendor or general ledger, we can set the clearing text for all selected open items to ensure that the text portion of the line item is not left blank for reporting purposes. Instead of typing the same text for all this items individually, we can simply set one clearing text that will be applied to all of these items.
For the purpose of this illustration, we will use Incoming Payment Processing transaction or F-28.
Procedure
1. Go to Incoming Payment Processing (F-28) and input the necessary data until you reached the open items selection screen.
2. Select the items to be cleared.
3. On the Menu Bar, go to Edit > Clearing Text or simply click Ctrl+F2.
4. Input the Clearing Text and click Enter.
5. Upon Simulation, you'll notice the offsetting customer line items are automatically filled with the clearing text you entered.
Please note that this (Clearing text) is the same as the field found in the F-28 initial screen. If you were able to maintain the details initially, this can be skipped.
How To Show Hierarchy Display in FS00
Use
This functionality is useful in maintaining single or multiple General Ledger accounts. With this, you can maintain and/or monitor accounts under a certain account group. You can also easily locate similar account and use it as a reference in creating a new GL account.
Procedure:
1. Go to Display G/L Account Centrally screen using Transaction Code FS00.
2. On Menu Bar, click Settings > Hierarchy Display > Display Accounts in Navigation Tree.
This functionality is useful in maintaining single or multiple General Ledger accounts. With this, you can maintain and/or monitor accounts under a certain account group. You can also easily locate similar account and use it as a reference in creating a new GL account.
Procedure:
1. Go to Display G/L Account Centrally screen using Transaction Code FS00.
2. On Menu Bar, click Settings > Hierarchy Display > Display Accounts in Navigation Tree.
How To Change Default Posting Date for Parking Documents
Use
You specify the posting date when a document is parked. However, when the document was approved or posted on a different date, you need to define whether the posting date of the parked document will remain unchanged or will it adopt the system date or the date at which the document was actually approved for posting. This post will show how you can configure the default Posting Date for your Parked Items.
Procedure:
1. On the Customizing screen, go to Financial Accounting (New) > Financial Accounting Global Settings (New) > Document > Document Parking > Change Posting Date for Parking Documents.
2. Alongside the Company Code, specify the posting date procedure or setting for your parked documents.
Note:
This can only be used in FI Classic parking transactions since the user can change the posting date of a parked item anytime using the SAP Enjoy Posting transactions.
You specify the posting date when a document is parked. However, when the document was approved or posted on a different date, you need to define whether the posting date of the parked document will remain unchanged or will it adopt the system date or the date at which the document was actually approved for posting. This post will show how you can configure the default Posting Date for your Parked Items.
Procedure:
1. On the Customizing screen, go to Financial Accounting (New) > Financial Accounting Global Settings (New) > Document > Document Parking > Change Posting Date for Parking Documents.
2. Alongside the Company Code, specify the posting date procedure or setting for your parked documents.
Note:
This can only be used in FI Classic parking transactions since the user can change the posting date of a parked item anytime using the SAP Enjoy Posting transactions.
How To Configure Standard Cash Flow Statement (Direct) in SAP
Use
SAP has standard Cash Flow Reporting functionalities that are often disregarded or unused. The reason can be because we require a different format or that configuring the standard is sometimes more tedious than creating a functional specification from scratch. Either way, it is still best to know how to do standard reporting and be a little conversant in using the report painter.
This post will show how you can make use of the standard Cash Flow Statement and configure it based on your own requirement.
Prerequisite
You should be able to define your own Financial Statement Version.
Procedure
1. Go to FSI6: Report Painter: Display Form
2. Select Form Type > 002: Financial Statement Key Figures
3. Double click 0SAPRATIO-04: Cash Flow (Direct)
4. Click Edit icon.
5. On the Menu Bar, select Edit > Gen. Data Selection.
6. Change Financial Statement Version: INT to the Financial Statement Version of your company or client then click Confirm.
7. On the Form, edit items and assign accounts to each Cash Flow Items based on your requirement.
8. Click Save.
9. To view report, go to transaction S_ALR_87012271 - Cash Flow (Direct Method).
10. Specify specific details such as Company Code and Fiscal Year then click Execute (F8).
SAP has standard Cash Flow Reporting functionalities that are often disregarded or unused. The reason can be because we require a different format or that configuring the standard is sometimes more tedious than creating a functional specification from scratch. Either way, it is still best to know how to do standard reporting and be a little conversant in using the report painter.
This post will show how you can make use of the standard Cash Flow Statement and configure it based on your own requirement.
Prerequisite
You should be able to define your own Financial Statement Version.
Procedure
1. Go to FSI6: Report Painter: Display Form
2. Select Form Type > 002: Financial Statement Key Figures
3. Double click 0SAPRATIO-04: Cash Flow (Direct)
4. Click Edit icon.
5. On the Menu Bar, select Edit > Gen. Data Selection.
6. Change Financial Statement Version: INT to the Financial Statement Version of your company or client then click Confirm.
7. On the Form, edit items and assign accounts to each Cash Flow Items based on your requirement.
8. Click Save.
9. To view report, go to transaction S_ALR_87012271 - Cash Flow (Direct Method).
10. Specify specific details such as Company Code and Fiscal Year then click Execute (F8).
How to Configure Default Line Layout for a More User-Friendly Incoming Payment Processing (F-28 / FBZ1)
Use
To be able to give our end-user a better appreciation of the incoming payment processing in SAP, we can modify the default layout of the open items in the incoming payment program (F-28 / FBZ1). We can assign fields that are necessary and are relevant in evaluating open items in the customer account. With this, end-user can easily select line items/invoices that are relevant to the payment received.
Procedure
1. On the Configuration (IMG) screen, go to Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Incoming Payments > Manual Incoming Payments> Make Settings for Processing Open Items > Define Line Layout (O7Z4S)
2. Click Create or Shift+F1.
3. Assign Line Layout code and Description then hit Enter.
4. Click Insert after... then double click the Field Name from the Field list that you want to show during the open item processing in F-28 or FBZ1. Repeat as needed.
5. Click Save button to create the Line Layout.
6. Next, go to Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Incoming Payments > Manual Incoming Payments> Make Settings for Processing Open Items > Choose Standard Line Layout (O7V3)
7. Double click FBZI: Post Incoming Payments.
8. Select Customer then assign the created Line Layout on the Detail Screen then click Enter.
9. Select F12 or simple close the remaining Selection window.
10. Click Save.
Result
When you process F-28 / FBZ1, the selected fields in the assigned layout was shown.
To be able to give our end-user a better appreciation of the incoming payment processing in SAP, we can modify the default layout of the open items in the incoming payment program (F-28 / FBZ1). We can assign fields that are necessary and are relevant in evaluating open items in the customer account. With this, end-user can easily select line items/invoices that are relevant to the payment received.
Procedure
1. On the Configuration (IMG) screen, go to Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Incoming Payments > Manual Incoming Payments> Make Settings for Processing Open Items > Define Line Layout (O7Z4S)
2. Click Create or Shift+F1.
3. Assign Line Layout code and Description then hit Enter.
4. Click Insert after... then double click the Field Name from the Field list that you want to show during the open item processing in F-28 or FBZ1. Repeat as needed.
5. Click Save button to create the Line Layout.
6. Next, go to Financial Accounting (New) > Accounts Receivable and Accounts Payable > Business Transactions > Incoming Payments > Manual Incoming Payments> Make Settings for Processing Open Items > Choose Standard Line Layout (O7V3)
7. Double click FBZI: Post Incoming Payments.
8. Select Customer then assign the created Line Layout on the Detail Screen then click Enter.
9. Select F12 or simple close the remaining Selection window.
10. Click Save.
Result
When you process F-28 / FBZ1, the selected fields in the assigned layout was shown.
How to Easily Identify Partial Payment and/or Credit Memo of an Invoice during Open Item Processing in F-28 / FBZ1
Use
This technique can help end-user who is processing customer incoming payment in SAP using F-28. User can easily identify if a particular invoice has been partially paid and/or if a credit memo exists for that invoice.
Procedure
1. On transaction FB00 under Open items tab, ensure that the Include invoice reference is selected.
Alternatively,
1. On the Post Incoming Payment Process open items screen of F-28, click
.
2. Check the Include invoice reference option.
3. Click Save and go Back to the Open Items screen.
Result
If there is an existing partial payment or credit memo, you can immediately notice that they have been grouped according to their invoice reference. You can also see that Partially Paid Amount column appears. The total credit memo and partial payments for the invoice were calculated.
This technique can help end-user who is processing customer incoming payment in SAP using F-28. User can easily identify if a particular invoice has been partially paid and/or if a credit memo exists for that invoice.
Procedure
1. On transaction FB00 under Open items tab, ensure that the Include invoice reference is selected.
Alternatively,
1. On the Post Incoming Payment Process open items screen of F-28, click
2. Check the Include invoice reference option.
3. Click Save and go Back to the Open Items screen.
Result
If there is an existing partial payment or credit memo, you can immediately notice that they have been grouped according to their invoice reference. You can also see that Partially Paid Amount column appears. The total credit memo and partial payments for the invoice were calculated.
How to Set Special Options for Single Screen Transactions where Document Date equals Posting Date
Use
On our day to day transactions in SAP, there are several options where you can make a customer invoice posting a little bit easier. One example is by setting your Document Date to equal your Posting Date.
Note: This is only applicable to Single Screen Transactions of SAP.
Procedure
1. Go to FB70 and click
.
2. Under Special Options for Single Screen Transactions, tick Document date equals Pstg Date.
3. Click Save.
4. Exit the transaction to take effect.
Result
Upon accessing FB70: Enter Customer Invoice again, you'll notice that the Invoice Date/Document Date is automatically filled.
On our day to day transactions in SAP, there are several options where you can make a customer invoice posting a little bit easier. One example is by setting your Document Date to equal your Posting Date.
Note: This is only applicable to Single Screen Transactions of SAP.
Procedure
1. Go to FB70 and click
2. Under Special Options for Single Screen Transactions, tick Document date equals Pstg Date.
3. Click Save.
4. Exit the transaction to take effect.
Result
Upon accessing FB70: Enter Customer Invoice again, you'll notice that the Invoice Date/Document Date is automatically filled.
How to Quickly Access General Ledger, Accounts Payable and Accounts Receivable Reports
Use
For periodic reporting needs, we usually access the SAP information system through the menu tree. However, instead of using such, there is an easier way to access these reports. This post will show you have to access FI-related reports using a four-character transaction code.
Procedure

For periodic reporting needs, we usually access the SAP information system through the menu tree. However, instead of using such, there is an easier way to access these reports. This post will show you have to access FI-related reports using a four-character transaction code.
Procedure
- Use Transaction Code F.97 to access General Ledger-related Reports.

- Use Transaction Code F.98 to access Accounts Payable-related Reports.
- Use Transaction Code F.99 to access Accounts Receivable-related Reports.
Tuesday, February 26, 2013
How to Mass Edit The Assignment Field in Customer Line Item Display (FBL5N)
Use
When you need to edit a field for several line items, you can simple select those items and type in the new value of that field. This method is useful specially when you need that certain field as a category for reporting or automatic clearing.
Procedure
1. Select the documents that needs to be changed.
2. Click the Mass Change button.
2. On the New Values screen, fields that can be changed are shown. Input the new value.
When you need to edit a field for several line items, you can simple select those items and type in the new value of that field. This method is useful specially when you need that certain field as a category for reporting or automatic clearing.
Procedure
1. Select the documents that needs to be changed.
2. Click the Mass Change button.
2. On the New Values screen, fields that can be changed are shown. Input the new value.
3. Click Execute changes.
Sunday, February 24, 2013
How to View Customer Line Item using its Name Rather than its Customer Code
Use
Memorizing a customer by code or account is unlikely specially when you have thousands of them. This is why when you need to view a certain customer in FBL5N (Customer Line Item Display), you can make use of the Search Help ID and Search String instead.
1. Select the Search Help ID.
2. Choose Customer (General).
4. Click Enter.
5. On the Search String, after the “*.*.*” insert another “.” then enter the Customer Name (e.g. Juan dela Cruz or simply Juan* to show all customer balances with names starting with Juan).
6. Click Execute.
Memorizing a customer by code or account is unlikely specially when you have thousands of them. This is why when you need to view a certain customer in FBL5N (Customer Line Item Display), you can make use of the Search Help ID and Search String instead.
Procedure
4. Click Enter.
5. On the Search String, after the “*.*.*” insert another “.” then enter the Customer Name (e.g. Juan dela Cruz or simply Juan* to show all customer balances with names starting with Juan).
6. Click Execute.
Optional: Save as Variant so that you can use this the next time you access FBL5N.
How to Display Transaction Codes on SAP Easy Access Screen
Use
Transaction Codes are shortcut codes to access an SAP transaction. If you do not have the transaction under your Favorites and you simply know the transaction code, you key-in this in the command field instead of accessing menu path.
Procedure
1. On the SAP Easy Access screen, click Extras > Settings from the Menu bar.
2. Select Display Technical Names then click Enter.
Transaction Codes are shortcut codes to access an SAP transaction. If you do not have the transaction under your Favorites and you simply know the transaction code, you key-in this in the command field instead of accessing menu path.
Procedure
1. On the SAP Easy Access screen, click Extras > Settings from the Menu bar.
2. Select Display Technical Names then click Enter.
Subscribe to:
Posts (Atom)






















