SAP ABAP Table CRMT_REPORT_SELHELPER (Line for CRMT_REPORT_SELHELPER_ta)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
⤷ CRM_REPORT (Package) Operative Reporting in CRM
⤷ CRM-BTX-ANA-RFW (Application Component) Reporting Framework
⤷ CRM_REPORT (Package) Operative Reporting in CRM
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_REPORT_SELHELPER | Table Relationship Diagram |
Short Description | Line for CRMT_REPORT_SELHELPER_ta |
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 | PARTNER_GUID | CRMT_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | GUID for an Individual Partner | ||
2 | .INCLUDE | 0 | 0 | Line for crmt_rprtng_inboxlist_ta | |||||
3 | .INCLUDE | 0 | 0 | One Order: Key Fields | |||||
4 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
5 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
6 | STAT | J_STATUS | J_STATUS | CHAR | 5 | 0 | Object status | ||
7 | .INCLUDE | 0 | 0 | Structure of an Activity - External Fields | |||||
8 | CATEGORY | CRMT_ACTIVITY_CATEGORY | CRM_ACTIVITY_CATEGORY | CHAR | 3 | 0 | Activity Category (Communication Type) | CRMC_ACT_CATEGOR | |
9 | PRIORITY | CRMT_PRIORITY | SC_PRIO | NUMC | 1 | 0 | Activity Priority | SCPRIO | |
10 | OBJECTIVE | CRMT_OBJECTIVE | CRM_OBJECTIVE | CHAR | 3 | 0 | Goal of an Activity | CRMC_ACT_OBJ | |
11 | DIRECTION | CRMT_DIRECTION | CRM_DIRECTION | CHAR | 1 | 0 | Direction of an Activity | ||
12 | EXTERN_ACT_ID | CRMT_EXTERNAL_ACTIVITY_ID | CRM_EXTERNAL_ACTIVITY_ID | CHAR | 20 | 0 | External Business Transaction Number | ||
13 | ADDRESS_ID | CRMT_ADDRESS | AD_ADDRNUM | CHAR | 10 | 0 | Location where Activity takes place | * | |
14 | PRIVATE_FLAG | CRMT_PRIVAT | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Task is Private | ||
15 | COMPLETION | CRMT_COMPLETION | CRM_COMPLETION | NUMC | 3 | 0 | Completion Rate in Percent | ||
16 | ACT_LOCATION | CRMT_ACTIVITY_LCTN | CRM_ACTIVITY_LOCATION | CHAR | 100 | 0 | Location | ||
17 | .INCLUDE | 0 | 0 | EEW Include | |||||
18 | ACTIVITY_H_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
19 | .INCLUDE | 0 | 0 | ||||||
20 | .INCLUDE | 0 | 0 | Header Data Opportunity - Structure of External Fields | |||||
21 | EXP_REVENUE | CRMT_REPORT_EXP_REVENUE | WERTV8 | CURR | 15 | 2 | Expected Sales Revenue | ||
22 | BUDGET_BP | CRMT_BUDGET_BP | WERTV8 | CURR | 15 | 2 | Budget Prospect | ||
23 | STARTDATE | CRMT_STARTDATE | DATUM | DATS | 8 | 0 | Opportunity Start Date | ||
24 | EXPECT_END | CRMT_EXPECT_END | DATUM | DATS | 8 | 0 | Expected Closing Date | ||
25 | CURR_PHASE | CRMT_CURR_PHASE | CRM_PHASE | CHAR | 3 | 0 | Sales Stage | CRMC_PHASE | |
26 | PHASE_SINCE | CRMT_PHASE_SINCE | DATUM | DATS | 8 | 0 | Sales Stage Since | ||
27 | PROBABILITY | CRMT_PROBABILITY | CRM_PROBABILITY | NUMC | 3 | 0 | Chance of Success | ||
28 | FORECAST_REL | CRMT_FORECAST_REL | CRM_FORECAST_REL | CHAR | 1 | 0 | Forecast Relevance | ||
29 | SOURCE | CRMT_SOURCE | CRM_SOURCE | CHAR | 3 | 0 | Origin of Opportunity/Lead | CRMC_SOURCE | |
30 | IMPORTANCE | CRMT_IMPORTANCE | CRM_IMPORTANCE | CHAR | 1 | 0 | Opportunity/Lead Priority | CRMC_OPPIMPOR | |
31 | SALESCYCLE | CRMT_SALESCYCLE | CRM_SALESCYCLE | CHAR | 5 | 0 | Sales Cycle | CRMC_CYCLE | |
32 | ADDRESS_NO | CRMT_OPP_ADDRESS | AD_ADDRNUM | CHAR | 10 | 0 | Opportunity Address | * | |
33 | TYPE | CRMT_OPPORT_TYPE | CRM_OPPORT_TYPE | CHAR | 4 | 0 | Opportunity Type | CRMC_OPPT_TYPE | |
34 | STATUS_SINCE | CRMT_STATUS_SINCE | DATUM | DATS | 8 | 0 | Status Since | ||
35 | SYS_PROBABILITY | CRMT_SYSTEM_PROBABILITY | CRM_SYSTEM_PROBABILITY | NUMC | 3 | 0 | Chance of Success of Opportunity - Calculated by System | ||
36 | DESCRIPTION_OPP | CRMT_DESCRIPTION_OPP | TEXT40 | CHAR | 40 | 0 | Opportunity Description | ||
37 | DESCR_OPP_UC | CRMT_DESCRIPTION_OPP_UC | TEXT40 | CHAR | 40 | 0 | Opportunity Description in UC | ||
38 | CUSTOMER_STATUS | CRMT_CUSTSTAT | CRM_CUSTSTAT | CHAR | 4 | 0 | Design Registration Project Phase | * | |
39 | .INCLUDE | 0 | 0 | EEW Include | |||||
40 | OPPORT_H_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
41 | .INCLUDE | 0 | 0 | ||||||
42 | .INCLUDE | 0 | 0 | General Header Data - Structure of External Fields | |||||
43 | OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
44 | PROCESS_TYPE | CRMT_PROCESS_TYPE_DB | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
45 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
46 | DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
47 | DESCR_LANGUAGE | CRMT_PROCESS_DESCRIPTION_LANGU | SPRAS | LANG | 1 | 0 | Language Key of Description | * | |
48 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
49 | CRM_RELEASE | SAPRELEASE | CHAR10 | CHAR | 10 | 0 | SAP Release | ||
50 | SCENARIO | CRMT_SCENARIO | CRM_SCENARIO | CHAR | 10 | 0 | Scenario Identity | ||
51 | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE_DB | CRM_TEMPLATE_TYPE | CHAR | 1 | 0 | Template Type of CRM Transaction | ||
52 | .INCLUDE | 0 | 0 | Time and User of Last Transaction Processing | |||||
53 | CREATED_AT | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
54 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
55 | CHANGED_AT | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
56 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
57 | HEAD_CHANGED_AT | CRMT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Time of Last Change to the Transaction | ||
58 | .INCLUDE | 0 | 0 | EEW Extension | |||||
59 | ORDERADM_H_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
60 | .INCLUDE | 0 | 0 | ||||||
61 | .INCLU--AP | 0 | 0 | Additional Fields in ORDERADM_H After Decoupling | |||||
62 | INPUT_CHANNEL | CRMT_INPUT_CHANNEL | CRM_INPUT_CHANNEL | CHAR | 3 | 0 | Input channel | ||
63 | BTX_CLASS | CRMT_TRANSACTION_CLASSIFICATN | CRM_TRANSACTION_CLASSIFICATION | CHAR | 1 | 0 | CRM Business Transaction Classification | ||
64 | AUTH_SCOPE | CRM_AUTH_SCOPE | CRM_AUTH_SCOPE | NUMC | 6 | 0 | Authorization Scope | * | |
65 | COMP_TX_HEADER | CRMT_COMP_TX_HEADER_GUID | SYSUUID | RAW | 16 | 0 | GUID of Composite Transaction Header | ||
66 | PROCESS_TYPE_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
67 | OPPTYPE_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
68 | TASK | CRMT_TASK | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator: Activity is a Task | ||
69 | CATEGORY_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
70 | PRIORITY_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
71 | OBJECTIVE_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
72 | DIRECTION_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
73 | RESULT_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
74 | PARTNER_FCT | CRMT_RPRTNG_MYFUNCTION | CHAR8 | CHAR | 8 | 0 | Function That a Processor Has in a Sales Document | ||
75 | FCT_DESCRIPTION | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
76 | FCT_SHORT_DESC | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
77 | MAIN_BP_1_NO | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
78 | MAIN_BP_1_FCT | CRMT_RPRTNG_ADDFUNCTION | CHAR8 | CHAR | 8 | 0 | Role of an Additional Business Partner for Display | ||
79 | MAIN_BP_1 | CRMT_RPRTNG_ADDPARTNER | NAME | CHAR | 35 | 0 | Additional Business Partner | ||
80 | MAIN_BP_1_DESC | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
81 | MAIN_BP_1_DESC_S | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
82 | MAIN_BP_1_NAMELIST | AD_LINE_S | CHAR80 | CHAR | 80 | 0 | One-line short form of formatted address | ||
83 | MAIN_BP_2_NO | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
84 | MAIN_BP_2_FCT | CRMT_RPRTNG_ADDFUNCTION | CHAR8 | CHAR | 8 | 0 | Role of an Additional Business Partner for Display | ||
85 | MAIN_BP_2 | CRMT_RPRTNG_ADDPARTNER | NAME | CHAR | 35 | 0 | Additional Business Partner | ||
86 | MAIN_BP_2_DESC | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
87 | MAIN_BP_2_DESC_S | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
88 | MAIN_BP_2_NAMELIST | AD_LINE_S | CHAR80 | CHAR | 80 | 0 | One-line short form of formatted address | ||
89 | STATUS_USER_LONG | CRMT_REPORT_STATUS_UL | CHAR100 | CHAR | 100 | 0 | Longform User Status | ||
90 | STATUS_USER | CRMT_REPORT_STATUS_U | CHAR40 | CHAR | 40 | 0 | Shortform Status | ||
91 | STATUS_LONG | CRMT_REPORT_STATUS_L | CHAR100 | CHAR | 100 | 0 | Longform Status | ||
92 | STATUS | CRMT_REPORT_STATUS | CHAR40 | CHAR | 40 | 0 | Status | ||
93 | PLANNEDDATEFROM | SC_DATEFRO | DATUM | DATS | 8 | 0 | Start Date | ||
94 | PLANNEDDATETO | SC_DATETO | DATUM | DATS | 8 | 0 | End Date | ||
95 | PLANNEDZONE | SC_ZONEFRO | TZNZONE | CHAR | 6 | 0 | Appointment calendar: Time zone of start of appointment | * | |
96 | PLANNEDTIMEFROM | SC_TIMEFRO | SYTIME | TIMS | 6 | 0 | From Time | ||
97 | PLANNEDTIMETO | SC_TIMETO | SYTIME | TIMS | 6 | 0 | To Time | ||
98 | ACTUALDATEFROM | SC_DATEFRO | DATUM | DATS | 8 | 0 | Start Date | ||
99 | ACTUALDATETO | SC_DATETO | DATUM | DATS | 8 | 0 | End Date | ||
100 | ACTUALZONE | SC_ZONEFRO | TZNZONE | CHAR | 6 | 0 | Appointment calendar: Time zone of start of appointment | * | |
101 | ACTUALTIMEFROM | SC_TIMEFRO | SYTIME | TIMS | 6 | 0 | From Time | ||
102 | ACTUALTIMETO | SC_TIMETO | SYTIME | TIMS | 6 | 0 | To Time | ||
103 | PROPOSEDDATEFROM | SC_DATEFRO | DATUM | DATS | 8 | 0 | Start Date | ||
104 | PROPOSEDDATETO | SC_DATETO | DATUM | DATS | 8 | 0 | End Date | ||
105 | PROPOSEDZONE | SC_ZONEFRO | TZNZONE | CHAR | 6 | 0 | Appointment calendar: Time zone of start of appointment | * | |
106 | PROPOSEDTIMEFROM | SC_TIMEFRO | SYTIME | TIMS | 6 | 0 | From Time | ||
107 | PROPOSEDTIMETO | SC_TIMETO | SYTIME | TIMS | 6 | 0 | To Time | ||
108 | PHASE_DESCRIPTION | CRMT_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Description | ||
109 | PO_NUMBER_SOLD | CRMT_PO_NUMBER_SOLD | TEXT35 | CHAR | 35 | 0 | Sold-To Party's External Reference Number | ||
110 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
111 | NET_VALUE | CRMT_NET_VALUE_CUM | WERTV8 | CURR | 15 | 2 | Total Net Value of Document in Document Currency | ||
112 | OBJECT_TYPE | SWO_OBJTYP | OJ_NAME | CHAR | 10 | 0 | Object Type | * | |
113 | OBJECT_TYPE_TXT | SAEOBJTEXT | SADC40 | CHAR | 40 | 0 | Object text for language-dependent table |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_REPORT_SELHELPER | CATEGORY | CRMC_ACT_CATEGOR | CATEGORY | |||
2 | CRMT_REPORT_SELHELPER | CURR_PHASE | CRMC_PHASE | PHASE | |||
3 | CRMT_REPORT_SELHELPER | IMPORTANCE | CRMC_OPPIMPOR | IMPORTANCE | |||
4 | CRMT_REPORT_SELHELPER | OBJECTIVE | CRMC_ACT_OBJ | OBJECTIVE | |||
5 | CRMT_REPORT_SELHELPER | PRIORITY | SCPRIO | PRIORITY | |||
6 | CRMT_REPORT_SELHELPER | SALESCYCLE | CRMC_CYCLE | SALESCYCLE | |||
7 | CRMT_REPORT_SELHELPER | SOURCE | CRMC_SOURCE | SOURCE | |||
8 | CRMT_REPORT_SELHELPER | TYPE | CRMC_OPPT_TYPE | TYPE |
History
Last changed by/on | SAP | 20140802 |
SAP Release Created in |