I_ASSETBALANCESHEETACCOUNT

CDS View

Asset Balance Sheet Account

I_ASSETBALANCESHEETACCOUNT is a CDS View in S/4HANA. Asset Balance Sheet Account. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_AssetClassWithAccountAssgmt view inner CONSUMPTION Fixed Asset with Account Assignment
SHSM_CADE_ACCT_DET view from CDS VH for Asset Account Determination

Fields (5)

KeyField CDS FieldsUsed in Views
KEY AssetAccountDetermination AssetAccountDetermination 1
KEY AssetRealDepreciationArea AssetRealDepreciationArea 1
KEY CompanyCode CompanyCode 1
AcqnProdnCostGLAccount AcqnProdnCostGLAccount 1
ChartOfAccounts ChartOfAccounts 1 
@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_TF_AssetBalanceSheetAccount( P_SAPClient : $session.client )

  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
}

Learn More