CRMS4_ACTV_SEARCH

Activity Search | view: CRMS4_ACTVSEARCH | Extraction: Not supported | Component: S4CRM: Reporting
Tables used: CRMS4D_ACTV_H, CRMD_BRELVONAE, CRMS4D_OPPT_H, CRMD_BRELVONAE, CRMS4D_OPPT_H, SKWG_BREL, CRMC_ACT_CAT_T, CRMC_ACT_OBJ_T, SCPRIOT, CRMS4C_STAT_LC_T, CRMC_PROC_TYPE, CRMC_PROC_TYPE_T, BUT000
Column Name Description
object_type FK Business Trans. Cat.
object_id Transaction ID
Column Name Description
Column Name Description
Column Name Description
valid_from null
valid_to null
fromdate null
todate null
from_time null
to_time null
posting_date Posting Date for a Business Transaction
CREATED_ON null
created_at_date null
changed_at_date null
Column Name Description
direction Direction of an Activity Show values
private_flag Indicator: Task is Private Show values
completion Completion Rate in Percent Show values
calendar Include Activity in Calendar Show values
task Indicator: Activity is a Task Show values
class Activity Class Show values
template_type Template Type of CRM Transaction Show values
archiving_flag Indicator Whether the Business Transaction Can Be Archived Show values
object_id_ok Indicator That Transaction ID Is Correct Show values
service_org_ori Origin Indicator: Service Organization Show values
service_orgr_ori Origin Indicator: Service Scenario Organizational Unit Show values
sales_org_ori Origin Indicator: Sales Organization Show values
dis_channel_ori Origin Indicator: Distribution Channel Show values
sales_off_ori Origin Indicator: Sales Office Show values
sales_group_ori Origin Indicator: Sales Group Show values
sales_orgr_ori Origin Indicator: Sales Scenario Organizational Unit Show values
division_ori Origin Flag: Division Show values
stat_lifecycle Life Cycle Status Show values
stat_cancelled Cancellation Status Show values
stat_released Release Status Show values
stat_error Error Status Show values
stat_archivable Archivable Show values
stat_archived Archived Show values
stat_open Status "Open" Show values
Column Name Description Domain name
lead_guid GUID of a CRM Order Object SYSUUID
lead_id Transaction ID CRM_OBJECT_ID
lead_des Transaction Description CRM_PROCESS_DESCRIPTION
lead_des_uc null
oppt_guid GUID of a CRM Order Object SYSUUID
oppt_id Transaction ID CRM_OBJECT_ID
oppt_des Transaction Description CRM_PROCESS_DESCRIPTION
oppt_des_uc null
attachment null
category_txt Description (20 Characters) TEXT20
priority_txt Description TEXT40
objective_txt Description (20 Characters) TEXT20
direction_txt Short Text for Fixed Values DDTEXT
extern_act_id External Business Transaction Number CRM_EXTERNAL_ACTIVITY_ID
act_location Location CRM_ACTIVITY_LOCATION
orderact_from Actual Start BCOS_TSTMP
orderact_to Actual End BCOS_TSTMP
orderplan_from Planned Start BCOS_TSTMP
orderplan_to Planned End BCOS_TSTMP
act_total_from Actual Total Value of Duration TIMEDURA
date_from Start Date TZNTSTMPS
date_to End Date TZNTSTMPS
due_on End Date TZNTSTMPS
header_guid GUID of a CRM Order Object SYSUUID
guid GUID of a CRM Order Object SYSUUID
process_type_txt Description (20 Characters) TEXT20
description Transaction Description CRM_PROCESS_DESCRIPTION
description_uc null
created_at_h Created At (Output in User Time Zone) COM_TSTMP
created_by_h User that Created the Transaction UNAME
created_at Created At (Output in User Time Zone) COM_TSTMP
created_by User that Created the Transaction UNAME
changed_at_h Changed At (Output in User Time Zone) COM_TSTMP
changed_at Changed At (Output in User Time Zone) COM_TSTMP
changed_by_h Transaction Last Changed By UNAME
changed_by Transaction Last Changed By UNAME
head_changed_at Time of Last Change to the Transaction BCOS_TSTMP
verify_date Time Period of Last Archiving Attempt BCOS_TSTMP
sales_org Sales Organization ID HROBJEC_14
sales_office Sales Office HROBJEC_14
sales_group Sales Group HROBJEC_14
sales_org_resp Organizational Unit (Sales) HROBJEC_14
service_org Service Organization HROBJEC_14
service_org_resp Organizational Unit (Service) HROBJEC_14
activity_partner_list null
contact_person_list null
person_resp_list null
INBOX_ASSIGNED_TO_list null
INBOX_GROUP_ASSIGNED_list null
INBOX_ACCOUNT_list null
INBOX_CONTACT_PERSON_list null
stat_lifecycle_desc Short Text for Fixed Values DDTEXT
stat_cancelled_desc Short Text for Fixed Values DDTEXT
stat_released_desc Short Text for Fixed Values DDTEXT
stat_error_desc Short Text for Fixed Values DDTEXT
stat_archivable_desc Short Text for Fixed Values DDTEXT
stat_archived_desc Short Text for Fixed Values DDTEXT
stat_open_desc Short Text for Fixed Values DDTEXT
equipment_id Object key SWO_TYPEID
catlvlguid01_01 Category GUID 1- schema 1 SYSUUID
catlvlguid02_01 Category GUID 2- schema 1 SYSUUID
catlvlguid03_01 Category GUID 3- schema 1 SYSUUID
catlvlguid04_01 Category GUID 4- schema 1 SYSUUID
catlvlguid05_01 Category GUID 5- schema 1 SYSUUID
catlvlguid06_01 Category GUID 6- schema 1 SYSUUID
catlvlguid07_01 Category GUID 7- schema 1 SYSUUID
catlvlguid08_01 Category GUID 8- schema 1 SYSUUID
catlvlguid09_01 Category GUID 9- schema 1 SYSUUID
catlvlguid10_01 Category GUID 10- schema 1 SYSUUID
asp_id_01 Coherent Cat. - Aspect ID CRM_ERMS_CAT_AS_ID_DO
cat_id_01 Coherent Cat. - Aspect ID CRM_ERMS_CAT_AS_ID_DO
Master Data Relations Join Conditions
Activity Partner
  • Activity Partner
  • Client
  • CRMS4_ACTV_SEARCH.ACTIVITY_PARTNER == BUT000.PARTNER
  • CRMS4_ACTV_SEARCH.MANDT == BUT000.CLIENT
