I_AccrEngineAccrSubobjParam

DDL: I_ACCRENGINEACCRSUBOBJPARAM SQL: IACESOPARAM Type: view BASIC

Accrual Subobject Parameter

I_AccrEngineAccrSubobjParam is a Basic CDS View that provides data about "Accrual Subobject Parameter" in SAP S/4HANA. It reads from 1 data source (acesobj_param) and exposes 16 fields with key fields AccrualEngineAccrualObjectType, AccrualObjectLogicalSystem, CompanyCode, AccrualObject, AccrualSubobject. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
acesobj_param acesobj_param from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_AccrEngineAccrObjectType _AccrObjectType $projection.AccrualEngineAccrualObjectType = _AccrObjectType.AccrualEngineAccrualObjectType
[0..1] I_LogicalSystem _AccrLogicalSystem $projection.AccrualObjectLogicalSystem = _AccrLogicalSystem.LogicalSystem
[1..1] I_AccrualEngineCompanyCode _AccrCompanyCode $projection.AccrualEngineAccrualObjectType = _AccrCompanyCode.AccrualEngineAccrualObjectType and $projection.CompanyCode = _AccrCompanyCode.CompanyCode
[0..1] I_AccrEngineAccrualObject _AccrObj $projection.AccrualEngineAccrualObjectType = _AccrObj.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _AccrObj.AccrualObjectLogicalSystem and $projection.CompanyCode = _AccrObj.CompanyCode and $projection.AccrualObject = _AccrObj.AccrualObject
[0..1] I_AccrEngineAccrualSubobject _AccrSubobj $projection.AccrualEngineAccrualObjectType = _AccrSubobj.AccrualEngineAccrualObjectType and $projection.AccrualObjectLogicalSystem = _AccrSubobj.AccrualObjectLogicalSystem and $projection.CompanyCode = _AccrSubobj.CompanyCode and $projection.AccrualObject = _AccrSubobj.AccrualObject and $projection.AccrualSubobject = _AccrSubobj.AccrualSubobject

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IACESOPARAM view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Accrual Subobject Parameter view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.entityChangeStateId AccrSubobjParamLastChgDteTime view
VDM.viewType #BASIC view
AbapCatalog.preserveKey true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY AccrualEngineAccrualObjectType comp
KEY AccrualObjectLogicalSystem logsys
KEY CompanyCode bukrs
KEY AccrualObject ref_key
KEY AccrualSubobject ref_subkey
KEY AccrualSubobjectParameter param_name
KEY AccrSubobjParamValdtyEndDte date_to
AccrSubobjParamValdtyStrtDte date_from
AccrualSubobjectParameterValue content
AccrSubobjectParameterXMLValue content_xml
AccrSubobjParamLastChgDteTime _AccrSubobj AccrSubobjLastChangeDateTime
_AccrObjectType _AccrObjectType
_AccrLogicalSystem _AccrLogicalSystem
_AccrCompanyCode _AccrCompanyCode
_AccrObj _AccrObj
_AccrSubobj _AccrSubobj
@AbapCatalog.sqlViewName: 'IACESOPARAM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Accrual Subobject Parameter'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory: #M,
  dataClass: #MASTER
 }
@ObjectModel.entityChangeStateId: 'AccrSubobjParamLastChgDteTime'
@VDM.viewType: #BASIC
@AbapCatalog.preserveKey:true
define view I_AccrEngineAccrSubobjParam
  as select from acesobj_param
  association [1..1] to I_AccrEngineAccrObjectType   as _AccrObjectType  on  $projection.AccrualEngineAccrualObjectType = _AccrObjectType.AccrualEngineAccrualObjectType
  association [0..1] to I_LogicalSystem              as _AccrLogicalSystem   on  $projection.AccrualObjectLogicalSystem = _AccrLogicalSystem.LogicalSystem
  association [1..1] to I_AccrualEngineCompanyCode   as _AccrCompanyCode on  $projection.AccrualEngineAccrualObjectType = _AccrCompanyCode.AccrualEngineAccrualObjectType
                                                                         and $projection.CompanyCode                    = _AccrCompanyCode.CompanyCode
  association [0..1] to I_AccrEngineAccrualObject    as _AccrObj         on  $projection.AccrualEngineAccrualObjectType = _AccrObj.AccrualEngineAccrualObjectType
                                                                         and $projection.AccrualObjectLogicalSystem     = _AccrObj.AccrualObjectLogicalSystem
                                                                         and $projection.CompanyCode                    = _AccrObj.CompanyCode
                                                                         and $projection.AccrualObject                  = _AccrObj.AccrualObject
  association [0..1] to I_AccrEngineAccrualSubobject as _AccrSubobj      on  $projection.AccrualEngineAccrualObjectType = _AccrSubobj.AccrualEngineAccrualObjectType
                                                                         and $projection.AccrualObjectLogicalSystem     = _AccrSubobj.AccrualObjectLogicalSystem
                                                                         and $projection.CompanyCode                    = _AccrSubobj.CompanyCode
                                                                         and $projection.AccrualObject                  = _AccrSubobj.AccrualObject
                                                                         and $projection.AccrualSubobject               = _AccrSubobj.AccrualSubobject

{
      @ObjectModel.foreignKey.association: '_AccrObjectType'
  key comp                                 as AccrualEngineAccrualObjectType,
      @ObjectModel.foreignKey.association: '_AccrLogicalSystem'
  key logsys                              as AccrualObjectLogicalSystem,
      @ObjectModel.foreignKey.association: '_AccrCompanyCode'
  key bukrs                                as CompanyCode,
      @ObjectModel.foreignKey.association: '_AccrObj'
  key ref_key                              as AccrualObject,
      @ObjectModel.foreignKey.association: '_AccrSubobj' 
  key ref_subkey                           as AccrualSubobject,


  key param_name                           as AccrualSubobjectParameter,
  key date_to                              as AccrSubobjParamValdtyEndDte,
      date_from                            as AccrSubobjParamValdtyStrtDte,

      content                              as AccrualSubobjectParameterValue,

      content_xml                          as AccrSubobjectParameterXMLValue,

      /*Etag */
      @Semantics.systemDateTime.lastChangedAt: true
      _AccrSubobj.AccrSubobjLastChangeDateTime        as AccrSubobjParamLastChgDteTime,


      _AccrObjectType,
      _AccrLogicalSystem,
      _AccrCompanyCode,
      _AccrObj,
      _AccrSubobj
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ACCRENGINEACCRUALSUBOBJECT",
"ACESOBJ_PARAM"
],
"ASSOCIATED":
[
"I_ACCRENGINEACCROBJECTTYPE",
"I_ACCRENGINEACCRUALOBJECT",
"I_ACCRENGINEACCRUALSUBOBJECT",
"I_ACCRUALENGINECOMPANYCODE",
"I_LOGICALSYSTEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/