I_BPCustomerDunningProcessTP

DDL: I_BPCUSTOMERDUNNINGPROCESSTP Type: view_entity TRANSACTIONAL Package: MDC_CUST_STAGING_BO

Business Partner Customer Dunning Process Data - TP

I_BPCustomerDunningProcessTP is a Transactional CDS View that provides data about "Business Partner Customer Dunning Process Data - TP" in SAP S/4HANA. It reads from 1 data source (I_BPCustomerDunningProcess) and exposes 29 fields with key fields MasterDataChangeProcess, MDChgProcessStep, MDChgProcessSrceSystem, MDChgProcessSrceObject, BPAssignmentID. It has 8 associations to related views. Part of development package MDC_CUST_STAGING_BO.

1 data source(s) 29 fields

Data Sources (1)

SourceAliasJoin Type
I_BPCustomerDunningProcess I_BPCustomerDunningProcess from

Associations (8)

CardinalityTargetAliasCondition
[0..1] I_BPProcessKPIRecordType _RecordType $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess and $projection.MDChgProcessStep = _RecordType.MDChgProcessStep and $projection.MDChgProcessSrceSystem = _RecordType.MDChgProcessSrceSystem and $projection.MDChgProcessSrceObject = _RecordType.MDChgProcessSrceObject
[0..1] I_MDChangeProcessKPIRowVH _KPIUpdateStatusText $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[0..1] I_DunningArea _DunningArea $projection.CompanyCode = _DunningArea.CompanyCode and $projection.DunningArea = _DunningArea.DunningArea
[0..1] I_Customer _DunningRecipient $projection.DunningRecipient = _DunningRecipient.Customer
[0..1] I_DunningProcedure _DunningProcedure $projection.DunningProcedure = _DunningProcedure.DunningProcedure
[0..1] I_DunningBlockingReasonCode _DunningBlockingReason $projection.DunningBlock = _DunningBlockingReason.DunningBlockingReason
[0..1] I_AccountingClerk _DunningClerk $projection.DunningClerk = _DunningClerk.AccountingClerk and $projection.CompanyCode = _DunningClerk.CompanyCode

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Business Partner Customer Dunning Process Data - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY MasterDataChangeProcess MasterDataChangeProcess
KEY MDChgProcessStep MDChgProcessStep
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem
KEY MDChgProcessSrceObject MDChgProcessSrceObject
KEY BPAssignmentID BPAssignmentID
KEY CompanyCode CompanyCode
KEY DunningArea DunningArea
Customer Customer
DunningProcedure DunningProcedure
DunningBlock DunningBlock
LastDunnedOn LastDunnedOn
DunningLevel DunningLevel
DunningRecipient DunningRecipient
LegDunningProcedureOn LegDunningProcedureOn
DunningClerk DunningClerk
MDChgProcessSourceModified MDChgProcessSourceModified
MDChgProcessSourceModifBinary MDChgProcessSourceModifBinary
MDChgProcSrceLastChgdDateTime MDChgProcSrceLastChgdDateTime
_CustomerCompanyCode _CustomerCompanyCode
_Customer _Customer
_BusinessPartner _BusinessPartner
_RecordType _RecordType
_KPIUpdateStatusText _KPIUpdateStatusText
_CompanyCode _CompanyCode
_DunningArea _DunningArea
_DunningBlockingReason _DunningBlockingReason
_DunningClerk _DunningClerk
_DunningProcedure _DunningProcedure
_DunningRecipient _DunningRecipient 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Business Partner Customer Dunning Process Data - TP'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #C,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustomerDunningProcessTP
  as select from I_BPCustomerDunningProcess
  association        to parent I_BPCustomerCompanyProcessTP as _CustomerCompanyCode   on  $projection.MasterDataChangeProcess = _CustomerCompanyCode.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _CustomerCompanyCode.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _CustomerCompanyCode.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _CustomerCompanyCode.MDChgProcessSrceObject
                                                                                      and $projection.BPAssignmentID          = _CustomerCompanyCode.BPAssignmentID
                                                                                      and $projection.CompanyCode             = _CustomerCompanyCode.CompanyCode

  association        to I_BPCustomerProcessTP               as _Customer              on  $projection.MasterDataChangeProcess = _Customer.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _Customer.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _Customer.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _Customer.MDChgProcessSrceObject
                                                                                      and $projection.BPAssignmentID          = _Customer.BPAssignmentID
  association        to I_BusinessPartnerProcessTP          as _BusinessPartner       on  $projection.MasterDataChangeProcess = _BusinessPartner.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _BusinessPartner.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _BusinessPartner.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _BusinessPartner.MDChgProcessSrceObject
  association [0..1] to I_BPProcessKPIRecordType            as _RecordType            on  $projection.MasterDataChangeProcess = _RecordType.MasterDataChangeProcess
                                                                                      and $projection.MDChgProcessStep        = _RecordType.MDChgProcessStep
                                                                                      and $projection.MDChgProcessSrceSystem  = _RecordType.MDChgProcessSrceSystem
                                                                                      and $projection.MDChgProcessSrceObject  = _RecordType.MDChgProcessSrceObject
  association [0..1] to I_MDChangeProcessKPIRowVH           as _KPIUpdateStatusText   on  $projection.MDChgProcKPIUpdateStatus = _KPIUpdateStatusText.MDChgProcKPIUpdateStatus
  association [0..1] to I_CompanyCode                       as _CompanyCode           on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [0..1] to I_DunningArea                       as _DunningArea           on  $projection.CompanyCode = _DunningArea.CompanyCode
                                                                                      and $projection.DunningArea = _DunningArea.DunningArea
  association [0..1] to I_Customer                          as _DunningRecipient      on  $projection.DunningRecipient = _DunningRecipient.Customer
  association [0..1] to I_DunningProcedure                  as _DunningProcedure      on  $projection.DunningProcedure = _DunningProcedure.DunningProcedure
  association [0..1] to I_DunningBlockingReasonCode         as _DunningBlockingReason on  $projection.DunningBlock = _DunningBlockingReason.DunningBlockingReason
  association [0..1] to I_AccountingClerk                   as _DunningClerk          on  $projection.DunningClerk = _DunningClerk.AccountingClerk
                                                                                      and $projection.CompanyCode  = _DunningClerk.CompanyCode
{
  key MasterDataChangeProcess,
  key MDChgProcessStep,
  key MDChgProcessSrceSystem,
  key MDChgProcessSrceObject,
  key BPAssignmentID,
  key CompanyCode,
  key DunningArea,
      Customer,
      DunningProcedure,
      DunningBlock,
      LastDunnedOn,
      DunningLevel,
      DunningRecipient,
      LegDunningProcedureOn,
      DunningClerk,
      MDChgProcessSourceModified,
      MDChgProcessSourceModifBinary,
      MDChgProcSrceLastChgdDateTime,
      cast(
        case
          when MDChgProcessSourceModified = '' then 'N'
          when MDChgProcessSourceModified = 'X' then 'M'
        else MDChgProcessSourceModified end as mdc_source_modified
      ) as MDChgProcKPIUpdateStatus,

      _CustomerCompanyCode,
      _Customer,
      _BusinessPartner,
      _RecordType,
      _KPIUpdateStatusText,
      _CompanyCode,
      _DunningArea,
      _DunningBlockingReason,
      _DunningClerk,
      _DunningProcedure,
      _DunningRecipient
}

Learn More