illegal join condition

[Former Member]

Hi ,

I have created Infoset using two Table TIBAN and LFBK .

Now the common field between the two tables in BANKN.

The length of BANKN from LFBK table is 18 char and the length of BANKN from TIBAN is of 35 char.

Due to length mismatch I am unable to join.

Any input on the above issue will be of great help .

If anyone has worked on creating infoset in SAP R3 system then please provide some input.

Regards,

Anjali Singh

[Former Member]

Hi,

I'm no expert on infosets, but the format change between the 18 character bank account number in LFBK and the 35 character number in TIBAN is done by function module CONVERT_BANK_ACCOUNT_NUMBER.

I would also point out that the account number alone does not represent a unique relationship, the country and back key are also necessary.

Regards,

Nick

[former_member302911]

In Infoset unfortunately you can't connect two field with different lenght.

You need to manage data through a Routine.

Regards,

Angelo.

[former_member227685]

This message was moderated.