topic Re: illegal join condition in Application Development and Automation Discussions

illegal join condition

Former Member — Thu, 20 Mar 2014 09:23:03 GMT

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

Re: illegal join condition

Former Member — Thu, 20 Mar 2014 09:42:12 GMT

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

Re: illegal join condition

former_member302911 — Thu, 20 Mar 2014 10:14:05 GMT

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

You need to manage data through a Routine.

Regards,

Angelo.

Re: illegal join condition

former_member227685 — Thu, 20 Mar 2014 10:22:24 GMT

This message was moderated.