CRMS4D_ACTV_H

Activity Header: Header transaction data | #header | Component: S4CRM: Business Transaction Framework
Column Name Description
CLIENT FK Client
OBJTYPE_H FK Business Trans. Cat.
OBJECT_ID Transaction ID
Column Name Description
Column Name Description
Column Name Description
POSTING_DATE Posting Date for a Business Transaction
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
SDM_STATUS_DURA SDM status of duration migration 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
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
HEADER_GUID GUID of a CRM Order Object SYSUUID
DESCRIPTION_H Transaction Description CRM_PROCESS_DESCRIPTION
CREATED_AT_H Created At (Output in User Time Zone) COM_TSTMP
CREATED_BY_H User that Created the Transaction UNAME
CHANGED_AT_H Changed At (Output in User Time Zone) COM_TSTMP
CHANGED_BY_H 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
HEADER_GUID_CHAR 32 Character CRM Object GUID (Converted)
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
SALES_ORG_SD Sales Organization VKORG
SALES_OFFICE_SD Sales office VKBUR
SALES_GROUP_SD Sales group VKGRP
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
ACTV_H_DUMMY_PS Single-Character Flag CHAR1
Master Data Relations Join Conditions
Activity Partner
  • Activity Partner
  • Client
  • CRMS4D_ACTV_H.ACTIVITY_PARTNER == BUT000.PARTNER
  • CRMS4D_ACTV_H.CLIENT == BUT000.CLIENT
Actual Duration Unit of Measure
  • CRMS4D_ACTV_H.CLIENT == T006.MANDT
  • CRMS4D_ACTV_H.ACT_TOTAL_UNIT == T006.MSEHI
Location where Activity takes place
  • Location where Activity takes place
  • ?
  • ?
  • CRMS4D_ACTV_H.CLIENT == ADRC.CLIENT
  • CRMS4D_ACTV_H.ADDRESS_ID == ADRC.ADDRNUMBER
  • CRMS4D_ACTV_H.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • CRMS4D_ACTV_H.[column in domain "AD_NATION"] == ADRC.NATION
Authorization Scope
  • ?
  • Authorization Scope
CRM Business Transaction Classification
  • CRM Business Transaction Classification
  • ?
Activity Category (Communication Type)
Client CRMS4D_ACTV_H.CLIENT == T000.MANDT
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4D_ACTV_H.CONTACT_PERSON == BUT000.PARTNER
  • CRMS4D_ACTV_H.CLIENT == BUT000.CLIENT
Language Key of Description CRMS4D_ACTV_H.DESCR_LANGUAGE == T002.SPRAS
Distribution Channel
  • Distribution Channel
  • Client
  • CRMS4D_ACTV_H.DIS_CHANNEL == TVTW.VTWEG
  • CRMS4D_ACTV_H.CLIENT == TVTW.MANDT
Division
  • CRMS4D_ACTV_H.CLIENT == TSPA.MANDT
  • CRMS4D_ACTV_H.DIVISION == TSPA.SPART
Sales Partners
  • Sales Partners
  • Client
  • CRMS4D_ACTV_H.INBOX_ACCOUNT == BUT000.PARTNER
  • CRMS4D_ACTV_H.CLIENT == BUT000.CLIENT
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4D_ACTV_H.INBOX_ASSIGNED_TO == BUT000.PARTNER
  • CRMS4D_ACTV_H.CLIENT == BUT000.CLIENT
Customer Contact Person
  • Customer Contact Person
  • Client
  • CRMS4D_ACTV_H.INBOX_CONTACT_PERSON == BUT000.PARTNER
  • CRMS4D_ACTV_H.CLIENT == BUT000.CLIENT
Responsible Group
  • Responsible Group
  • Client
  • CRMS4D_ACTV_H.INBOX_GROUP_ASSIGNED == BUT000.PARTNER
  • CRMS4D_ACTV_H.CLIENT == BUT000.CLIENT
Status of Agent Inbox Item
Goal of an Activity
Business Trans. Cat. CRMS4D_ACTV_H.OBJTYPE_H == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Employee Responsible
  • Employee Responsible
  • Client
  • CRMS4D_ACTV_H.PERSON_RESP == BUT000.PARTNER
  • CRMS4D_ACTV_H.CLIENT == BUT000.CLIENT
Activity Priority
  • CRMS4D_ACTV_H.CLIENT == SCPRIO.CLIENT
  • CRMS4D_ACTV_H.PRIORITY == SCPRIO.PRIORITY
Business Transaction Type