SAP ABAP Table CRMT_BSP_CMG_RESULT (Transfer Structure for Case Management: Search Results)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-CM (Application Component) Case Management
⤷ CRM_BSP_MODEL_IL_CMG (Package) Model Implementation: Case Management
⤷ CRM-CM (Application Component) Case Management
⤷ CRM_BSP_MODEL_IL_CMG (Package) Model Implementation: Case Management
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_BSP_CMG_RESULT | Table Relationship Diagram |
Short Description | Transfer Structure for Case Management: Search Results |
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 | OBJECT_KEY | CRMT_BSP_OBJECTKEY | CHAR | 100 | 0 | Object Key | |||
2 | .INCLUDE | 0 | 0 | Case Attributes | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
4 | CASE_GUID | SCMG_CASE_GUID | SYSUUID_C | CHAR | 32 | 0 | Technical Case Key (Case GUID) | SCMG_T_CASE | |
5 | .INCLUDE | 0 | 0 | Case Attributes | |||||
6 | CASE_TYPE | SCMGCASE_TYPE | SCMGCASE_TYPE | CHAR | 4 | 0 | Case Type | SCMGCASETYPE | |
7 | EXT_KEY | SCMG_EXT_KEY | SCMG_EXT_KEY | CHAR | 12 | 0 | Case ID | ||
8 | EXT_REF | SCMG_EXT_REF | CHAR30 | CHAR | 30 | 0 | External reference | ||
9 | CREATED_BY | SCMG_CREATE_USER | XUBNAME | CHAR | 12 | 0 | Created By | USR02 | |
10 | CREATE_TIME | SCMG_CREATE_TIME | SCMG_TIMESTAMP | DEC | 15 | 0 | Created On | ||
11 | CHANGED_BY | SCMG_CHANGE_USER | XUBNAME | CHAR | 12 | 0 | Last Changed by | USR02 | |
12 | CHANGE_TIME | SCMG_CHANGE_TIME | SCMG_TIMESTAMP | DEC | 15 | 0 | Last Changed On | ||
13 | CLOSED_BY | SCMG_CLOSED_BY | XUBNAME | CHAR | 12 | 0 | Closed by User | USR02 | |
14 | CLOSING_TIME | SCMG_CLOSING_TIME | SCMG_TIMESTAMP | DEC | 15 | 0 | Closed at Time | ||
15 | PLAN_END_DATE | SCMG_PLAN_END_DATE | DATUM | DATS | 8 | 0 | Planned Close Date | ||
16 | PROCESSOR | SCMG_PROCESSOR | XUBNAME | CHAR | 12 | 0 | Processor | USR02 | |
17 | RESPONSIBLE | SCMG_RESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | USR02 | |
18 | CASE_TITLE | SCMG_CASE_TITLE | TEXT80 | CHAR | 80 | 0 | Case Title | ||
19 | ESCAL_REASON | SCMG_ESCAL_REASON | CHAR2 | CHAR | 2 | 0 | Reason for Escalation | SCMGATTR_SESCAL | |
20 | CATEGORY | SCMG_CATEGORY | CHAR4 | CHAR | 4 | 0 | Category | SCMGATTR_CATEGO | |
21 | PRIORITY | SCMG_PRIORITY | NUM01 | NUMC | 1 | 0 | Priority | SCMGATTR_PRIO | |
22 | SECURE_LEVEL | SCMG_SECURE_LEVEL | CHAR1 | CHAR | 1 | 0 | Authorization level | SCMGAUT_SECLEVL | |
23 | PROFILE_ID | SCMGSTATUSPROFID | SCMGPROFID | CHAR | 8 | 0 | Case: Status Profile | SCMGSTATPROF | |
24 | STAT_ORDERNO | SCMGSTATUSONR | SCMGSTATUSONR | NUMC | 2 | 0 | Case: Status | SCMGSTATPROFS | |
25 | STAT_PARA | SCMGSTATPARA | CHAR03 | CHAR | 3 | 0 | Case: System Status | SCMGSTAT | |
26 | STAT_OBJNR | SCMGSTATOBJNR | SYSUUID_C | CHAR | 32 | 0 | Case: Status Object Number (GUID), (Central Status Managmnt) | ||
27 | STAT_LINE | SCMGSTATLINE | SCMGSTATLINE | CHAR | 40 | 0 | Case: System Status Description (Central Status Management) | ||
28 | STAT_USER_LINE | SCMGSTATUSERLINE | SCMGSTATLINE | CHAR | 40 | 0 | Case: User Status Description (Central Status Management) | ||
29 | REASON_CODE | SCMG_REASON_CODE | CHAR4 | CHAR | 4 | 0 | Reason for Case | SCMGATTR_REASON | |
30 | CREATE_DATE | SCMG_CREATE_DATE | DATUM | DATS | 8 | 0 | Created On | ||
31 | CHANGE_DATE | SCMG_CHANGE_DATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
32 | CLOSING_DATE | SCMG_CLOSING_DATA | DATUM | DATS | 8 | 0 | Closed On | ||
33 | NUM_OF_BP | CRMD_CMG_NUM_OF_BP | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter Field: Number of Business Partners | ||
34 | NUM_OF_PRD | CRMD_CMG_NUM_OF_PRD | CHAR | 6 | 0 | Counter Field: Number of Products | |||
35 | NUM_OF_ACT | CRMD_CMG_NUM_OF_ACT | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter Field: Number of Activities | ||
36 | NUM_OF_DOC | CRMD_CMG_NUM_OF_DOC | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter Field: Number of Documents | ||
37 | NUM_OF_BO | CRMD_CMG_NUM_OF_BO | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter Field: Number of Business Objects | ||
38 | NUM_OF_1O | CRMD_CMG_NUM_OF_1O | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter: Number of Transactions | ||
39 | CRM_SCH_REF_DATE | CRMT_CMG_SCH_REF_DATE | DATUM | DATS | 8 | 0 | CRM Case Management - Schema Reference Date | ||
40 | CRM_SCH_REF_TIM | CRMT_CMG_SCH_REF_TIME | CMG_TIME | TIMS | 6 | 0 | CRM Case Management - Schema Reference Time | ||
41 | CRM_CAT_LABEL | CRMT_CMG_CAT_LABEL | CRM_ERMS_CAT_DESC_DO | CHAR | 50 | 0 | CRM Case Management - Reference Category Label | ||
42 | CRM_BUS_REF_DATE | CRMT_CMG_REF_DATE | DATUM | DATS | 8 | 0 | CRM Case Management - Business Reference Date | ||
43 | .INCLUDE | 0 | 0 | Case Management: Internal Bus. Partner (Processor, Owner) | |||||
44 | PROCESSOR_BUPA | CRMD_CMG_PROCESSOR_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Case Man.: Partner Number of Processed Business Partner | * | |
45 | RESPONSIBLE_BUPA | CRMD_CMG_RESPONSIBLE_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Case Man.: Partner Number of Responsible Business Partner | * | |
46 | PROCESSOR_TEXT | CRMD_CMG_PROCESSOR_BUPA | BU_TEXT50 | CHAR | 50 | 0 | Case Management: Short Description of Processing Bus.Partner | ||
47 | RESPONSIBLE_TEXT | CRMD_CMG_RESPONSIBLE_BUPA | BU_TEXT50 | CHAR | 50 | 0 | Case Management: Short Description of Owner Business Partner | ||
48 | .INCLUDE | 0 | 0 | Include for CRM-Specific Case Attributes(SAP, IBU and Cust.) | |||||
49 | CRM_CASE_TITLE | CRMT_CMG_CASE_TITLE_UPPER | CHAR80 | CHAR | 80 | 0 | Text Without Upper/Lower Case | ||
50 | CRM_SCH_REF_TIME | CRMT_CMG_SCH_REF_TSTMP | CMG_TIMESTAMP | DEC | 15 | 0 | Schema Reference Timestamp - Categories | ||
51 | CRM_BUS_REF_TIME | CRMT_CMG_REF_TSTMP | CMG_TIMESTAMP | DEC | 15 | 0 | Business Reference Timestamp - Categories | ||
52 | CRM_SCHEMA_ID | CRMT_CMG_SCH_ID | CRM_ERMS_CAT_AS_ID_DO | CHAR | 40 | 0 | CRM Case Management - Schema ID | ||
53 | CRM_CATEGORY_ID | CRMT_CMG_CAT_ID | CRM_ERMS_CAT_CA_ID_DO | CHAR | 40 | 0 | CRM Case Management - Reference Category ID | ||
54 | .INCLUDE | 0 | 0 | ||||||
55 | .INCLUDE | 0 | 0 | ||||||
56 | .INCLUDE | 0 | 0 | ||||||
57 | .INCLUDE | 0 | 0 | ||||||
58 | .INCLUDE | 0 | 0 | ||||||
59 | .INCLUDE | 0 | 0 | ||||||
60 | .INCLUDE | 0 | 0 | FS-Specific Case Attributes | |||||
61 | PROD_CAT_ID | CRMT_PROD_HIERARCHY | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category | ||
62 | CATEGORY_TEXT | COMT_CATEGORY_TEXT | TEXT80 | CHAR | 80 | 0 | Category Description | ||
63 | .INCLUDE | 0 | 0 | Include for Customer Includes used by Standard Case | |||||
64 | CMG_EEW_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
65 | .INCLUDE | 0 | 0 | ||||||
66 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_BSP_CMG_RESULT | CASE_GUID | SCMG_T_CASE | CASE_GUID | KEY | 1 | 1 |
2 | CRMT_BSP_CMG_RESULT | CASE_TYPE | SCMGCASETYPE | CASE_TYPE | KEY | ||
3 | CRMT_BSP_CMG_RESULT | CATEGORY | SCMGATTR_CATEGO | CATEGORY | KEY | ||
4 | CRMT_BSP_CMG_RESULT | CHANGED_BY | USR02 | BNAME | |||
5 | CRMT_BSP_CMG_RESULT | CLOSED_BY | USR02 | BNAME | |||
6 | CRMT_BSP_CMG_RESULT | CREATED_BY | USR02 | BNAME | |||
7 | CRMT_BSP_CMG_RESULT | ESCAL_REASON | SCMGATTR_SESCAL | ESCAL_REASON | |||
8 | CRMT_BSP_CMG_RESULT | PRIORITY | SCMGATTR_PRIO | PRIORITY | KEY | ||
9 | CRMT_BSP_CMG_RESULT | PROCESSOR | USR02 | BNAME | |||
10 | CRMT_BSP_CMG_RESULT | PROFILE_ID | SCMGSTATPROF | PROFILE_ID | KEY | 1 | N |
11 | CRMT_BSP_CMG_RESULT | REASON_CODE | SCMGATTR_REASON | REASON_CODE | KEY | ||
12 | CRMT_BSP_CMG_RESULT | RESPONSIBLE | USR02 | BNAME | |||
13 | CRMT_BSP_CMG_RESULT | SECURE_LEVEL | SCMGAUT_SECLEVL | SECURE_LEVEL | KEY | ||
14 | CRMT_BSP_CMG_RESULT | STAT_ORDERNO | SCMGSTATPROFS | STAT_ORDERNO | KEY | 1 | N |
15 | CRMT_BSP_CMG_RESULT | STAT_PARA | SCMGSTAT | STAT_PARA | KEY | 1 | N |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 400 |