I_CustMgmtActivity

Customer Management Activity | view: IACTIVITY | TRAN | Extraction: Not supported | Component: S4CRM: Tasks & Activities
Tables used: CRMS4D_ACTV_H
Column Name Description
CustMgmtObjectType FK Business Trans. Cat.
CustMgmtActivity Transaction ID
Column Name Description
Column Name Description
Column Name Description
Column Name Description
CustMgmtActivityIsPrivate Indicator: Task is Private Show values
BusinessActivityClass Activity Class Show values
CustMgmtActivityDirection Direction of an Activity Show values
CustMgmtActyIsDspdInCalendar Include Activity in Calendar Show values
CustMgmtTaskCompltnRateInPct Completion Rate in Percent Show values
CustMgmtActivityStatus Life Cycle Status Show values
CustMgmtActivityIsRejected Cancellation Status Show values
Column Name Description Domain name
CustMgmtActivityDescription Transaction Description CRM_PROCESS_DESCRIPTION
CustMgmtActivityLocationText Location CRM_ACTIVITY_LOCATION
CustMgmtActivityUUID GUID of a CRM Order Object SYSUUID
CustMgmtActivityStartDateTime Start Date TZNTSTMPS
CustMgmtActivityEndDateTime End Date TZNTSTMPS
SalesOrganizationOrgUnitID Sales Organization ID HROBJEC_14
SalesOfficeOrgUnitID Sales Office HROBJEC_14
SalesGroupOrgUnitID Sales Group HROBJEC_14
ResponsibleSalesOrganization Organizational Unit (Sales) HROBJEC_14
ServiceOrganization Service Organization HROBJEC_14
ResponsibleServiceOrganization Organizational Unit (Service) HROBJEC_14
TextObjectKey 32 Character CRM Object GUID (Converted)
Master Data Relations Join Conditions
Activity Partner
  • Client
  • Activity Partner
  • I_CUSTMGMTACTIVITY.MANDT == BUT000.CLIENT
  • I_CUSTMGMTACTIVITY.ACCOUNT == BUT000.PARTNER
Customer Contact Person
  • Client
  • Customer Contact Person
  • I_CUSTMGMTACTIVITY.MANDT == BUT000.CLIENT
  • I_CUSTMGMTACTIVITY.CONTACTPERSON == BUT000.PARTNER
Activity Category (Communication Type)
  • Activity Category (Communication Type)
  • Client
Activity Priority
  • Client
  • Activity Priority
  • I_CUSTMGMTACTIVITY.MANDT == SCPRIO.CLIENT
  • I_CUSTMGMTACTIVITY.CUSTMGMTACTIVITYPRIORITY == SCPRIO.PRIORITY
Business Transaction Type
  • Client
  • Business Transaction Type
Business Trans. Cat. I_CUSTMGMTACTIVITY.CUSTMGMTOBJECTTYPE == CRMC_SUBOB_CAT.SUBOBJ_CATEGORY
Distribution Channel
  • Client
  • Distribution Channel
  • I_CUSTMGMTACTIVITY.MANDT == TVTW.MANDT
  • I_CUSTMGMTACTIVITY.DISTRIBUTIONCHANNEL == TVTW.VTWEG
Division
  • Client
  • Division
  • I_CUSTMGMTACTIVITY.MANDT == TSPA.MANDT
  • I_CUSTMGMTACTIVITY.DIVISION == TSPA.SPART