P_AssetBalanceSheetAccount

DDL: P_ASSETBALANCESHEETACCOUNT Type: view BASIC

P_AssetBalanceSheetAccount is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (P_TF_AssetBalanceSheetAccount, P_TF_AssetRedesignSwitchStatus, P_TF_AssetRedesignSwitchStatus, t001, t095) and exposes 9 fields with key fields CompanyCode, AssetAccountDetermination, AssetRealDepreciationArea, AssetAccountDetermination, AssetRealDepreciationArea.

5 data source(s) 9 fields

Data Sources (5)

SourceAliasJoin Type
P_TF_AssetBalanceSheetAccount P_TF_AssetBalanceSheetAccount union_all
P_TF_AssetRedesignSwitchStatus P_TF_AssetRedesignSwitchStatus inner
P_TF_AssetRedesignSwitchStatus P_TF_AssetRedesignSwitchStatus inner
t001 t001 from
t095 t095 inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIASSETBALACCT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode t001 bukrs
KEY AssetAccountDetermination t095 ktogr
KEY AssetRealDepreciationArea t095 afabe
ChartOfAccounts t095 ktopl
IsActiveXkeyCompanyCode
KEY AssetAccountDetermination AssetAccountDetermination
KEY AssetRealDepreciationArea AssetRealDepreciationArea
ChartOfAccounts ChartOfAccounts
AcqnProdnCostGLAccount AcqnProdnCostGLAccount 
@AbapCatalog: { sqlViewName: 'PFIASSETBALACCT', preserveKey: true, compiler.compareFilter: true }
@VDM.viewType: #BASIC
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_AssetBalanceSheetAccount
  as select from t001
    inner join   t095                                                            on t095.ktopl = t001.ktopl
    inner join   P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = ''
{
  key t001.bukrs  as CompanyCode,
  key t095.ktogr  as AssetAccountDetermination,
  key t095.afabe  as AssetRealDepreciationArea,

      t095.ktopl  as ChartOfAccounts,
      t095.ktansw as AcqnProdnCostGLAccount
}

union all select from P_TF_AssetBalanceSheetAccount( P_SAPClient : $session.client )
  inner join          P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = 'X'
{
  key CompanyCode,
  key AssetAccountDetermination,
  key AssetRealDepreciationArea,

      ChartOfAccounts,
      AcqnProdnCostGLAccount
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001",
"T095"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More