SAP Knowledge Base Article - Public

3275744 - Map Format Data For Payments Delimiter in text file

Symptom

You need to create a custom payment format mapping which is delimited by tabulator. You do not know how to enter tabulator as a delimiter.

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Environment

SAP S/4HANA Cloud 

Resolution

Possible workarounds

Workaround 1 

1.1 In app Custom Logic (App ID F1481)

Create own implementation (See Including Custom Reference Fields and How to export a custom field (e-mail) in the payment file)

Business Context: Finance Payment Medium

Badi Description: Payment Medium: Custom Additional Reference Fields 

 paymentcustomerfields-zref01(1) = cl_abap_char_utilities=>horizontal_tab.


1.2 In customizing Map Format Data for Payments (100558)

It is necessary to manually add every delimiter and make sure that if a field is not issued, also delimiter is not issued. 



Output looks like this:

 

Workaround 2:
Workaround 2 is only possible in 3 system landscape using Developer Extensibility  

1.1 In customizing Map Format Data for Payments (100558) create a delimiter and then replace it in the post-processing BADI.

1.2   Maintain as standard delimiter in Format Mapping Properties -> File Data choose Field Type Fields are separated by a delimiter


2.2 The placement of the character depends on the requirements of the defined format. 

In this example the dollar sign is placed in Delimiter in Segment Groups, Delimiter in Segments and Delimiter in Composites

See File Data for information on same.

3.   DMEE_OUTPUT_POSTPROCESSING is released for use in Cloud Development 



In the ABAP Development Tools 

Implement BADI for 

Enhancement Spot: ES_DMEEX 
Badi definition: DMEE_OUTPUT_POSTPROCESSING 

Filter on

TREE_TYPE = PAYM

TREE_ID = name of custom payment medium format. 



4.  In the custom class replace the defined delimiters with horizontal_tab (tabulator).



5. In the output you can see both lines exactly the same. First used the Key User app using the ZREF01 field, second the DMEEX BADI for Postprocessing.

See Also

Map Format Data for Payments File Data

File Data 

 Use System-Internally (C1)


Keywords

 tab, delimiter, Escape Character, escape character t (horizontal tab), DMEEX, PMF, TXT, CL_ABAP_CHAR_UTILITIES=>HORIZONTAL_TAB Tab character delimiter  , KBA , FI-AP-AP-B1 , Payment transfer (w/o DE, US) , How To

Product

SAP S/4HANA Cloud all versions

Attachments

Pasted image.png