CRMT_BSP_CMG_SEARCH SAP (Transfer Structure for Case Management: Search Structure) Structure details
Description: Transfer Structure for Case Management: Search Structure
Related tables to CRMT_BSP_CMG_SEARCH
Access table CRMT_BSP_CMG_SEARCH
Structure field list including key, data, relationships and ABAP select examples
CRMT_BSP_CMG_SEARCH is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Transfer Structure for Case Management: Search Structure" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_CRMT_BSP_CMG_SEARCH TYPE CRMT_BSP_CMG_SEARCH.
The CRMT_BSP_CMG_SEARCH table consists of various fields, each holding specific information or linking keys about Transfer Structure for Case Management: Search Structure data available in SAP. These include PARTNER_FCT (Partner Function), CRM_MAIN_PARTNER (Main Partner (For Ambiguous Partner Functions)), MANDT (Client), CASE_GUID (Technical Case Key (Case GUID)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP CRMT_BSP_CMG_SEARCH structure fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
OBJECT_KEY | Object Key | CRMT_BSP_OBJECTKEY | CHAR | 100 | |||||
PARTNER_FCT | Partner Function | COMT_PARTNER_FCT | CHAR | 8 | COM_PARTNER_FCT | ||||
CRM_MAIN_PARTNER | Main Partner (For Ambiguous Partner Functions) | CRMT_PARTNER_MAIN | CHAR | 1 | CRM_BOOLEAN | ||||
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
CASE_GUID | Technical Case Key (Case GUID) | SCMG_CASE_GUID | CHAR | 32 | Assigned to domain | SYSUUID_C | |||
CASE_TYPE | Case Type | SCMGCASE_TYPE | CHAR | 4 | Assigned to domain | SCMGCASE_TYPE | |||
EXT_KEY | Case ID | SCMG_EXT_KEY | CHAR | 12 | ALPHA | SCMG_EXT_KEY | |||
EXT_REF | External reference | SCMG_EXT_REF | CHAR | 30 | CHAR30 | ||||
CREATED_BY | Created By | SCMG_CREATE_USER | CHAR | 12 | Assigned to domain | XUBNAME | |||
CREATE_TIME | Created On | SCMG_CREATE_TIME | DEC | 15 | TSTPS | SCMG_TIMESTAMP | |||
CHANGED_BY | Last Changed by | SCMG_CHANGE_USER | CHAR | 12 | Assigned to domain | XUBNAME | |||
CHANGE_TIME | Last Changed On | SCMG_CHANGE_TIME | DEC | 15 | TSTPS | SCMG_TIMESTAMP | |||
CLOSED_BY | Closed by User | SCMG_CLOSED_BY | CHAR | 12 | USR02 | XUBNAME | |||
CLOSING_TIME | Closed at Time | SCMG_CLOSING_TIME | DEC | 15 | TSTPS | SCMG_TIMESTAMP | |||
PLAN_END_DATE | Planned Close Date | SCMG_PLAN_END_DATE | DATS | 8 | DATUM | ||||
PROCESSOR | Processor | SCMG_PROCESSOR | CHAR | 12 | Assigned to domain | XUBNAME | USER_ADDR | ||
RESPONSIBLE | Person Responsible | SCMG_RESPONSIBLE | CHAR | 12 | Assigned to domain | XUBNAME | USER_ADDR | ||
CASE_TITLE | Case Title | SCMG_CASE_TITLE | CHAR | 80 | TEXT80 | ||||
ESCAL_REASON | Reason for Escalation | SCMG_ESCAL_REASON | CHAR | 2 | Assigned to domain | CHAR2 | |||
CATEGORY | Category | SCMG_CATEGORY | CHAR | 4 | Assigned to domain | CHAR4 | |||
PRIORITY | Priority | SCMG_PRIORITY | NUMC | 1 | Assigned to domain | NUM01 | |||
SECURE_LEVEL | Authorization level | SCMG_SECURE_LEVEL | CHAR | 1 | SCMGAUT_SECLEVL | CHAR1 | |||
PROFILE_ID | Case: Status Profile | SCMGSTATUSPROFID | CHAR | 8 | SCMGSTATPROF | SCMGPROFID | |||
STAT_ORDERNO | Case: Status | SCMGSTATUSONR | NUMC | 2 | SCMGSTATPROFS | SCMGSTATUSONR | |||
STAT_PARA | Case: System Status | SCMGSTATPARA | CHAR | 3 | Assigned to domain | CHAR03 | |||
STAT_OBJNR | Case: Status Object Number (GUID), (Central Status Managmnt) | SCMGSTATOBJNR | CHAR | 32 | SYSUUID_C | ||||
STAT_LINE | Case: System Status Description (Central Status Management) | SCMGSTATLINE | CHAR | 40 | SCMGSTATLINE | ||||
STAT_USER_LINE | Case: User Status Description (Central Status Management) | SCMGSTATUSERLINE | CHAR | 40 | SCMGSTATLINE | ||||
REASON_CODE | Reason for Case | SCMG_REASON_CODE | CHAR | 4 | Assigned to domain | CHAR4 | |||
CREATE_DATE | Created On | SCMG_CREATE_DATE | DATS | 8 | DATUM | ||||
CHANGE_DATE | Date of Last Change | SCMG_CHANGE_DATE | DATS | 8 | DATUM | ||||
CLOSING_DATE | Closed On | SCMG_CLOSING_DATA | DATS | 8 | DATUM | ||||
PRODUCT_ID | Product ID | COMT_PRODUCT_ID | CHAR | 40 | PRID1 | COM_PRODUCT_ID | COM_PR_COLLECTION | ||
IBASE | IBase: Number of the Installed Base/IBase | IB_IBASE | NUMC | 18 | ALPHA | IB_INSTANCE | IIB | IBIBM | |
IN_OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
INSTANCE | IB: Component (instance) | IB_INSTANCE | NUMC | 18 | ALPHA | IB_INSTANCE | IBC | ||
CLASSIFICATION_ID1 | Classification | CRMT_CMG_CLASS_ITEM | NUMC | 18 | ALPHA | IB_INSTANCE | |||
PARTNER | Business Partner Number | BU_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
OBJECT_ID | Transaction ID | CRMT_OBJECT_ID | CHAR | 10 | ALPHA | CRM_OBJECT_ID | CRM_OBJECT_ID | CRM_ORDER_OBJECT_ID | |
BUAG_ID | Number of the Business Agreement | CRMT_BUAG_ID | CHAR | 12 | ALPHA | CRMT_BUAG_ID | CRM_BUAG | ||
DOC_NO | Contract Accounts Receivable and Payable Document Number | OPBEL_CA | CHAR | 12 | OPBEL_CA | ||||
PYCLS | Category of Payment Information Assigned | PYCLS_CA | CHAR | 2 | |||||
PYKEY | Key for Payment Information Assigned | PYKEY_CA | CHAR | 24 | |||||
PROCESS | Permitted Process for Case Type | SCMGPROCESS | CHAR | 4 | Assigned to domain | SCMGPROCESS | |||
MY_ACTIVITIES | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
MY_CASES | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
MAX_HITS | Counter | NUM03 | NUMC | 3 | NUM03 | ||||
NUM_OF_BP | Counter Field: Number of Business Partners | CRMD_CMG_NUM_OF_BP | CHAR | 6 | CRMD_CMG_NUM | ||||
NUM_OF_PRD | Counter Field: Number of Products | CRMD_CMG_NUM_OF_PRD | CHAR | 6 | |||||
NUM_OF_ACT | Counter Field: Number of Activities | CRMD_CMG_NUM_OF_ACT | CHAR | 6 | CRMD_CMG_NUM | ||||
NUM_OF_ORD | Counter field: Number of Transactions | CRMD_CMG_NUM_OF_ORD | CHAR | 6 | |||||
NUM_OF_DOC | Counter Field: Number of Documents | CRMD_CMG_NUM_OF_DOC | CHAR | 6 | CRMD_CMG_NUM | ||||
NUM_OF_BO | Counter Field: Number of Business Objects | CRMD_CMG_NUM_OF_BO | CHAR | 6 | CRMD_CMG_NUM | ||||
CLOSED_CASES | Boolean Variable (X=True, -=False, Space=Unknown) | BOOLEAN | CHAR | 1 | BOOLEAN | ||||
MY | CRM Case: My (Cases, Favorites, Activities) | CRMD_CMG_MY | CHAR | 1 | CRMD_CMG_MY | ||||
PRODUCT_GUID | Internal Unique ID of Product | COMT_PRODUCT_GUID | RAW | 16 | SYSUUID | ||||
OBJECT_GUID | GUID of a CRM Order Object | CRMT_OBJECT_GUID | RAW | 16 | SYSUUID | ||||
IBASE_GUID | IB: Unique record number | IB_RECNO | CHAR | 22 | SYSUUID_22 | ||||
PARTNER_GUID | Business Partner GUID | BU_PARTNER_GUID | RAW | 16 | SYSUUID | ||||
BUAG_GUID | GUID of Business Agreement in Character Format | CRMT_BUAG_GUID_C | CHAR | 32 | SYSUUID_C | ||||
CREATE_DATE_TO | CRM Case Management: Creation Date To | CRMD_CMG_CREATE_DATE_TO | DATS | 8 | DATUM | ||||
CHANGE_DATE_TO | CRM Case Management: Change Date To | CRMD_CMG_CHANGE_DATE_TO | DATS | 8 | DATUM | ||||
CRM_CASE_TITLE | Text Without Upper/Lower Case | CRMT_CMG_CASE_TITLE_UPPER | CHAR | 80 | CHAR80 | ||||
CRM_SCH_REF_TIME | Schema Reference Timestamp - Categories | CRMT_CMG_SCH_REF_TSTMP | DEC | 15 | TSTPS | CMG_TIMESTAMP | |||
CRM_BUS_REF_TIME | Business Reference Timestamp - Categories | CRMT_CMG_REF_TSTMP | DEC | 15 | TSTPS | CMG_TIMESTAMP | |||
CRM_SCHEMA_ID | CRM Case Management - Schema ID | CRMT_CMG_SCH_ID | CHAR | 40 | CRM_ERMS_CAT_AS_ID_DO | ||||
CRM_CATEGORY_ID | CRM Case Management - Reference Category ID | CRMT_CMG_CAT_ID | CHAR | 40 | CRM_ERMS_CAT_CA_ID_DO | ||||
PROD_CAT_ID | Product Category | CRMT_PROD_HIERARCHY | CHAR | 20 | COM_CATEGORY_ID | COM_CAT_SALES | |||
CATEGORY_TEXT | Category Description | COMT_CATEGORY_TEXT | CHAR | 80 | TEXT80 | ||||
STATPARA_DESCR | Case: System Status Description | SCMGSTATPARA_DESCR | CHAR | 40 | TEXT40 | ||||
PRIO_DESCR | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
ESCAL_DESCR | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
CATEG_DESCR | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
REASON_DESCR | Text Field of Length 60 | TEXT60 | CHAR | 60 | TEXT60 | ||||
CASETYPE_DESCR | Short Text for Case Type | SCMGTYPEDESCR | CHAR | 40 | TEXT40 | ||||
ISMNR | SDB: Symptom Number | ISMNR | CHAR | 12 | Assigned to domain | ALPHA | ISMNR | ISMNR | |
ISLNR | SDB: Solution Number | ISLNR | CHAR | 12 | Assigned to domain | ALPHA | ISLNR | ISLNR | |
CRM_BUS_REF_DATE | CRM Case Management - Business Reference Date | CRMT_CMG_REF_DATE | DATS | 8 | DATUM | ||||
CRM_SCH_REF_DATE | CRM Case Management - Schema Reference Date | CRMT_CMG_SCH_REF_DATE | DATS | 8 | DATUM | ||||
CRM_SCH_REF_TIM | CRM Case Management - Schema Reference Time | CRMT_CMG_SCH_REF_TIME | TIMS | 6 | CMG_TIME | ||||
CRM_INCL_SUBCATEGORIES | Case Search Including Subcategories | CRMT_CMG_INCL_SUBCATEGORIES | CHAR | 1 | CRM_BOOLEAN | ||||
CRM_CAT_LABEL | CRM Case Management - Reference Category Label | CRMT_CMG_CAT_LABEL | CHAR | 50 | CRM_ERMS_CAT_DESC_DO | ||||
PROFILID_STATUS | User Status | CRMT_CMGPROFILSTATUS | CHAR | 11 | CHAR11 | ||||
PROFILID_STATUS_DESCR | Description of User Status | CRMT_CMGPROFSTATDESCR | CHAR | 41 | CHAR41 | ||||
OBJECT_TYPE | Object type | OJ_NAME | CHAR | 10 | Assigned to domain | OJ_NAME | |||
PROCESSOR_BUPA | Case Man.: Partner Number of Processed Business Partner | CRMD_CMG_PROCESSOR_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
RESPONSIBLE_BUPA | Case Man.: Partner Number of Responsible Business Partner | CRMD_CMG_RESPONSIBLE_PARTNER | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | BPA | BUPA |
PROCESSOR_TEXT | Case Management: Short Description of Processing Bus.Partner | CRMD_CMG_PROCESSOR_BUPA | CHAR | 50 | BU_TEXT50 | ||||
RESPONSIBLE_TEXT | Case Management: Short Description of Owner Business Partner | CRMD_CMG_RESPONSIBLE_BUPA | CHAR | 50 | BU_TEXT50 |
Key field | Non-key field |
How do I retrieve data from SAP structure CRMT_BSP_CMG_SEARCH using ABAP code?
As CRMT_BSP_CMG_SEARCH is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on CRMT_BSP_CMG_SEARCH as there is no data to select.How to access SAP table CRMT_BSP_CMG_SEARCH
Within an ECC or HANA version of SAP you can also view further information about CRMT_BSP_CMG_SEARCH and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects