I_MngCollStrgyCollStrategy

DDL: I_MNGCOLLSTRGYCOLLSTRATEGY SQL: IMNGCOLLSTRGY Type: view BASIC

Collection Strategies

I_MngCollStrgyCollStrategy is a Basic CDS View that provides data about "Collection Strategies" in SAP S/4HANA. It reads from 1 data source (I_CollectionsStrategy) and exposes 22 fields with key field CollectionStrategy. It has 3 associations to related views.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_CollectionsStrategy I_CollectionsStrategy from

Associations (3)

CardinalityTargetAliasCondition
[1..1] P_CollectionStrategyUsage _CollectionStrategyUsage _CollectionStrategyUsage.CollectionStrategy = $projection.CollectionStrategy
[1..*] I_CollectionStrategyStatusText _StatusText _StatusText.CollStrgyIsActive = $projection.CollStrgyIsActive
[1..1] P_CollectionStrategyValuation _CollectionStrategyValuation _CollectionStrategyValuation.CollectionStrategy = $projection.CollectionStrategy

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMNGCOLLSTRGY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Collection Strategies view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CollectionStrategy CollectionStrategy
CollStrgyName
CollStrgyCurrency CollStrgyCurrency
CollStrgyMaxValuation CollStrgyMaxValuation
CollDuDteCshDiscIsConsidered CollDuDteCshDiscIsConsidered
CollStrgyNmbrDaysBeforeDueDate CollStrgyNmbrDaysBeforeDueDate
CollStrgyTolDaysAfterDunn CollStrgyTolDaysAfterDunn
CollItmWthLglDunProcedIsExcl CollItmWthLglDunProcedIsExcl
CollStrgyOverduePeriod1 CollStrgyOverduePeriod1
CollStrgyOverduePeriod2 CollStrgyOverduePeriod2
CollStrgyOverduePeriod3 CollStrgyOverduePeriod3
CollStrgyOverduePeriod4 CollStrgyOverduePeriod4
CollStrgyDueDatePeriod1 CollStrgyDueDatePeriod1
CollStrgyDueDatePeriod2 CollStrgyDueDatePeriod2
CollStrgyDueDatePeriod3 CollStrgyDueDatePeriod3
CollStrgyDueDatePeriod4 CollStrgyDueDatePeriod4
CollStrgyCreatedBy CollStrgyCreatedBy
CollStrgyCreatedOn CollStrgyCreatedOn
CollStrgyLastChangedBy CollStrgyLastChangedBy
CollStrgyLastChangedOn CollStrgyLastChangedOn
_StatusText _StatusText
_Currency _Currency 
@AbapCatalog.sqlViewName: 'IMNGCOLLSTRGY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 

@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #BASIC

@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass:  #CUSTOMIZING
@ObjectModel.usageType.serviceQuality: #C

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Collection Strategies'

define view I_MngCollStrgyCollStrategy
  as select from I_CollectionsStrategy

  //is strategy used?

  association [1..1] to P_CollectionStrategyUsage      as _CollectionStrategyUsage     on  _CollectionStrategyUsage.CollectionStrategy = $projection.CollectionStrategy
  
  association [1..*] to I_CollectionStrategyStatusText as _StatusText                  on  _StatusText.CollStrgyIsActive = $projection.CollStrgyIsActive
  
  association [1..1] to P_CollectionStrategyValuation  as _CollectionStrategyValuation on  _CollectionStrategyValuation.CollectionStrategy = $projection.CollectionStrategy
   
{

  key CollectionStrategy,
      cast(_CollectionsStrategyText[Language = $session.system_language].CollStrgyName as fin_mng_colstr_strategy_text) as CollStrgyName,

      @Semantics.currencyCode:true
      CollStrgyCurrency,
      CollStrgyMaxValuation,
      cast(
        case when _CollectionStrategyValuation.CollStrgyDefaultValuation is null and CollStrgyMaxValuation = 0
             or   _CollectionStrategyValuation.CollStrgyDefaultValuation = CollStrgyMaxValuation 
             then 'X'
             else ''
      end            as fin_mng_colstr_auto_valuation )                                                      as CollStrgyAutoValuation,

      cast( case when _CollectionStrategyUsage.CollStrgyIsActiv = 'X' then 'X'
                                                                      else ''
            end  as fin_mng_colstr_is_active)                                                                as CollStrgyIsActive,

      CollDuDteCshDiscIsConsidered,
      CollStrgyNmbrDaysBeforeDueDate,
      CollStrgyTolDaysAfterDunn,
      CollItmWthLglDunProcedIsExcl,

      //periods

      CollStrgyOverduePeriod1,
      CollStrgyOverduePeriod2,
      CollStrgyOverduePeriod3,
      CollStrgyOverduePeriod4,

      CollStrgyDueDatePeriod1,
      CollStrgyDueDatePeriod2,
      CollStrgyDueDatePeriod3,
      CollStrgyDueDatePeriod4,

      // change log

      @Semantics.user.createdBy: true
      CollStrgyCreatedBy,
      @Semantics.systemDateTime.createdAt: true
      CollStrgyCreatedOn,
      @Semantics.user.lastChangedBy: true
      CollStrgyLastChangedBy,
      @Semantics.systemDateTime.lastChangedAt: true
      CollStrgyLastChangedOn,
      
      _StatusText,
      _Currency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COLLECTIONSSTRATEGY",
"I_COLLECTIONSSTRATEGYTEXT",
"P_COLLECTIONSTRATEGYUSAGE",
"P_COLLECTIONSTRATEGYVALUATION"
],
"ASSOCIATED":
[
"I_COLLECTIONSTRATEGYSTATUSTEXT",
"I_CURRENCY",
"P_COLLECTIONSTRATEGYUSAGE",
"P_COLLECTIONSTRATEGYVALUATION"
],
"BASE":
[
"I_COLLECTIONSSTRATEGY"
],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More