Bank File and File Formats

[Former Member]

When sending ach file to bank after it gets placed on application server (what is application server transaction code) a direct interface or not? If not what is a direct interface?

What is flat file and xml file. Please tell the difference with example??

What are various file formats sap supports for importing ebs in sap? What information should be requested from bank?

[Former Member]

Hi Sheena,

1. Outbound files - You can create a ACH file in any format you want. SAP support text file, IDOC.

After you run your payment program - F110 - the last step is to create the payment medium. When you run this payment medium program it creates the file in a specific format as per your configuration. This file can be stored in your hard drive (C:) or in the SAP server based on the path given by you in the variant.

You can use T-code FDTA to view the file.

If it gets stored in C: you can just go to the directory and double click the file.

If it is stored in SAP server you can use transaction AL11 to view the file.

2. Inbound file - The electronic bank statements come in various formats. The most common formats are BAI in US, Multicash in Germany, MT940 in Europe. Each format has been defined separately, you can go to Googe and search for details about these format.

SAP has standard program which read these formats and post them to your General Ledger.

If you have more questions, please post them and I would try to answer.

[Former Member]

Thanks Kalyan,

When talking to the bank the first time, what information should be requested for EBS from them??

[Former Member]

If there are check encashment file coming from bank, then do we need that included in EBS? If yes, then how do we include the check encashment file.

WHat does the EBS include? What all would it reconcile???

[Former Member]

Plese refer to

http://en.wikipedia.org/wiki/XML

http://en.wikipedia.org/wiki/Flat_file_database

for the directories of the serve check tcode AL11

Hopes its help