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:
BBKPF-BLDAT(6) = IMPORT_BKPF-BLDAT(6).
BBKPF-BLDAT+6(2) = IMPORT_BKPF-BLDAT+8(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).
REPLACE ALL OCCURRENCES OF ‘.’ IN IMPORT_BKPF-BLDAT WITH ”.
BBKPF-BLDAT = IMPORT_BKPF-BLDAT.
Use program SALV_BS_ADMIN_MAINTAIN to remove or change default format for your user or globally.
For some specific processes the default asset account determination leads does not satisfy business department. The amounts should be posted to another accounts. One of the solution, is to post balances manually, the other is to create new line item schema.
1. Find out, which line item schema is used during posting.
Set break point on function ‘TA1MZ_READ’.
2. Copy this schema to new ‘Z’
Start transaction ABUZSM or SM34 and maintain cluster view VC_TA1MZ01.
Copy the schema SAP_300_001 to some Z*.
3. Change the accounts
Start transaction SM34 for maintenance view VC_T093H01.
There are two possibilities:
a. Use fields of table T095 / T095B
b. assign accounts assigned to general modification: Transaction OBYD
Assign modification to country and set up filter for depreciation area and transaction type
Now the posting will use accounts, defined in line item schema, not in asset account determination (TA: AO90).
Old “wrong” document:
Clearing account was changed only in depreciation area 01 and for defined transaction types.
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.
Use program RM07MMFI to check the Balance difference between FI and MM:
Transaction MB5L to compare Stock Values:
OSS Note for correction of inconsistency: 382797
In order to have nice Business conception, following icons, styles etc. can be taken from SAP guidelines.
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
Program for maintenance of default parameters: SALV_BS_ADMIN_MAINTAIN.
Alternatively, to reset default parameter: in ALV list just before export to excel, type in command box: &reset_excel and hit enter.
Hint from colleague of mine: Enable debugging of DMEE by entering in the table DMEE_TREE_DEBUG required tree and node (SE16N)
Thanks Michal! 😉
Sometimes its nice to distinguish systems and clients in windows taskbar, something like this:
1. Create 16×16 icons (for example with GIMP).
2. Activate GuiXT in SAP
3. In profile of GuiXT define storage of Script
4. Select component GuiXT
5. Make window to be hidden
6. In Further settings select No language key
7. Click OK
Further on, the GuiXT profile may be started with command: guixt.exe visible
8. Edit the script file, created in script storage directory (something like saplsmtr_navigation.0100.txt)
Use following coding, for example for systems with clients
if V[_database=E20] and V[_client=005]
or with single client:
Log in to the system…
Should work now!