Dme Configuration In Sap 3j335b

Easy Steps To Create And Configure DME File Table of Contents: 1) Introduction: Significance of DME Files 2) DME Tree structure 3) DME File Configuration Settings 4) Conclusion Introduction: 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. T-Code for DME files is: DMEE Main components of DME File are:  Header Data  Nodes  Data Mapping There are some standard DME file formats, which can be changed as per country or bank requirements. A complete new DME format can also be created if requirement is different from pre existing formats. Step by Step procedure to create DME file format : 1) Go to tcode DMEE.Provide tree type from available ones.Create a new format tree ZGB_PAYMENT_DME

2) DME files can be generated in flat files or XML format.

3) Provide short description and documentation fields :

4) DME tree has some standard structures and system fields for file as shown below:

5) There are some fields which are available for DME file as shown below.

5a) Note to payee data in txt form

5b) System Fields like Date and Time

DME tree Nodes creation procedure: Header Data: Following header information needs to be maintained in various tabs under header data:

istrative Data: Provide istrative data in node first tab.

Format Attributes: Depending on the type of file format, you can specify other details: for flat files, you can enter delimiter information; for XML files, you can specify further processing (via exit module) for a file after its creation, by entering an XSLT program. For format trees of the tree type PAYM, you can additionally specify that an accompanying sheet is to be printed when the file is generated. The system s the printing of both simplified sheets and sheets with subtotals. If you specify an accompanying sheet with subtotals, you must maintain the key fields on the Sort/key fields tab.

Levels The number of levels defines the no of levels in a tree. This tab also defines the repetition level which tells how often a certain level may be output. If this number is exceeded, the corresponding level cannot be output anymore.

If the limit is reached for the uppermost level in the format tree and additional data is to be processed, a second file is generated. If the limit is reached for lower levels, the preceding level is repeated so that data can continue to be output for this level.

Sort Key Fields: File Data can be sorted based on given fields based on their order. Here you can specify how certain fields are to be sorted. For the payment program, for example, you can sort according to currency or by specifying the appropriate source field. If a sort field is additionally marked as a key field, then a change to the value in this field causes the corresponding format level to end. By activating both Key Field and No Sorting, you specify that data does not need to be sorted by this criterion (if, for example, it is already presorted in the Payment Medium Workbench); this results in additional space in the sort fields, which allows you to use additional fields as sort fields.

File Data: This tab provides the file row separator and segment ending indicator.

After creating a segment group, a segment will be created. A tree can have multiple segments as well multiple segments. Create a segment by right click as shown below: Segments can be seen as header and footer and elements can be seen as header and footer tree node. Due to its tree like structure it is called DME Tree.

Node Info: Provide node information for output Comment: This column is used to contain comments for nodes. Maximum three lines of comments per node, this tab is visible for all nodes except the header. Create Elements in Sub node as shown below: These elements can be of various types as shown in mapping procedures. 1) Constant: This type of element is used to contain constant value like ‘DME’ which is assigned in source tab as shown below:

In source tab maintain the system field

Tables : FPAYHX-Payment Medium: Prepared Data for Payment FPAYH-Payment medium: Payment data FPAYP-Payment medium: Data on paid items

3. Configuration of DME File After creation of DME file, next step is to configure the DME file for automatic payment run which requires below steps:

1) Go to Tcode FBZP and select ‘pmnt methods in country’

2) Here different payment methods can be defined for country as shown below:-

3) Now select specific payment method and double click on the same. Following screen will be displayed. In payment medium workbench, DME tree can be assigned in Format column as shown below:

4) Click on Format settings.

Configuration for creating Payment Medium Format The payment medium format controls how payment orders and debit memo orders to the bank are created. The specifications (published by the banks or the central banking committees) of the formats serve as the basis for definition of payment medium formats. The payment medium format can be country-dependent or country-independent and is assigned to one or more payment methods.

PMF

Customer settings for PMF

Assign variants for the House bank requiring the DME settings.

Variant created :ZGB_PAYMENT_DME

Payment run Transaction F110:

DME File :

Now DME tree format is being attached for a particular country and a particular payment method. To generate the DME file, you have to run the automatic payment program with this payment method. After the payments have been successfully posted, you can go to DME istration and with the help of DME manager files on your PC. DME can be attached to a print program and form for the creation of Payment Advices. Whenever there is an automatic payment run for the country for a specific payment method. Conclusion: DME engine provides different layouts and readymade way to create flat files or XML files for external systems. It provides speed and flexibility over conventional abap programs. Files can be modified based on country and regulations. The system can trigger the creation of a DME file from the payment program if, for example, you want to submit your vendor payments to your bank electronically. For this tree type, you use the PMW) to configure payment media.