Table Name for Search term

[Former Member]

Hello,

Need to know table name for search term 2 in vendor master data ( general data)

Field name is SORT2. need to know when i enter some term let say test in search term 2 of vendor master data, where its going to hit in table.

Thanks

Himanshu

[Former Member · Accepted solution]

Hi

Pass the vendor into LFA1 table ,Take the Address number field(ADRNR) from the LFA1 Table and go to ADRC table , pass the address number into ADDRNUMBER field and fetch the Search Term2 field

Regards

Amuthan M

[Former Member · Accepted solution]

Hello,

My main issue is i need to use search term 2 for some transactions.

lets say for one customize transaction z123 i am using search term 1(vendor master) already and now i want to use search term 2 also.

This z123 is let say vendor report transcation, so when i get venor details now there must be search term 2 column also in report.

Now i need to find out link between vendor number and table adrc so that i can tell abap person to do developement.

Thanks

Himanshu

[JL23 · Accepted solution]

use vendor master field LFA1-ADRNR to find the corresponding address record in table field ADRC-ADDRNUMBER

[JL23]

table ADRC