Standard bank file format "JP_ZENGINKYO" does not output data in SAP public cloud

[khanhlynx99]

Hi experts, 

I used the standard format "JP_ZENGINKYO" to output a bank file, and although the CSV file was created, no data was displayed (except for Kind of record (constant) ).

Using a new format created by copying the standard one and changing the mapping source of some fields, I gained a bank file with some information corresponding to the edited fields. 

I.e.

・Standard format

・Customized format

And some other similarly edited fields. 

The bank file 

Trace result shows that the edited fields received input values, meaning the system can still extract data from master data and payment, but the unedited fields have blank input values, meaning the standard format's sources are not passed with data. 

I came up with an idea that we might need to customize the logic to pass values for these fields. However, in the app "Custom logic", the source of the standard format (table: FPAYHX) is not under CHANGING parameters but IMPORTING parameters, making it not customizable in Fiori launchpad.

Do you have any idea why the sources of the standard format (FPAYHX-REFxx) cannot receive any values? Debugging is not supported in SAP public cloud, so we cannot determine the exact location of the problem. 
Thank you very much. 

[RaymondGiuseppi · Accepted solution]

Did you look at

• KBA 3478710 - No Payment Media file generated for Payment Medium Format JP_ZENGINKYO - SAP S/4HANA Cloud... 
• Note 2758836 - Japan: Documentation on Payment Medium Programs for ZENGINKYO Domestic Transfer (with attachments)

[khanhlynx99 · Accepted solution]

Hi @RaymondGiuseppi

Thank you for your answers. I have checked 2 links you attached, and about the 1st one, it is not the case because my view log showed no errors. Regarding the 2nd, I am reviewing all the guidance documents attached to the SAP note to identify the potential issue. 
I will update the answer if there is any progress. 
Again, thank you for sharing the references. 

Best regards,

Khanh Linh Nguyen

[khanhlynx99 · Accepted solution]

Hi @RaymondGiuseppi,

[khanhlynx99 · Accepted solution]

Hi @RaymondGiuseppi, thanks to your document, I already can solve the problem. Thank you a lot, it is really informative and helpful document to refer for any bank file problems.

[Chris1973]

Good day @khanhlynx99 

Thank you for your question.

Have a look at the following references for further details.

Payment Medium Format, Creating Custom Payment Medium Formats, Creating Custom Payment Medium Formats, Customizing for Payments

To summarise, in public cloud, when you use or copy a standard payment medium format (such as JP_ZENGINKYO) in the Manage Payment Medium Formats app, it is common to observe that certain standard mapping sources (e.g., FPAYHX-REFxx) appear empty in your custom format even though data exists in the payment run.

The reason is because of how the standard extraction logic for the FPAYHX (Header) and FPAYP (item) structures is encapsulated in SAP’s internal class CL_PYMTM_FORMAT_JP_ZENGINKYO, which cannot be modified or enhanced in the public cloud.

When you copy the standard format, that link to the SAP internal extraction routine is not inherited, and therefore, the system does not populate the FPAYHX reference fields unless the mapping source explicitly refers to a supported structure or field populated by your custom logic.

Let me know if you have further questions.

Best regards

Chris

[khanhlynx99]

Hi @Chris1973 

Thank you for your comment. 

I understand that your reply may answer why the standard format's fields in my custom format were outputted blank. What a pity that I cannot access the source code in SAP public cloud to truly confirm it. 

However, as I mentioned in my question, even when I directly used the original format, it still returned blank files. I captured the proposal log before running automatic payment and the trace result as below. I will highly appreciate it if you can have a look and kindly advise me if there is any problem. 

- Proposal log : There was no error or warning in my log view

- Payment :

- Payment medium 

- Bank file 

- Trace result: The result displayed that the input data was totally blank 

Thank you a lot !

Best regards, 

Khanh Linh Nguyen 

[khanhlynx99]

Hi @Chris1973,

[Chris1973]

Hello @khanhlynx99

Thank you for the detailed follow-up and screenshots.

Let us analyse your screenshots and the details you provided.

Based on the proposal log, Manage Automatic Payments, payment medium, bank file and trace result details in your screenshot every FPAYHX and FPAYP field is blank. Which means your extractions were either not executed or the system failed to pass items to the extraction logic. If the extractions logic was running, at least some fields would appear even if REFxx were empty.

To summarise, you used H payment method which is not compatible with JP_ZENGINKYO. The reason JP_ZENGINKYO payment medium output is completely blank is because the payment run did not pass any payment items into the FPAYHX and FPAYP extraction structures.

Your trace screenshots confirm that both structures were entirely empty, which highlights that the extraction logic was never executed for any payment item. That is the case when settings or workbench configuration for JP formats is incomplete. That will then lead to payment proposal succeeding but no eligible items will be handed over to the payment medium generation step. Which will then result in your file only displaying the 1,2,8 and 9 as visible in your screenshot.

Screenshots are used for reference purpose only in the below guidance.

Make sure that your payment method country is correctly set to JP, the one used in your run belongs to JP, your supplier bank country is JP and confirm your Bank Country is JP. If any of these is not equal, the structure will be blank and JP_ZENGINKYO output will be empty.

In your Inhouse bank account, ensure the master is JP else it will generate a blank JP_ZENGINKYO. The ID must correspond to the one used by JP_ZENGINKYO. If your payment medium ID is blank or assigned to any other PMW process, the extractor will not map values into your files.

I hope this brings more clarity.

Best regards

Chris

[khanhlynx99]

Hi @Chris1973, thank you for your answer. The payment method I used was "T" (Domestic bank transfer) which goes with JP_ZENGINKYO and all other configuration was also compatible with each other. The problem was that when creating House bank, I accidentally forget to enter company code for "payment medium general data". That leaded to the fact that all concerned information was available but could not be extracted into the file. I updated the problem in case of reference for other users encountering the same errors. Again, thank you a lot for active contribution and comments.