BASIC LSMW EXERCISE

1. BASIC LSMW EXERCISE

PHASE I – Mapping and Definition

EXAMINE THE TRANSACTION

Create a Financial Document using transaction FB01

DOCUMENT HEADER

Document Date: today

Document Type: SA

Company Code: UKCC

Currency: GBP

FIRST DOCUMENT ITEM (input on the same screen)

Posting key: 50

Account: 24100

Press Enter

Amount: 12

SECOND DOCUMENT ITEM (input on the next screen)

Posting key: 40

Account: 33300

Press Enter

Amount: 12

Press Save

LSMW Set up

Start the LSMW (Transaction LSMW)

Create Project LSMW-xx - Description LSMW Demo

Create SubProject SUBxx - Description First Subproject

Create Object CTxx - Description FI Documents – Call Transaction

Maintain Object Attributes

Standard Batch / Direct Input

Object 100 Financial Documents

Maintain Source Structures

Create the structures GLHEADER and GLITEMS (below GLHEADER)

Maintain Source Fields

GLHEADER

Name Description Length Type Value

ID Record Type 1 C H

REF Reference Number 9 C

DATE Document Date 10 DDMY

TYPE Document Type 4 C

CUR Currency Code 2 C

GLITEMS

Name Description Length Type Value

ID Record Type 1 C P

KEY Posting Key 4 C

ACCOUNT G/L Account Number 10 C

AMOUNT Amount in Document Currency 15 AMT1

TEXT Item Text 6 C

MAPPING

There are a large number of fields in the object definition! To save time, the following is the list of fields for which we need data.

DOCUMENT HEADER

Field Meaning Length

BLART Document Type 2

BUKRS Company Code 4

BLDAT Document Date 8

WAERS Currency Code 5

BKTXT Document Text 25

DOCUMENT ITEM

Field Meaning Length

NEWBS Posting Key 2

WRBTR Amount 16

NEWKO G/L Account 17

SGTXT Document Text 50

QUESTIONS

What values did we use in the manual data of the transaction for these fields?

Which source fields map to which target fields?

Look at the source data – which fields will need translating?

What field(s) are not supplied in the source?

PHASE II – Reading, Conversion and Processing

Structure Relations

Assign BGR00 and BBKPF to the Document Header

Assign BBSEG to the Document Item

FIELD MAPPING

TARGET STRUCTURE TARGET FIELD SOURCE STRUCTURE SOURCE FIELD REMARKS

BBKPF BLDAT GLHEADER DATE Assign the field as DDMMYYYY

BBKPF BLART GLHEADER TYPE Translation needed

BBKPF BUKRS Constant Value ‘UKCC’

BBKPF WAERS GLHEADER CUR Translation needed

BBKPF BKTXT GLHEADER REF

BBSEG NEWBS GLITEMS KEY Translation needed

BBSEG WRBTR GLITEMS AMOUNT

BBSEG NEWKO GLITEMS ACCOUNT

BBSEG SGTXT GLITEMS TEXT

MAINTAIN FIXED VALUES, TRANSLATION RULES

Set up translation rules for the data, note that if you miss any entries, the system will fill in the source value entries when the conversion program runs for the first time.

SPECIFY & ASSIGN FILES

Select Legacy data on the PC. Then:

File: C:\TEMP\LSMW Data.txt

Description: (Your choice)

Check Data for several source structures

Assign the files to the source structures.

READ THE DATA

Display the data to confirm the successful data formatting

CONVERT THE DATA

Display the data to confirm the successful data conversion

START DIRECT INPUT PROGRAM

Use option Program RFBIBL00, then Data Transfer Type C. Note down the document numbers created.

Note that if the program finds any errors, then it will create a batch input session with the name of the LSMW Object. Use SM35 to investigate this.

In case of errors, rerun the appropriate steps.

Look the documents you created via transaction FB03

2. LSMW EXERCISE – ERROR HANDLING

COPY & TEST

Copy the object CTxx created above to CTERRxx, then work with the new object.

Change the file being read to C:\TEMP\LSMW Data errors.txt

Rerun the read and convert processes.

Look at the convert file – can you find any of the errors?

ERROR HANDLING

There are at least 3 errors.

A missing currency code in the translation table.

A document with financial postings out of balance.

JPY data being incorrectly formatted.

These will all be fixed by setting up ABAP code in the Mapping Step

Make the Processing Points and Global Data Definitions visible by choosing the menu option Extras >

...