SAP ABAP Table CRMT_ACTIVITY_DETAIL (CRM Activity: Header Data and Short Texts)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-ACT (Application Component) Activity Management
⤷ CRM_ACTIVITY_H (Package) CRM Activity Header Data
⤷ CRM-BTX-ACT (Application Component) Activity Management
⤷ CRM_ACTIVITY_H (Package) CRM Activity Header Data
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_ACTIVITY_DETAIL | Table Relationship Diagram |
Short Description | CRM Activity: Header Data and Short Texts |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | BO CRM Activity: CRM Activity Header Data Method getDetail() | |||||
2 | GUID | CRMT_OBJECT_GUID_C | SYSUUID_C | CHAR | 32 | 0 | GUID of a CRM Order Object, 32 Bit Characters | ||
3 | PROCESS_TYPE | CRMT_PROCESS_TYPE | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | CRMC_PROC_TYPE | |
4 | OBJECT_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
5 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | TBDLS | |
6 | OBJECT_TYPE | SWO_OBJTYP | OJ_NAME | CHAR | 10 | 0 | Object Type | * | |
7 | DESCR_LANGUAGE | CRMT_PROCESS_DESCRIPTION_LANGU | SPRAS | LANG | 1 | 0 | Language Key of Description | T002 | |
8 | LANGU_ISO | LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
9 | DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
10 | ARCHIVING_FLAG | CRMT_ARCHIVING_FLAG | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator Whether the Business Transaction Can Be Archived | ||
11 | CATEGORY | CRMT_ACTIVITY_CATEGORY | CRM_ACTIVITY_CATEGORY | CHAR | 3 | 0 | Activity Category (Communication Type) | CRMC_ACT_CATEGOR | |
12 | PRIORITY | CRMT_PRIORITY | SC_PRIO | NUMC | 1 | 0 | Activity Priority | SCPRIO | |
13 | OBJECTIVE | CRMT_OBJECTIVE | CRM_OBJECTIVE | CHAR | 3 | 0 | Goal of an Activity | CRMC_ACT_OBJ | |
14 | DIRECTION | CRMT_DIRECTION | CRM_DIRECTION | CHAR | 1 | 0 | Direction of an Activity | ||
15 | EXTERN_ACT_ID | CRMT_EXTERNAL_ACTIVITY_ID | CRM_EXTERNAL_ACTIVITY_ID | CHAR | 20 | 0 | External Business Transaction Number | ||
16 | ADDRESS_ID | CRMT_ADDRESS | AD_ADDRNUM | CHAR | 10 | 0 | Location where Activity takes place | * | |
17 | PRIVATE_FLAG | CRMT_PRIVAT | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Task is Private | ||
18 | COMPLETION | CRMT_COMPLETION | CRM_COMPLETION | NUMC | 3 | 0 | Completion Rate in Percent | ||
19 | ADDRESS_GUID | BAD_ADDRESS_GUID32 | SYSUUID_C | CHAR | 32 | 0 | GUID for an Address Object in BAPI Format | ||
20 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
21 | CREATED_AT | CRMT_CREATED_AT | BCOS_TSTMP | DEC | 15 | 0 | Transaction was Created at this Time | ||
22 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
23 | CHANGED_AT | CRMT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Time of Last Change to the Transaction | ||
24 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
25 | ACT_LOCATION | CRMT_ACTIVITY_LCTN | CRM_ACTIVITY_LOCATION | CHAR | 100 | 0 | Location | ||
26 | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE | CRM_TEMPLATE_TYPE | CHAR | 1 | 0 | CRM Transaction: Template Type | ||
27 | .INCLUDE | 0 | 0 | CRM Activity : Short Texts | |||||
28 | DIRECTION_TXT | VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Short Text for Fixed Values | ||
29 | PRIORITY_TXT | VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Short Text for Fixed Values | ||
30 | STATUS_TXT | J_TXT30 | TEXT30 | CHAR | 30 | 0 | Object status | ||
31 | STATUS_REASON_TXT | CHAR80 | CHAR80 | CHAR | 80 | 0 | Char 80 | ||
32 | ACT_REASON_TXT | CHAR80 | CHAR80 | CHAR | 80 | 0 | Char 80 | ||
33 | TARGET_TXT | VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Short Text for Fixed Values | ||
34 | CATEGORY_TXT | VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Short Text for Fixed Values | ||
35 | PROCESS_TYPE_TXT | VAL_TEXT | DDTEXT | CHAR | 60 | 0 | Short Text for Fixed Values |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_ACTIVITY_DETAIL | CATEGORY | CRMC_ACT_CATEGOR | CATEGORY | KEY | 1 | CN |
2 | CRMT_ACTIVITY_DETAIL | DESCR_LANGUAGE | T002 | SPRAS | KEY | 1 | CN |
3 | CRMT_ACTIVITY_DETAIL | LOGICAL_SYSTEM | TBDLS | LOGSYS | KEY | 1 | CN |
4 | CRMT_ACTIVITY_DETAIL | OBJECTIVE | CRMC_ACT_OBJ | OBJECTIVE | KEY | 1 | CN |
5 | CRMT_ACTIVITY_DETAIL | PRIORITY | SCPRIO | PRIORITY | KEY | 1 | CN |
6 | CRMT_ACTIVITY_DETAIL | PROCESS_TYPE | CRMC_PROC_TYPE | PROCESS_TYPE | KEY | 1 | CN |
History
Last changed by/on | SAP | 20140117 |
SAP Release Created in | 30A |