Bank Statement Conversion

[Former Member]

Hi all

We get one file from the bank that is being ftp that contains all items for numerous bank statements. We need to create 2 files (header(AUSZUG.TXT ) and transaction file(UMSATZ.TXT)) per bank account contained in this file. So theoretically if we have 2 bank accounts in the source file, we will create 4 files that we will load into SAP.

Anyone delt with this before?

Is there a idoc we can map this to that will load the data into SAP?

Any help wil be appreciated

[Former Member]

Hi

Thank for the reply.

Not exactly sure how the input file will look, it's going to be one flat file with records in it probaly looking like:

78 0 0 0 06 0614540608911454060840220820085326C0087964000000001850000CHEQUE 0009 06 1454060891 1454060840 22082008 5326 C 00879640 00000001850000 CHEQUE 0009 1850000 1072909510

79 0 0 0 06 0614540608911454060840220820085326C0087964100000000105006SERVEST (PTY) LTD 0009 06 1454060891 1454060840 22082008 5326 C 00879641 00000000105006 SERVEST (PTY) LTD 0009 105006 1073014516

That is just two records in the flat file. It needs to be split in Header and line on each change of account number the header into separete file and line into seperate file.

Header:

AUSZUG.TXT

-

---

Field# Type min. max. opt. Description

1 A 0 12 bank key

2 A 0 24 bank account number

3 N 1 4 statement number

4 X 8 8 statement date

5 A 3 3 currency key

6 N 1 18.2 opening balance amount

7 N 1 18.2 debit total

8 N 1 18.2 credit total

9 N 1 18.2 closing balance amount

10 A 0 35 bank account holder

11 A 0 35 X special account name

12 X 8 8 X life start

13 X 8 8 X life end

14 0 0 not used

15 0 0 not used

16 0 0 not used

17 0 0 not used

18 N 1 5 number of records in statement

Line:

UMSATZ.TXT

==========

Field# Type min. max. opt. Description

1 A 0 12 bank key

2 A 0 24 bank account number

3 N 1 4 statement number

4 X 8 8 value date

5 N 1 10 X primary note number

6 A 0 27 X note to payee 1

7 A 0 27 X bank posting text

8 0 0 not used

9 A 0 4 X text key

10 A 0 16 X check number

11 N 1 18.2 amount

12 0 0 not used

13 0 0 not used

14 X 8 8 Posting Date

15 0 00 not used

16 0 00 not used

17 A 0 27 X note to payee 2

18 A 0 27 X note to payee 3

19 A 0 27 X note to payee 4

20 A 0 27 X note to payee 5

21 A 0 27 X note to payee 6

22 A 0 27 X note to payee 7

23 A 0 27 X note to payee 8

24 A 0 27 X note to payee 9

25 A 0 27 X note to payee 10

26 A 0 27 X note to payee 11

27 A 0 27 X note to payee 12

28 A 0 27 X note to payee 13

29 A 0 27 X note to payee 14

30 A 0 27 X business partner

31 A 0 27 X business partner

32 A 0 12 X bank key of the partner's bank

33 A 0 24 X bank account number of the partner

34 A 0 3 X business transaction code

35 0 0 not used

Regards

[Former Member]

Y can't you go for Abap Proxy?

Can u post us SOurce and target file as well.

Thanks

Prabhakar