S-Remove Spaces / Accounting Formats

S-Remove Spaces / Accounting Formats

Remove Spaces / Accounting Formats functionality removes spaces and accounting format to pass into SAP.

 

Let us consider an example of FB50 transaction for conversion to absolute value or remove negative sign.

1.Launch Process Runner.

 

ProR_360_Icon

 

2.Click on 'File' and select 'New Process' from backstage pane to record a new transaction.

 

New_ProR_1

Process Runner will present 'New Process' wizard that will guide the users through the recording

 

Click Here to understand transaction recording best practices and how it works.

 

Follow the below mentioned steps to record FB50 Transaction.

 

1.Ensure that 'Transaction' is selected at left pane of SAP Processes.

2.Enter 'FB50' in 'Transaction Code' field.

3.Click on 'Start Recording' button.

 

New_ProR_2

 

4.When 'Start Recording' button is clicked, Process Runner will ask you, which SAP System to use for recording at Innowera Connector for SAP window. Follow the steps mentioned below:

a.Select the appropriate SAP system for performing a sample transaction recording

b.Click on Logon.

c.Enter Client, User, Password and Language which is required to logon into SAP.

d.Click on OK.

 

standard_logon_02

 

Note: In case of SNC environment, username and password are not required (3rd Step in screenshot).

 

5.Process Runner will display message similar to below image in “New Process" window.

 

pro_trans_running

 

Shortly after that, your normal SAP GUI will start with transaction code you provided for the recording.

 

Step 2 - Recording Transaction

 

1.Enter the company code and press 'Enter' or click on 2016-11-08_154953. 'Company Code' popup appears only if it is configured in SAP system. If the company code screen is not prompted, move to the next step.

 

WCC-1-rcrd

 

2.Follow the steps mentioned below:

a.Enter Document Date, Currency, Posting Date, Reference and Doc Header Text and

b.click on tickmrkforenter

Note: User might have to click on tickmrkforenter twice or thrice if warning messages are returned from SAP

 

sap_enter_gl_account_doc

 

3.In the items grid enter G/L acct, D/C (H-Credit, S-Debit), Amount, Tax Code, Cost Center etc starting from the second row in the grid. Refer to the provided/existing excel file.

 

Note: Loop recording is tricky as you have to select a row where data is to be entered, and then click on 2016-11-15_162630 button (Insert Row) to feed the next entry. When this is followed, SAP pushes everything downwards for FB50 transaction code and keeps 2nd row empty so that the next entry can be entered there. This is standard SAP behavior.

 

Tip: 'Document Date', 'Currency' and 'Posting Date' are mandatory fields.

 

fbsoccdr-1

 

 

4.Click on the block of Status column (first column beside G/L acct) at the row where data is entered, to achieve validation check mark.

 

sap_enter_status

 

5.Follow the steps mentioned below to push the entered record downwards for an ease of next entry:

 

a)Select the record that was just entered.

b)Click on Insert Row 2016-11-15_162630.

 

sap_add_item

 

6.Repeat Steps (3) to (5) until the amount is balanced. (Otherwise SAP won’t allow to exit out of screen without balancing the amount). Once the amount is balanced, move to next step (7).

 

sap_finish_recording

 

 

7.Click on 'Save' button to exit the recording session of SAP GUI as shown in the image below.

 

Note: Please note that while recording, actual database update in SAP takes place.

 

save_exit-SAPGUI

 

 

Mapper Settings for recording

 

1.Process Runner automatically maps the fields to Excel Data file that were specified in New Process Wizard during recording.

2.Click on Advance View in Mapper toolbar at the bottom.

3.Ensure to Remove Dynamic Skip 'A-Execute only on the first call' from the first screen ' SAPLACHD - 1000' (Company Code pop-up) as FB50 Transaction does not require Dynamic Skip 'A-Execute only on the first call'

 

mapper_screen_001

 

4.Follow the steps mentioned below to deactivate the mapped screens which were inserted to balance the recording as it was performed to exit out of SAP GUI.

a.Select the entire mapped screen for the second item which are not required.

Note: Ensure to delete all the screens (In case if step 3 to Step 5 of recording section is followed more than two times) that were used to balance the recording.

 

b.Click on 'Deactivate Selected Row(s)' option stationed at 'Edit' group. This will deactivate the selected screens.

 

mapper_screen_002

 

5.Exclude the Header items and click 'SAPMF05A - 1001' and select 'Start loop' from the dropdown menu.

 

mapper_screen_003

 

6.The End Loop for the line items will be set automatically. By default the Block Type column for the Start Loop row will be set to 'On Value-Ignore Blank' and Block Value as 'A'. This will instruct Process Runner to differentiate multi-line documents at A column in Excel file.

 

mapper_screen_004

 

7.Once the changes are concluded in Mapper, go to Home and select 'Generate Template' command from Generate Template drop-down.

 

mapper_screen_005

 

8.Remove unwanted Excel rows as shown in the image below.

 

Screen_17

 

9.The format for the highlighted field is set as 'Accounting' which utilizes symbols such as currency and comma's. This might not be accepted by SAP. Selecting 'Convert to absolute value' will transform the current format into SAP acceptable format.

 

Screen_18

 

10.Select the parameter for corresponding field as shown in the image below.

 

Remove_spaces

 

 

Next

T-Get Internal Value