Skip to Content
Author's profile photo Mrunal Mhaskar

Generate custom MT103 file format for electronic vendor payments

Introduction-

Our client was exporting vendor payments via txt file from sap, but now they wanted to change the file format from txt to SIF format. So that they can export

data in SIF format from sap and do the vendor payments  ahead. So we have created new file format ZMT103 which was copy of MT103  And extended to further modifications as per the requirement.  

Steps to create the new file format ZMT103

1. In order to change the file format for vendor payment from txt to MT103,Copy the existing file format from MT103 to ZMT103 in tcode ‘OBPM1’ as shown below

/wp-content/uploads/2015/11/1_841281.png

2. Create 2 function modules in SE37.

    Copy FM ‘ZFI_PAYMEDIUM_MT103_20’ from FI_PAYMEDIUM_MT103_20

    In this FM, Modify header section of the file as per the requirement.

    then Copy FM ZFI_PAYMEDIUM_MT103_30 from FI_PAYMEDIUM_MT103_30

    In this FM, Modify main section in file as per the requirement.

3.Go to Tcode -> OBPM3 -> assign Fm ZFI_PAYMEDIUM_MT103_20 to Event ‘21’

   And FM ZFI_PAYMEDIUM_MT103_30 to Event ‘31’ as shown below.

/wp-content/uploads/2015/11/2_841282.png

/wp-content/uploads/2015/11/3_841292.png

4.Goto Tcode OBPM4 and create variant as shown below. Variant will not be transported, it should be created in each system

/wp-content/uploads/2015/11/4_841293.png

/wp-content/uploads/2015/11/5_841294.png

5.Now go to FBZP-> Payments in Country-> select country and specific method -> and assign format ‘ZMT103’ in the option ‘use payment medium

   workbench’ as shown below.

/wp-content/uploads/2015/11/6_841254.png

6.At last execute the payment run in F110 and get the file generated at the path mentioned in the variant /PBMG/legacy/ZEU6004_ZMT103.txt as shown

   below in the ZMT103 format.

/wp-content/uploads/2015/11/12_841333.png

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Dear Mrunal,

      Thankyou for your post, I found it very helpful.
      However, there is one issue I need further clarity on. I am using standard MT103, and using event modules with it in following way

      When the payment medium is created; the payment is written in file TWICE. Once as per standard, and once as per modifications I've made in function module.

      Can you please suggest what I am missing.

      Regards,
      Talha Aftab