Recalculate amounts in FAGLFLEXT

Execute transaction FAGLF03 (program TFC_COMPARE_VZ).
The difference will be displayed and saved in protocol:

Then execute the report TFC_ADJUST_VZ.
Status of the protocol was adjusted:

At last, execute again FAGLF03 to check for remaining inconsistency.

 

Convert text string to date format DDMMYYYY for LSMW

In excel date format is DD.MM.YYYY (10 characters)
In LSMW the target field has 8 characters (DDMMYYYY) or (DD.MM.YY) or (YYYYMMDD).

Code to convert the text:
Alternative 1:
BBKPF-BLDAT(6) = IMPORT_BKPF-BLDAT(6).
BBKPF-BLDAT+6(2) = IMPORT_BKPF-BLDAT+8(2).
Result: 01.10.16

Alternative 2:
BBKPF-BLDAT(2) = IMPORT_BKPF-BLDAT(2).
BBKPF-BLDAT+2(2) = IMPORT_BKPF-BLDAT+3(2).
BBKPF-BLDAT+4(4) = IMPORT_BKPF-BLDAT+6(4).
Result: 01102016

Alternative 3:
REPLACE ALL OCCURRENCES OF ‘.’ IN IMPORT_BKPF-BLDAT WITH ”.
BBKPF-BLDAT = IMPORT_BKPF-BLDAT.
Result: 01102016

Alternative 4:
concatenate main-DOC_DATE+6(4)
main-DOC_DATE+3(2)
main-DOC_DATE+0(2)
into E1BPFAPO_GEN_INFO-DOC_DATE.
Result: 20161001

Correct wrongly generated asset depreciation run in SAP

In case that depreciation run was not posted in FI module and restart is not wanted (for example due to wrong accounting objects, like cost center), the wrongly prepared data may be deleted.

In the table ANLP select and adjust accounting objects in positions where BELNR = initial.

Process AFAB once again in restart mode.

Display change documents in SAP

Change on field contents is stored in tables:
CDHDR – Change document header
CHPOS – Change document items

Program RSSCD100 displays contents of both tables.

Alternatively changes may be found in table
DBTABLOG – Log Records of Table Changes

If modification was done with SE16N, then changes are logged in following tables:
SE16N_CD_KEY – Table Display: Change Documents – Header
SE16N_CD_DATA – Table Display: Change Documents – Data

Add field to SAP FI Substitution / Validation

To activate field in SAP FI Substitution, execute Tr. SM30 for maintenance view V_GB01C.

Additionally, field should not be excluded in view: VWTYGB01:

The table GB01 should not be edited directly, there are routines, which are activated after change in view.
Check the SAP OSS Note 842318.

Syncing Google with Outlook

I had a problem with getting the data from Google to Outlook, and had to stop using outlook.
Recently I have found one great program, which syncs Google Calendar and Contacts with Outlook.
GO Contact Sync Mod. Works perfectly, and the version 3.9.0 includes support of API3 from Google.
Now I am back to Outlook!