www sunrisetrainings.com/blog 491-9711130075, Data Medium Exchange Engine (DMEE) 1. Create DME Tree , TCode DMEE Tree type - | PAYM (DMEE for Payment Program) Format tree -__ SEPA_CT_0010013 (Reference format given by SAP) re rear Format tree ‘SEPA CTOON00103 Click on Copy button and create new DMEE Select Active version YouTube Channel : Sunrise Trainings491-9711130075, |_ Source format tree Tree type PAYM) Format tree SEPA_CT_ 00100103 ‘Active version (O)Maintenance version In Target format tree Format tree = Give ID for your DMEE Tree like in this example ‘Z_2172_DME_Tree’ Press Enter DMEE format tree SEPA_CT_00100103 was copied to Z_2172_DME_TREE Above message will display YouTube Channel : Sunrise Trainingscom/blog 491-9711130075, ar a ts a ta rn fs Se se seo ae = = = = tba ee Sse os ———— =e I si a” ee Sere teatce 2. Create Payment Medium Work (PMW), TCode OBPM1 :- ep @ caution: The table is cross-cient Click on enter button From the list of Payment Medium Formats select ‘SEPA_CT_00100103° And click on ‘Copy’ button SEA Cede Tan For SE act Oe (ak alton) Sek Dec Out ep 03.02 SEPAEDD Form ‘tog (Oct Dei fr Sin Cae Taner POSTEO Sdn, Foregn pamers Sean 5 1 ott US Fed Gove 10 arr Us Fadel ner Slovenia een A feat Svea coma AP feat Sora“ SWF, MT 300 Crt by OEE rey 950127 YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, Format - —__Z_Payment_format_CoCode (give any alpha/numeric) Description - __Z_Payment_Format_CoCode [Deus nk acct Structure for format parameters - Z_2172_DME_Tree (Select your DMEE ID) Press Save button 3. Assign Payment Medium Work (PMW) format, TCode FBZP :- Select Country -US Create New Payment Method - 5 (With Reference to existing payment method Bank Transfer with ID “T’, any single character apha/number/special) Assign Your PMW Format (e.g. Z_Payment_format_2172) in the Payment Method:- YouTube Channel : Sunrise Trainings491-9711130075, et en at rt? ater cr mn Gone eprops ise Pmt rere Cees ce ‘Dacor inte Rete Disa Reastes (Dis ene Ragaret [iettan nuerabo sn hana are 4, Assign New Payment Method to CoCode :- YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, |Wicurtnender bank bread allowed? Copii by petal ode “rsauryDeparevent ‘Corsepondencs| Wane US Wc 3488 Une tens oH 5. Assign New Payment Method in Bank Determination :~ -Ranking Order : Disks Stucre ‘stmart US UC -Bank Account :~ YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, Y row trees Gab EB Dal Scare Paying company code (202) viamartus uc (Casank Acourts (Enhanced) Girvalabe amounts Bivsiue ote Hows bank Pin Cures. Account Sank ubaccount cherge ind Bus azz 7_usb 00001 200103, [errs 3 va conor —so010 ELLs ews —caaot —s00107 6. Create Payment Medium Variant: TCode OBPM4 Percy sonra donate ne. = aon eS iaean sega s) |) | | FBS) LB) IR resrorAToo, Dan atm acne. n as TS Format Finland for Recur.. (Peat Howe Bk Sa. vero | au Fecsin Pomrat Tanacte., 2272 SHEL Bum Sotorecsomes, (aro sae WPS UAE i oe (ZBNK_POR FORMAT. t ao 20H OTA all aesay abe el ee ee Romero anc, | Ganmecm cmcentesrnsc: || i200 aso ‘sous mate so Banc Sonceat re | tee amon Frac erttomein. ul 1400 Samia fest paper tooo Bane [rw meet en too iS amie aoe curenmecs’ | 2000 Bane Seovanemmnm tao za Perm cst eo. [sone BE ow [restomeenesentes Ifa —Se0o Rion Peat ae |B) ZPAYMENT.FORMAT 21722 Payert Format 2172 * Select your PMW Format and to go your House Bank and keep the cursor YouTube Channel : Sunrise Trainingscom/blog 491-9711130075, Payment Medium Format Z_PAYMENT FORMAT 2172 Format Description Z Payment Format 2172 ureait variant Fst | poocd House Bk Set, variant | 2172 errr crrr2 Ennes WELLS 1000 1001 Create PMW Variant by clicking on change variant button een ewe Cs Created oO [Number Ty. ‘1000 Full screen YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 4919711130075 7. Assign DMEE Payment Method in Vendor Master Data vendor {100700 |) chevron Manefocuing LP Wiener US LLC nf Terme 2172 “Tolerance greup Cr memo terms. ‘Chk double inv. oO fon> i [) 7c ‘revi pmot aoe Bleich us Prtadebyeor Atoore(doe) far 8, Goto Automatic Payment Program — F110 YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, Maintain Parameter Te. 03.2020 Optional step YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, Run Date 17.03.2020 [¥iDue date check Payment method selection in all cases (]Pmnt method selection if not successful [¥]Line items of the payment documents. Accounts required Vendors (from/to) Customers (from/to) f 100700 YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, Schedule Payment Proposal :- YouTube Channel : Sunrise Trainings491-9711130075, Run Date 17,03.2020 Identification [DMEL | freee Start dato: Start time Target computer [WiCreate payment medium Check Proposal, there should be Green Indicator for the relevant line items Parameters have been entered (@ Payment proposal has been created YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, Dil Loos ‘es Payment Run Payment Maur, rs SE neice Shh ith See toate Steinsaoaan a0. —¥ Saree ese ae ae ce Pali an ey YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, Execute Payment Run :- Identification DMEL Goto Menu and select DME Overview © payment tun Edt Geto | Erakenment | Sistem Hele Delay contig Miran con Marea Variants (heck tferation . rect Debt Prenatiction » {2 Poramtars have bean ented Parent ropaa has bean crested Payment run hae been card out Posing ord: tgenaratad, 1 canotad YouTube Channel : Sunrise Trainingswww sunrisetrainings.com/blog 491-9711130075, Semen ate ae Enema aoa inh emcenenne> = I mrenriae bo enrienners Semen Beckles Se tee & Scar temo mai re po ine ooo ae fie nce a mucins oie Sieecnne —- End of DMEE, YouTube Channel : Sunrise TrainingsDMEE Tree CreationSteps to Create a DMEE Format 4. Run transaction DMEE, 2. On the DME Engine: Initial Screen, specify the following and choose Create. ‘+ Tree type: PAYM (standard tree type for Payment) + Format tree: specify the name of the tree you want to create (for example, Z_JP_EMC_XML) DME Engine: Initial Screen ueo8 3. In the next dialog box, choose the type of file ((Flat fle or XML file) that you want to create, What nd oie wou you ks to este wth tha OEE fost? 4, On the DME: Create Format Tree screen, specify the following: ‘+ Inthe Administrative Data tab page, specify the short description for the format tree nt 2248 or a eeIn the Format Attributes tab page, specify the name of the format-specific structure ME: Cat Format Te ZENE Note You use format parameter structure to specify additional information or choase additional fle structure formatting options while executing the DMEE format, With a certain transaction, the user can create variants for the formatting options per house banks per payment method To do this, run transaction SPRO and choose SAP Reference IMG. In the IMG tree, choose Financial Accounting > Accounts Receivable and Accounts Payable > Business Transactions > Outgoing Payments > Automatic Outgoing Payments > Payment Media > Make settings for payment medium formats for payment medium > Create/Assign Selection Variant. In the Levels tab page, specify the levels with their repetition factors ea foe Saige Fa [ise estonia ES In the above screen shot, you have specified three levels: Level 0, Level 1, and Level 2. The repetition factor specified against each level indicates the number of times the information at @ particular level can be repeated in the DME file. This means that you have all these levels in your DME format. The level 1 information can ‘come only once in the output file, but level 2 information can be repeated up to 9999999 times in the file.+ Inthe Sortkey fields tab page, you can set the levels for the fields along with the structure name If sort field is selected as key field, then a change to the value in this field causes the corresponding format level to end. You need to define the key fields correctly to ensure that during file generation the sequence of the different levels is output as they are defined in the format. Example: Ifyou want the company code (FPAYH-ZBUKR) to be at level 1, specify it as shown in the above screen shot. As the repetition factor for Levet is 1, this information is only displayed once in the DME file. If you have 2 company codes, then the OME file would be split and two separate ‘output files are created for the two company codes. Ifyou want the payment document (FPAYH-DOC1R) to be at level 2, specify it as shown in the ‘example. As the repetition factor for Level 2 is 999999, level 2 information can come up to 99999 limes in the DMEE file. In the File Data tab page, you can specify the characters that you want to allow and disallow in your DME file. ‘arate Deft wat ee S*d5. For creating new nodes, right click on the node DME tree: properties present on the left hand and choose the node type (for example, element, atom, technical node) to be created. a) ) 9 4) e) Type of Nodes: nade oes woraten + @eement * imc state + Be Technical node +B Reference of node + By Reference to another nods ents Element ‘An element is used to get output values in the target fle for a defined tag. For each element, you specify the value or the source field to be used to fil this tag. You can define further elements and XML attributes as subnodes of an element. XML Attribute ‘An XML attribute is used to further specify the values of an element, ‘You can choose either a value or a source field. Technical Node A technical node is an element that is not output to the target file. It stores values that are used in other tree nodes (elements, atoms) by reference to the technical node. For this reason, a technical node generally contains a reference ID.If you wish to ‘output the contents of the technical node to the target file, then you can convert the node to an element. Example: An account number, represented by an element, is output to the target file, The attribute determines whether itis the account number of the payer or payee. Atom ‘You need to create an atom when you define more than one mapping rule for an element. You need to create atoms as subnodes of an element in the following scenarios: > Several mapping rules exist for the element that are to be applied if certain conditions are met > Different parts of the tag are to be filled separately with values rence ID of node ‘Anode that contains a reference ID can be referenced from other nodes in the format tree. You can specify such a reference when you define mapping rules, conditions, or aggregation. You must assign unique reference IDs (within the tree). When you delete a node that contains a reference ID, be sure that no references to this node exist.In the Attributes tab page, specify the following DMEE: Create Format Tree Z 78 EMC XML es fo Cenee Tae Under Attributes section, specify details such as name, short description, length, type and level Under Mapping Procedure section, select one of the following source type: > Constant Used if any constant value is the source y Reference to tree node Used if the node value is determined by the value of another node in the format tree. You can assign this relationship by means of a reference ID. > Aggregation Used if the value of this node results from the aggregation of other node values. > Atom Han Used ifthe final value of an element is derived by combining the values of atoms in different ways. > No Mapping Used if no source value is assigned to the node. > Structure Used if the source field is from the payment specific structures such as FPAYH, FPAYHX, and FPAYP, You can see the structures in transaction SE11,> Exit Module Used if the information is retrieved by an exit module. Stops to create exit modules: a) Run transaction SE37. b)_ Inthe Function Builder: Initial Screen, specify the following in the Function module field, and choose Copy = DMEE_EXIT_TEMPLATE_EXTEND_ABA (for releases 500 and above) = DMEE_EXIT_TEMPLATE_EXTENDED (for 470 release) Function Builder: Initial Screen & 1 BSH OOP roam, Fanctan Hole Eee — ©) Inthe Copy Functional Module dialog box, speciy the following and choose Copy Fr Function Module: Name of the standard template exit module To Function Module: Name of the exit module that you want to create Function Group: Name of the function group in which you want to create the exit module ‘To Function module pees Ez Fe Function module fee ewe ee ‘ACT TEWPLATE_EATEN ABA Function group d) Save and activate the function module in your package, In the Source tab page, specify the constant or structure field from where you want to get the information. In the Condition tab page, specify the conditions, if any In the Comment tab page, specify comments, if any Similarly, you create the various nodes in the DME tree. Save and activate your DMEE formatCustomizing settings for DMEE Format (Note) Here, we use the DMEE format “CGI_XML_CT”, which has a format parameter structure, as an ‘example. The DMEE format CGI_XML_CT has the format parameter structure "FPM_CGI", Create Payment Medium Workbench (PMW) Format: 4. Run transaction OBPM1 2, Choose New Entries, 3. Enter the name of your DME format in the Format field, and populate the other fields as shown below: ‘Change View “Payment Mechum Formats": Details P vee OBO OBS coun a) Tas hire == a) (rar ne HE wee (oreeare) Payer ut oe ye OE (ae inka 4. In the Dialogue Structure tree, click on Event Modules for Payment Formats 5. Attach function module name for event 05, which is used to fill the reference fields. To do this, choose New Entries in the menu bar and select Event 05 as shown in the screen shot below:Change View “Event Modules for Payment Medium Formats”: Overview F now ones OG BO (Sb Noe oro aaa a a [fore Farareter Rear Clsupserent er Povren || — Bent Funeion meta (iter Feta fr Reterera | 22 LPAI BEE 6 framenumpueeccil | 20 FLPAYMEDIM ONEEO 5 FLemmetIM OEE ZS 0 FLPaMEDIN ONEESO Events of PMW: ‘The Payment Medium Workbench contains several predefined events (positions in the coding). If during the process flow of the PMW, such an event is reached and if a function module is assigned to this event in the customizing (transaction OBPM1 and OBPM3), then this function module will be executed The following events are available for the usage by SAP: [Eventno. ~~~_~+| Eventname fo ~:~ FP Sr Fred [oe ———~—~—“‘“CY QRilVaadditiona reference iets | io ——~—~—“‘i‘“—s~s—s**CCCC YF Check Format parameters | (20 YF StartiFile header 3 —~”~”CSCSCS*C*YS* ile cTosevopen [30 Orderftransaction record a0 Endl taller Process: 4. Event 20 Function module DMEE_START is called and the DME file is opened 2. Event 05 Fills the reference fields for the REGUH records 3. Event 30Calls the function module DMEE_PUT_ITEM in a loop for every entry of table REGUP that corresponds to the first REGUH entry 4, Event 25 Calls the function module DMEE_NEW_FILE and checks whether a new file needs to be created according to the key fleld settings in the format tree definition, 5. Event 40 Calls the function module DMEE_END and closes the DME file If required, it prints the SAPScript form. In the Dialog Structure tree, click on Text Fields for Reference Information and make any necessary cchanges to the number and length of text fields as shown below: Change View "Text Flelds for Reference Information”: Overview & newertes BE OBB Dabog Smuts | (Ge Note to payee] + Expayment nodur Form + Clevent modules for FJ + CiFomat Parmeter + supplements for Fa Feldten. Now tds EO “sk aDefine Payment Method for Country 4. Run transaction FBZP 2, Choose Pmnt methods in country 3. Choose New Entries and populate the fields for your country format as shown in the example below. Here, the payment method T(Bank Transfer) of the country TH has the DMEE format CGI_XML_CT. va BoRaa eo Damar hn) oeenevame gee reat NCPaee ony stonbe Fass ence. Inthe Payment medium group box, select Use payment medium workbench radio button and populate the Format field with the value of name of your DMEE format . In the Dialog Structure, choose Note to Payee by Or payee to the transaction inthe dialog structure and assign the note to iraymene methee/county © Clcuranoes Aswad + Carerntzed vesunznon countresNote: Before specifying the Note to Payee in the above dialog box, you need to create the Note to Payot structure in transaction OBPM2 per your business requirement, Create Note to Payee 4. Run transaction OBPM2 2, Choose New Entries 3. Inthe subsequent screen, maintain entries as follows: Dn vega == [mi [Blaithewrase | europe jaro eee toto one tuner ete wang re 4, In the Dialog Structure box, select Default Note to Payee 5. Choose New Entries and maintain entries as follows: {Bmpr nt ree : Th Hear oauRRAEA- DATE ae) ‘re ater 6. Save the changes and assign the Note to Payee to the format using transaction FBZP.Assign Payment Method and Country to Company Code 4, Run transaction FBZP 2. Choose Pmnt methods in countryinGianas, Mew ctteintenenes of Comowny, Code Dts Fors Payment tte vo PSO REE me ‘erweemno it Ereeoiing = Banatbching ‘check secre) ‘nen Eco bn En tindon C90) ‘OWL: SnnaRehuoen nnlecheck bet Aandeabrg [patos [O11 hurangstgen lrteheck ost Uberti Eoxberwating ee secede heen Nerang Gn Kr) ese Ansonia) 7 venue Bevo Tate mare ‘ecu eto Bantabbiching ‘oawesingCfomuir + fanlabbucung OME 5 i | p02 county Teno At Agertien | tes ounty Tavobie AT (austin Coyne w owe a new o one R nw ny wg 3, Choose New Entries and populate as shown in below screen shotP ven ome Co ae acoso] cut aro prtmatiod—‘AAS) som Teer Ce unerumareune [005,00 Th earum araunt i Dtibutin ar _Foregn paymentsfoeign cency parents (Forean business zane alowed |TiFecegn cureney alowed lossy vendor bank abroad stowed? ©_tomosa tie ‘country Template Thai “Tes tame 2 eee Teacye«® ovat ics ovo | Onmsey ster ato no. of has 4, Save your changes oun of Rene (Dsngje payment for marted tam Dayment per due doy [Diestended mevdua Payment Bank select contre (No entiation Coptmae by bank gous O.optmae by postal code | Serta of correspondence Lne tare “Rguce nates alestances “Thare& 90 note to payee neon thaGeneration of DMEE File ‘Once you do create vendor master data, post vendor invoice, and then execute the payment run or 1yment proposal or payment run (by F110), you execute the report SAPFPAYM or transaction FBPM to generate the output DME payment file. 4, Run transaction FBPM 2. Specify the details as shown in screen shot © *(8\ece@ DAR Stas Bn On Payment Medium: Creation oone a Seer ol eres rpms 3. Choose Execute Creation of Variant ‘You can create the variant for a particular payment run date and identification, 1. Run transaction FBPM 2. Specify the following details: > F110 Run Date > Identification > Select Proposal run check box if you have only executed the proposal run ad not the payment run > Payment medium format name3. Choose Save (Ctrl +S) to save the variant. The system displays the following screen: 4. Specify the variant name, description, and choose Save. The system saves the variant © Sa pece cue cece mmom eco