Actual Duration Unit of Measure
  • Client
  • Actual Duration Unit of Measure
  • CRMS4_ACTV_SEARCH.MANDT == T006.MANDT
  • CRMS4_ACTV_SEARCH.ACT_TOTAL_UNIT == T006.MSEHI
Location where Activity takes place
  • Location where Activity takes place
  • Client
  • ?
  • ?
  • CRMS4_ACTV_SEARCH.ADDRESS_ID == ADRC.ADDRNUMBER
  • CRMS4_ACTV_SEARCH.MANDT == ADRC.CLIENT
  • CRMS4_ACTV_SEARCH.[column in domain "AD_NATION"] == ADRC.NATION
  • CRMS4_ACTV_SEARCH.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Authorization Scope
  • Authorization Scope
  • Client
  • ?
CRM Business Transaction Classification
  • CRM Business Transaction Classification
  • ?
Activity Category (Communication Type)
  • Activity Category (Communication Type)
  • Client
Customer Contact Person
  • Client
  • Customer Contact Person
  • CRMS4_ACTV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_ACTV_SEARCH.CONTACT_PERSON == BUT000.PARTNER
Language Key of Description
  • Language Key of Description
  • Language Key of Description
  • Language Key of Description
  • CRMS4_ACTV_SEARCH.LEAD_DES_LANGUAGE == T002.SPRAS
  • CRMS4_ACTV_SEARCH.DESCR_LANGUAGE == T002.SPRAS
  • CRMS4_ACTV_SEARCH.OPPT_DES_LANGUAGE == T002.SPRAS
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4_ACTV_SEARCH.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4_ACTV_SEARCH.MANDT == TVTW.MANDT
Division
  • Client
  • Division
  • CRMS4_ACTV_SEARCH.MANDT == TSPA.MANDT
  • CRMS4_ACTV_SEARCH.DIVISION == TSPA.SPART
Sales Partners
  • Client
  • Sales Partners
  • CRMS4_ACTV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_ACTV_SEARCH.INBOX_ACCOUNT == BUT000.PARTNER
Employee Responsible
  • Client
  • Employee Responsible
  • CRMS4_ACTV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_ACTV_SEARCH.INBOX_ASSIGNED_TO == BUT000.PARTNER
Customer Contact Person
  • Client
  • Customer Contact Person
  • CRMS4_ACTV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_ACTV_SEARCH.INBOX_CONTACT_PERSON == BUT000.PARTNER
Responsible Group
  • Responsible Group
  • Client
  • CRMS4_ACTV_SEARCH.INBOX_GROUP_ASSIGNED == BUT000.PARTNER
  • CRMS4_ACTV_SEARCH.MANDT == BUT000.CLIENT
Status of Agent Inbox Item
  • Status of Agent Inbox Item
  • Client
Language Key of Description
  • Language Key of Description
  • Language Key of Description
  • Language Key of Description
  • CRMS4_ACTV_SEARCH.LEAD_DES_LANGUAGE == T002.SPRAS
  • CRMS4_ACTV_SEARCH.DESCR_LANGUAGE == T002.SPRAS
  • CRMS4_ACTV_SEARCH.OPPT_DES_LANGUAGE == T002.SPRAS
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
Goal of an Activity
  • Client
  • Goal of an Activity
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
Language Key of Description
  • Language Key of Description
  • Language Key of Description
  • Language Key of Description
  • CRMS4_ACTV_SEARCH.LEAD_DES_LANGUAGE == T002.SPRAS
  • CRMS4_ACTV_SEARCH.DESCR_LANGUAGE == T002.SPRAS
  • CRMS4_ACTV_SEARCH.OPPT_DES_LANGUAGE == T002.SPRAS
Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
  • Business Trans. Cat.
Employee Responsible
  • Client
  • Employee Responsible
  • CRMS4_ACTV_SEARCH.MANDT == BUT000.CLIENT
  • CRMS4_ACTV_SEARCH.PERSON_RESP == BUT000.PARTNER
Activity Priority
  • Client
  • Activity Priority
  • CRMS4_ACTV_SEARCH.MANDT == SCPRIO.CLIENT
  • CRMS4_ACTV_SEARCH.PRIORITY == SCPRIO.PRIORITY
Business Transaction Type
  • Client
  • Business Transaction Type