SAP ABAP Table CRMT_CMG_SELPARA (CRM Case: Selection Parameters)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-CM (Application Component) Case Management
⤷ CRM_CMG_GENERAL (Package) Case Management: General Components
⤷ CRM-CM (Application Component) Case Management
⤷ CRM_CMG_GENERAL (Package) Case Management: General Components
Basic Data
Table Category | INTTAB | Structure |
Structure | CRMT_CMG_SELPARA | Table Relationship Diagram |
Short Description | CRM Case: Selection Parameters |
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 | CRM Case: Include for Partner Function Search | |||||
2 | PARTNER_FCT | COMT_PARTNER_FCT | COM_PARTNER_FCT | CHAR | 8 | 0 | Partner Function | ||
3 | CRM_MAIN_PARTNER | CRMT_PARTNER_MAIN | CRM_BOOLEAN | CHAR | 1 | 0 | Main Partner (For Ambiguous Partner Functions) | ||
4 | .INCLUDE | 0 | 0 | Case Attributes | |||||
5 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
6 | CASE_GUID | SCMG_CASE_GUID | SYSUUID_C | CHAR | 32 | 0 | Technical Case Key (Case GUID) | SCMG_T_CASE | |
7 | .INCLUDE | 0 | 0 | Case Attributes | |||||
8 | CASE_TYPE | SCMGCASE_TYPE | SCMGCASE_TYPE | CHAR | 4 | 0 | Case Type | SCMGCASETYPE | |
9 | EXT_KEY | SCMG_EXT_KEY | SCMG_EXT_KEY | CHAR | 12 | 0 | Case ID | ||
10 | EXT_REF | SCMG_EXT_REF | CHAR30 | CHAR | 30 | 0 | External reference | ||
11 | CREATED_BY | SCMG_CREATE_USER | XUBNAME | CHAR | 12 | 0 | Created By | USR02 | |
12 | CREATE_TIME | SCMG_CREATE_TIME | SCMG_TIMESTAMP | DEC | 15 | 0 | Created On | ||
13 | CHANGED_BY | SCMG_CHANGE_USER | XUBNAME | CHAR | 12 | 0 | Last Changed by | USR02 | |
14 | CHANGE_TIME | SCMG_CHANGE_TIME | SCMG_TIMESTAMP | DEC | 15 | 0 | Last Changed On | ||
15 | CLOSED_BY | SCMG_CLOSED_BY | XUBNAME | CHAR | 12 | 0 | Closed by User | USR02 | |
16 | CLOSING_TIME | SCMG_CLOSING_TIME | SCMG_TIMESTAMP | DEC | 15 | 0 | Closed at Time | ||
17 | PLAN_END_DATE | SCMG_PLAN_END_DATE | DATUM | DATS | 8 | 0 | Planned Close Date | ||
18 | PROCESSOR | SCMG_PROCESSOR | XUBNAME | CHAR | 12 | 0 | Processor | USR02 | |
19 | RESPONSIBLE | SCMG_RESPONSIBLE | XUBNAME | CHAR | 12 | 0 | Person Responsible | USR02 | |
20 | CASE_TITLE | SCMG_CASE_TITLE | TEXT80 | CHAR | 80 | 0 | Case Title | ||
21 | ESCAL_REASON | SCMG_ESCAL_REASON | CHAR2 | CHAR | 2 | 0 | Reason for Escalation | SCMGATTR_SESCAL | |
22 | CATEGORY | SCMG_CATEGORY | CHAR4 | CHAR | 4 | 0 | Category | SCMGATTR_CATEGO | |
23 | PRIORITY | SCMG_PRIORITY | NUM01 | NUMC | 1 | 0 | Priority | SCMGATTR_PRIO | |
24 | SECURE_LEVEL | SCMG_SECURE_LEVEL | CHAR1 | CHAR | 1 | 0 | Authorization level | SCMGAUT_SECLEVL | |
25 | PROFILE_ID | SCMGSTATUSPROFID | SCMGPROFID | CHAR | 8 | 0 | Case: Status Profile | SCMGSTATPROF | |
26 | STAT_ORDERNO | SCMGSTATUSONR | SCMGSTATUSONR | NUMC | 2 | 0 | Case: Status | SCMGSTATPROFS | |
27 | STAT_PARA | SCMGSTATPARA | CHAR03 | CHAR | 3 | 0 | Case: System Status | SCMGSTAT | |
28 | STAT_OBJNR | SCMGSTATOBJNR | SYSUUID_C | CHAR | 32 | 0 | Case: Status Object Number (GUID), (Central Status Managmnt) | ||
29 | STAT_LINE | SCMGSTATLINE | SCMGSTATLINE | CHAR | 40 | 0 | Case: System Status Description (Central Status Management) | ||
30 | STAT_USER_LINE | SCMGSTATUSERLINE | SCMGSTATLINE | CHAR | 40 | 0 | Case: User Status Description (Central Status Management) | ||
31 | REASON_CODE | SCMG_REASON_CODE | CHAR4 | CHAR | 4 | 0 | Reason for Case | SCMGATTR_REASON | |
32 | CREATE_DATE | SCMG_CREATE_DATE | DATUM | DATS | 8 | 0 | Created On | ||
33 | CHANGE_DATE | SCMG_CHANGE_DATE | DATUM | DATS | 8 | 0 | Date of Last Change | ||
34 | CLOSING_DATE | SCMG_CLOSING_DATA | DATUM | DATS | 8 | 0 | Closed On | ||
35 | PRODUCT_ID | COMT_PRODUCT_ID | COM_PRODUCT_ID | CHAR | 40 | 0 | Product ID | ||
36 | IBASE | IB_IBASE | IB_INSTANCE | NUMC | 18 | 0 | IBase: Number of the Installed Base/IBase | ||
37 | IN_OBJNR | J_OBJNR | J_OBJNR | CHAR | 22 | 0 | Object number | * | |
38 | INSTANCE | IB_INSTANCE | IB_INSTANCE | NUMC | 18 | 0 | IB: Component (instance) | ||
39 | CLASSIFICATION_ID1 | CRMT_CMG_CLASS_ITEM | IB_INSTANCE | NUMC | 18 | 0 | Classification | ||
40 | PARTNER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
41 | OBJECT_ID | CRMT_OBJECT_ID | CRM_OBJECT_ID | CHAR | 10 | 0 | Transaction ID | ||
42 | BUAG_ID | CRMT_BUAG_ID | CRMT_BUAG_ID | CHAR | 12 | 0 | Number of Business Agreement | ||
43 | DOC_NO | OPBEL_CA | OPBEL_CA | CHAR | 12 | 0 | Contract Accounts Receivable and Payable Document Number | ||
44 | PYCLS | PYCLS_CA | CHAR | 2 | 0 | Category of Payment Information Assigned | |||
45 | PYKEY | PYKEY_CA | CHAR | 24 | 0 | Key for Payment Information Assigned | |||
46 | PROCESS | SCMGPROCESS | SCMGPROCESS | CHAR | 4 | 0 | Permitted Process for Case Type | * | |
47 | MY_ACTIVITIES | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
48 | MY_CASES | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
49 | MAX_HITS | NUM03 | NUM03 | NUMC | 3 | 0 | Counter | ||
50 | NUM_OF_BP | CRMD_CMG_NUM_OF_BP | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter Field: Number of Business Partners | ||
51 | NUM_OF_PRD | CRMD_CMG_NUM_OF_PRD | CHAR | 6 | 0 | Counter Field: Number of Products | |||
52 | NUM_OF_ACT | CRMD_CMG_NUM_OF_ACT | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter Field: Number of Activities | ||
53 | NUM_OF_ORD | CRMD_CMG_NUM_OF_ORD | CHAR | 6 | 0 | Counter field: Number of Transactions | |||
54 | NUM_OF_DOC | CRMD_CMG_NUM_OF_DOC | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter Field: Number of Documents | ||
55 | NUM_OF_BO | CRMD_CMG_NUM_OF_BO | CRMD_CMG_NUM | CHAR | 6 | 0 | Counter Field: Number of Business Objects | ||
56 | CLOSED_CASES | BOOLEAN | BOOLEAN | CHAR | 1 | 0 | Boolean Variable (X=True, -=False, Space=Unknown) | ||
57 | MY | CRMD_CMG_MY | CRMD_CMG_MY | CHAR | 1 | 0 | CRM Case: My (Cases, Favorites, Activities) | ||
58 | PRODUCT_GUID | COMT_PRODUCT_GUID | SYSUUID | RAW | 16 | 0 | Internal Unique ID of Product | ||
59 | OBJECT_GUID | CRMT_OBJECT_GUID | SYSUUID | RAW | 16 | 0 | GUID of a CRM Order Object | ||
60 | IBASE_GUID | IB_RECNO | SYSUUID_22 | CHAR | 22 | 0 | IB: Unique record number | ||
61 | PARTNER_GUID | BU_PARTNER_GUID | SYSUUID | RAW | 16 | 0 | Business Partner GUID | ||
62 | BUAG_GUID | CRMT_BUAG_GUID_C | SYSUUID_C | CHAR | 32 | 0 | GUID of Business Agreement in Character Format | ||
63 | CREATE_DATE_TO | CRMD_CMG_CREATE_DATE_TO | DATUM | DATS | 8 | 0 | CRM Case Management: Creation Date To | ||
64 | CHANGE_DATE_TO | CRMD_CMG_CHANGE_DATE_TO | DATUM | DATS | 8 | 0 | CRM Case Management: Change Date To | ||
65 | .INCLUDE | 0 | 0 | Include for CRM-Specific Case Attributes(SAP, IBU and Cust.) | |||||
66 | CRM_CASE_TITLE | CRMT_CMG_CASE_TITLE_UPPER | CHAR80 | CHAR | 80 | 0 | Text Without Upper/Lower Case | ||
67 | CRM_SCH_REF_TIME | CRMT_CMG_SCH_REF_TSTMP | CMG_TIMESTAMP | DEC | 15 | 0 | Schema Reference Timestamp - Categories | ||
68 | CRM_BUS_REF_TIME | CRMT_CMG_REF_TSTMP | CMG_TIMESTAMP | DEC | 15 | 0 | Business Reference Timestamp - Categories | ||
69 | CRM_SCHEMA_ID | CRMT_CMG_SCH_ID | CRM_ERMS_CAT_AS_ID_DO | CHAR | 40 | 0 | CRM Case Management - Schema ID | ||
70 | CRM_CATEGORY_ID | CRMT_CMG_CAT_ID | CRM_ERMS_CAT_CA_ID_DO | CHAR | 40 | 0 | CRM Case Management - Reference Category ID | ||
71 | .INCLUDE | 0 | 0 | ||||||
72 | .INCLUDE | 0 | 0 | ||||||
73 | .INCLUDE | 0 | 0 | ||||||
74 | .INCLUDE | 0 | 0 | ||||||
75 | .INCLUDE | 0 | 0 | ||||||
76 | .INCLUDE | 0 | 0 | ||||||
77 | .INCLUDE | 0 | 0 | FS-Specific Case Attributes | |||||
78 | PROD_CAT_ID | CRMT_PROD_HIERARCHY | COM_CATEGORY_ID | CHAR | 20 | 0 | Product Category | ||
79 | CATEGORY_TEXT | COMT_CATEGORY_TEXT | TEXT80 | CHAR | 80 | 0 | Category Description | ||
80 | .INCLUDE | 0 | 0 | Include for Customer Includes used by Standard Case | |||||
81 | CMG_EEW_DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 | ||
82 | .INCLUDE | 0 | 0 | ||||||
83 | .INCLUDE | 0 | 0 | ||||||
84 | STATPARA_DESCR | SCMGSTATPARA_DESCR | TEXT40 | CHAR | 40 | 0 | Case: System Status Description | ||
85 | STAT_ORDNO_DESCR | SCMGSTAT_DESCR | SCMGSTAT_DESCR | CHAR | 40 | 0 | Case: Status Description | ||
86 | PRIO_DESCR | TEXT40 | TEXT40 | CHAR | 40 | 0 | Text, 40 Characters Long | ||
87 | ESCAL_DESCR | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
88 | CATEG_DESCR | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
89 | REASON_DESCR | TEXT60 | TEXT60 | CHAR | 60 | 0 | Text Field of Length 60 | ||
90 | CASETYPE_DESCR | SCMGTYPEDESCR | TEXT40 | CHAR | 40 | 0 | Short Text for Case Type | ||
91 | ISMNR | ISMNR | ISMNR | CHAR | 12 | 0 | Number of Problem Record | * | |
92 | ISLNR | ISLNR | ISLNR | CHAR | 12 | 0 | Number of Solution Record | * | |
93 | CRM_BUS_REF_DATE | CRMT_CMG_REF_DATE | DATUM | DATS | 8 | 0 | CRM Case Management - Business Reference Date | ||
94 | CRM_SCH_REF_DATE | CRMT_CMG_SCH_REF_DATE | DATUM | DATS | 8 | 0 | CRM Case Management - Schema Reference Date | ||
95 | CRM_SCH_REF_TIM | CRMT_CMG_SCH_REF_TIME | CMG_TIME | TIMS | 6 | 0 | CRM Case Management - Schema Reference Time | ||
96 | CRM_INCL_SUBCATEGORIES | CRMT_CMG_INCL_SUBCATEGORIES | CRM_BOOLEAN | CHAR | 1 | 0 | Case Search Including Subcategories | ||
97 | CRM_CAT_LABEL | CRMT_CMG_CAT_LABEL | CRM_ERMS_CAT_DESC_DO | CHAR | 50 | 0 | CRM Case Management - Reference Category Label | ||
98 | PROFILID_STATUS | CRMT_CMGPROFILSTATUS | CHAR11 | CHAR | 11 | 0 | User Status | ||
99 | PROFILID_STATUS_DESCR | CRMT_CMGPROFSTATDESCR | CHAR41 | CHAR | 41 | 0 | Description of User Status | ||
100 | OBJECT_TYPE | OJ_NAME | OJ_NAME | CHAR | 10 | 0 | Object type | * | |
101 | PARTNER_FCT_MAIN | COMT_PARTNER_FCT | COM_PARTNER_FCT | CHAR | 8 | 0 | Partner Function | ||
102 | ORG_UNIT | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
103 | PROCESSOR_DESCR | CRMD_CMG_PROCESSOR_BUPA | BU_TEXT50 | CHAR | 50 | 0 | Case Management: Short Description of Processing Bus.Partner | ||
104 | RESPONSIBLE_DESCR | CRMD_CMG_RESPONSIBLE_BUPA | BU_TEXT50 | CHAR | 50 | 0 | Case Management: Short Description of Owner Business Partner | ||
105 | ORG_UNIT_DESCRP | BU_NAMEOR1 | BU_NAME | CHAR | 40 | 0 | Name 1 of organization | ||
106 | PARENT_CASE | SCMG_EXT_KEY | SCMG_EXT_KEY | CHAR | 12 | 0 | Case ID | ||
107 | PARENT_CASE_TITLE | SCMG_CASE_TITLE | TEXT80 | CHAR | 80 | 0 | Case Title | ||
108 | QUERY_IC | CRM_BOOLEAN | CRMD_BOOLEAN | CHAR | 1 | 0 | Data element to simulate bool: 'X' is true and ' ' is false | ||
109 | IC_EMPL_ASSIGNED | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
110 | IC_EMPL_ASSIGNED_DESCRP | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
111 | IC_GROUP_ASSIGNED | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
112 | IC_GROUP_ASSIGNED_DESCRP | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
113 | IC_CUSTOMER | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
114 | IC_CUSTOMER_DESCRP | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner | ||
115 | IC_CONTACT_PERSON | BU_PARTNER | BU_PARTNER | CHAR | 10 | 0 | Business Partner Number | * | |
116 | IC_CONTACT_PERSON_DESCRP | BU_DESCRIP | BU_TEXT50 | CHAR | 50 | 0 | Short name of business partner |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | CRMT_CMG_SELPARA | CASE_GUID | SCMG_T_CASE | CASE_GUID | KEY | 1 | 1 |
2 | CRMT_CMG_SELPARA | CASE_TYPE | SCMGCASETYPE | CASE_TYPE | KEY | ||
3 | CRMT_CMG_SELPARA | CATEGORY | SCMGATTR_CATEGO | CATEGORY | KEY | ||
4 | CRMT_CMG_SELPARA | CHANGED_BY | USR02 | BNAME | |||
5 | CRMT_CMG_SELPARA | CLOSED_BY | USR02 | BNAME | |||
6 | CRMT_CMG_SELPARA | CREATED_BY | USR02 | BNAME | |||
7 | CRMT_CMG_SELPARA | ESCAL_REASON | SCMGATTR_SESCAL | ESCAL_REASON | |||
8 | CRMT_CMG_SELPARA | PRIORITY | SCMGATTR_PRIO | PRIORITY | KEY | ||
9 | CRMT_CMG_SELPARA | PROCESSOR | USR02 | BNAME | |||
10 | CRMT_CMG_SELPARA | PROFILE_ID | SCMGSTATPROF | PROFILE_ID | KEY | 1 | N |
11 | CRMT_CMG_SELPARA | REASON_CODE | SCMGATTR_REASON | REASON_CODE | KEY | ||
12 | CRMT_CMG_SELPARA | RESPONSIBLE | USR02 | BNAME | |||
13 | CRMT_CMG_SELPARA | SECURE_LEVEL | SCMGAUT_SECLEVL | SECURE_LEVEL | KEY | ||
14 | CRMT_CMG_SELPARA | STAT_ORDERNO | SCMGSTATPROFS | STAT_ORDERNO | KEY | 1 | N |
15 | CRMT_CMG_SELPARA | STAT_PARA | SCMGSTAT | STAT_PARA | KEY | 1 | N |
History
Last changed by/on | SAP | 20141013 |
SAP Release Created in | 400 |