1. Home
  2. Resources
  3. SAP Tables
  4. SERPSLS_CUSTOMER - Customer Master Data: SD Area and Address Data

SAP Table SERPSLS_CUSTOMER

Customer Master Data: SD Area and Address Data

SERPSLS_CUSTOMER (Customer Master Data: SD Area and Address Data) 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 SERPSLS_CUSTOMER to other SAP tables.

SERPSLS_CUSTOMER table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
KUNNR Customer Number KUNNR KNA1 CHAR 10 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW CHAR 2 0
SPART Division SPART TSPA CHAR 2 0
VKBUR Sales Office VKBUR TVBUR CHAR 4 0
VKGRP Sales Group VKGRP TVKGR CHAR 3 0
MCOD1 Search term for matchcode search MCDD1 CHAR 25 0
MCOD3 Search term for matchcode search MCDD3 CHAR 25 0
SORTL Sort field SORTL CHAR 10 0
NAME Name 1 NAME1_GP CHAR 35 0
STREET Street AD_STREET CHAR 60 0
STREET_NO House Number AD_HSNM1 CHAR 10 0
PCODE Postal Code PSTLZ CHAR 10 0
CITY City ORT01_GP CHAR 35 0
COUNTRY Country Key LAND1_GP CHAR 3 0
REGION Region (State, Province, County) REGIO CHAR 3 0
TELF1 First telephone number TELF1 CHAR 16 0
AUFSDZ Central order block for customer AUFSD_X CHAR 2 0
AUFSDV Customer order block (sales area) AUFSD_V CHAR 2 0
LIFSDZ Central delivery block for the customer LIFSD_X CHAR 2 0
LIFSDV Customer delivery block (sales area) LIFSD_V CHAR 2 0
FAKSDZ Central billing block for customer FAKSD_X CHAR 2 0
FAKSDV Billing block for customer (sales and distribution) FAKSD_V CHAR 2 0
LOEVMZ Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
LOEVMV Deletion flag for customer (sales level) LOEVM_V CHAR 1 0
X Yes
NULL No
NODEL Central deletion block for master record NODEL_X CHAR 1 0
X Yes
NULL No

SERPSLS_CUSTOMER foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
SERPSLS_CUSTOMER KUNNR SERPSLS_CUSTOMER MANDT KNA1 General Data in Customer Master MANDT
SERPSLS_CUSTOMER KUNNR SERPSLS_CUSTOMER KUNNR KNA1 General Data in Customer Master KUNNR
SERPSLS_CUSTOMER SPART SERPSLS_CUSTOMER MANDT TSPA Organizational Unit: Sales Divisions MANDT
SERPSLS_CUSTOMER SPART SERPSLS_CUSTOMER SPART TSPA Organizational Unit: Sales Divisions SPART
SERPSLS_CUSTOMER VKBUR SERPSLS_CUSTOMER MANDT TVBUR Organizational Unit: Sales Offices MANDT
SERPSLS_CUSTOMER VKBUR SERPSLS_CUSTOMER VKBUR TVBUR Organizational Unit: Sales Offices VKBUR
SERPSLS_CUSTOMER VKGRP SERPSLS_CUSTOMER MANDT TVKGR Organizational Unit: Sales Groups MANDT
SERPSLS_CUSTOMER VKGRP SERPSLS_CUSTOMER VKGRP TVKGR Organizational Unit: Sales Groups VKGRP
SERPSLS_CUSTOMER VKORG SERPSLS_CUSTOMER MANDT TVKO Organizational Unit: Sales Organizations MANDT
SERPSLS_CUSTOMER VKORG SERPSLS_CUSTOMER VKORG TVKO Organizational Unit: Sales Organizations VKORG
SERPSLS_CUSTOMER VTWEG SERPSLS_CUSTOMER MANDT TVTW Organizational Unit: Distribution Channels MANDT
SERPSLS_CUSTOMER VTWEG SERPSLS_CUSTOMER VTWEG TVTW Organizational Unit: Distribution Channels VTWEG