- Yossi Levi, CPA (Isr.)
Using DME Field Conditions
Recently we are facing an increasing need for creating specific DME (Data Medium Exchange) files for different purposes: banks (i.e. Citi Direct), customers, credit companies etc.
The standard SAP DME tool is the DMEE Engine which includes several file structures supported by SAP. However, non-standard structures are not supported and even if they are, you still often need to configure these structures for specific customer requirements.
In this post, we will focus on using DME field conditions.
The need
When we are creating a new structure, or changing an existing one, a basic requirement is to populate one of the fields with different values based on a specific rule.
Example
In one of the bank DME file structure there is a new regulation that requires for currency CNY (Chinese Yuan) payments to populate a new field with a payment description.
Requirement:
Add a new field to DME file, field name 'Purpose of CNY Payment' with default value = blank.
Condition 1: In case of payment currency CNY and payment type '300' (Goods), field value should be 'Business/goods Trade'.
Condition 2: In case of payment currency CNY and payment type '339' (Services), field value should be 'Business/Service Trade'.
Solution:
1. Add to the existing field ‘Payment type’ a reference ID = ‘PAYM_TYPE’
2. Add a new field 'Purpose of CNY Payment' with two atoms.
'Purpose of CNY Payment' – field type should be 'Own mapping (atoms)'
Atom1 –field type should be 'Constant' with value 'Business/goods Trade'
Atom2 - field type should be 'Constant' with value 'Business/Service Trade'
3. Define the conditions in the atoms as follow:
Atom 1
Atom 2
Summary:
In that simple way, we can populate any DME field in the required structure based on any logic rule.
For more information, please contact us: info@allegropro.co.il
