P_AssetClassWithAccountAssgmt

DDL: P_ASSETCLASSWITHACCOUNTASSGMT SQL: PCADEASTCLS Type: view CONSUMPTION

P_AssetClassWithAccountAssgmt is a Consumption CDS View in SAP S/4HANA. It reads from 6 data sources and exposes 9 fields with key fields CompanyCode, AssetClass, AssetRealDepreciationArea.

6 data source(s) 9 fields

Data Sources (6)

SourceAliasJoin Type
I_AssetClassByCompanyCode AssetClass left_outer
I_AssetClass AssetClassDetail inner
I_AssetBalanceSheetAccount BSAccount inner
I_CompanyCode CompanyCode from
I_OrdinaryDeprValAdjmtAccount OrdinaryDeprValAdjmtAccount inner
I_RevalOrdnryDeprValAdjmtAcct RevalValueAdjustmentAccount inner

Parameters (1)

NameTypeDefault
P_AssetRealDepreciationArea afabe_d

Annotations (7)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName PCADEASTCLS view
VDM.viewType #CONSUMPTION view
VDM.private true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_CompanyCode CompanyCode
KEY AssetClass I_AssetClassByCompanyCode AssetClass
KEY AssetRealDepreciationArea
ChartOfAccounts I_CompanyCode ChartOfAccounts
AssetClassName I_AssetClassByCompanyCode AssetClassName
AssetAccountDetermination I_AssetClass AssetAccountDetermination
AcqnProdnCostGLAccount
OrdinaryDeprValAdjmtGLAccount
RevalOrdnryDeprValAdjmtGLAcct 
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'PCADEASTCLS'
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_AssetClassWithAccountAssgmt
  with parameters
    P_AssetRealDepreciationArea : afabe_d
  as select from I_CompanyCode as CompanyCode
    left outer join I_AssetClassByCompanyCode  as AssetClass             on AssetClass.CompanyCode = CompanyCode.CompanyCode 
                                                                         or AssetClass.CompanyCode = '*'
    inner join   I_AssetClass                  as AssetClassDetail       on AssetClassDetail.AssetClass = AssetClass.AssetClass
    inner join   I_AssetBalanceSheetAccount    as BSAccount              on  BSAccount.CompanyCode               = CompanyCode.CompanyCode
                                                                         and BSAccount.AssetAccountDetermination = AssetClassDetail.AssetAccountDetermination
                                                                         and BSAccount.AssetRealDepreciationArea = $parameters.P_AssetRealDepreciationArea
    inner join   I_OrdinaryDeprValAdjmtAccount as OrdinaryDeprValAdjmtAccount on  OrdinaryDeprValAdjmtAccount.CompanyCode               = CompanyCode.CompanyCode
                                                                              and OrdinaryDeprValAdjmtAccount.AssetAccountDetermination = AssetClassDetail.AssetAccountDetermination
                                                                              and OrdinaryDeprValAdjmtAccount.AssetRealDepreciationArea = $parameters.P_AssetRealDepreciationArea                                                                                        
    inner join   I_RevalOrdnryDeprValAdjmtAcct as RevalValueAdjustmentAccount on  RevalValueAdjustmentAccount.CompanyCode               = CompanyCode.CompanyCode
                                                                         and RevalValueAdjustmentAccount.AssetAccountDetermination = AssetClassDetail.AssetAccountDetermination
                                                                         and RevalValueAdjustmentAccount.AssetRealDepreciationArea = $parameters.P_AssetRealDepreciationArea
{
  key CompanyCode.CompanyCode,
  key AssetClass.AssetClass,
  key $parameters.P_AssetRealDepreciationArea as AssetRealDepreciationArea,
      CompanyCode.ChartOfAccounts,
      AssetClass.AssetClassName,
      AssetClassDetail.AssetAccountDetermination                      as AssetAccountDetermination,
      ltrim(BSAccount.AcqnProdnCostGLAccount,'0')                     as AcqnProdnCostGLAccount,
      ltrim(OrdinaryDeprValAdjmtAccount.OrdinaryDeprValAdjmtGLAccount,'0') as OrdinaryDeprValAdjmtGLAccount,
      ltrim(RevalValueAdjustmentAccount.RevalOrdnryDeprValAdjmtGLAcct,'0') as RevalOrdnryDeprValAdjmtGLAcct
      //      cast('' as abap.char( 10 )) as OrdinaryDeprValAdjmtGLAccount,

      //      cast('' as abap.char( 10 )) as RevalOrdnryDeprValAdjmtGLAcct

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETBALANCESHEETACCOUNT",
"I_ASSETCLASS",
"I_ASSETCLASSBYCOMPANYCODE",
"I_COMPANYCODE",
"I_ORDINARYDEPRVALADJMTACCOUNT",
"I_REVALORDNRYDEPRVALADJMTACCT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More