SAP ABAP View SMOG_R3_V (View in order to select in SMOG_R3DAT with correct version)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MW-SRV (Application Component) Flow / Services
     ⤷ SMOH (Package) Replication&Realignment Service

Basic Data

View Type	D	Database View
Database View	SMOG_R3_V
Short Description	View in order to select in SMOG_R3DAT with correct version
Root table	SMOG_VERS	Transaction repository version information

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	SMOG_VERS	SMOG_VERS
2	SMOG_R3DOM
3	SMOG_R3DAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	SMOG_VERS	SMOG_VERS	JL	EQ				0	0
2	SMOG_R3DAT	SMOG_VERS	JR	EQ			AND	0	0
3	SMOG_VERS	SMOG_VERS	JL	EQ				0	0
4	SMOG_R3DOM	SMOG_VERS	JR	EQ			AND	0	0
5	SMOG_R3DAT	R3DOM_ID	JL	EQ				0	0
6	SMOG_R3DOM	R3DOM_ID	JR	EQ			AND	0	0
7	SMOG_VERS	DELETED		EQ	'0'		AND	0	0
8	SMOG_VERS	ACTFLAG		EQ	'1'		AND	0	0
9	SMOG_R3DOM	DELETED		EQ	'0'		AND	0	0
10	SMOG_R3DAT	DELETED		EQ	'0'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	SMOG_VERS	SMOG_R3DOM	SMOG_VERS		☐	SMOG_VER	☐	Version Number Key (GUID)
2	SMOG_R3DOM	SMOG_R3DOM	SMOG_R3DOM		☐	SMOG_RDOM	☐	R3 Domain Prim Key
3	R3DOM_ID	SMOG_R3DOM	R3DOM_ID		☐	SMOG_DOMID	☐	Data domain ID
4	DOMNAME	SMOG_R3DOM	DOMNAME		☐	SMOG_DOMNA	☐	Domain Name
5	DATATYPE	SMOG_R3DOM	DATATYPE		☐	SMOG_DTYPE	☐	Data Type
6	STYPE_ID	SMOG_R3DOM	STYPE_ID		☐	SMOG_STID	☐	SQL Type ID
7	LENG	SMOG_R3DOM	LENG		☐	SMOG_LEN	☐	Length
8	DECIMALS	SMOG_R3DOM	DECIMALS		☐	SMOG_DEC	☐	Decimals Size of segment field
9	LANGFLAG	SMOG_R3DOM	LANGFLAG		☐	SMOG_LFLAG	☐	Language Flag
10	LOCKFLAG	SMOG_R3DOM	LOCKFLAG		☐	SMOG_LOCKF	☐	Lockflag
11	TR_EXT01	SMOG_R3DOM	TR_EXT01		☐	SMOG_EXT1	☐	Main classification of bdoc type
12	TIMESTAMP	SMOG_R3DOM	TIMESTAMP		☐	SMOG_TS	☐	Timestamp
13	TR_ID	SMOG_R3DOM	TR_ID		☐	SMOG_TID	☐	BDoc Message ID
14	TR_STATUS	SMOG_R3DOM	TR_STATUS		☐	SMOG_ST	☐	Transaction status
15	TR_USER	SMOG_R3DOM	TR_USER		☐	SMOG_USER	☐	User ID
16	DELETED	SMOG_R3DOM	DELETED		☐	SMOG_DEL	☐	Deletion flag
17	R3DAT_ID	SMOG_R3DAT	R3DAT_ID		☐	SMOG_DATID	☐	Data element ID

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