I_AccrEngineAccrItemTypeBasic

DDL: I_ACCRENGINEACCRITEMTYPEBASIC SQL: IACEITEMTYPEB Type: view BASIC Package: ACE_S4_COMMON

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 9 fields with key fields AccrualEngineAccrualObjectType, AccrualItemType. It has 2 associations to related views. It is exposed through 3 OData services (UI_ACCRUALS_MANAGE, UI_ACCRUALS_PERDCAMT_MANAGE, UI_PURCHASEORDERACCRS_DISPLAY). Part of development package ACE_S4_COMMON.

1 data source(s) Exposed by 3 service(s) 9 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

OData Services (3)

ServiceBindingVersionContractRelease
UI_ACCRUALS_MANAGE UI_ACCRUALS_MANAGE V2 C1 NOT_RELEASED
UI_ACCRUALS_PERDCAMT_MANAGE UI_ACCRS_PERDCAMT_MANAGE V2 C1 NOT_RELEASED
UI_PURCHASEORDERACCRS_DISPLAY UI_PURCHASEORDERACCRS_DSP V2 C1 NOT_RELEASED

Fields (9)

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
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,

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

      tace_itemtype.itemtype_category                                 as AccrualItemTypeCategory,
      _AccrObjectType,
      _Text
}

Learn More