Skip to Content
author's profile photo Former Member
Former Member

How to Convert file using RFEBKA00 (electronic bank Statement)

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2011 at 12:12 PM

    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.

    "^.-"

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2011 at 12:16 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 05, 2011 at 07:26 AM

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

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 05, 2011 at 12:00 PM

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

    BR Hana

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Godavari SAP

      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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.