SAP ABAP Table SMORELATION (Assignment Table (Business Partner to Hierarchy Node))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSA (Application Component) Mobile Sales
     ⤷ CDB (Package) new CDB tables for new BDocs for CRM 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	SMORELATION	Table Relationship Diagram
Short Description	Assignment Table (Business Partner to Hierarchy Node)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	SFARELATION	☑	SMO_SFAREL	SMO_GUID	CHAR	32	0	SFA KEY of Assignment Table (Business Partner to Hier. Node)
3	SFAGROUP	☐	SMO_SFAGRP	SMO_GUID	CHAR	32	0	SFA KEY of Group Hierarchy Type
4	SFAKNA1	☐	SMO_SFAKN1	SMO_GUID	CHAR	32	0	SFA Key of Business Partner
5	SFANODE	☐	SMO_SFANOD	SMO_GUID	CHAR	32	0	SFA KEY of Hierarchy Node Table
6	SFATREE	☐	SMO_SFATRE	SMO_GUID	CHAR	32	0	SFA KEY of Created Hierarchy Trees
7	VALID_FROM	☐	SMO3DATAB	DATUM	DATS	8	0	Valid-from date
8	VALID_TO	☐	SMO3DATBI	DATUM	DATS	8	0	Valid to date
9	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
10	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
11	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
12	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
13	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
14	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
15	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object
16	SEARCH_TERM	☐	BU_NODE_SEARCH_TERM		CHAR	20	0	Hierarchy Node ID

History

Last changed by/on	SAP	20041011
SAP Release Created in	30A