P_AstKeyFigBalComprnCube1

DDL: P_ASTKEYFIGBALCOMPRNCUBE1 SQL: PASTKEYFIGCMPC1 Type: view CONSUMPTION Package: FINS_FAA_MD_VALUES

Asset Key Figure Balance Comparison Cube 1

P_AstKeyFigBalComprnCube1 is a Consumption CDS View that provides data about "Asset Key Figure Balance Comparison Cube 1" in SAP S/4HANA. It reads from 3 data sources (I_AssetValuation, I_DepreciationAreaForLedger, P_AstKeyFigBalComprnCube2) and exposes 19 fields with key fields CompanyCode, AssetDepreciationArea, Ledger, MasterFixedAsset, FixedAsset. Part of development package FINS_FAA_MD_VALUES.

3 data source(s) 19 fields

Data Sources (3)

SourceAliasJoin Type
I_AssetValuation AssetValuation inner
I_DepreciationAreaForLedger DepreciationAreaForLedger from
P_AstKeyFigBalComprnCube2 P_AstKeyFigBalComprnCube2 inner

Parameters (7)

NameTypeDefault
P_CompanyCode bukrs
P_MasterFixedAsset anln1
P_FixedAsset anln2
P_AssetAccountingKeyFigureSet faa_key_figure_set
P_CurrencyRole fis_curtp
P_CreationDateTime timestampl
P_UserID username

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PASTKEYFIGCMPC1 view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.buffering.status #NOT_ALLOWED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode Values CompanyCode
KEY AssetDepreciationArea I_DepreciationAreaForLedger AssetDepreciationArea
KEY Ledger Values Ledger
KEY MasterFixedAsset Values MasterFixedAsset
KEY FixedAsset Values FixedAsset
KEY FiscalYear FiscalYear
KEY CurrencyRole CurrencyRole
KEY AssetAccountingValueType AssetAccountingValueType
KEY AssetValuationView Values AssetValuationView
DisplayCurrency DisplayCurrency
AmountInDisplayCurrency AmountInDisplayCurrency
Criticality Criticality
_CompanyCode Values _CompanyCode
_MasterFixedAsset Values _MasterFixedAsset
_FixedAsset Values _FixedAsset
_Ledger Values _Ledger
_AssetAccountingValueType Values _AssetAccountingValueType
_Currency Values _Currency
_CurrencyRole Values _CurrencyRole 
@AbapCatalog.sqlViewName: 'PASTKEYFIGCMPC1'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AbapCatalog.buffering.status: #NOT_ALLOWED

define view P_AstKeyFigBalComprnCube1
  with parameters
    P_CompanyCode                 : bukrs,
    P_MasterFixedAsset            : anln1,
    P_FixedAsset                  : anln2,
    P_AssetAccountingKeyFigureSet : faa_key_figure_set,
    P_CurrencyRole                : fis_curtp,
    P_CreationDateTime            : timestampl,
    P_UserID                      : username

  as select from I_DepreciationAreaForLedger as DepreciationAreaForLedger

  inner join          I_AssetValuation            as AssetValuation on  AssetValuation.CompanyCode           = :P_CompanyCode
                                                                    and AssetValuation.MasterFixedAsset      = :P_MasterFixedAsset
                                                                    and AssetValuation.FixedAsset            = :P_FixedAsset
                                                                    and AssetValuation.Ledger                = DepreciationAreaForLedger.Ledger
                                                                    and AssetValuation.AssetDepreciationArea = DepreciationAreaForLedger.AssetDepreciationArea

  inner join          P_AstKeyFigBalComprnCube2( P_CompanyCode:                  :P_CompanyCode,
                                                 P_MasterFixedAsset:             :P_MasterFixedAsset,
                                                 P_FixedAsset:                   :P_FixedAsset,
                                                 P_AssetAccountingKeyFigureSet:  :P_AssetAccountingKeyFigureSet,
                                                 P_CurrencyRole:                 :P_CurrencyRole,
                                                 P_CreationDateTime:             :P_CreationDateTime,
                                                 P_UserID:                       :P_UserID
                                               )  as Values         on  Values.CompanyCode           = DepreciationAreaForLedger.CompanyCode
                                                                    and Values.Ledger                = DepreciationAreaForLedger.Ledger
                                                                    and Values.AssetDepreciationArea = DepreciationAreaForLedger.AssetDepreciationArea

{
       @ObjectModel.foreignKey.association: '_CompanyCode'
  key  Values.CompanyCode,
  key  DepreciationAreaForLedger.AssetDepreciationArea,
       @ObjectModel.foreignKey.association: '_Ledger'
  key  Values.Ledger,
       @ObjectModel.foreignKey.association: '_MasterFixedAsset'
  key  Values.MasterFixedAsset,
       @ObjectModel.foreignKey.association: '_FixedAsset'
  key  Values.FixedAsset,
  key  FiscalYear,
       @ObjectModel.foreignKey.association: '_CurrencyRole'
  key  CurrencyRole,
       @ObjectModel.foreignKey.association: '_AssetAccountingValueType'
  key  AssetAccountingValueType,
  key  Values.AssetValuationView,

       @Semantics.currencyCode:true
       @ObjectModel.foreignKey.association: '_Currency'
       DisplayCurrency,

       @DefaultAggregation:#SUM
       @Semantics.amount.currencyCode: 'DisplayCurrency'
       AmountInDisplayCurrency,

       Criticality,

       Values._CompanyCode,
       Values._MasterFixedAsset,
       Values._FixedAsset,
       Values._Ledger,
       Values._AssetAccountingValueType,
       Values._Currency,
       Values._CurrencyRole

}

Learn More