I_AssetTransactionStatisticOvw

DDL: I_ASSETTRANSACTIONSTATISTICOVW SQL: IASSETSTSOV Type: view COMPOSITE

Asset Statistics Overview

I_AssetTransactionStatisticOvw is a Composite CDS View that provides data about "Asset Statistics Overview" in SAP S/4HANA. It reads from 2 data sources (I_FixedAssetTransaction, I_FixedAssetTransaction) and exposes 74 fields with key fields CompanyCode, AssetDepreciationArea, MasterFixedAsset, FixedAsset, Ledger. It has 1 association to related views.

2 data source(s) 74 fields

Data Sources (2)

SourceAliasJoin Type
I_FixedAssetTransaction I_FixedAssetTransaction from
I_FixedAssetTransaction I_FixedAssetTransaction union

Parameters (1)

NameTypeDefault
P_KeyDate fagl_keydate

Associations (1)

CardinalityTargetAliasCondition
[1] I_AssetRedesignSwitchStatus _AssetRedesignSwitchStatus _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = '' or _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = 'X'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IASSETSTSOV view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Asset Statistics Overview view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AssetDepreciationArea AssetDepreciationArea
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY Ledger Ledger
KEY LedgerFiscalYear LedgerFiscalYear
KEY FiscalYear FiscalYear
KEY FiscalPeriod FiscalPeriod
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet
KEY AccountingDocument AccountingDocument
KEY TransactionSubitem TransactionSubitem
KEY DebitCreditCode DebitCreditCode
KEY CurrencyRole CurrencyRole
ControllingArea ControllingArea
AssetClass AssetClass
AssetAccountDetermination AssetAccountDetermination
AssetCountryOfOrigin
AssetSupplier _FixedAsset Supplier
SupplierAccountGroup
SupplierBasicAuthorizationGrp
AssetCostCenter AssetCostCenter
AssetPlant AssetPlant
AssetProfitCenter AssetProfitCenter
AssetSegment AssetSegment
SelectedCurrencyBranch SelectedCurrencyBranch
DisplayCurrency DisplayCurrency
AcqnProdnAmtInDspCrcy AcqnProdnAmtInDspCrcy
OriglAcqnAmtInCoCodeCrcy AcqnProdnAmtInDspCrcy
RtrmtNetBookValueAmtInDspCrcy RtrmtNetBookValueAmtInDspCrcy
RetirementAmountInDspCrcy
AmountInDisplayCurrency
OriginalAmountInDspCrcy
_FixedAsset _FixedAsset
_AssetClassText _AssetClassText
KEY AssetDepreciationArea AssetDepreciationArea
KEY MasterFixedAsset MasterFixedAsset
KEY FixedAsset FixedAsset
KEY Ledger Ledger
KEY LedgerFiscalYear LedgerFiscalYear
KEY FiscalYear FiscalYear
KEY FiscalPeriod FiscalPeriod
KEY SubLedgerAcctLineItemType SubLedgerAcctLineItemType
KEY AssetAcctTransClassfctn AssetAcctTransClassfctn
KEY AssetAccountingKeyFigure AssetAccountingKeyFigure
KEY AssetAccountingKeyFigureSet AssetAccountingKeyFigureSet
KEY AccountingDocument AccountingDocument
KEY TransactionSubitem TransactionSubitem
KEY DebitCreditCode DebitCreditCode
KEY CurrencyRole CurrencyRole
ControllingArea ControllingArea
AssetClass AssetClass
AssetAccountDetermination AssetAccountDetermination
AssetCountryOfOrigin _FixedAsset AssetCountryOfOrigin
AssetSupplier _FixedAsset Supplier
SupplierAccountGroup
SupplierBasicAuthorizationGrp
AssetCostCenter AssetCostCenter
AssetPlant AssetPlant
AssetProfitCenter AssetProfitCenter
AssetSegment AssetSegment
SelectedCurrencyBranch SelectedCurrencyBranch
DisplayCurrency DisplayCurrency
AcqnProdnAmtInDspCrcy AcqnProdnAmtInDspCrcy
OriglAcqnAmtInCoCodeCrcy
RtrmtNetBookValueAmtInDspCrcy RtrmtNetBookValueAmtInDspCrcy
RetirementAmountInDspCrcy
AmountInDisplayCurrency
OriginalAmountInDspCrcy
_FixedAsset _FixedAsset
_AssetClassText _AssetClassText
_AssetRedesignSwitchStatus _AssetRedesignSwitchStatus 
@AbapCatalog.sqlViewName: 'IASSETSTSOV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Asset Statistics Overview'
@ObjectModel.usageType: {
  sizeCategory: #XXL,
  serviceQuality: #C,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
define view I_AssetTransactionStatisticOvw
  with parameters
    P_KeyDate : fagl_keydate
  as select from I_FixedAssetTransaction(P_KeyDate                    : :P_KeyDate,
                                         P_AssetAccountingKeyFigureSet: 'TRANS_ACQ')
    association [1] to I_AssetRedesignSwitchStatus as _AssetRedesignSwitchStatus on  _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = ''  
                                                                                 or  _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = 'X'
{
  key    CompanyCode,
  key    AssetDepreciationArea,
  key    MasterFixedAsset,
  key    FixedAsset,
  key    Ledger,
  key    LedgerFiscalYear,
  key    FiscalYear,
  key    FiscalPeriod,
  key    SubLedgerAcctLineItemType,
  key    AssetAcctTransClassfctn,
  key    AssetAccountingKeyFigure,
  key    AssetAccountingKeyFigureSet,
  key    AccountingDocument,
  key    TransactionSubitem,
  key    DebitCreditCode,
  key    CurrencyRole,

         ControllingArea,

         /* Fields from Fixed Asset */
         AssetClass,
         AssetAccountDetermination,
         cast(_FixedAsset.AssetCountryOfOrigin as faa_asset_cntry_of_origin)     as AssetCountryOfOrigin,
         _FixedAsset.Supplier                                                    as AssetSupplier,
         _FixedAsset._Supplier.SupplierAccountGroup,
         _FixedAsset._Supplier.AuthorizationGroup                                as SupplierBasicAuthorizationGrp,

         /* Fields from Fixed Asset (Time-Dependent Data) */
         AssetCostCenter,
         AssetPlant,
         AssetProfitCenter,
         AssetSegment,

         @Environment.sql.passValue: true
         SelectedCurrencyBranch,

         /* Amounts */
         @Semantics.currencyCode:true
         DisplayCurrency,

         @Semantics.amount.currencyCode: 'DisplayCurrency'
         AcqnProdnAmtInDspCrcy,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         AcqnProdnAmtInDspCrcy                                                   as OriglAcqnAmtInCoCodeCrcy,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         RtrmtNetBookValueAmtInDspCrcy,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         cast(0 as fis_retirementnbv)                                            as RetirementAmountInDspCrcy,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         cast(AcqnProdnAmtInDspCrcy as farp_amount_display_crcy preserving type) as AmountInDisplayCurrency,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         cast(AcqnProdnAmtInDspCrcy as farp_amount_display_crcy)                 as OriginalAmountInDspCrcy,

         /* Associations */
         _FixedAsset,
         _AssetClassText,
         @Consumption.hidden: true  
         _AssetRedesignSwitchStatus //for DCL

}
union select from I_FixedAssetTransaction(P_KeyDate                    : :P_KeyDate,
                                          P_AssetAccountingKeyFigureSet: 'TRANS_RET')
  association [1] to I_AssetRedesignSwitchStatus as _AssetRedesignSwitchStatus on  _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = ''  
                                                                               or  _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = 'X'
{
  key    CompanyCode,
  key    AssetDepreciationArea,
  key    MasterFixedAsset,
  key    FixedAsset,
  key    Ledger,
  key    LedgerFiscalYear,
  key    FiscalYear,
  key    FiscalPeriod,
  key    SubLedgerAcctLineItemType,
  key    AssetAcctTransClassfctn,
  key    AssetAccountingKeyFigure,
  key    AssetAccountingKeyFigureSet,
  key    AccountingDocument,
  key    TransactionSubitem,
  key    DebitCreditCode,
  key    CurrencyRole,

         ControllingArea,

         /* Fields from Fixed Asset */
         AssetClass,
         AssetAccountDetermination,
         _FixedAsset.AssetCountryOfOrigin,
         _FixedAsset.Supplier                                                      as AssetSupplier,
         _FixedAsset._Supplier.SupplierAccountGroup,
         _FixedAsset._Supplier.AuthorizationGroup                                  as SupplierBasicAuthorizationGrp,

         /* Fields from Fixed Asset (Time-Dependent Data) */
         AssetCostCenter,
         AssetPlant,
         AssetProfitCenter,
         AssetSegment,

         @Environment.sql.passValue: true
         SelectedCurrencyBranch,

         /* Amounts */
         @Semantics.currencyCode:true
         DisplayCurrency,

         @Semantics.amount.currencyCode: 'DisplayCurrency'
         AcqnProdnAmtInDspCrcy,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         cast(0 as fis_apcamount)                                                  as OriglAcqnAmtInCoCodeCrcy,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         RtrmtNetBookValueAmtInDspCrcy,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         ( RtrmtNetBookValueAmtInDspCrcy * -1 )                                    as RetirementAmountInDspCrcy,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         cast(( RtrmtNetBookValueAmtInDspCrcy * -1 ) as farp_amount_display_crcy ) as AmountInDisplayCurrency,
         @Semantics.amount.currencyCode: 'DisplayCurrency'
         cast(RtrmtNetBookValueAmtInDspCrcy as farp_amount_display_crcy)           as OriginalAmountInDspCrcy,

         /* Associations */
         _FixedAsset,
         _AssetClassText,
         @Consumption.hidden: true  
         _AssetRedesignSwitchStatus //for DCL

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FIXEDASSET",
"I_FIXEDASSETTRANSACTION",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_ASSETCLASSTEXT",
"I_ASSETREDESIGNSWITCHSTATUS",
"I_FIXEDASSET"
],
"BASE":
[
"I_FIXEDASSETTRANSACTION"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More