A_CustMgmtTask

DDL: A_CUSTMGMTTASK Type: view COMPOSITE

Customer Management Task Activity

A_CustMgmtTask is a Composite CDS View that provides data about "Customer Management Task Activity" in SAP S/4HANA. It reads from 1 data source (I_CustMgmtActivityEnhcd) and exposes 21 fields with key field CustMgmtTask. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CustMgmtActivityEnhcd CustMgmtTask from

Associations (3)

CardinalityTargetAliasCondition
[0..*] A_CustMgmtTaskPersonResp _PersonResponsible $projection.CustMgmtTask = _PersonResponsible.CustMgmtTask
[0..*] A_CustMgmtTaskText _Text $projection.CustMgmtTask = _Text.CustMgmtTask
[0..1] E_ActivityDocument _Extension _Extension.BusinessObjectType = 'BUS2000125' and $projection.CustMgmtTask = _Extension.ActivityDocument

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Customer Management Task Activity view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AbapCatalog.sqlViewName ACUSTMGMTTASK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CustMgmtTask CustMgmtActivity
CustMgmtTaskType CustMgmtActivityType
CustMgmtTaskDescription CustMgmtActivityDescription
CustMgmtTaskUUID CustMgmtActivityUUID
CustMgmtTaskPriority CustMgmtActivityPriority
CustMgmtTaskIsPrivate CustMgmtActivityIsPrivate
Account Account
ContactPerson ContactPerson
CustMgmtTaskIsRejected CustMgmtActivityIsRejected
CustMgmtTaskStartDateTime CustMgmtActivityStartDateTime
CustMgmtTaskEndDateTime CustMgmtActivityEndDateTime
ResponsibleSalesOrganization ResponsibleSalesOrganization
ServiceOrganization ServiceOrganization
ResponsibleServiceOrganization ResponsibleServiceOrganization
DistributionChannel DistributionChannel
Division Division
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
_PersonResponsible _PersonResponsible
_Text _Text
@ClientHandling.algorithm:#SESSION_VARIABLE
@EndUserText.label: 'Customer Management Task Activity'
@VDM: {
  viewType: #COMPOSITE,
  lifecycle.contract.type: #PUBLIC_REMOTE_API
}
@AbapCatalog: {
  sqlViewName: 'ACUSTMGMTTASK',
  compiler.compareFilter: true,
  preserveKey:true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ObjectModel: {
   createEnabled: true,
   updateEnabled: true,
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #C,
     sizeCategory:   #L
   }
}
@Metadata.ignorePropagatedAnnotations: true

define view A_CustMgmtTask
  as select from I_CustMgmtActivityEnhcd as CustMgmtTask

  association [0..*] to A_CustMgmtTaskPersonResp as _PersonResponsible on $projection.CustMgmtTask = _PersonResponsible.CustMgmtTask

  association [0..*] to A_CustMgmtTaskText       as _Text              on $projection.CustMgmtTask = _Text.CustMgmtTask
  //Extensibility

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

  key CustMgmtActivity            as CustMgmtTask,
      CustMgmtActivityType        as CustMgmtTaskType,
      CustMgmtActivityDescription as CustMgmtTaskDescription,
      CustMgmtActivityUUID        as CustMgmtTaskUUID,
      CustMgmtActivityPriority    as CustMgmtTaskPriority,
      CustMgmtActivityIsPrivate   as CustMgmtTaskIsPrivate,
      Account,
      ContactPerson,
      case CustMgmtActivityStatus
       when 'C' then 'X'
       else ''
       end                        as CustMgmtTaskIsCompleted,
      CustMgmtActivityIsRejected  as CustMgmtTaskIsRejected,
      CustMgmtActivityStartDateTime as CustMgmtTaskStartDateTime,
      CustMgmtActivityEndDateTime   as CustMgmtTaskEndDateTime,
      ResponsibleSalesOrganization,
      ServiceOrganization,
      ResponsibleServiceOrganization,
      DistributionChannel,
      Division,
      SalesOrganizationOrgUnitID,
      SalesOfficeOrgUnitID,
      SalesGroupOrgUnitID,
      //Associations

      _PersonResponsible,
      _Text
}
where
  CustMgmtObjectType = 'BUS2000125' // Task