SAP Table VENDOR_FIND
Search Parameters for Vendor Master Records
VENDOR_FIND (Search Parameters for Vendor Master Records) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link VENDOR_FIND to other SAP tables.
VENDOR_FIND table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MC_NAME | Name (field NAME1) in upper case for matchcode | AD_MC_NAME | CHAR | 25 | 0 | |||
| SORT1 | Search Term 1 | AD_SORT1 | CHAR | 20 | 0 | |||
| SORT2 | Search Term 2 | AD_SORT2 | CHAR | 20 | 0 | |||
| MC_CITY1 | City name in upper case for search help | AD_MC_CITY | CHAR | 25 | 0 | |||
| POST_CODE1 | City postal code | AD_PSTCD1 | CHAR | 10 | 0 | |||
| MC_STREET | Street name in upper case for search help | AD_MC_STRT | CHAR | 25 | 0 | |||
| HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | 0 | |||
| COUNTRY | Country Key | LAND1 | CHAR | 3 | 0 | |||
| REGION | Region (State, Province, County) | REGIO | CHAR | 3 | 0 | |||
| NAME1_LNG | Name 1 | AD_NAME1 | CHAR | 40 | 0 | |||
| CITY1_LNG | City | AD_CITY1 | CHAR | 40 | 0 | |||
| STREET_LNG | Street | AD_STREET | CHAR | 60 | 0 | |||
