Skip to Content
author's profile photo Former Member
Former Member

LSMW

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2008 at 09:56 AM

    +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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 22, 2008 at 10:14 AM

    Hii..

    Check this link

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

    Regards,

    Aakash

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.