table to find Search term 2 of customer master ?

[Former Member]

Hi,

In which table do i find serach term2 of customer master?

Rgds

Praveen

[Former Member]

KNA1-MCOD2?

Thanks,

SKJ

[former_member181962]

KNA1 field MCOD2

Regards,

ravi

[ferry_lianto]

Hi,

Please check table KNA1-MCOD2 or view V_KNA1_CORE-MCOD2.

Regards,

Ferry Lianto

[Former Member]

Hi,

MCOD2 is name2.

I need search term 2.

Rgds

Praveen

[former_member181962]

NAME2 is name2, MCOD2 is Search Terms 2.

If you consider SORTL as the Search term 1, then MCOD1 will be your search term2.

Regards,

Ravi

[Former Member]

ravi,

I want to extract ADDR1_DATA-SORT2 whic is search 2 from my customer master.

I searched KNA1 for all the mentioned fields NAME1,NAME2,MCOD1,MCOD2.

unfortunately I did not see my record.

Any ideas?

rgds

Praveen

[former_member181962]

YOu need to get the address number from KNA1 table.

KNA1-ADRNR.

ANd pass it to ADRC table to field ADDRNUMBER.

The you can get the seeach term in ADRC-SORT2.

Regards,

Ravi

[ferry_lianto]

Hi,

Please check table ADRC and field SORT2.

Regards,

Ferry Lianto

[Former Member]

Thank you very much.

Problem solved it is ADRC-SORT2.

I awarded points:-)

Rgrds

Praveen

[former_member1092107]

ADRC is the correct table