SAP table SERPSLS_CUSTOMER (Customer Master Data: SD Area and Address Data)

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

SERPSLS_CUSTOMER foreign key relationships

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