Skip to Content
Technical Articles
Author's profile photo Bohdan Petrushchak

Counter of line items in DMEE tree

Hello, SAPers!

Sometimes when you create custom DMEE tree to meet the requirements of your house bank concerning the format of file with payment orders, you have to configure the field with counter of line items in file. This counter represents a simple field with incremental value from 1 to n, where n equals the number of line items in the payment run. However, there are no standard field in the structures FPAYH, FPAYHX and FPAYP. Therefore you have to use another standard functionality that will be discussed in this document.

 

The solution described in this blog was initially described back in 2014. Later on i.e. in 2017 SAP issued a standard FM for Brazil i.e. DMEE_EXIT_BR_FEBR_COUNT, which can be used to achieve the same result with less efforts. Thanks to Engin YILMAZ for pointing out this FM in the comments section. You can use this FM and skip this blog. Or you can read it and gain some new knowledge 🙂

In order to create node that will retrieve the consequential number of line item in the payment run the following activities have to be performed:

1) Create technical node

Technical node stores values that are used in other tree nodes (elements or atom) by a reference to this node. However, the values stored in technical nodes are not shown as output in a target file. Thus, you have to create a technical node with the following characteristics:

Technical node.png

On the tab Source specify the constant value that equals to 1:

/wp-content/uploads/2014/04/technical_node_value_441191.png

          2) Create element with reference to tree node with the following characteristics:

/wp-content/uploads/2014/04/counter_441192.png

On the tab Source specify the reference to the technical tree node created previously and insert “3” (Counter reading) in the field Attribute:

/wp-content/uploads/2014/04/counter_value_441195.png

The nodes in the tree menu of DMEE structure for your payment medium should look as follows:

Overview.png

Create other nodes as required for payment medium for your bank and activate the tree. Afterwards, when you run the transaction FBPM and create the payment medium, your will have the counter starting at one in the beginning of each line item:

Orders.png

Anyway, I hope this information will be useful. All suggestions are welcome!

P.S. This post can also be found on Medium platform under the following link.

 

     Best regards,

     The Wirtschaftsmann

Assigned Tags

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

      Thanks for sharing your knowledge!

      Author's profile photo Ivaylo Mutafchiev
      Ivaylo Mutafchiev

      Thanks,

      also looking for solution like this. Obviously for SAP_APPL 618 it doesn't work. Returns error:

      Node SEQNUM: Cannot map to reference node filled with a constant

      Perhaps something was changed in the core. Played with this for an hours w/o success.

       

      Rgds.

      Author's profile photo Eduardo Hernandez
      Eduardo Hernandez

      Hi Bohdan!!!

       

      Nice post !

       

      I have a Q for you.

       

      If I want my counter to start with X+1 (for example number 2 instead number 1) how can achieve this?

       

      thanks in advance!

      cheers

      Author's profile photo Engin YILMAZ
      Engin YILMAZ

      Hello Bohdan,

       

      Thanks for sharing, very useful.

      I also managed to do it by assigning the function DMEE_EXIT_BR_FEBR_COUNT for the field.

       

      Kind regards,

      Engin

      Author's profile photo Bohdan Petrushchak
      Bohdan Petrushchak
      Blog Post Author

      Hi Engin YILMAZ,

      Thank you ! This is a very good finding. From what I can see, the FM was released around 2017 and at the time when I wrote this post - in 2014 it was not available yet. Anyway, I'll update the post and mention this FM.

      Thank you !

      Regards,

      Bohdan

      Author's profile photo Engin YILMAZ
      Engin YILMAZ

      Hi Bohdan Petrushchak ,

      I am only glad to have contributed to this blog. Thanks for the appreciation.

      Kind regards,

      Engin