I_AssetBalanceOverview

@AbapCatalog.sqlViewName: 'IASSETBALOVW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Asset Balance Overview'
@ObjectModel.usageType: {
  sizeCategory: #XL,
  serviceQuality: #D,
  dataClass: #MIXED
}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_AssetBalanceOverview
  with parameters
    P_TodayDate                   : fagl_keydate,
    P_AssetAccountingKeyFigureSet : faa_key_figure_set,
    P_FiscalYear                  : fis_ryear,
    P_FiscalPeriod                : fis_poper,
    P_KeyDate                     : fagl_keydate
  as select from I_AssetBalanceCube( P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet,
                                     P_FiscalYear:                  :P_FiscalYear,
                                     P_FiscalPeriod:                :P_FiscalPeriod,
                                     P_KeyDate:                     :P_KeyDate )
  association [1] to I_AssetRedesignSwitchStatus as _AssetRedesignSwitchStatus on _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = ''
                                                                               or _AssetRedesignSwitchStatus.AssetRedesignSwitchIsActive = 'X'
{
  key CompanyCode,
  key MasterFixedAsset,
  key FixedAsset,
  key AssetDepreciationArea,
  key Ledger,
  key LedgerFiscalYear,
  key FiscalYear,
  key FiscalPeriod,
  key SubLedgerAcctLineItemType,
  key AssetAcctTransClassfctn,
  key AssetAccountingKeyFigure,
  key AssetAccountingKeyFigureSet,
  key AccountingDocument,
  key TransactionSubitem,
  key DebitCreditCode,
  key CurrencyRole,

      @Environment.sql.passValue: true
      SelectedCurrencyBranch,

      FiscalYearVariant,
      ChartOfDepreciation,
      ControllingArea,

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

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

      /* Fixed Asset Under Construction */
      _FixedAsset.AssetUnderConstIsInvmtMsr,
      _FixedAsset.IsLineItemSettled,

      /* Text Fields */
      _FixedAsset.FixedAssetDescription,

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

      @Semantics.amount.currencyCode: 'DisplayCurrency'
      AmountInDisplayCurrency                                             as NetBookValueAmtInDspCrcy,

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

}
where
  AssetAccountingKeyFigure = '0010790401' // Net Book Value at Reporting Date, Planned - "KeyFigure" - see view FAAV_KFCSET_SPEC

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