on 12-26-2013 3:16 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.