Electronic Bank Format CAMT.053 specific to Germany

[Former Member]

Hi, I am new to a German project where the earlier format DTAUS0 is getting replaced by CAMT.053.  I was trying to maintain the external transaction codes in customizing settings and OT83,  but unable to find the relevant values for transactions.  I have the GVC codes with me and please let me know how to derive the transactions out of it.  Or should I use a different approach.

Please help.

[former_member49722]

Hi Raj,

you have todo some steps:

1. Create Account Symbols

    for example "Bank" and "Costs"

2. Assign Accounts to Account Symbol

    for example "Bank"=10000, "Costs"=20000

3. Create Keys for Posting Rules

    for example rule "0001" Bank and Costs

4. Define Posting Rules

Pstg Rule PosAr PK SG Acct symbol   Comp.ind. PK SG Acct symbol   Comp.ind. Doc. Type PstTy

0001      1           BANK           50    COSTS                    BB        4

5. Create Transaction Type

6. Assign External Transaction Types to Posting Rules

TransTyp ExtT +- Name Pst. rule Int algthm

V00001   001  -       0001              13

7. Assign Bank Accounts to Transaction Types

Bank Key Bank acct  TransTyp

55555555 999999999   V00001

For more automation you can use also OTPM and an include ZXF01U01

The CVC's are from

EBICS.DE: DFÜ-Abkommen Anlage 3 (Formatstandards)

I hope that will help.

Thomas

[Former Member]

Thanks Thomas. 

But here my question is what are the values of 'External transaction types'?  I am not able to get this information.

[former_member49722]

Hi Raj,

can you give me some more details pls.

Do you mean the Business Transaction Codes?

8.2.6 Business Transaction Codes (GVC) (page 492) in the english version.

Best regards

Thomas

[Former Member]

Hi Thomas,

I am trying to find out the values for 'Bank Transaction Code' which is populated in <BkTxCd><Prtry><Cd> in the XML.  In the document you have shared I saw below information(page 414).

The code comprises the following components that are set up as a string each component being linked to the next by a “+”:

1. Four-digit SWIFT transaction code

2. Business transaction code (GVC)

3. Optional: prima nota number (10 digits maximum)

4. DTA text key supplement, if displayable

Examples: <Cd>NDDT+109+9002/405+901</Cd> Example for a SEPA direct debit

So here, GVC is there in the document you have given.  What about the other values. 

[former_member49722 · Accepted solution]

Hi Raj,

in your example the GVC is 109 as discribed.

This GVC is exact the same from page 492.

The other values are optional and depends on each bank, so maybe different.

For the OT83 number 2. Bisiness Transaction code should be enough.

Best regards

Thomas

[Former Member]

Thanks Thomas.

We don't have full clarity on what Bank is going to send.  So as of now I will proceed with GVC.

[former_member49722]

Hi Raj,

thats correct to use the GVC's.

There are no differences between MT940 and CAMT.

The business transaction codes from

8.2.6 Business Transaction Codes (GVC) from DFÜ Agreement (Appendix 3: Specification of Data Formats) are obligatory for each German Bank.

That means the business process behind GVC 109 is the same at all banks.

- 109 SEPA Direct Debit (debit; reversal debit, Core)

So all codes here have to use from all banks.

Best regards

Thomas

[Former Member]

Hi Thomas,

Thanks for your help.

One more query.  How do we retrieve this 3 digit GVC code then.  Since other values are optional which may or may not come.  How to differentiate them and read only this GVC code.

[former_member49722]

Hi Raj,

when you import the camt.053 via ff.5 the GVC will be save in FEBEP-VGEXT.

This 3 digit GVC code is included in the bank statement in camt.053 format. The GVC is obligatory.

You must assign the posting rules to the GVC codes on behalf of your business needs.

The SAP standard transformation for camt will map the camt.053 file from your bank automatically, but only if the file meet the requirement of the CGI Initiative (https://www.swift.com/cgi).

Its based on ISO20022 standard and is valid worldwide.

Transformation for camt.053 (note 1729745) and camt.054 (note 1729746)

If your bank dosn't provide the bank statement CGI conform you must adjust the transformation for camt.053 which is not so easy.

Best regards

Thomas