Monitor Bank Fees app Camt.086 AFP service Service Codes calculated volume field

[emma_c1]

Hi Experts,

System: S4Hana 2022 (S4CORE 107)

We are testing "Monitor Bank Fees" app with camt.086.001.01.

We are checking OSS notes 3279603 - Monitor Bank Fees: Enhancements for Bank Fee Validation to understand the logic for field "calculated volume".

In the OSS note, it mentioned below: If both of the following conditions are met, the calculated service volume is set to the total volume of the service as stated in the bank statements. “Payment Transaction Type Group” and “External Transaction” are updated with the value in the identified bank statement and the bank statement items respectively.

Bank service mapping for the service is maintained in app “Manage Banks”

Bank statements for the bank service mapping can be found

With above mentioned logic, we got below questions:

Q1: In BSB file, we only got AFP Global Service Codes. We don't see any external transaction code. We maintain 8 digi AFP Global Service Codes as a external transaction code in OT83 and assign them to manage banks app. However, system still show zero field "calculated volume" in the app.
Does anyone know how do we map Camt.086 AFP Global Service Codes to sap OT83 external transaction code?

Or external transaction code in which XML tag in camt.086.001.01?

Thanks

Emma Chou

[BulentD]

Hi Emma,

I have the same issue and could get the correct volumes only by not assigning the service codes in the "Manage Bank" app. Have you got any solution with assignment?

Thanks,

Bulent

[NarendarsaptrM]

Hi Emma,

We are having the same issues in our client. I have maintained the service code in OT83, and with and without assigning service in the Manage Bank Fees app, it is not working. I mean, the calculated volume field is not getting updated. We did the custom transformation as suggested by SAP, but still.

Here is the sample list. Can you elaborate how you resolved the issue?

•  

Service IDService Common Code IssuerService Common CodeService Type00099 (DEPOSIT BANK ASSESSMENT)AFP000230 01005 (INTEREST BEARING ACCOUNT MAINT)AFP010010 01564 (CASHPRO CONNECT PDR ACCT)AFP400002 01565 (CASHPRO CONNECT PDR ITEM)AFP400222 01566 (CASHPRO CONNECT CDR ACCT)AFP400005 01567 (CASHPRO CONNECT CDR ITEM)AFP400225 01655 (CASHPRO ONLINE SUBSCRIPTION)AFP40027Z 01701 (WIRE MONTHLY SUBSCRIPTION)AFP350000 01720 (CASHPRO REPORTING SUBSCRIPTION)AFP40027Z 01721 (CASHPRO ONLINE PDR ACCOUNT)AFP400052 01724 (CASHPRO ONLINE PDR ITEM)AFP400272 01743 (CASHPRO ONLINE CDR ACCOUNT)AFP400055 01744 (CASHPRO ONLINE CDR ITEM)AFP400275 08529 (ELEC WIRE OUT-DOMESTIC)AFP350103 17554 (CASHPRO CONNECT PMTS PER ITEM)AFP330020 17555 (CASHPRO CONNECT PMTS PER FILE)AFP330010 19525 (CASHPRO CONNECT PMTS MAINT)AFP330000 19761 (ACH BLOCKS AUTH INSTRUCTIONS)AFP251057 20365 (CASHPRO GP CUST MNT TMPLT STRG)AFP350551 44332 (CASHPRO IMAGE SUBSCRIPTION)AFP151350 45042 (ACH MONTHLY MAINTENANCE)AFP250000 45076 (ACH BLOCKS AUTH MAINTENANCE)AFP251050 82003 (DEBITS POSTED-OTHER)AFP010100 82004 (CREDITS POSTED-OTHER)AFP010101 99970 (EDI SERVICES CR ADJ)AFP999999 

[BulentD]

Hi Narendar,

If bank service mapping for the service is maintained in app “Manage Banks” and the EoD bank statements for the bank service mapping was imported into the correct period then, the volume will be retrieved from the bank statements (number of lines which has the external transaction codes for the service charges&fees such as CHG-)

[NarendarsaptrM]

Thanks for your response BulentD,
I am getting below error message while maintaining the external codes in "Manage Banks" under the tab Bank Service Mapping.
Transaction type 40000200, external transaction FEE assigned to service 40000200FCLM_BAM_MAINT2/036.In OT83 we just created as below 

,
Can you please guide me how to proceed further , SAP Replied we need to check our self as it is custom transfermation. 

[BulentD]

Hi Narendar,

You do not need to create new external transaction codes in OT83 but assign the ones to the banks which correspond to the bank fees. Let's say "MSC" and "NCHG" are bank service&charge related external transaction types for Payment Transaction Type Group "MT940". In that case, you should do the mapping as below: 

After the mapping above and the EoD bank statements were imported, system will count the number of transactions with the MSC&NCHG external codes within the bank statements and calculate the volume.

For example, if you have the below bank statement imported then the volume will be calculated as "3":

Hope this helps..

Bulent

[NarendarsaptrM]

Dear BulentD,

Thanks for your reply. When you talk about "the EoD bank statement," I assume you are referring to current day or prior day files. Actually, we are not using MT940; we are using CAMT.053. I did not see those codes.

Here is the example. Do I need to maintain different codes?

[BulentD]

I am referring to all the bank statements that were imported in the period in which you are monitoring your bank fees. For camt.053, bank codes are within the <BkTxCd> tag and have values like "COMM" for Comissions etc.