SAP ABAP Table SMOG_JOIN (Defines joins between transparent tables)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MW (Application Component) Middleware
     ⤷ SMO4 (Package) Transaction Layer and Transaction Repository Services

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMOG_JOIN	Table Relationship Diagram
Short Description	Defines joins between transparent tables

Delivery and Maintenance

Pool/cluster
Delivery Class	W	System table, contents transportable via separate TR objects
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	SMOG_TRANS	☑	SMOG_TRAN	SMOG_GUID	CHAR	32	0	Transaction Key (GUID)	SMOG_TRANS
2	SMOG_JOIN	☑	SMOG_JN	SMOG_GUID	CHAR	32	0	Table join primary key.
3	SMOG_VERS	☐	SMOG_VER	SMOG_GUID	CHAR	32	0	Version Number Key (GUID)	SMOG_VERS
4	SMOG_TSEGM	☐	SMOG_TSEG	SMOG_GUID	CHAR	32	0	Transaction segment key (GUID)
5	SMOG_SQL	☐	SMOG_SEQL	SMOG_GUID	CHAR	32	0	SMOG_SQL key (GUID)
6	SMOG_SEGM	☐	SMOG_SEG	SMOG_GUID	CHAR	32	0	Segment key (GUID)
7	POS	☐	SMOG_POS	SMOG_NUM4	NUMC	4	0	Position
8	TR_JCOND	☐	SMOG_JCND	SMOG_CH255	CHAR	255	0	Table Join Condition.
9	TR_DEST	☐	SMOG_TDST	SMOG_GUID	CHAR	32	0	Table Join Destination Table.
10	TR_RECOMP	☐	SMOG_TRREC	SMOG_INT1	INT1	3	0	Recompile corresponding function modules
11	TIMESTAMP	☐	SMOG_TS	SMOG_TS	INT4	10	0	Timestamp
12	TR_ID	☐	SMOG_TRID	SMOG_TRID	CHAR	32	0	BDoc type ID (base class ID)
13	TR_STATUS	☐	SMOG_ST	SMOG_CHR4	CHAR	4	0	Transaction status
14	TR_USER	☐	SMOG_USER	SMOG_GUID	CHAR	32	0	User ID
15	DELETED	☐	SMOG_DEL	SMOG_CHR1	CHAR	1	0	Deletion flag
16	REL_STATUS	☐	BDM_RELSTT	BDM_STATUS	CHAR	3	0	BDoc Release Status
17	OWNER	☐	BDM_OWNER	BDM_OWNER	CHAR	1	0	DE for owner- Customer Sap Object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	SMOG_JOIN	SMOG_TRANS	SMOG_TRANS	SMOG_TRANS	KEY
2	SMOG_JOIN	SMOG_VERS	SMOG_VERS	SMOG_VERS	KEY

History

Last changed by/on	SAP	20010219
SAP Release Created in