cancel
Showing results for 
Search instead for 
Did you mean: 

Enter Long Bank Account number for China in Vendor Master

Former Member
0 Kudos

Hi,

We have vendors in China who supplied us with their 34 digit Bank account. Since the Bank account (LFBK-BANKN) field in Vendor master can only take 18 digits, how to accomodate complete bank account number.

Once Vendor master is fixed, how to get the data in Payment File (via F110).

Thanks,

Mbm

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member

In general in standard SAP the maximum length of the field "Bank account number" is 18. In case you need to enter more than 18chars of "Bank account number" as is the case with China etc then you can follow the procedure as mentioned in note 1585003.


1585003 - How to enter a long account number

A long account number can be subdivided into the basic part (18 characters) and the remaining characters part, hard-coded in the conversion modules (example: Russia, China, Poland).

Example:

CN - China

First 18 positions into the field Account Number, the remaining positions into the field Reference. No general rules for bank number usage. The SWIFT code can be used as the SAP Bank Key.

Examples:

Bank account number: 31014005000220005842
SAP:
Account Number: 310140050002200058
Reference: 42

Bank account number: NRA 622 202 040 800 391 9953
SAP:
Account Number: 622202040800391995
Reference: 3
(the code NRA stands for 'non-resident alien' and should not be necessary for the payment)

For you information purposes, here is a more detailed explanation:

This field is represented by data element BANKN which is defined as CHAR18 and this is part of many databases in the whole Financials and it's also database key. Extension of any database key field is very complicated because all stored data must be converted. This has to be done for all tables using data element BANKN as database key field as well.

You may also refer note:

96624 - DME for bank account numbers with more than 18 digits

115002 - DME for house bank account numbers w/more than 18 digits

Regards,

Sonal Chaudhary

Former Member
0 Kudos

Thank you to Everyone for your advise. It is highly appreciated.

Former Member
0 Kudos

HI please use the t code OY17 ..

Former Member
0 Kudos

Thanks Gaurav & Shekhar,

If i understand correctly:

I have to break Account numbers in Account Field and Reference field.

I would also have to create new Events 3070 and 3080, which would be called at the time of creating the DME file via F110, and the system would concatenate the bank account

number? 

thanks!

Former Member
0 Kudos

Yes mbm

You need to distribute the account number in both the fields. Maintain maximum length in bank number field and additional digits in the reference field. The total account number will be picked up when you run the payment run program.

Regards

Phani

Former Member
0 Kudos

Yes, please take a look at the Example 2 of SAP Note 1037617. Best Regards Zidane

Former Member
0 Kudos

Hi,

Please check this link.

http://scn.sap.com/thread/3383760

Regards,

Gaurav

Former Member
0 Kudos

This can be achieved using the BTE in Transaction FIBF, product ZBNKREF with event 3070 and 3080 function module ZBKK_3070_ACC_AND_BKONT and ZBKK_3080_ACC_AND_BKONT. Please check the relevant sap notes. Also check the above thread.

Regards

Shekhar