Regarding customer master table

[former_member307532]

Hi Friends,

we have one report which shows the sold to party's details. now our requirement is we need to add two columns(Search term 1/2) in that report.search term 1/2 details which we maintain in the custmer master needs to appear in that report. there are two boxes for the search term 1/2 filed in customer master. but in KNA1 table only one box is appearing. Is there any other table for customer master general data view which shows the two boxes details of search term field, so then our technical team will add the search tearm two columns in the report as per that table.

kindly help me on this.

Thanks & Regards,

Jai Prabhu.

[former_member182378 · Accepted solution]

Jai,

Both fields (Search 1/2) can be got from table ADRC.

Please read the post by Nick Young in below link

http://scn.sap.com/thread/648780

Explanation:

In order to get the value of field "Search term 2", you have to

1. go to KNA1, give KUNNR and fetch ADRNR

2. then go to ADRC, give KNA1-ADRNR in field ADRC-ADDRNUMBER and fetch SORT2 (field Search term 2)