1. Home
  2. Resources
  3. SAP Tables
  4. CUSTOMER_FOUND - Results Table for Customer Master Record Search

SAP Table CUSTOMER_FOUND

Results Table for Customer Master Record Search

CUSTOMER_FOUND (Results Table for Customer Master Record Search) 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 CUSTOMER_FOUND to other SAP tables.

CUSTOMER_FOUND table fields

Field Data element Checktable Datatype Length Decimals
ADDR_TYPE Addresses: Address type ADDR_TYPE CHAR 1 0
P Private address
C Business address
KUNNR Customer Number KUNNR CHAR 10 0
PARNR Number of contact person PARNR NUMC 10 0
NAME Name 1 AD_NAME1 CHAR 40 0
FIRSTNAME First name AD_NAMEFIR CHAR 40 0
STREET Street AD_STREET CHAR 60 0
CITY1 City AD_CITY1 CHAR 40 0
MC_NAME Name (field NAME1) in upper case for matchcode AD_MC_NAME CHAR 25 0
MC_FIRSTNAME First name in upper case for search help AD_MC_NMFI 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
NAME_L_LNG Last name AD_NAMELAS CHAR 40 0
NAME_F_LNG First name AD_NAMEFIR CHAR 40 0
CITY1_LNG City AD_CITY1 CHAR 40 0
STREET_LNG Street AD_STREET CHAR 60 0
POST_CODE2 PO Box Postal Code AD_PSTCD2 CHAR 10 0
PO_BOX PO Box AD_POBX CHAR 10 0