SAP ABAP Table ESALES_SETTYPE_SERVLOC (Set Type: Premise)

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS-CRM (Application Component) Integration: Customer Relationship Management
     ⤷ EE_SALES (Package) IS-U Sales Processing

Basic Data

Table Category	INTTAB	Structure
Structure	ESALES_SETTYPE_SERVLOC	Table Relationship Diagram
Short Description	Set Type: Premise

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	.INCLUDE	☐				0	0	Premise
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VSTELLE	☐	VSTELLE	VSTELLE	CHAR	10	0	Premise	*
4	HAUS	☐	HAUS	TPLNR	CHAR	30	0	Connection Object	*
5	STR_ERG2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
6	HAUS_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
7	TXTLANGU	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
8	LGZUSATZ	☐	LGZUSATZ	LGZUSATZ	CHAR	40	0	Additional Information on Location
9	VBSART	☐	VBSART	VBSART	CHAR	8	0	Type of premise	TE102
10	EIGENT	☐	E_GPARTNER	BU_PARTNER	CHAR	10	0	Owner	BUT000
11	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
12	TPLNUMMER	☐	TPLNUMMER	TPLNR	CHAR	30	0	Number of functional location	IFLOT
13	.INCLUDE	☐				0	0	Creation and Change Data (Author, Group and Deletion Flag)
14	.INCLUDE	☐				0	0	Creation and Change Data
15	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
16	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
17	AEDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
18	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
19	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
20	LOEVM	☐	LOEVM	XFELD	CHAR	1	0	Deletion Indicator
21	ANZPERS	☐	ANZ_PERS	ANZ_PERS	NUMC	3	0	Number of persons
22	FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
23	ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
24	HPTWHNSITZ	☐	MAINRESI	KENNZX	CHAR	1	0	Main residence
25	STR_ERG4	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
26	.INCLUDE	☐				0	0
27	.INCLU-C	☐				0	0	Connect. Obj.
28	.INCLUDE	☐				0	0	Connection Object Without Customer Include
29	MANDTC	☐	MANDT	MANDT	CLNT	3	0	Client	*
30	HAUSC	☐	HAUS	TPLNR	CHAR	30	0	Connection Object	*
31	SPRASC	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
32	PLTXTC	☐	PLTXT	TEXT40	CHAR	40	0	Description of functional location
33	KZLTXC	☐	KZLTX	XFELD	CHAR	1	0	Indicator: More long text exists
34	TPLKZC	☐	TPLKZ	TPLKZ	CHAR	5	0	Functional location structure indicators	*
35	FLTYPC	☐	FLTYP	FLTYP	CHAR	1	0	Functional Location Category	*
36	TPLMAC	☐	TPLMA	TPLNR	CHAR	30	0	Superior functional location	*
37	DATABC	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
38	BEGRUC	☐	IAUTG	IAUTG	CHAR	4	0	Authorization Group for Technical Object	T370B
39	EINZLIC	☐	INH_BEGRUI	INHER	CHAR	1	0	Data origin for authorization group field
40	IWERKC	☐	IWERK	WERKS	CHAR	4	0	Maintenance Planning Plant	*
41	IWERKIC	☐	INH_IWERKI	INHER	CHAR	1	0	Data origin for planning plant field
42	POSNRC	☐	ILOM_POSNR	CHAR4	CHAR	4	0	Position in superior technical object
43	ISTYPC	☐	ILOM_ISTYP	ILOM_ISTYP	CHAR	1	0	Object category for Industry Solutions (IS)
44	PREMSC	☐	ILOM_PREMS	CHAR10	CHAR	10	0	Premise
45	EQFNRC	☐	EQFNR	CHAR30	CHAR	30	0	Sort Field
46	SWERKC	☐	SWERK	WERKS	CHAR	4	0	Maintenance Plant	T001W
47	SWERKIC	☐	INH_SWERKI	INHER	CHAR	1	0	Data origin for maintenance plant field
48	BUKRSC	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
49	BUKRSIC	☐	INH_BUKRSI	INHER	CHAR	1	0	Data origin for company code field
50	ADDRNUMBERC	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
51	ADRNRIC	☐	INH_ADRNRI	INHER	CHAR	1	0	Data origin for address field
52	LVORMC	☐	LVORM	XFELD	CHAR	1	0	Deletion Indicator
53	ILOANC	☐	ILOAN	ILOAN	CHAR	12	0	Location and account assignment for technical object	*
54	IEQUIC	☐	IEQUI	X	CHAR	1	0	Installation of equipment allowed at the functional location
55	IEQUIIC	☐	INH_IEQUII	INHER	CHAR	1	0	Data origin for equip. inst. allowed field
56	COUNCC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
57	REGIOGROUPC	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
58	REGPOLITC	☐	REGPOLIT	REGPOLIT	CHAR	8	0	Political regional structure element	TE227
59	REGIOGROUP_PERMC	☐	REGIOGROUP_PERMIT	REGIOGROUP	CHAR	8	0	Regional structure group for supply permit processing	ADRREGGRP
60	OBJNRC	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
61	ERDATC	☐	ICRDT	DATUM	DATS	8	0	Date on Which Object Was Created
62	ERNAMC	☐	ICRNA	USNAM	CHAR	12	0	Name of User Who Created the Object
63	AEDATC	☐	IUPDT	DATUM	DATS	8	0	Date on which the object was last changed
64	AENAMC	☐	IUPNA	USNAM	CHAR	12	0	Name of the User Who Last Changed the Object
65	CRM_GUIDC	☐	EHAU_GUID	SYSUUID	RAW	16	0	CRM GUID of Connection Object
66	STRNOC	☐	AO_STRNO	ILOM_STRNO	CHAR	40	0	Connection Object Identification
67	.INCLUDE	☐				0	0
68	.INCLU-A	☐				0	0	Include structure with ADRC attributes without name fields
69	NAME_COA	☐	AD_NAME_CO	TEXT40	CHAR	40	0	c/o name
70	CITY1A	☐	AD_CITY1	TEXT40	CHAR	40	0	City
71	CITY2A	☐	AD_CITY2	TEXT40	CHAR	40	0	District
72	CITY_CODEA	☐	AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	ADRCITY
73	CITYP_CODEA	☐	AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	ADRCITYPRT
74	HOME_CITYA	☐	AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
75	CITYH_CODEA	☐	AD_CITYHNM	CITY_CODE	CHAR	12	0	Different city for city/street file	ADRCITY
76	CHCKSTATUSA	☐	AD_CHECKST	AD_CHECKST	CHAR	1	0	City file test status
77	REGIOGROUPA	☐	REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	ADRREGGRP
78	POST_CODE1A	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
79	POST_CODE2A	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
80	POST_CODE3A	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
81	PCODE1_EXTA	☐	AD_PST1XT	CHAR10	CHAR	10	0	(Not Supported)City Postal Code Extension, e.g. ZIP+4+2 Code
82	PCODE2_EXTA	☐	AD_PST2XT	CHAR10	CHAR	10	0	(Not Supported) PO Box Postal Code Extension
83	PCODE3_EXTA	☐	AD_PST3XT	CHAR10	CHAR	10	0	(Not Supported) Major Customer Postal Code Extension
84	PO_BOXA	☐	AD_POBX	CHAR10	CHAR	10	0	PO Box
85	DONT_USE_PA	☐	AD_NO_USEP	AD_NO_USE	CHAR	4	0	PO Box Address Undeliverable Flag	TSAD12
86	PO_BOX_NUMA	☐	AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
87	PO_BOX_LOCA	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
88	CITY_CODE2A	☐	AD_CIT2NUM	CITY_CODE	CHAR	12	0	City PO box code (City file)	ADRCITY
89	PO_BOX_REGA	☐	AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	T005S
90	PO_BOX_CTYA	☐	AD_POBXCTY	LAND1	CHAR	3	0	PO box country	T005
91	POSTALAREAA	☐	AD_PSTLAR	TEXT15	CHAR	15	0	(Not Supported) Post Delivery District
92	TRANSPZONEA	☐	LZONE	ZONE	CHAR	10	0	Transportation zone to or from which the goods are delivered	TZONE
93	STREETA	☐	AD_STREET	TEXT60	CHAR	60	0	Street
94	DONT_USE_SA	☐	AD_NO_USES	AD_NO_USE	CHAR	4	0	Street Address Undeliverable Flag	TSAD12
95	STREETCODEA	☐	AD_STRNUM	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
96	STREETABBRA	☐	AD_STRABBR	STRTYPEAB	CHAR	2	0	(Not Supported) Abbreviation of Street Name	ADRSTRTYPE
97	HOUSE_NUM1A	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
98	HOUSE_NUM2A	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
99	HOUSE_NUM3A	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
100	STR_SUPPL1A	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
101	STR_SUPPL2A	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
102	STR_SUPPL3A	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
103	LOCATIONA	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
104	BUILDINGA	☐	AD_BLDNG	TEXT20	CHAR	20	0	Building (Number or Code)
105	FLOORA	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
106	ROOMNUMBERA	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
107	COUNTRYA	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
108	LANGUA	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
109	REGIONA	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
110	SORT1A	☐	AD_SORT1UL	TEXT20	CHAR	20	0	Search Term 1
111	SORT2A	☐	AD_SORT2UL	TEXT20	CHAR	20	0	Search Term 2
112	SORT_PHNA	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
113	ADDRORIGINA	☐	AD_ORIGINA	AD_ORIGIN	CHAR	4	0	(Not Supported) Address Data Source (Key)	TSAD6
114	EXTENSION1A	☐	AD_EXTENS1	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. data line)
115	EXTENSION2A	☐	AD_EXTENS2	TEXT40	CHAR	40	0	Extension (only for data conversion) (e.g. telebox)
116	TIME_ZONEA	☐	AD_TZONE	TZNZONE	CHAR	6	0	Address time zone	TTZZ
117	TAXJURCODEA	☐	AD_TXJCD	AD_TXJCD	CHAR	15	0	Tax Jurisdiction
118	ADDRESS_IDA	☐	AD_ADDR_ID	AD_ADDR_ID	CHAR	10	0	(Not supported) Physical address ID
119	REMARKA	☐	AD_REMARK1	TEXT50	CHAR	50	0	Address notes
120	LANGU_CREAA	☐	AD_LANGUCR	SPRAS	LANG	1	0	Address record creation original language	T002
121	PO_BOX_LOBBYA	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
122	DELI_SERV_TYPEA	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service	ADDRC_DELI_SERV
123	DELI_SERV_NUMBERA	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
124	COUNTY_CODEA	☐	AD_CNTYNUM	CNTY_CODE	CHAR	8	0	County code for county	ADRCOUNTY
125	COUNTYA	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
126	TOWNSHIP_CODEA	☐	AD_TWSHPNUM	TWSHP_CODE	CHAR	8	0	Township code for Township	ADRTOWNSHIP
127	TOWNSHIPA	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
128	DISTRIBUTOR	☐	SERVICE_PROV_DIST	SERVICE_PROV	CHAR	10	0	Service Provider that Acts as Distributor	*
129	.INCLU-I	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ESALES_SETTYPE_SERVLOC	ADDRORIGINA	TSAD6	ORIGIN	REF	C	CN
2	ESALES_SETTYPE_SERVLOC	BEGRUC	T370B	BEGRU	REF	C	CN
3	ESALES_SETTYPE_SERVLOC	CITYH_CODEA	ADRCITY	CITY_CODE	REF	C	CN
4	ESALES_SETTYPE_SERVLOC	CITYP_CODEA	ADRCITYPRT	CITYP_CODE	REF	C	CN
5	ESALES_SETTYPE_SERVLOC	CITY_CODE2A	ADRCITY	CITY_CODE	REF	C	CN
6	ESALES_SETTYPE_SERVLOC	CITY_CODEA	ADRCITY	CITY_CODE	REF	C	CN
7	ESALES_SETTYPE_SERVLOC	COUNCC	T005E	COUNC
8	ESALES_SETTYPE_SERVLOC	COUNTRYA	T005	LAND1	REF	C	CN
9	ESALES_SETTYPE_SERVLOC	COUNTY_CODEA	ADRCOUNTY	COUNTY_CODE	REF	C	CN
10	ESALES_SETTYPE_SERVLOC	DELI_SERV_TYPEA	ADDRC_DELI_SERV	DELI_SERV_TYPE		1	CN
11	ESALES_SETTYPE_SERVLOC	DONT_USE_PA	TSAD12	UNDELIVER	KEY	C	CN
12	ESALES_SETTYPE_SERVLOC	DONT_USE_SA	TSAD12	UNDELIVER	KEY	C	CN
13	ESALES_SETTYPE_SERVLOC	EIGENT	BUT000	PARTNER
14	ESALES_SETTYPE_SERVLOC	LANGUA	T002	SPRAS	REF	C	CN
15	ESALES_SETTYPE_SERVLOC	LANGU_CREAA	T002	SPRAS	REF	C	CN
16	ESALES_SETTYPE_SERVLOC	MANDT	T000	MANDT	KEY
17	ESALES_SETTYPE_SERVLOC	OBJNR	ONR00	OBJNR	KEY
18	ESALES_SETTYPE_SERVLOC	PO_BOX_CTYA	T005	LAND1	REF	C	CN
19	ESALES_SETTYPE_SERVLOC	PO_BOX_REGA	T005S	BLAND	REF	C	CN
20	ESALES_SETTYPE_SERVLOC	REGIOGROUPA	ADRREGGRP	REGIOGROUP	REF	C	CN
21	ESALES_SETTYPE_SERVLOC	REGIOGROUPC	ADRREGGRP	REGIOGROUP	REF	C	CN
22	ESALES_SETTYPE_SERVLOC	REGIOGROUP_PERMC	ADRREGGRP	REGIOGROUP	REF	C	CN
23	ESALES_SETTYPE_SERVLOC	REGIONA	T005S	BLAND	REF	C	CN
24	ESALES_SETTYPE_SERVLOC	REGPOLITC	TE227	REGPOLIT	REF	C	CN
25	ESALES_SETTYPE_SERVLOC	STREETABBRA	ADRSTRTYPE	STRTYPEAB	REF	C	CN
26	ESALES_SETTYPE_SERVLOC	STREETCODEA	ADRSTREET	STRT_CODE	REF	C	CN
27	ESALES_SETTYPE_SERVLOC	SWERKC	T001W	WERKS	REF	1	CN
28	ESALES_SETTYPE_SERVLOC	TIME_ZONEA	TTZZ	TZONE	REF	C	CN
29	ESALES_SETTYPE_SERVLOC	TOWNSHIP_CODEA	ADRTOWNSHIP	TOWNSHIP_CODE	REF	C	CN
30	ESALES_SETTYPE_SERVLOC	TPLNUMMER	IFLOT	TPLNR	REF
31	ESALES_SETTYPE_SERVLOC	TRANSPZONEA	TZONE	ZONE1	REF	C	CN
32	ESALES_SETTYPE_SERVLOC	TXTLANGU	T002	SPRAS		1	CN
33	ESALES_SETTYPE_SERVLOC	VBSART	TE102	VBSART	REF

History

Last changed by/on	SAP	20130529
SAP Release Created in	462