DME-DATA MEDIUM EXCHANGE
Overview
In Simple word – DME is Output file submit to bank and then bank transfer the amount to vendors.
DME stands for Data Medium Exchange
A data medium exchange (DME) is a data exchange file which is used to send payment information of
an enterprise to banks or tax authority. Basically, these files contain financial data which can be in flat
file or xml file format. Different File formats can be created for different countries and different banks
based on their own norm which replaces conventional ABAP programs.
There are some important payment methods
APP Cheques - In this, Company will print Cheque and send to Vendors.
APP IDOC - In this, Bank will print Cheque and send to Vendors.
APP DME - In this, output file will be submitted to Bank, and Bank will Transfer the amount to
vendors.
Output File (Flat file) – Above Format is created in DME which is given by bank or as per bank
requirement we have to create the format.
Explanation of FLAT file
Field Name Example Value Description
Record Date 30.07.2023 The date when the file was generated or the payment is to be made.
Company Code TASL The company code or identifier initiating the payment.
File Reference TASLF11000000120
A unique file reference or batch number for tracking.
Number 23
Transaction No 101 Sequential payment/transaction number.
Payment Mode RTGS Payment mode (e.g., RTGS, NEFT, etc.).
Debit Bank Name ICICI Bank name from which money will be debited.
Debit Account No 14785214477 Bank account number from which money will be debited.
Debit IFSC Code ICIC0007414 IFSC code of the debit (paying company's) account.
Vendor Name Reliance Digital Ltd. Name of the vendor/beneficiary.
Vendor Account
1.46001E+11 Beneficiary/Vendor’s bank account number.
No
Vendor IFSC
ICIC0001460 IFSC code for vendor’s bank account.
Code
Currency INR Currency code (INR for Indian Rupees).
Payment amount, formatted as 10000,00 (comma is decimal separator
Amount 10000,00
here).
Some Important key Points of DME
1. Transaction to create DME Tree: DMEE
2. Each DME tree must contain a Root level.
3. A DME tree must be activated before it can be used.
4. All DME Format trees for payments are driven by SAP standard program SAPFPAYM.
5. Each field in a DME tree is named an “Element.”
6. An Element’s subfield is called an “Atoms.” These atoms can be used to add additional
flexibility to a field.
There are 5 main types of attributes which can be assigned to an Element or Atom.
1. Constant
2. Structure Field
3. Reference Tree Node
4. Aggregation
5. Exit Module
DME Tree Format
Header Level Nodes
Node Name Structure-Field Name Length Mapping Procedure Node Value Level Node Order
Date FPAYH-LAUFD C(10) Structure Field Level 1 1
Company Code FPAYH-ZBUKR C(4) Structure Field Level 1 2
Bank Reference FPAYH-DOC1R C(24) Structure Field Level 1 3
Transaction Level Nodes
Node Name Structure-Field Name Length Mapping Procedure Node Value Level Node Order
Sequence No FPAYH-LFDNR C(5) Structure Field Level 2 1
Payment Type #NA C(4) Constant Level 2 2
House Bank FPAYH-HBKID C(15) Structure Field Level 2 3
Payer IFSC FPAYHX-USWIF C(11) Structure Field Level 2 5
Payer Bank A/c FPAYHX-UBKNT C(35) Structure Field Level 2 4
Vendor Name FPAYH-ZNME1 C(40) Structure Field Level 2 6
Vendor IFSC FPAYH-ZSWIF C(11) Structure Field Level 2 8
Vendor Bank Acc FPAYH-ZBNKN C(15) Structure Field Level 2 7
Currency FPAYH-WAERS C(5) Structure Field Level 2 9
Amount FPAYH-RWBTR P(12) Structure Field Level 2 10
CONSTANT -Where we need more than 1 node value example – Payment type -RTGS/IMPS/NEFT.
STRUCTURE FIELD- Where we know the field names.
Based on above Header and transaction level Nodes out output file DME is created.
We will also create technical field in DME tree During configuration based on that our file will get all
details like date, company code, bank, vendor etc.
Below is the Screen of T. Code – DMEE
we create a Format Tree named - /zdme_test
IN FBZP > Payment method in country > select payment method > in format field we put our DME
format tree /zdme_test
While Doing F110
we can export this file and share with our bank.
Table – FINSV_f4_LDBURKS
Configuration
To configure DMEE we would need to have below details
FI configuration –
FI Enterprises Structure Configuration
Edit, Copy, Delete, Check Company Code
Define Field Status Variants
Assign Company Code to Field Status Variants
Assign Company Code to a Fiscal Year Variant
Define Variants for Open Posting Periods
Assign Variants to Company Code
Open and Close Posting Periods
Copy to Company Code
Define Tolerance Groups for Employees
Edit Chart of Accounts List
Assign Company Code to Chart of Accounts
Define Account Group
Define Retained Earnings Account
Define Settings for Ledgers and Currency Types
Accounts Payable- BP and vendors
Note:- If client requirement is same no. for both business partner and vendor/customer master
Define Vendor Number Range is Externally and BP Number Range is Internally.
House Bank- Bank
APP configuration -FBZP
DMEE Configuration Steps :-
Steps Descriptions T-code
1 Create Payment Medium Formats (OBPM1) /ZDME_ICICI
2 Assign Payment Medium Format to Payment Method at Country Level (FBZP)
3 Create and Assign variants for the House bank (OBPM4) Transaction SA38 SAPFPAYM
4 Data Medium Exchange (DME)- Mapping (DMEE)
Step 1
Create Payment Medium format – OBPM1
Click on new entries select type as 01 for flat file and select Mapping using DME engine and
Payment medium as company code and house bank and save.
STEP 2 TCODE - FBZP
Assign Payment Medium Format to Payment Method at Country Level
STEP 3 TCODE- OBPM4
Create and Assign variants for the House bank
Here we select our payment medium format and create a variant
Click on yes and then select for all selection sc
Click on continue
Need to put format which we created and select print parameters and select LP01 standard printer
Give description and save