SAP ABAP Table BDMS_JOIN (Defines joins between transparent tables)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MW-BDM (Application Component) BDOC Modeler
     ⤷ SMW_BDM (Package) CRM Middleware - BDoc Model

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	BDMS_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	BDOC_NAME	☑	SMOG_GNAME	SMOG_GNAME	CHAR	26	0	Generation name of BDoc type
2	SMOG_JOIN	☑	SMOG_JN	SMOG_GUID	CHAR	32	0	Table join primary key.
3	SMOG_TRANS	☐	SMOG_TRAN	SMOG_GUID	CHAR	32	0	Transaction Key (GUID)	SMOG_TRANS
4	SMOG_VERS	☐	SMOG_VER	SMOG_GUID	CHAR	32	0	Version Number Key (GUID)	SMOG_VERS
5	SMOG_TSEGM	☐	SMOG_TSEG	SMOG_GUID	CHAR	32	0	Transaction segment key (GUID)
6	SMOG_SQL	☐	SMOG_SEQL	SMOG_GUID	CHAR	32	0	SMOG_SQL key (GUID)
7	SMOG_SEGM	☐	SMOG_SEG	SMOG_GUID	CHAR	32	0	Segment key (GUID)
8	POS	☐	SMOG_POS	SMOG_NUM4	NUMC	4	0	Position
9	TR_JCOND	☐	SMOG_JCND	SMOG_CH255	CHAR	255	0	Table Join Condition.
10	TR_DEST	☐	SMOG_TDST	SMOG_GUID	CHAR	32	0	Table Join Destination Table.
11	TR_RECOMP	☐	SMOG_TRREC	SMOG_INT1	INT1	3	0	Recompile corresponding function modules
12	TIMESTAMP	☐	SMOG_TS	SMOG_TS	INT4	10	0	Timestamp
13	TR_ID	☐	SMOG_TRID	SMOG_TRID	CHAR	32	0	BDoc type ID (base class ID)
14	TR_STATUS	☐	SMOG_ST	SMOG_CHR4	CHAR	4	0	Transaction status
15	TR_USER	☐	SMOG_USER	SMOG_GUID	CHAR	32	0	User ID
16	DELETED	☐	SMOG_DEL	SMOG_CHR1	CHAR	1	0	Deletion flag
17	REL_STATUS	☐	BDM_RELSTT	BDM_STATUS	CHAR	3	0	BDoc Release Status
18	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	BDMS_JOIN	SMOG_TRANS	SMOG_TRANS	SMOG_TRANS	KEY
2	BDMS_JOIN	SMOG_VERS	SMOG_VERS	SMOG_VERS	KEY

History

Last changed by/on	SAP	20020829
SAP Release Created in	400