I_BPCUSTOMERDUNNINGTP

CDS View

BO view for Customer Dunning

I_BPCUSTOMERDUNNINGTP is a CDS View in S/4HANA. BO view for Customer Dunning. It contains 14 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 14 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_BPCustomerDunning view from CONSUMPTION Consumption View for Customer Dunning

Fields (14)

KeyField CDS FieldsUsed in Views
KEY BusinessPartner BusinessPartner 1
KEY CompanyCode CompanyCode 1
KEY DunningArea DunningArea 1
BusinessPartnerForEdit BusinessPartnerForEdit 1
CompanyCodeForEdit CompanyCodeForEdit 1
Customer Customer 1
DunningAreaForEdit DunningAreaForEdit 1
DunningBlock DunningBlock 1
DunningClerk DunningClerk 1
DunningLevel DunningLevel 1
DunningProcedure DunningProcedure 1
DunningRecipient DunningRecipient 1
LastDunnedOn LastDunnedOn 1
LegDunningProcedureOn LegDunningProcedureOn 1 
@AbapCatalog.sqlViewName: 'IBPCUSTDUNTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'BO view for Customer Dunning'
@ObjectModel.semanticKey: ['BusinessPartner', 'CompanyCode', 'DunningArea']
@ObjectModel.writeDraftPersistence: 'CUST_DUN_D'
@ObjectModel.draftEnabled:true
@ObjectModel.createEnabled: 'EXTERNAL_CALCULATION'
@ObjectModel.updateEnabled 
@ObjectModel.deleteEnabled: 'EXTERNAL_CALCULATION'
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #XXL
@ObjectModel.usageType.dataClass: #MASTER
@Search.searchable: true
@VDM.viewType: #TRANSACTIONAL
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]
define view I_BPCustomerDunningTP as select from I_CustomerDunning as CustomerDunning 
  association [1..1] to I_CustomerToBusinessPartner as _CustomerToBusinessPartner on $projection.Customer = _CustomerToBusinessPartner.Customer

  association [1..1] to I_BusinessPartnerTP as _BusinessPartner on $projection.businesspartner = _BusinessPartner.BusinessPartner

  association [1..1] to I_BusinessPartnerCustCoTP  as _BusinessPartnerCustomerCo on $projection.businesspartner = _BusinessPartnerCustomerCo.BusinessPartner
                                                                                  and $projection.CompanyCode     = _BusinessPartnerCustomerCo.CompanyCode                                                                                  
{

  key _CustomerToBusinessPartner._BusinessPartner.BusinessPartner,
  key CustomerDunning.CompanyCode,
  key CustomerDunning.DunningArea,
      CustomerDunning.Customer,
      _CustomerToBusinessPartner._BusinessPartner.BusinessPartner as BusinessPartnerForEdit,
      CustomerDunning.CompanyCode as CompanyCodeForEdit,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      CustomerDunning.DunningArea as DunningAreaForEdit,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      CustomerDunning.DunningRecipient,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      CustomerDunning.LegDunningProcedureOn,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      CustomerDunning.LastDunnedOn,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      CustomerDunning.DunningProcedure,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      CustomerDunning.DunningLevel,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      CustomerDunning.DunningBlock,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      CustomerDunning.DunningClerk,
      @ObjectModel.mandatory: 'EXTERNAL_CALCULATION'
      cast(' ' as boole_d) as StandardUsage,

      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT ]
      _BusinessPartner,
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT ]
      _BusinessPartnerCustomerCo,
      _DunningAreaText,
      _DunningProcedureText,
      _DunningBlockText
}

Learn More