SAP ABAP View SMOSUVA (View on SMOHVALUES SMOHPOTCRT SOG_SEGM)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA-TER (Application Component) Territory Management
     ⤷ MW_TERRITORY (Package) DDIC Objects for territory CDB tables

Basic Data

View Type	D	Database View
Database View	SMOSUVA
Short Description	View on SMOHVALUES SMOHPOTCRT SOG_SEGM
Root table	SMOHVALUES	Criteria Values for Subscriptions

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SMOHVALUES	SMOHVALUES
2	SMOHPOTCRT
3	SMOG_SEGM

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SMOHVALUES	SMOHREPOBJ	JL	EQ				0	0
2	SMOHPOTCRT	SMOHREPOBJ	JR	EQ			AND	0	0
3	SMOHVALUES	SMOHPOTCRT	JL	EQ				0	0
4	SMOHPOTCRT	SMOHPOTCRT	JR	EQ			AND	0	0
5	SMOHPOTCRT	MSGSEG	JL	EQ				0	0
6	SMOG_SEGM	SMOG_SEGM	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SMOHVALUES	MANDT		☐	MANDT	☐	Client
2	SMOHVALUES	SMOHVALUES	SMOHVALUES		☐	SMO_VALUES	☐	Subscription Values Key
3	SMOHSUBSCR	SMOHVALUES	SMOHSUBSCR		☐	SMO_SUBSCR	☐	Subscription Key
4	SMOHPUBL	SMOHVALUES	SMOHPUBL		☐	SMO_PUBL	☐	Publication Key
5	SMOHREPOBJ	SMOHVALUES	SMOHREPOBJ		☐	SMOH_RO	☐	Replication Object Key
6	SMOHPOTCRT	SMOHVALUES	SMOHPOTCRT		☐	SMOH_POTCRT	☐	Potential Criteria Field Key
7	VALUE1	SMOHVALUES	VALUE1		☐	SMO_VALUEL	☐	Value for Criterias
8	VALUE2	SMOHVALUES	VALUE2		☐	SMO_VALUEH	☐	Value for Criterias
9	SMOHRULES	SMOHVALUES	SMOHRULES		☐	SMO_RULES	☐	Rules Key (Link Publication to Replication Object)
10	SMOHCRITS	SMOHVALUES	SMOHCRITS		☐	SMO_CRITS	☐	Criteria Field Key
11	FEEDBKFLAG	SMOHVALUES	FEEDBKFLAG		☐	SMO_FEEDBK	☐	Return Info/Feedback/Error Flag
12	TR_USER	SMOHVALUES	TR_USER		☐	SMO_TR_USR	☐	Transaction User
13	DELETED	SMOHVALUES	DELETED		☐	SMO_DELETD	☐	Mobile Sales Deleted
14	ACCDATE	SMOHVALUES	ACCDATE		☐	SMOH_DDATE	☐	Last Access Date
15	ACCTIME	SMOHVALUES	ACCTIME		☐	SMOH_DTIME	☐	Last Access Time
16	SMOVERS	SMOHPOTCRT	SMOVERS		☐	SMOREPVERS	☐	Repository Version
17	FIELD	SMOHPOTCRT	FIELD		☐	SMOESFNAME	☐	Segment Field Name
18	DATATYPE	SMOHPOTCRT	DATATYPE		☐	SMO_DTYPE	☐	Data Type of Criteria
19	SMOG_SEGM	SMOG_SEGM	SMOG_SEGM		☐	SMOG_SEG	☐	Segment key (GUID)
20	TR_SNAME	SMOG_SEGM	TR_SNAME		☐	SMOG_SNAME	☐	Segment name (long name)
21	SMOG_TRANS	SMOG_SEGM	SMOG_TRANS		☐	SMOG_TRAN	☐	Transaction Key (GUID)

Maintenance Status

Access

☑   read only

☐   read and change

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

☐   read, change, delete and insert

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

History

Last changed by/on	SAP	20100420
SAP Release Created in	20C