SAP ABAP Table CDBC_ORGPROF (Used in Organisation Determination)

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	CDBC_ORGPROF	Table Relationship Diagram
Short Description	Used in Organisation Determination

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ORGPROFGUID	☑	SMO_GUID	SMO_GUID	CHAR	32	0	Global Unique Identifier
3	ORG_PROFILID	☐	CRMT_ORG_PROFILID	CHAR12	CHAR	12	0	Organizational Data Profile
4	SCENARIO	☐	OM_ATTRSCN	OM_ATTRSCN	CHAR	8	0	General Attribute Maintenance: Application Scenario	T77OMATTSC
5	OBJTYP_ROL_OE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
6	ORG_ROL_OE	☐	CRMT_ORGPROF_ROL_1	HR_SOBJID	NUMC	8	0	Determination Rule: Org.Data Model	HRSOBJECT
7	OBJTYP_ROL_RESP	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
8	ORG_ROL_RESP	☐	CRMT_ORGPROF_ROL_2	HR_SOBJID	NUMC	8	0	Responsibilities Determin. Rule	HRSOBJECT
9	OBL_SALESORG	☐	CRMT_FC_O_SALESORG	CRM_ORGPROF_CHOICE	CHAR	1	0	Sales Organization is Obligatory
10	OBL_DISTCHAN	☐	CRMT_FC_O_DISTCHAN	CRM_ORGPROF_CHOICE	CHAR	1	0	Distribution Channel is Obligatory
11	OBL_DIVISION	☐	CRMT_FC_O_DIVISION	CRM_ORGPROF_CHOICE	CHAR	1	0	Division is Obligatory
12	OBL_SALESOFFICE	☐	CRMT_FC_O_SALESOFFICE	CRM_ORGPROF_CHOICE	CHAR	1	0	Sales Office is Obligatory
13	OBL_SALESGROUP	☐	CRMT_FC_O_SALESGROUP	CRM_ORGPROF_CHOICE	CHAR	1	0	Sales Group is Obligatory
14	OBL_SERVICEORG	☐	CRMT_FC_O_SERVICEORG	CRM_ORGPROF_CHOICE	CHAR	1	0	Service Organization is Obligatory
15	OBL_PURCHORG	☐	CRMT_FC_O_PURCHORG	CRM_ORGPROF_CHOICE	CHAR	1	0	Purchasing Organization is Obligatory
16	OBL_PURCHGROUP	☐	CRMT_FC_O_PURCHGROUP	CRM_ORGPROF_CHOICE	CHAR	1	0	Purchasing Group is Obligatory
17	REGISTRATOR	☐	CRMT_REGISTRATOR	USNAM	CHAR	12	0	User Who Created an Entry
18	.INCLUDE	☐				0	0	Communication Fields for Mobile Sales/Service
19	TR_USER	☐	SMO_TR_USR	SMO_TR_USR	CHAR	32	0	Transaction User
20	TR_ID	☐	SMO_TR_ID	SMO_TR_ID	CHAR	32	0	Transaction Identifier
21	TR_STATUS	☐	SMO_TR_STS	SMO_TR_STS	CHAR	4	0	Status of Transaction
22	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
23	DELETED	☐	SMO_DELETD	SMO_DELETD	CHAR	1	0	Mobile Sales Deleted
24	TR_ROOTID	☐	SMO_RTGUID	SMO_GUID	CHAR	32	0	Identifier of BDoc Root object

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CDBC_ORGPROF	CLIENT	T000	MANDT
2	CDBC_ORGPROF	OBJTYP_ROL_OE	T778O	OTYPE
3	CDBC_ORGPROF	OBJTYP_ROL_RESP	T778O	OTYPE
4	CDBC_ORGPROF	ORG_ROL_OE	HRSOBJECT	OBJID
5	CDBC_ORGPROF	ORG_ROL_RESP	HRSOBJECT	OBJID
6	CDBC_ORGPROF	SCENARIO	T77OMATTSC	SCENARIO

History

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