SAP ABAP Table SMOG_SQL (Mapping of transaction segment to physical table)

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_SQL	Table Relationship Diagram
Short Description	Mapping of transaction segment to physical table

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_SQL	☑	SMOG_SEQL	SMOG_GUID	CHAR	32	0	SMOG_SQL key (GUID)
3	SMOG_VERS	☑	SMOG_VER	SMOG_GUID	CHAR	32	0	Version Number Key (GUID)	SMOG_VERS
4	SMOG_SEGM	☐	SMOG_SEG	SMOG_GUID	CHAR	32	0	Segment key (GUID)
5	TR_STMNT	☐	SMOG_STMT	SMOG_GUID	CHAR	32	0	GUID SMOG_STMNT
6	TR_SPROC	☐	SMOG_SPROC	SMOG_CH255	CHAR	255	0	Call of stored procedure
7	TR_RECOMP	☐	SMOG_TRREC	SMOG_INT1	INT1	3	0	Recompile corresponding function modules
8	TIMESTAMP	☐	SMOG_TS	SMOG_TS	INT4	10	0	Timestamp
9	TR_ID	☐	SMOG_TRID	SMOG_TRID	CHAR	32	0	BDoc type ID (base class ID)
10	TR_STATUS	☐	SMOG_ST	SMOG_CHR4	CHAR	4	0	Transaction status
11	TR_USER	☐	SMOG_USER	SMOG_GUID	CHAR	32	0	User ID
12	DELETED	☐	SMOG_DEL	SMOG_CHR1	CHAR	1	0	Deletion flag

Foreign Keys

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

History

Last changed by/on	SAP	20010219
SAP Release Created in