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

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ SD-SLS (Application Component) Sales
     ⤷ ERP_SALES_PORTAL (Package) ERP Sales Portal Roles

Basic Data

Table Category	INTTAB	Structure
Structure	SERPSLS_CUSTOMER	Table Relationship Diagram
Short Description	Customer Master Data: SD Area and Address Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
3	VKORG	☐	VKORG	VKORG	CHAR	4	0	Sales Organization	TVKO
4	VTWEG	☐	VTWEG	VTWEG	CHAR	2	0	Distribution Channel	TVTW
5	SPART	☐	SPART	SPART	CHAR	2	0	Division	TSPA
6	VKBUR	☐	VKBUR	VKBUR	CHAR	4	0	Sales office	TVBUR
7	VKGRP	☐	VKGRP	VKGRP	CHAR	3	0	Sales group	TVKGR
8	MCOD1	☐	MCDD1	CHAR25	CHAR	25	0	Search term for matchcode search
9	MCOD3	☐	MCDD3	CHAR25	CHAR	25	0	Search term for matchcode search
10	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
11	NAME	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
12	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
13	STREET_NO	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
14	PCODE	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
15	CITY	☐	ORT01_GP	TEXT35	CHAR	35	0	City
16	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
17	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
18	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
19	AUFSDZ	☐	AUFSD_X	KAUFS	CHAR	2	0	Central order block for customer	*
20	AUFSDV	☐	AUFSD_V	KAUFS	CHAR	2	0	Customer order block (sales area)	*
21	LIFSDZ	☐	LIFSD_X	LIFSP	CHAR	2	0	Central delivery block for the customer	*
22	LIFSDV	☐	LIFSD_V	LIFSP	CHAR	2	0	Customer delivery block (sales area)	*
23	FAKSDZ	☐	FAKSD_X	FAKSP	CHAR	2	0	Central billing block for customer	*
24	FAKSDV	☐	FAKSD_V	FAKSP	CHAR	2	0	Billing block for customer (sales and distribution)	*
25	LOEVMZ	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
26	LOEVMV	☐	LOEVM_V	XFELD	CHAR	1	0	Deletion flag for customer (sales level)
27	NODEL	☐	NODEL_X	XFELD	CHAR	1	0	Central deletion block for master record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SERPSLS_CUSTOMER	KUNNR	KNA1	KUNNR
2	SERPSLS_CUSTOMER	SPART	TSPA	SPART
3	SERPSLS_CUSTOMER	VKBUR	TVBUR	VKBUR
4	SERPSLS_CUSTOMER	VKGRP	TVKGR	VKGRP
5	SERPSLS_CUSTOMER	VKORG	TVKO	VKORG
6	SERPSLS_CUSTOMER	VTWEG	TVTW	VTWEG

History

Last changed by/on	SAP	20110901
SAP Release Created in	500