cancel
Showing results for 
Search instead for 
Did you mean: 

how to creat LSMW to Upload data FB01

Former Member
0 Kudos

Dear All

I want to upload data with defrenet reference  for Ex:-

I have data form excel sheet like this:-

code    Account    Account name    assigin. value date     cost center    text                                 doc number

40        XXXX         ..............        123                            XXXXXXX       ???????????                 100000123

40        XXXX          .............         111                            XXXXXX        ???????????                  100000123

50        XXXX          .............        56456   12/12/2013                           ???????????                  100000123

40        XXXX         ..............        123                            XXXXXXX       ???????????                 100000124

40        XXXX          .............         111                            XXXXXX        ???????????                  100000124

50        XXXX          .............        56456   12/12/2013                           ???????????                  100000124

40        XXXX         ..............        123                            XXXXXXX       ???????????                 100000125

40        XXXX          .............         111                            XXXXXX        ???????????                  100000125

50        XXXX          .............        56456   12/12/2013                           ???????????                  100000125

and I gave it doc number   I want to uploud this data to sap

any one has any idea 

Accepted Solutions (1)

Accepted Solutions (1)

Marssel700
Active Contributor
0 Kudos

Mustafa,

You mean Reference XBLNR ? You have to add this field in your LSMW recording

Please import my sample attached below. Go to LSMW -> extras -> Import porject.

Regards

Former Member
0 Kudos

Thanks  marssel

about the reference  (it's does n't matter I just gave an ex  and I mean  I want the sap system to make a doc to each reference   >

I'll tell you why I want that ,  we bought sap system last year  and I want to enter the old data docs to the system.  I I need a fast method to do that   that's all


Marssel700
Active Contributor

Mustafa,

Ok. Import the enclosed file in your LSMW and create a excel sheet like below:

BLDAT                          C(008)    Document Date

BLART                          C(002)    Document Type

BUKRS                          C(004)    Company Code

BUDAT                          C(008)    Posting Date

WAERS                          C(004)    Currency

XBLNR                          C(016)    Reference

BKTXT                          C(025)    Header Text

NEWBS                          C(002)    Posting Key 01

NEWKO                          C(017)    GL Account

WRBTR                          C(013)    Amount

ZUONR                          C(018)    assignment

SGTXT                          C(050)    Historical Text

NEWKO2                         C(017)    Off setting GL Account

WRBTR2                         C(013)    Off Setting Amount

ZUONR2                         C(018)    assignment

SGTXT2                         C(050)    Historical Text

NEWBS2                         C(002)    Posting Key 02

If you have a ABAPer I recommend you ask for a development for document mass upload.

Let me know if you need more information.

Regards

Answers (0)