P_RevalOrdnryDeprValAdjmtAcct

DDL: P_REVALORDNRYDEPRVALADJMTACCT Type: view BASIC

P_RevalOrdnryDeprValAdjmtAcct is a Basic CDS View in SAP S/4HANA. It reads from 5 data sources (P_TF_AssetRedesignSwitchStatus, P_TF_AssetRedesignSwitchStatus, P_TF_RevalOrdDeprValAdjmtAcct, t001, t095b) 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_AssetRedesignSwitchStatus P_TF_AssetRedesignSwitchStatus inner
P_TF_AssetRedesignSwitchStatus P_TF_AssetRedesignSwitchStatus inner
P_TF_RevalOrdDeprValAdjmtAcct P_TF_RevalOrdDeprValAdjmtAcct union_all
t001 t001 from
t095b t095b inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PFIRVLODVALADJAC 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 t095b ktogr
KEY AssetRealDepreciationArea t095b afabe
ChartOfAccounts t095b ktopl
IsActiveXkeyCompanyCode
KEY AssetAccountDetermination AssetAccountDetermination
KEY AssetRealDepreciationArea AssetRealDepreciationArea
ChartOfAccounts ChartOfAccounts
RevalOrdnryDeprValAdjmtGLAcct RevalOrdnryDeprValAdjmtGLAcct 
@AbapCatalog: { sqlViewName: 'PFIRVLODVALADJAC', 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_RevalOrdnryDeprValAdjmtAcct
  as select from t001
    inner join   t095b                                                           on t095b.ktopl = t001.ktopl
    inner join   P_TF_AssetRedesignSwitchStatus( P_SAPClient : $session.client ) on P_TF_AssetRedesignSwitchStatus.IsActive = ''
{
  key t001.bukrs   as CompanyCode,
  key t095b.ktogr  as AssetAccountDetermination,
  key t095b.afabe  as AssetRealDepreciationArea,

      t095b.ktopl  as ChartOfAccounts,
      t095b.ktaunb as RevalOrdnryDeprValAdjmtGLAcct
}

union all select from P_TF_RevalOrdDeprValAdjmtAcct( 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,
      RevalOrdnryDeprValAdjmtGLAcct
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T001",
"T095B"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More