SAP ABAP Table CRMT_OPPORTUNITY_ALV (CRM: Structre for Applicaiton Workplace - Opportunities)
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_OPPORTUNITY_ALV | Table Relationship Diagram |
Short Description | CRM: Structre for Applicaiton Workplace - Opportunities |
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 | General Header Data - Structure of External Fields | |||||
2 | OBJECT_ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
3 | PROCESS_TYPE | CRMT_PROCESS_TYPE_DB | CRM_PROCESS_TYPE | CHAR | 4 | 0 | Business Transaction Type | * | |
4 | POSTING_DATE | CRMT_POSTING_DATE | DATS | 8 | 0 | Posting Date for a Business Transaction | |||
5 | DESCRIPTION | CRMT_PROCESS_DESCRIPTION | CRM_PROCESS_DESCRIPTION | CHAR | 40 | 0 | Transaction Description | ||
6 | DESCR_LANGUAGE | CRMT_PROCESS_DESCRIPTION_LANGU | SPRAS | LANG | 1 | 0 | Language Key of Description | * | |
7 | LOGICAL_SYSTEM | CRMT_LOGSYS | LOGSYS | CHAR | 10 | 0 | Logical System | * | |
8 | CRM_RELEASE | SAPRELEASE | CHAR10 | CHAR | 10 | 0 | SAP Release | ||
9 | SCENARIO | CRMT_SCENARIO | CRM_SCENARIO | CHAR | 10 | 0 | Scenario Identity | ||
10 | TEMPLATE_TYPE | CRMT_TEMPLATE_TYPE_DB | CRM_TEMPLATE_TYPE | CHAR | 1 | 0 | Template Type of CRM Transaction | ||
11 | .INCLUDE | 0 | 0 | Time and User of Last Transaction Processing | |||||
12 | CREATED_AT | COMT_CREATED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Created At (Output in User Time Zone) | ||
13 | CREATED_BY | CRMT_CREATED_BY | UNAME | CHAR | 12 | 0 | User that Created the Transaction | ||
14 | CHANGED_AT | COMT_CHANGED_AT_USR | COM_TSTMP | DEC | 15 | 0 | Changed At (Output in User Time Zone) | ||
15 | CHANGED_BY | CRMT_CHANGED_BY | UNAME | CHAR | 12 | 0 | Transaction Last Changed By | ||
16 | HEAD_CHANGED_AT | CRMT_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Time of Last Change to the Transaction | ||
17 | .INCLUDE | 0 | 0 | EEW Extension | |||||
18 | ORDERADM_H_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
19 | .INCLUDE | 0 | 0 | ||||||
20 | .INCLU--AP | 0 | 0 | Additional Fields in ORDERADM_H After Decoupling | |||||
21 | INPUT_CHANNEL | CRMT_INPUT_CHANNEL | CRM_INPUT_CHANNEL | CHAR | 3 | 0 | Input channel | ||
22 | BTX_CLASS | CRMT_TRANSACTION_CLASSIFICATN | CRM_TRANSACTION_CLASSIFICATION | CHAR | 1 | 0 | CRM Business Transaction Classification | ||
23 | AUTH_SCOPE | CRM_AUTH_SCOPE | CRM_AUTH_SCOPE | NUMC | 6 | 0 | Authorization Scope | * | |
24 | COMP_TX_HEADER | CRMT_COMP_TX_HEADER_GUID | SYSUUID | RAW | 16 | 0 | GUID of Composite Transaction Header | ||
25 | .INCLUDE | 0 | 0 | General Header Data - Structure of System Fields | |||||
26 | OBJECT_TYPE | CRMT_SUBOBJECT_CATEGORY_DB | CRM_OJ_NAME_PROCESS | CHAR | 10 | 0 | Business Trans. Cat. | * | |
27 | ARCHIVING_FLAG | CRMT_ARCHIVING_FLAG | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator Whether the Business Transaction Can Be Archived | ||
28 | DESCRIPTION_UC | CRMT_PROCESS_DESCRIPTION_UC | CRM_PROCESS_DESCRIPTION_UC | CHAR | 40 | 0 | Transaction Description (Upper Case) | ||
29 | OBJECT_ID_OK | CRMT_OBJECT_ID_OK | CRM_BOOLEAN | CHAR | 1 | 0 | Indicator Whether Business Transaction Number is Correct | ||
30 | VERIFY_DATE | CRMT_VERIFY_DATE | BCOS_TSTMP | DEC | 15 | 0 | Time Period of Last Archiving Attempt | ||
31 | CRM_CHANGED_AT | CRMT_ONLINE_CHANGED_AT | BCOS_TSTMP | DEC | 15 | 0 | Time of Last Change in CRM Online | ||
32 | .INCLUDE | 0 | 0 | One Order: Key Fields | |||||
33 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
34 | GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
35 | .INCLUDE | 0 | 0 | Header Data Opportunity - Structure of External Fields | |||||
36 | EXP_REVENUE | CRMT_REPORT_EXP_REVENUE | WERTV8 | CURR | 15 | 2 | Expected Sales Revenue | ||
37 | BUDGET_BP | CRMT_BUDGET_BP | WERTV8 | CURR | 15 | 2 | Budget Prospect | ||
38 | STARTDATE | CRMT_STARTDATE | DATUM | DATS | 8 | 0 | Opportunity Start Date | ||
39 | EXPECT_END | CRMT_EXPECT_END | DATUM | DATS | 8 | 0 | Expected Closing Date | ||
40 | CURR_PHASE | CRMT_CURR_PHASE | CRM_PHASE | CHAR | 3 | 0 | Sales Stage | CRMC_PHASE | |
41 | PHASE_SINCE | CRMT_PHASE_SINCE | DATUM | DATS | 8 | 0 | Sales Stage Since | ||
42 | PROBABILITY | CRMT_PROBABILITY | CRM_PROBABILITY | NUMC | 3 | 0 | Chance of Success | ||
43 | FORECAST_REL | CRMT_FORECAST_REL | CRM_FORECAST_REL | CHAR | 1 | 0 | Forecast Relevance | ||
44 | SOURCE | CRMT_SOURCE | CRM_SOURCE | CHAR | 3 | 0 | Origin of Opportunity/Lead | CRMC_SOURCE | |
45 | IMPORTANCE | CRMT_IMPORTANCE | CRM_IMPORTANCE | CHAR | 1 | 0 | Opportunity/Lead Priority | CRMC_OPPIMPOR | |
46 | SALESCYCLE | CRMT_SALESCYCLE | CRM_SALESCYCLE | CHAR | 5 | 0 | Sales Cycle | CRMC_CYCLE | |
47 | ADDRESS_NO | CRMT_OPP_ADDRESS | AD_ADDRNUM | CHAR | 10 | 0 | Opportunity Address | * | |
48 | TYPE | CRMT_OPPORT_TYPE | CRM_OPPORT_TYPE | CHAR | 4 | 0 | Opportunity Type | CRMC_OPPT_TYPE | |
49 | STATUS_SINCE | CRMT_STATUS_SINCE | DATUM | DATS | 8 | 0 | Status Since | ||
50 | SYS_PROBABILITY | CRMT_SYSTEM_PROBABILITY | CRM_SYSTEM_PROBABILITY | NUMC | 3 | 0 | Chance of Success of Opportunity - Calculated by System | ||
51 | DESCRIPTION_OPP | CRMT_DESCRIPTION_OPP | TEXT40 | CHAR | 40 | 0 | Opportunity Description | ||
52 | DESCR_OPP_UC | CRMT_DESCRIPTION_OPP_UC | TEXT40 | CHAR | 40 | 0 | Opportunity Description in UC | ||
53 | CUSTOMER_STATUS | CRMT_CUSTSTAT | CRM_CUSTSTAT | CHAR | 4 | 0 | Design Registration Project Phase | * | |
54 | .INCLUDE | 0 | 0 | EEW Include | |||||
55 | OPPORT_H_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
56 | .INCLUDE | 0 | 0 | ||||||
57 | CREATE_DATE | CRMT_RPRTNG_CREATED_AT | CRM_RPRTNG_DATE | DATS | 8 | 0 | CRM Reporting: 'Created on' Date | ||
58 | OPPTYPE_TEXT | CRMT_DESCRIPTION_20 | TEXT20 | CHAR | 20 | 0 | Description (20 Characters) | ||
59 | PHASE_DESCRIPTION | CRMT_DESCRIPTION | TEXT40 | CHAR | 40 | 0 | Description | ||
60 | FCT_DESCRIPTION | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
61 | FCT_SHORT_DESC | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
62 | MAIN_BP_1 | CRMT_RPRTNG_ADDPARTNER | NAME | CHAR | 35 | 0 | Additional Business Partner | ||
63 | MAIN_BP_1_NO | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
64 | MAIN_BP_1_FCT | CRMT_RPRTNG_ADDFUNCTION | CHAR8 | CHAR | 8 | 0 | Role of an Additional Business Partner for Display | ||
65 | MAIN_BP_1_DESC | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
66 | MAIN_BP_1_DESC_S | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
67 | MAIN_BP_1_NAMELIST | AD_LINE_S | CHAR80 | CHAR | 80 | 0 | One-line short form of formatted address | ||
68 | MAIN_BP_2 | CRMT_RPRTNG_ADDPARTNER | NAME | CHAR | 35 | 0 | Additional Business Partner | ||
69 | MAIN_BP_2_NO | CRMT_PARTNER_NO | CRM_PARTNER_NO | CHAR | 32 | 0 | Partner Number | ||
70 | MAIN_BP_2_FCT | CRMT_RPRTNG_ADDFUNCTION | CHAR8 | CHAR | 8 | 0 | Role of an Additional Business Partner for Display | ||
71 | MAIN_BP_2_DESC | CRMT_REPORT_FNKT_LONG | TEXT30 | CHAR | 30 | 0 | Partner Function: Long Text | ||
72 | MAIN_BP_2_DESC_S | CRMT_REPORT_FNKT_SHORT | TEXT4 | CHAR | 4 | 0 | Partner Function: Short Text | ||
73 | MAIN_BP_2_NAMELIST | AD_LINE_S | CHAR80 | CHAR | 80 | 0 | One-line short form of formatted address | ||
74 | STAT | J_STATUS | J_STATUS | CHAR | 5 | 0 | Object status | ||
75 | STATUS | CRMT_REPORT_STATUS_L | CHAR100 | CHAR | 100 | 0 | Longform Status | ||
76 | STATUS_USER_LONG | CRMT_REPORT_STATUS_UL | CHAR100 | CHAR | 100 | 0 | Longform User Status | ||
77 | STATUS_USER | CRMT_REPORT_STATUS_U | CHAR40 | CHAR | 40 | 0 | Shortform Status | ||
78 | CURRENCY | CRMT_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_OPPORTUNITY_ALV | CURR_PHASE | CRMC_PHASE | PHASE | |||
2 | CRMT_OPPORTUNITY_ALV | IMPORTANCE | CRMC_OPPIMPOR | IMPORTANCE | |||
3 | CRMT_OPPORTUNITY_ALV | SALESCYCLE | CRMC_CYCLE | SALESCYCLE | |||
4 | CRMT_OPPORTUNITY_ALV | SOURCE | CRMC_SOURCE | SOURCE | |||
5 | CRMT_OPPORTUNITY_ALV | TYPE | CRMC_OPPT_TYPE | TYPE |
History
Last changed by/on | SAP | 20140802 |
SAP Release Created in |