Select from T012k Table based on Bank Account

[Former Member]

HI All,

We have a requirment where in we are selecting data from T012k Table based on Bank Account no.The bank accnt no is given through a flat file which is of length 10.But in the table T012K its 12. So how can i select the data comparing the bank accnt no in the flat file and the accnt no in db table.we need to select data based on the 10 digit bank accnt no of flat file.

Thanks,

Rakesh.

[Former Member]

Hi,

Try this..

Call the function module CONVERSION_EXIT_ALPHA_INPUT with your flat file value..to put zeroes in front..

Then with that value use it in the select statement.

Thanks,

Naren

[Former Member]

I cant append Zeros..since the account no may not have zeros in the first 2 digits...

[Former Member]

hi,

make use of Fm CONVERSION_EXIT_ALPHA_INPUT to place leading zero's

[Former Member]

Here is a sample data:

BANKN in T012k = 6301545822509.

BANKN in Flat file = 1545822509.

[Former Member]

Hi ,

use like this :

concatenate 'XXX' itab_ffile-accno into acc_no. " replace X with ur desired char.'630' in ur case

Jogdand M B

Message was edited by:

Jogdand M B

[dev_parbutteea]

Hi,

either your test data is wrong meaning that you should be getting Bank Account no of lenght 12.

Or 1545822509 means 0001545822509.

Regards,

Sooness.