I_AccrEngineAccrItemTypeBasic

DDL: I_ACCRENGINEACCRITEMTYPEBASIC SQL: IACEITEMTYPEB Type: view BASIC

Accrual Engine: Accrual Item Type

I_AccrEngineAccrItemTypeBasic is a Basic CDS View (Dimension) that provides data about "Accrual Engine: Accrual Item Type" in SAP S/4HANA. It reads from 1 data source (tace_itemtype) and exposes 10 fields with key fields AccrualEngineAccrualObjectType, AccrualItemType. It has 2 associations to related views.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
tace_itemtype tace_itemtype from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_AccrEngineAccrObjectType _AccrObjectType $projection.AccrualEngineAccrualObjectType = _AccrObjectType.AccrualEngineAccrualObjectType
[0..*] I_AccrEngineAccrItemTypeText _Text $projection.AccrualEngineAccrualObjectType = _Text.AccrualEngineAccrualObjectType and $projection.AccrualItemType = _Text.AccrualItemType

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IACEITEMTYPEB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accrual Engine: Accrual Item Type view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey AccrualItemType view
VDM.viewType #BASIC view
Search.searchable true view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType tace_itemtype comp
KEY AccrualItemType tace_itemtype itemtype
PlanAccrualItemType tace_itemtype planned_itemtype
ActualAccrualItemType tace_itemtype actual_itemtype
DeferralItemType tace_itemtype deferral_itemtype
AccrualItemTypeIsDerived tace_itemtype xdependent
UpldOfPeriodicAmountIsAllowed tace_itemtype xupld_currnt_acramnt
AccrualItemTypeCategory tace_itemtype itemtype_category
_AccrObjectType _AccrObjectType
_Text _Text 
@AbapCatalog.sqlViewName: 'IACEITEMTYPEB'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Accrual Engine: Accrual Item Type'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #CUSTOMIZING
 }  
@ObjectModel.representativeKey: 'AccrualItemType'
@VDM.viewType: #BASIC
@Search.searchable: true
@Analytics.dataCategory: #DIMENSION
@Analytics.internalName:#LOCAL
@Metadata.allowExtensions:true
define view I_AccrEngineAccrItemTypeBasic
  as select from tace_itemtype
  association [0..1] to I_AccrEngineAccrObjectType   as _AccrObjectType on  $projection.AccrualEngineAccrualObjectType = _AccrObjectType.AccrualEngineAccrualObjectType
  association [0..*] to I_AccrEngineAccrItemTypeText as _Text           on  $projection.AccrualEngineAccrualObjectType = _Text.AccrualEngineAccrualObjectType
                                                                        and $projection.AccrualItemType                = _Text.AccrualItemType
{
      @ObjectModel.foreignKey.association: '_AccrObjectType'
  key tace_itemtype.comp                                              as AccrualEngineAccrualObjectType,
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @ObjectModel.text.association: '_Text'
  key tace_itemtype.itemtype                                          as AccrualItemType,

      tace_itemtype.planned_itemtype                                  as PlanAccrualItemType,
      tace_itemtype.actual_itemtype                                   as ActualAccrualItemType,
      tace_itemtype.deferral_itemtype                                 as DeferralItemType,
      tace_itemtype.xdependent                                        as AccrualItemTypeIsDerived,
      
      tace_itemtype.xupld_currnt_acramnt                              as UpldOfPeriodicAmountIsAllowed,

      /* item type catagory*/
//      cast( '' as ace_s4_itemtype_category preserving type ) as AccrualItemTypeCategory,

      tace_itemtype.itemtype_category                                 as AccrualItemTypeCategory,
      _AccrObjectType,
      _Text
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TACE_ITEMTYPE"
],
"ASSOCIATED":
[
"I_ACCRENGINEACCRITEMTYPETEXT",
"I_ACCRENGINEACCROBJECTTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More