Generate custom MT103 file format for electronic vendor payments
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
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.
4.Goto Tcode OBPM4 and create variant as shown below. Variant will not be transported, it should be created in each system
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.
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.
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.