SAP ABAP Table CRMT_ACTIVITY_ALV (CRM: Structure for the Application Workplace - Activities)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-BF (Application Component) Basic Functions for Business Transactions
⤷ CRM_USERFACE (Package) User Interface One Order
⤷ CRM-BTX-BF (Application Component) Basic Functions for Business Transactions
⤷ CRM_USERFACE (Package) User Interface One Order
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_ACTIVITY_ALV | Table Relationship Diagram |
Short Description | CRM: Structure for the Application Workplace - Activities |
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 | Structure of an Activity - External Fields | |||||
2 | CATEGORY | CRMT_ACTIVITY_CATEGORY | CRM_ACTIVITY_CATEGORY | CHAR | 3 | 0 | Activity Category (Communication Type) | CRMC_ACT_CATEGOR | |
3 | PRIORITY | CRMT_PRIORITY | SC_PRIO | NUMC | 1 | 0 | Activity Priority | SCPRIO | |
4 | OBJECTIVE | CRMT_OBJECTIVE | CRM_OBJECTIVE | CHAR | 3 | 0 | Goal of an Activity | CRMC_ACT_OBJ | |
5 | DIRECTION | CRMT_DIRECTION | CRM_DIRECTION | CHAR | 1 | 0 | Direction of an Activity | ||
6 | EXTERN_ACT_ID | CRMT_EXTERNAL_ACTIVITY_ID | CRM_EXTERNAL_ACTIVITY_ID | CHAR | 20 | 0 | External Business Transaction Number | ||
7 | ADDRESS_ID | CRMT_ADDRESS | AD_ADDRNUM | CHAR | 10 | 0 | Location where Activity takes place | * | |
8 | PRIVATE_FLAG | CRMT_PRIVAT | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Task is Private | ||
9 | COMPLETION | CRMT_COMPLETION | CRM_COMPLETION | NUMC | 3 | 0 | Completion Rate in Percent | ||
10 | ACT_LOCATION | CRMT_ACTIVITY_LCTN | CRM_ACTIVITY_LOCATION | CHAR | 100 | 0 | Location | ||
11 | .INCLUDE | 0 | 0 | EEW Include | |||||
12 | ACTIVITY_H_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
13 | .INCLUDE | 0 | 0 | ||||||
14 | .INCLUDE | 0 | 0 | General Header Data - Structure of External Fields | |||||
15 | OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
16 | PROCESS_TYPE | CRMT_PROCESS_TYPE_DB | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
17 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
18 | DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
19 | DESCR_LANGUAGE | CRMT_PROCESS_DESCRIPTION_LANGU | SPRAS | LANG | 1 | 0 | Language Key of Description | * | |
20 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
21 | CRM_RELEASE | SAPRELEASE | CHAR10 | CHAR | 10 | 0 | SAP Release | ||
22 | SCENARIO | CRMT_SCENARIO | CRM_SCENARIO | CHAR | 10 | 0 | Scenario Identity | ||
23 | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE_DB | CRM_TEMPLATE_TYPE | CHAR | 1 | 0 | Template Type of CRM Transaction | ||
24 | .INCLUDE | 0 | 0 | Time and User of Last Transaction Processing | |||||
25 | CREATED_AT | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
26 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
27 | CHANGED_AT | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
28 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
29 | HEAD_CHANGED_AT | CRMT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Time of Last Change to the Transaction | ||
30 | .INCLUDE | 0 | 0 | EEW Extension | |||||
31 | ORDERADM_H_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
32 | .INCLUDE | 0 | 0 | ||||||
33 | .INCLU--AP | 0 | 0 | Additional Fields in ORDERADM_H After Decoupling | |||||
34 | INPUT_CHANNEL | CRMT_INPUT_CHANNEL | CRM_INPUT_CHANNEL | CHAR | 3 | 0 | Input channel | ||
35 | BTX_CLASS | CRMT_TRANSACTION_CLASSIFICATN | CRM_TRANSACTION_CLASSIFICATION | CHAR | 1 | 0 | CRM Business Transaction Classification | ||
36 | AUTH_SCOPE | CRM_AUTH_SCOPE | CRM_AUTH_SCOPE | NUMC | 6 | 0 | Authorization Scope | * | |
37 | COMP_TX_HEADER | CRMT_COMP_TX_HEADER_GUID | SYSUUID | RAW | 16 | 0 | GUID of Composite Transaction Header | ||
38 | .INCLUDE | 0 | 0 | One Order: Key Fields | |||||
39 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
40 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
41 | STAT | J_STATUS | J_STATUS | CHAR | 5 | 0 | Object status | ||
42 | STATUS | CRMT_RPRTNG_STATUS_L | TEXT40 | CHAR | 40 | 0 | Longtext Status for a Sales Document | ||
43 | CATEGORY_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
44 | PRIORITY_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
45 | OBJECTIVE_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
46 | DIRECTION_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
47 | PARTNER_FCT | CRMT_RPRTNG_MYFUNCTION | CHAR8 | CHAR | 8 | 0 | Function That a Processor Has in a Sales Document | ||
48 | FCT_DESCRIPTION | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
49 | FCT_SHORT_DESC | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
50 | MAIN_BP_1_NO | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
51 | MAIN_BP_1_FCT | CRMT_RPRTNG_ADDFUNCTION | CHAR8 | CHAR | 8 | 0 | Role of an Additional Business Partner for Display | ||
52 | MAIN_BP_1 | CRMT_RPRTNG_ADDPARTNER | NAME | CHAR | 35 | 0 | Additional Business Partner | ||
53 | MAIN_BP_1_DESC | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
54 | MAIN_BP_1_DESC_S | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
55 | MAIN_BP_1_NAMELIST | AD_LINE_S | CHAR80 | CHAR | 80 | 0 | One-line short form of formatted address | ||
56 | MAIN_BP_2_NO | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
57 | MAIN_BP_2_FCT | CRMT_RPRTNG_ADDFUNCTION | CHAR8 | CHAR | 8 | 0 | Role of an Additional Business Partner for Display | ||
58 | MAIN_BP_2 | CRMT_RPRTNG_ADDPARTNER | NAME | CHAR | 35 | 0 | Additional Business Partner | ||
59 | MAIN_BP_2_DESC | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
60 | MAIN_BP_2_DESC_S | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
61 | MAIN_BP_2_NAMELIST | AD_LINE_S | CHAR80 | CHAR | 80 | 0 | One-line short form of formatted address | ||
62 | STATUS_USER_LONG | CRMT_REPORT_STATUS_UL | CHAR100 | CHAR | 100 | 0 | Longform User Status | ||
63 | STATUS_USER | CRMT_REPORT_STATUS_U | CHAR40 | CHAR | 40 | 0 | Shortform Status | ||
64 | STATUS_LONG | CRMT_REPORT_STATUS_L | CHAR100 | CHAR | 100 | 0 | Longform Status | ||
65 | PLANNEDDATEFROM | SC_DATEFRO | DATUM | DATS | 8 | 0 | Start Date | ||
66 | PLANNEDDATETO | SC_DATETO | DATUM | DATS | 8 | 0 | End Date | ||
67 | PLANNEDZONE | SC_ZONEFRO | TZNZONE | CHAR | 6 | 0 | Appointment calendar: Time zone of start of appointment | * | |
68 | PLANNEDTIMEFROM | SC_TIMEFRO | SYTIME | TIMS | 6 | 0 | From Time | ||
69 | PLANNEDTIMETO | SC_TIMETO | SYTIME | TIMS | 6 | 0 | To Time | ||
70 | ACTUALDATEFROM | SC_DATEFRO | DATUM | DATS | 8 | 0 | Start Date | ||
71 | ACTUALDATETO | SC_DATETO | DATUM | DATS | 8 | 0 | End Date | ||
72 | ACTUALZONE | SC_ZONEFRO | TZNZONE | CHAR | 6 | 0 | Appointment calendar: Time zone of start of appointment | * | |
73 | ACTUALTIMEFROM | SC_TIMEFRO | SYTIME | TIMS | 6 | 0 | From Time | ||
74 | ACTUALTIMETO | SC_TIMETO | SYTIME | TIMS | 6 | 0 | To Time | ||
75 | PROPOSEDDATEFROM | SC_DATEFRO | DATUM | DATS | 8 | 0 | Start Date | ||
76 | PROPOSEDDATETO | SC_DATETO | DATUM | DATS | 8 | 0 | End Date | ||
77 | PROPOSEDZONE | SC_ZONEFRO | TZNZONE | CHAR | 6 | 0 | Appointment calendar: Time zone of start of appointment | * | |
78 | PROPOSEDTIMEFROM | SC_TIMEFRO | SYTIME | TIMS | 6 | 0 | From Time | ||
79 | PROPOSEDTIMETO | SC_TIMETO | SYTIME | TIMS | 6 | 0 | To Time |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_ACTIVITY_ALV | CATEGORY | CRMC_ACT_CATEGOR | CATEGORY | |||
2 | CRMT_ACTIVITY_ALV | OBJECTIVE | CRMC_ACT_OBJ | OBJECTIVE | |||
3 | CRMT_ACTIVITY_ALV | PRIORITY | SCPRIO | PRIORITY |
History
Last changed by/on | SAP | 20140802 |
SAP Release Created in |