P_FIXEDASSETVALUE

@AbapCatalog: { sqlViewName: 'PFASSETVALUE',
                preserveKey:true}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true

define view P_FixedAssetValue
  with parameters
    P_AssetAccountingKeyFigureSet : faa_key_figure_set

  as select from P_FixedAssetValueWthDetn(P_AssetAccountingKeyFigureSet: :P_AssetAccountingKeyFigureSet) as values
    inner join   I_AssetKeyFigureSetSpec                                                                 as AssetKeyFigureSetSpec on AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet = :P_AssetAccountingKeyFigureSet
    inner join   I_AssetKeyFigureSpecification                                                           as AssetKeyFigureSpec    on  AssetKeyFigureSpec.AssetAccountingKeyFigure      = AssetKeyFigureSetSpec.AssetAccountingKeyFigure
                                                                                                                                  and AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn = values.AssetAcctAnlytlTransClassfctn
                                                                                                                                  and AssetKeyFigureSpec.SubLedgerAcctLineItemType     = values.SubLedgerAcctLineItemType
{

  key values.AssetDepreciationArea,
  key values.CompanyCode,
  key values.FiscalYear,
  key values.MasterFixedAsset,
  key values.FixedAsset,
  key values.AccountingDocument,
  key values.TransactionSubitem,
  key values.Ledger,
  key values.FiscalPeriod,
  key values.SubLedgerAcctLineItemType,
  key values.AssetAcctTransClassfctn,
  key values.DebitCreditCode,

      LedgerFiscalYear,
      FiscalYearVariant,
      FiscalYearPeriod,
      DepreciationFiscalPeriod,

      AssetKeyFigureSetSpec.AssetAccountingSortedKeyFigure,
      values.AssetAcctAnlytlTransClassfctn,
      values.LedgerGroup,
      values.ChartOfAccounts,
      values.CountryChartOfAccounts,
      values.GLAccount,
      values.AlternativeGLAccount,
      values.GroupMasterFixedAsset,
      values.GroupFixedAsset,
      values.FinancialAccountType,
      values.ChartOfDepreciation,

      values.AccountingDocumentCreationDate,
      values.CreationTime,
      values.AccountingDocCreatedByUser,
      values.JointVentureCostRecoveryCode,
      values.CostCenter,
      values.Plant,
      values.BusinessArea,
      values.PersonnelNumber,
      values.FinancialManagementArea,
      values.Fund,
      values.GrantID,
      values.FunctionalArea,
      values.BudgetPeriod,
      values.ProfitCenter,
      values.Segment,
      values.FundsCenter,
      values.AssetTransactionType,
      values.AssetDeactivationDate,
      AssetKeyFigureSpec.AssetAccountingKeyFigure,
      AssetKeyFigureSpec.PlannedValueIsInclusive,

      values.ReferenceDocumentItem,
      values.ReferenceDocumentType,
      values.LogicalSystem,
      values.ReferenceDocument,
      values.ReferenceDocumentContext,
      values.ReversalReferenceDocument,
      values.ReversalReferenceDocumentCntxt,
      values.ReversalTransactionSubitem,
      values.IsReversal,
      values.IsReversed,
      values.DocumentDate,
      values.PostingDate,
      values.AssetValueDate,
      values.AccountingDocumentType,
      values.AssignmentReference,
      values.DocumentItemText,
      values.IsStatisticalDocument,
      values.GLBusinessTransactionType,
      values.PartnerMasterFixedAsset,
      values.PartnerFixedAsset,

      @Semantics.currencyCode:true
      values.CompanyCodeCurrency,
      @Semantics.currencyCode:true
      values.GlobalCurrency,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency1,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency2,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency3,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency4,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency5,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency6,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency7,
      @Semantics.currencyCode:true
      values.FreeDefinedCurrency8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      values.ActualAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      values.ActualAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      values.ActualAmountInFreeDfndCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      values.ActualAmountInFreeDfndCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      values.ActualAmountInFreeDfndCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      values.ActualAmountInFreeDfndCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      values.ActualAmountInFreeDfndCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      values.ActualAmountInFreeDfndCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      values.ActualAmountInFreeDfndCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      values.ActualAmountInFreeDfndCrcy8,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'CompanyCodeCurrency'} }
      values.PlanAmountInCompanyCodeCrcy,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'GlobalCurrency'} }
      values.PlanAmountInGlobalCurrency,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency1'} }
      values.PlanAmountInFreeDefinedCrcy1,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency2'} }
      values.PlanAmountInFreeDefinedCrcy2,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency3'} }
      values.PlanAmountInFreeDefinedCrcy3,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency4'} }
      values.PlanAmountInFreeDefinedCrcy4,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency5'} }
      values.PlanAmountInFreeDefinedCrcy5,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency6'} }
      values.PlanAmountInFreeDefinedCrcy6,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency7'} }
      values.PlanAmountInFreeDefinedCrcy7,

      @DefaultAggregation: #SUM
      @Semantics: { amount : {currencyCode: 'FreeDefinedCurrency8'} }
      values.PlanAmountInFreeDefinedCrcy8,

      @Semantics.unitOfMeasure:true
      BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Quantity
}
where
  (
    (
          IsPlanningDocument                         =  ''
    )
    or(
          IsPlanningDocument                         =  'X'
      and AssetKeyFigureSpec.PlannedValueIsInclusive <> '0'
    )
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETKEYFIGURESETSPEC",
"I_ASSETKEYFIGURESPECIFICATION",
"P_FIXEDASSETVALUEWTHDETN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/