SAP ABAP View SMOHPUB_ACTIVE (Selektion of valid Publications)

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	SMOHPUB_ACTIVE
Short Description	Selektion of valid Publications
Root table	SMOHPARIND	Current Industry

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SMOHPARIND	SMOHPARIND
2	SMOHPUBL

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SMOHPUBL	INDUSTRY	JL	EQ				0	0
2	SMOHPARIND	INDUSTRY	JR	EQ			AND	0	0
3	SMOHPUBL	DELETED		EQ	'0'		AND	0	0
4	SMOHPUBL	SMOACTV		EQ	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	SMOHPARIND	MANDT		☐	MANDT	☐	Client
2	SMOHPUBL	SMOHPUBL	SMOHPUBL		☐	SMO_PUBL	☐	Publication Key
3	SMOVERS	SMOHPUBL	SMOVERS		☐	SMOREPVERS	☐	Repository Version
4	INDUSTRY	SMOHPUBL	INDUSTRY		☐	SMO_INDUST	☐	Industry Flag
5	PUBL_NAME	SMOHPUBL	PUBL_NAME		☐	SMO_PUBNAM	☐	Publication Name
6	SHORT_NAME	SMOHPUBL	SHORT_NAME		☐	SMO_PUBSHT	☐	Short Name of Publication
7	BULK_REPL	SMOHPUBL	BULK_REPL		☐	SMO_BOOL	☐	Boolean
8	INTERLINK	SMOHPUBL	INTERLINK		☐	SMO_BOOL	☐	Boolean
9	FEEDBKFLAG	SMOHPUBL	FEEDBKFLAG		☐	SMO_FEEDBK	☐	Return Info/Feedback/Error Flag
10	SMOACTV	SMOHPUBL	SMOACTV		☐	SMOACTVERS	☐	Marker for the Active Version of a Repository Object
11	TR_USER	SMOHPUBL	TR_USER		☐	SMO_TR_USR	☐	Transaction User
12	DELETED	SMOHPUBL	DELETED		☐	SMO_DELETD	☐	Mobile Sales Deleted
13	ACCDATE	SMOHPUBL	ACCDATE		☐	SMOH_DDATE	☐	Last Access Date
14	ACCTIME	SMOHPUBL	ACCTIME		☐	SMOH_DTIME	☐	Last Access Time
15	NAME_SPACE	SMOHPUBL	NAME_SPACE		☐	NAMESPACE	☐	Namespace
16	PUTYPE	SMOHPUBL	PUTYPE		☐	SMO_PUTYPE	☐	Publication Type

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	20041219
SAP Release Created in	300