A_PhoneCallActivity

DDL: A_PHONECALLACTIVITY Type: view COMPOSITE

Phone Call Activity

A_PhoneCallActivity is a Composite CDS View that provides data about "Phone Call Activity" in SAP S/4HANA. It reads from 1 data source (I_CustMgmtActivityEnhcd) and exposes 26 fields with key field PhoneCallActivity. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustMgmtActivityEnhcd PhoneCallActivity from

Associations (4)

CardinalityTargetAliasCondition
[0..*] A_PhoneCallActivityPersonResp _PersonResponsible $projection.PhoneCallActivity = _PersonResponsible.PhoneCallActivity
[0..*] A_PhoneCallActivityAttendee _Attendee $projection.PhoneCallActivity = _Attendee.PhoneCallActivity
[0..*] A_PhoneCallActivityText _Text $projection.PhoneCallActivity = _Text.PhoneCallActivity
[0..1] E_ActivityDocument _Extension _Extension.BusinessObjectType = 'BUS2000126' and $projection.PhoneCallActivity = _Extension.ActivityDocument

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Phone Call Activity view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName APHCLACT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey PhoneCallActivity view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY PhoneCallActivity CustMgmtActivity
PhoneCallActivityType CustMgmtActivityType
PhoneCallActivityDescription CustMgmtActivityDescription
PhoneCallActivityUUID CustMgmtActivityUUID
CustMgmtActivityCategory CustMgmtActivityCategory
CustMgmtActivityPriority CustMgmtActivityPriority
CustMgmtActivityDirection CustMgmtActivityDirection
CustMgmtActivityIsPrivate CustMgmtActivityIsPrivate
CustMgmtActyIsDspdInCalendar CustMgmtActyIsDspdInCalendar
Account Account
ContactPerson ContactPerson
PhoneCallActivityIsRejected CustMgmtActivityIsRejected
CustMgmtActivityStartDateTime CustMgmtActivityStartDateTime
CustMgmtActivityEndDateTime CustMgmtActivityEndDateTime
ResponsibleSalesOrganization ResponsibleSalesOrganization
ServiceOrganization ServiceOrganization
ResponsibleServiceOrganization ResponsibleServiceOrganization
DistributionChannel DistributionChannel
Division Division
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
MarketingReferenceCampaignID
_PersonResponsible _PersonResponsible
_Attendee _Attendee
_Text _Text
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Phone Call Activity'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'APHCLACT',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   representativeKey: 'PhoneCallActivity',
   createEnabled: true,
   updateEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #B,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view A_PhoneCallActivity
  as select from I_CustMgmtActivityEnhcd as PhoneCallActivity

  association [0..*] to A_PhoneCallActivityPersonResp as _PersonResponsible on  $projection.PhoneCallActivity = _PersonResponsible.PhoneCallActivity

  association [0..*] to A_PhoneCallActivityAttendee   as _Attendee          on  $projection.PhoneCallActivity = _Attendee.PhoneCallActivity

  association [0..*] to A_PhoneCallActivityText       as _Text              on  $projection.PhoneCallActivity = _Text.PhoneCallActivity

  //Extensibility

  association [0..1] to E_ActivityDocument            as _Extension         on  _Extension.BusinessObjectType   = 'BUS2000126'
                                                                            and $projection.PhoneCallActivity = _Extension.ActivityDocument
{

  key CustMgmtActivity            as PhoneCallActivity,
      CustMgmtActivityType        as PhoneCallActivityType,
      CustMgmtActivityDescription as PhoneCallActivityDescription,
      CustMgmtActivityUUID        as PhoneCallActivityUUID,
      CustMgmtActivityCategory,
      CustMgmtActivityPriority,
      CustMgmtActivityDirection,
      CustMgmtActivityIsPrivate,
      CustMgmtActyIsDspdInCalendar,
      Account,
      ContactPerson,
      case CustMgmtActivityStatus
       when 'C' then 'X'
       else ''
       end                        as PhoneCallActivityIsCompleted,
      CustMgmtActivityIsRejected  as PhoneCallActivityIsRejected,
      CustMgmtActivityStartDateTime,
      CustMgmtActivityEndDateTime,
      // CustMgmtActyPlndStartDateTime,

      // CustMgmtActyPlndEndDateTime,

      ResponsibleSalesOrganization,
      ServiceOrganization,
      ResponsibleServiceOrganization,
      DistributionChannel,
      Division,
      SalesOrganizationOrgUnitID,
      SalesOfficeOrgUnitID,
      SalesGroupOrgUnitID,
      ''                          as MarketingReferenceCampaignID,

      //Associations

      _PersonResponsible,
      _Attendee,
      _Text

}
where
      CustMgmtObjectType    = 'BUS2000126' // Customer Management Activity

  and BusinessActivityClass = 'A'          // Class - Phone Call