crms4_case_search

CRM Case Search | view: CRMS4_CASESEARCH | Extraction: Not supported | Component: S4CRM: Case Management
Column Name Description
CASE_GUID FK Technical Case Key (Case GUID)
Column Name Description
Column Name Description
Column Name Description
PLAN_END_DATE Planned Close Date
Column Name Description
crm_main_partner Main Partner (For Ambiguous Partner Functions) Show values
Column Name Description Domain name
EXT_KEY Case ID SCMG_EXT_KEY
EXT_REF External Reference CHAR30
CREATE_TIME Created On SCMG_TIMESTAMP
CHANGE_TIME Last Changed On SCMG_TIMESTAMP
CLOSING_TIME Closed at Time SCMG_TIMESTAMP
CASE_TITLE Case Title TEXT80
STAT_OBJNR Case: Status Object Number (GUID), (Central Status Managmnt) SYSUUID_C
STAT_LINE Case: System Status Description (Central Status Management) SCMGSTATLINE
STAT_USER_LINE Case: User Status Description (Central Status Management) SCMGSTATLINE
crm_case_title Text Without Upper/Lower Case CHAR80
CRM_SCH_REF_TIME Schema Reference Timestamp - Categories CMG_TIMESTAMP
CRM_BUS_REF_TIME Business Reference Timestamp - Categories CMG_TIMESTAMP
CRM_CATEGORY_ID CRM Case Management - Reference Category ID CRM_ERMS_CAT_CA_ID_DO
crm_schema_id CRM Case Management - Schema ID CRM_ERMS_CAT_AS_ID_DO
category_text Category Description TEXT80
prod_cat_id Product Category COM_CATEGORY_ID
object_type Business Trans. Cat. CRM_OJ_NAME_PROCESS
CRM_OBJECT_ID Transaction ID CRM_OBJECT_ID
CRM_PRODUCT_ID Material Number MATNR
CRM_PARTNER_FCT Partner Function COM_PARTNER_FCT
CRM_PARTNER_NO Partner Number CRM_PARTNER_NO
Master Data Relations Join Conditions
Case Type
  • Case Type
  • Client
Category
  • Category
  • Case Type
  • Client
Last Changed By
  • Last Changed By
  • Client
  • CRMS4_CASE_SEARCH.CHANGED_BY == USR02.BNAME
  • CRMS4_CASE_SEARCH.MANDT == USR02.MANDT
Closed by User
  • Closed by User
  • Client
  • CRMS4_CASE_SEARCH.CLOSED_BY == USR02.BNAME
  • CRMS4_CASE_SEARCH.MANDT == USR02.MANDT
Created By
  • Created By
  • Client
  • CRMS4_CASE_SEARCH.CREATED_BY == USR02.BNAME
  • CRMS4_CASE_SEARCH.MANDT == USR02.MANDT
Reason for Escalation
  • Reason for Escalation
  • Client
Priority
  • Priority
  • Client
Processor
  • Processor
  • Client
  • CRMS4_CASE_SEARCH.PROCESSOR == USR02.BNAME
  • CRMS4_CASE_SEARCH.MANDT == USR02.MANDT
Case: Status Profile
  • Client
  • Case: Status Profile
Reason for Case
  • Reason for Case
  • Case Type
  • Client
Person Responsible
  • Person Responsible
  • Client
  • CRMS4_CASE_SEARCH.RESPONSIBLE == USR02.BNAME
  • CRMS4_CASE_SEARCH.MANDT == USR02.MANDT
Authorization level
  • Client
  • Authorization level
Case: Status
  • Client
  • Case: Status Profile
  • Case: Status
Case: System Status CRMS4_CASE_SEARCH.STAT_PARA == SCMGSTAT.STAT_PARA