How to Convert file using RFEBKA00 (electronic bank Statement)

[Former Member]

Hi, I am practicing Electronic Bank Statement and I dont have bank file. SAP has provided some procedure to practice electronic bank statement by converting the file using se38 and RFEBKA00. If anybody knows the procedure to convert the file in sap readable format please provide the procedure.

Thanks

[Former Member]

Hello, I can recommend you the report RFEBKATX. You get 2 multicash data sets for testing.

BR Hana

[former_member182714]

HI All,

I would like to create statement in Multicash, using RFEBKATX programme.

Can you pls let me know the mandatory parameters to be given here.

Pls advice

Niranjan

[former_member318765]

Hi,

Format (M-Multicash, O-OFX) M

Statement file C:\auszug.txt

Line item file C:\umsatz.txt

Company code ENTER corresponding Value

House bank (ID) ENTER corresponding Value

Account (ID) ENTER corresponding Value

Enter Statement date Enter Invoice date

Enter values to create open items based on your requirement to post in posting area 1 or 2 or both. Read the program documentation for more details.

Import the Multicash files created via program RFEBKA00 program once the necessary customising of EBS is done. You can

refer to online documentation of EBS for more details.

Hope this helps

Kind Regards

Soumya

[former_member182714]

HI Soumya,

I have run programme to generate test file in Multicash. However, I have got the below error.

For Main Bank A/c I assigned 200101, clearing accounts - 200102,200103.

I have no idea why 200119 is getting triggered when this is not existing.

09.12.2011 Test Tool RFEBKATX: Create Open Items and Bank Statement Files 1

Account info

Company code 1981

House bk SBI

Bank acct SBI1

Bank number SBI1729

Acct number 8050029

Currncy INR

09.12.2011 Test Tool RFEBKATX: Create Open Items and Bank Statement Files 2

Subsidiary ledger

1 000000046

00001 FB01 DR 001 01 1000000046 INR 5.000,00-

002 50 200119 INR 5.000,00

0A Error: (F5 106) G/L account 200119 RLIF does not exist

09.12.2011 Test Tool RFEBKATX: Create Open Items and Bank Statement Files 3

G/L acct postings

C ash disbursement

00002 FB01 SA 001 40 200119 INR 30.000,00-

002 50 200102 INR 30.000,00

0A Error: (F5 106) G/L account 200119 RLIF does not exist

O utgoing checks

00003 FB01 SA 001 40 200119 INR 31.000,00-

002 50 200101 INR 31.000,00

0A Error: (F5 106) G/L account 200119 RLIF does not exist

O utgoing checks

00004 FB01 SA 001 40 200119 INR 32.000,00-

002 50 200101 INR 32.000,00

0A Error: (F5 106) G/L account 200119 RLIF does not exist

I ncoming checks

00005 FB01 SA 001 40 200108 INR 40.000,00-

002 50 200119 INR 40.000,00

0A Error: (F5 106) G/L account 200119 RLIF does not exist

09.12.2011 Test Tool RFEBKATX: Create Open Items and Bank Statement Files 4

Files created

0A No open items created

0A No files generated

Edited by: Yandamuri Niranjan on Dec 9, 2011 6:07 PM

[former_member318765]

Hi,

Test Tool RFEBKATX is used to create Open Items and Bank Statement Files. There are certain prerequisites for the same as mentioned in the program documenation. One of the points mentioned is about this acct determination which is hardcoded in the program as below

Include RFEBKAT8 Active

...

DATA: S_BANK LIKE BSEG-HKONT VALUE '++++++++00',

S_SONST LIKE BSEG-HKONT VALUE '++++++++19',

S_CKEING LIKE BSEG-HKONT VALUE '++++++++08',

S_CKAUSG LIKE BSEG-HKONT VALUE '++++++++01',

S_GELDAUSG LIKE BSEG-HKONT VALUE '++++++++02'.

Please read the documentation for more details as requested earlier. Especially the below part

"Create customer

3. Create a substitute account for the postings which lead to the creation of open items in customer accounts. The number of this G/L account must be the same as that of the G/L account for the house bank account, except that the last two digits must be replaced with "19".f die

Example:

G/L account: 113100

Substitute account: 113119"

Hope this clarifies. Have a Nice Day,

Kind Regards

Soumya

[Former Member]

Thanks Pramitha and Variablestar. I am working on ur suggestions and will revert back if needed.

Regards

[Former Member]

Hi,

EBS using for uploading external file format (SWIFT MT940 ,Mt942,BAI,BAI2.....) to SAP. (FF_5 (RFEBKA00) /FF.5 ).For testing purpose load EBS use a note pad with formats (SWIFT MT940 ,Mt942,BAI,BAI2.....) & also do the configuration in IMG path in SAP.Please refer this links.

http://www.sap-img.com/financial/customizing-an-electronic-bank-reconciliation-statement.htm

http://srilogix.com/casesWhitepapers/Electronic%20Bank%20Statement.pdf

Regards,

Pramitha.

Edited by: pramitha on Mar 31, 2011 2:17 PM

[Former Member]

Hello Keyin,

You can use Note 0000036833 to check EBS Bank Statement MC format for RFEBKA00 program (Header, Line item format).

RFEBKA00 Progarm need some Bank format (Such as MC format) and you can make example file form MC format Layout in Note 0000036833.

"^.-"