C_CAInstlmntPlanWrkflwEmlTmpl

DDL: C_CAINSTLMNTPLANWRKFLWEMLTMPL Type: view CONSUMPTION

Installment Plan Workflow Email Template

C_CAInstlmntPlanWrkflwEmlTmpl is a Consumption CDS View that provides data about "Installment Plan Workflow Email Template" in SAP S/4HANA. It reads from 1 data source (I_WorkflowTask) and exposes 16 fields with key field WorkflowTaskInternalID. It has 1 association to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkflowTask Workflowtask from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CAWorkflowTaskURL _WorkflowTaskURL _WorkflowTaskURL.WorkflowTaskInternalID = Workflowtask.WorkflowTaskInternalID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CINSTPWFEMLTMPL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Installment Plan Workflow Email Template view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WorkflowTaskInternalID I_WorkflowTask WorkflowTaskInternalID
CAInstallmentPlan _InstallmentPlan CAInstallmentPlan
TransactionCurrency _InstallmentPlan TransactionCurrency
CAInstallmentPlanStartDate _InstallmentPlan CAInstallmentPlanStartDate
CAInstallmentPlanEndDate _InstallmentPlan CAInstallmentPlanEndDate
CANumberOfInstallments _InstallmentPlan CANumberOfInstallments
ContractAccount _InstallmentPlan ContractAccount
BusinessPartner _InstallmentPlan BusinessPartner
CAContract _InstallmentPlan CAContract
CompanyCode _InstallmentPlan CompanyCode
CAInstallmentPlanIssueDate _InstallmentPlan CAInstallmentPlanIssueDate
CAInstallmentPlanIssueTime _InstallmentPlan CAInstallmentPlanIssueTime
CAInstallmentPlanCategory _InstallmentPlan CAInstallmentPlanCategory
CAInstallmentPlanCategoryName
WorkflowTaskURL _WorkflowTaskURL WorkflowTaskURL
_BusinessPartner _InstallmentPlan _BusinessPartner 
@AbapCatalog: {
  sqlViewName: 'CINSTPWFEMLTMPL',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #('TRANSACTIONAL_DATA')
}
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Installment Plan Workflow Email Template'
@ObjectModel.usageType : {
  serviceQuality: #D,
  sizeCategory: #L,
  dataClass: #TRANSACTIONAL
}
@VDM.viewType : #CONSUMPTION


define view C_CAInstlmntPlanWrkflwEmlTmpl
  as select from           I_WorkflowTask              as Workflowtask
    left outer to one join I_WorkflowTaskApplObject    as _WorkflowTaskApplObject on Workflowtask.WorkflowTaskInternalID = _WorkflowTaskApplObject.WorkflowTaskInternalID
    left outer to one join I_CAInstallmentPlanHeader   as _InstallmentPlan        on _InstallmentPlan.CAInstallmentPlan = _WorkflowTaskApplObject.TechnicalWrkflwObject
    left outer to one join I_CAInstallmentPlanCategory as _InstallmentPlanCat     on _InstallmentPlan.CAInstallmentPlanCategory = _InstallmentPlanCat.CAInstallmentPlanCategory
  association [0..1] to I_CAWorkflowTaskURL as _WorkflowTaskURL on _WorkflowTaskURL.WorkflowTaskInternalID = Workflowtask.WorkflowTaskInternalID
{
  key Workflowtask.WorkflowTaskInternalID,
      _InstallmentPlan.CAInstallmentPlan,
      _InstallmentPlan.TransactionCurrency,
      _InstallmentPlan.CAInstallmentPlanStartDate,
      _InstallmentPlan.CAInstallmentPlanEndDate,
      _InstallmentPlan.CANumberOfInstallments,
      _InstallmentPlan.ContractAccount,
      _InstallmentPlan.BusinessPartner,
      _InstallmentPlan.CAContract,
      _InstallmentPlan.CompanyCode,
      _InstallmentPlan.CAInstallmentPlanIssueDate,
      _InstallmentPlan.CAInstallmentPlanIssueTime,
      _InstallmentPlan.CAInstallmentPlanCategory,
      _InstallmentPlanCat._Text[1: Language=$session.system_language ].CAInstallmentPlanCategoryName,
      _WorkflowTaskURL.WorkflowTaskURL,
      _InstallmentPlan._BusinessPartner
}

where
  (
       _WorkflowTaskApplObject.WorkflowObjectRole            = '01'
    or _WorkflowTaskApplObject.WorkflowObjectRole            = '99'
  )
  and  _WorkflowTaskApplObject.SAPObjectNodeRepresentation   = 'ContrAcctgInstallmentPlan'
  and  _WorkflowTaskApplObject.TechnicalWrkflwObjectCategory = 'CL'

Learn More