Multiple invoice register - FB60

[Former Member]

Hi guys,

actually I have to register in sap with FB60 a list of invoice. Example:

vendor a         

vendor b

vendor c

I'm used to enter one by one the amount, the related cost center etc.

Is there a way to import a list of them without adding one by one?

I have an Excel sheet compiled with all the info I need..

[sampat_kumkar]

Hi

Develop the report with help of ABAPer or user LSMW method to upload data

user below link

http://help.sap.com/saphelp_nw04s/helpdata/en/87/f3ae74e68111d1b3ff006094b944c8/content.htm

http://www.sap-topjobs.com/LSMW.pdf

there are steps in LSMW.

Regards

Sampath

[Former Member]

very hard to do .. 

I'm attaching you the data i need to upload.. does anybody can help in a step by step process throught LSMW..?

[Former Member]

I'm in the "creating recording process".

I type the "fb60" in transaction code.. and then?

[msshihab1987]

HI Friend

Follow the documentations shared by Mr. Sampath. Once you have familiar with the process you can use the same for many purpose like master data upload etc. You need to select only required field while recording. Always choose the specific field using Mouse do not use TAB key to choose the field.

[Former Member]

perfect!

i'm at this stage:

Here you update the field name, the type of field whether C (Character,

alphanumeric) or N (Numeric) and the length of the field

but:

ACCNT	C	17
BLDAT	Dats	8
BUDAT	Dats	8
BUSCS	Char	1
HKONT_01	Char	10
KOSTL_01	Char	10
MWSKZ	Char	2
SGTXT	Char	50
WAERS	Cuky	5
WRBTR	Currency	13
XBLNR	char	16
XMWST	char	1

what should i put under currency and Cuky?

[sampat_kumkar]

Hi

Char for both

sampath

[former_member363756]

Hi

Please enter like given below screen shot.

[Former Member]

updating correcting with your suggestion

[Former Member]

too difficult in my honest opinion..

you have to save the excel file in the txt -> import it -> update sap

correct?

I have to do this job once a month..

[msshihab1987]

HI Friend

Please use LSMW to upload the transaction,

[Former Member]

how can i do it?