SAP ABAP View V_SMI_USR_SGASSN (User to Search Group Assignment)

Hierarchy

☛ SAP_BS_FND (Software Component) SAP Business Suite Foundation
   ⤷ CA-EPT-SMI (Application Component) Social Media Intelligence Foundation
     ⤷ BS_SOMI_DATA_MODELS (Package) Datta Models for Social Media Intelligence

Basic Data

View Type	C	Maintenance View
Maintenance View	V_SMI_USR_SGASSN
Short Description	User to Search Group Assignment
Root table	SMI_USR_SGASSGN	User to Search Group Assignment

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SMI_USR_SGASSGN	SMI_USR_SGASSGN
2	SMI_SRCHGRP	SMI_USR_SGASSGN	ASSOCIATEDGROUP	E
3	USR21	SMI_USR_SGASSGN	BNAME	E
4	SMI_SRCHGRP_T	SMI_SRCHGRP	SEARCHGROUP	I
5	ADRP	USR21	PERSNUMBER	E

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	SMI_USR_SGASSGN	CLIENT		☐	MANDT	☐	Client
2	BNAME	SMI_USR_SGASSGN	BNAME		☐	XUBNAME	☐	User Name in User Master Record
3	ASSOCIATEDGROUP	SMI_USR_SGASSGN	ASSOCIATEDGROUP		☐	SMI_ASSOCIATEDGROUP	☐	Search Group ID
4	SEARCHGROUPTEXT	SMI_SRCHGRP_T	SEARCHGROUPTEXT		☐	SMI_SRCHGROUPTEXT	☐	Search Group Text
5	NAME_TEXT	ADRP	NAME_TEXT		☐	AD_NAMTEXT	☐	Full Name of Person

Maintenance Status

Access

☐   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☑   read, change, delete and insert

Delivery Class	G	Customizing table, protected against SAP Upd., only INS all.
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

History

Last changed by/on	SAP	20140802
SAP Release Created in