I_AssetBalanceSheetAccount

DDL: I_ASSETBALANCESHEETACCOUNT Type: view BASIC

Asset Balance Sheet Account

I_AssetBalanceSheetAccount is a Basic CDS View that provides data about "Asset Balance Sheet Account" in SAP S/4HANA. It reads from 1 data source (P_AssetBalanceSheetAccount) and exposes 9 fields with key fields CompanyCode, AssetAccountDetermination, AssetRealDepreciationArea. It has 4 associations to related views.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
P_AssetBalanceSheetAccount P_AssetBalanceSheetAccount from

Associations (4)

CardinalityTargetAliasCondition
[1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode
[1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[1] I_AssetAcctDetermination _AssetAccountDetermination $projection.AssetAccountDetermination = _AssetAccountDetermination.AssetAccountDetermination
[0..1] I_GLAccountInChartOfAccounts _AcqnProdnCostGLAccount $projection.ChartOfAccounts = _AcqnProdnCostGLAccount.ChartOfAccounts and $projection.AcqnProdnCostGLAccount = _AcqnProdnCostGLAccount.GLAccount

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IFIASSETBALACCT view
AbapCatalog.preserveKey true view
EndUserText.label Asset Balance Sheet Account view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AssetAccountDetermination AssetAccountDetermination
KEY AssetRealDepreciationArea AssetRealDepreciationArea
ChartOfAccounts ChartOfAccounts
AcqnProdnCostGLAccount AcqnProdnCostGLAccount
_CompanyCode _CompanyCode
_ChartOfAccounts _ChartOfAccounts
_AssetAccountDetermination _AssetAccountDetermination
_AcqnProdnCostGLAccount _AcqnProdnCostGLAccount 
@AbapCatalog: {sqlViewName: 'IFIASSETBALACCT', preserveKey: true}
@EndUserText.label: 'Asset Balance Sheet Account'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_AssetBalanceSheetAccount
  as select from P_AssetBalanceSheetAccount

  association [1]    to I_CompanyCode                as _CompanyCode               on  $projection.CompanyCode = _CompanyCode.CompanyCode
  association [1]    to I_ChartOfAccounts            as _ChartOfAccounts           on  $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
  association [1]    to I_AssetAcctDetermination     as _AssetAccountDetermination on  $projection.AssetAccountDetermination = _AssetAccountDetermination.AssetAccountDetermination
  association [0..1] to I_GLAccountInChartOfAccounts as _AcqnProdnCostGLAccount    on  $projection.ChartOfAccounts        = _AcqnProdnCostGLAccount.ChartOfAccounts
                                                                                   and $projection.AcqnProdnCostGLAccount = _AcqnProdnCostGLAccount.GLAccount
{
      @ObjectModel.foreignKey.association: '_CompanyCode'
  key CompanyCode,
      @ObjectModel.foreignKey.association: '_AssetAccountDetermination'
  key AssetAccountDetermination,
  key AssetRealDepreciationArea,

      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      ChartOfAccounts,
      @ObjectModel.foreignKey.association: '_AcqnProdnCostGLAccount'
      AcqnProdnCostGLAccount,

      //* Associations *//

      _CompanyCode,
      _ChartOfAccounts,
      _AssetAccountDetermination,
      _AcqnProdnCostGLAccount
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ASSETBALANCESHEETACCOUNT"
],
"ASSOCIATED":
[
"I_ASSETACCTDETERMINATION",
"I_CHARTOFACCOUNTS",
"I_COMPANYCODE",
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More