LSMW

[Former Member]

Can anyone please explain the steps for uploading the GL line items through F-02 using LSMW.

As this Transactional data, I am not able to do LSMW because fields are repeating like Posting Key, GL Account, Amount, Business Area...........So please explain how to map in 3 rd & 5th step.

[Former Member]

Hii..

Check this link

http://code.ittoolbox.com/Codemaster/code/FIfromExcel.zip

Regards,

Aakash

[Former Member]

+Use standard object 0100 to post FI documents

Standard object

Object 0100 u2014 Financial documents

Method 0000

Program name u2014 RFBIBL00

Program type u2014 B batch input

+ Define two structures and a key field

Header structure for FI document header

Detail structure for account line items

Define key field (Doc_No) for linking header and line items

+Define two input files for the two structures

+Source structures

HEAD - document header

POSI - document line

+Target struct.

BGR00 - Batch Input Structure for Session Data

BBKPF - Document Header for Accntng Document (Batch Input Structure)

BBSEG - Accounting Document Segment (Batch Input Structure)

+Structure relations

BGR00 <=== HEAD

BBKPF <=== HEAD

BBSEG <=== POSI

Here an example of the source fields. Remember the link between them is de Document number.

HEAD - document header

REF DOCUMENT number Type:C Lgth:009 Position:0001

SET1 Set indicator for header Type:C Lgth:001 Position:0002

DATE Document date Type:D Lgth:010 Position:0003

TYPE Document type Type:C Lgth:004 Position:0004

CU Document currency Type:C Lgth:002 Position:0005

POSI - document line

REF DOCUMENT number Type:C Lgth:009 Position:0001

SET2 Set indicator for position Type:C Lgth:001 Position:0002

KEY posting key Type:C Lgth:004 Position:0003

ACCOUNT Account number Type:C Lgth:010 Position:0004

AMOUNT Amount in document currency Type:A Lgth:015 Position:0005

TEXT Description of the document item Type:C Lgth:006 Position:0006

REGARDS, hope it help