SAP ABAP Table EMKPRMSE (Premise data (marketing))

Hierarchy

☛ IS-UT (Software Component) SAP Utilities/Telecommunication
   ⤷ IS-U-CS-MA (Application Component) Marketing
     ⤷ EE_CRM_MKT_LDB (Package) Logical Database for Marketing Analyses in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	EMKPRMSE	Table Relationship Diagram
Short Description	Premise data (marketing)

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EMKPRMSE	EIGENT	BUT000	PARTNER
2	EMKPRMSE	MANDT	T000	MANDT	KEY
3	EMKPRMSE	OBJNR	ONR00	OBJNR	KEY
4	EMKPRMSE	TPLNUMMER	IFLOT	TPLNR	REF
5	EMKPRMSE	TXTLANGU	T002	SPRAS		1	CN
6	EMKPRMSE	VBSART	TE102	VBSART	REF

History

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