Life, SAP, Consulting, Programming, Coding, ASP.NET, Sharepoint, MVC, Javascript, PHP, WebDesign, CSS, HTML

DMEE Aggregation field

How to create a aggregation field in DME file?

 
 

Follow the settings like below (Sample template: LUX_VIR2000)

 
 

Setup Sort fields: Sum by Vendor level + Value date in DME file.

 
 


 
 

 
 

1 segment contains lower level (2) data for aggregation field


 
 

Technical Field with Reference ID (N_P_VLUE)


 
 

 
 

Target field mapping is Aggregation, setup to N_PVLUE node.


 
 

Result (to test alternative payee with one payment in DME file):


 
 

Finally we have DME result:


 
 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: