I_BPCUSTOMERDUNNINGPROCESS

CDS View

BP Customer Dunning Process Data

I_BPCUSTOMERDUNNINGPROCESS is a CDS View in S/4HANA. BP Customer Dunning Process Data. It contains 7 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 7 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_BPCustDunningProcessChanges view_entity from TRANSACTIONAL BP Cust Dunning Area Proc Changes
I_BPCustDunningProcessChanges view_entity union_all TRANSACTIONAL BP Cust Dunning Area Proc Changes
I_BPCustomerDunningGov view_entity from COMPOSITE BP Customer Dunning Data Gov
I_BPCustomerDunningProcessTP view_entity from TRANSACTIONAL Business Partner Customer Dunning Process Data - TP

Fields (7)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY DunningArea DunningArea 1
KEY MasterDataChangeProcess MasterDataChangeProcess 1
KEY MDChgProcessSrceObject MDChgProcessSrceObject 1
KEY MDChgProcessSrceSystem MDChgProcessSrceSystem 1
KEY MDChgProcessStep MDChgProcessStep 1
MDChgProcessSourceModified MDChgProcessSourceModified 1 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'BP Customer Dunning Process Data'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
@VDM.viewType: #BASIC
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view entity I_BPCustomerDunningProcess
  as select from knb5_prc
  
  association [0..1] to I_BPCustomerProcess 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 [0..1] to I_BPCustomerCompanyProcess 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
{
  key process_id               as MasterDataChangeProcess,
  key process_step_no          as MDChgProcessStep,
  key source_system            as MDChgProcessSrceSystem,
  key source_id                as MDChgProcessSrceObject,
  key bukrs                    as CompanyCode,
  key maber                    as DunningArea,
      assignment_id            as BPAssignmentID,
      kunnr                    as Customer,
      mahna                    as DunningProcedure,
      mansp                    as DunningBlock,
      madat                    as LastDunnedOn,
      mahns                    as DunningLevel,
      knrma                    as DunningRecipient,
      gmvdt                    as LegDunningProcedureOn,
      busab                    as DunningClerk,
      source_modified          as MDChgProcessSourceModified,
      source_modification_blip as MDChgProcessSourceModifBinary,
      source_recency           as MDChgProcSrceLastChgdDateTime,

      _Customer,
      _CustomerCompanyCode
}
where
     assignment_id = '000000000002'
  or assignment_id is initial

Learn More