P_FixedAssetTransaction2

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@VDM.private:true
@Metadata.ignorePropagatedAnnotations: true

define view entity P_FixedAssetTransaction2
  with parameters
    P_AssetAccountingKeyFigureSet : faa_key_figure_set

  as select from I_LedgerCompanyCodeCrcyRoles  as LedgerCompanyCodeCrcyRole
    inner join   I_FixedAssetLineItem          as Values                on  Values.CompanyCode = LedgerCompanyCodeCrcyRole.CompanyCode
                                                                        and Values.Ledger      = LedgerCompanyCodeCrcyRole.Ledger
    inner join   I_AssetKeyFigureSetSpec       as AssetKeyFigureSetSpec on AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet = $parameters.P_AssetAccountingKeyFigureSet
    inner join   I_AssetKeyFigureSpecification as AssetKeyFigureSpec    on  AssetKeyFigureSpec.AssetAccountingKeyFigure      = AssetKeyFigureSetSpec.AssetAccountingKeyFigure
                                                                        and AssetKeyFigureSpec.AssetAcctAnlytlTransClassfctn = Values.AssetAcctTransClassfctn
                                                                        and AssetKeyFigureSpec.SubLedgerAcctLineItemType     = Values.SubLedgerAcctLineItemType
{
  key Values.CompanyCode,
  key Values.AssetDepreciationArea,
  key Values.MasterFixedAsset,
  key Values.FixedAsset,
  key Values.Ledger,
  key Values.FiscalYear,
  key Values.FiscalPeriod,
  key Values.SubLedgerAcctLineItemType,
  key Values.AssetAcctTransClassfctn,
  key AssetKeyFigureSetSpec.AssetAccountingKeyFigure,
  key AssetKeyFigureSetSpec.AssetAccountingKeyFigureSet,
  key Values.AccountingDocument,
  key Values.LedgerGLLineItem,
  key Values.TransactionSubitem,
  key Values.DebitCreditCode,

      Values.ChartOfDepreciation,
      Values.ControllingArea,
      Values.Country,
      Values.FinancialManagementArea,
      Values.FiscalYearVariant,
      Values.LedgerFiscalYear,
      Values.FiscalYearPeriod,
      Values.LedgerGroup,

      Values.GroupMasterFixedAsset,
      Values.GroupFixedAsset,
      Values.AccountingDocumentCreationDate,
      Values.CreationTime,
      Values.PostingDate,
      Values.DocumentDate,
      Values.AssetValueDate,
      Values.AccountingDocCreatedByUser,
      Values.AssetTransactionType,
      Values.AssignmentReference,
      Values.DocumentItemText,
      Values.ReferenceDocumentType,
      Values.ReferenceDocument,
      Values.LogicalSystem,
      Values.ReferenceDocumentContext,
      Values.ReversalReferenceDocumentCntxt,
      Values.ReversalReferenceDocument,
      Values.ReversalTransactionSubitem,
      Values.IsReversal,
      Values.IsReversed,
      Values.BusinessArea,
      Values.Segment,
      Values.FinancialAccountType,
      Values.Fund,
      Values.GrantID,
      Values.FunctionalArea,
      Values.BudgetPeriod,
      Values.IsStatisticalDocument,

      Values.CompanyCodeCurrency,
      Values.GlobalCurrency,
      Values.FunctionalCurrency,
      Values.FreeDefinedCurrency1,
      Values.FreeDefinedCurrency2,
      Values.FreeDefinedCurrency3,
      Values.FreeDefinedCurrency4,
      Values.FreeDefinedCurrency5,
      Values.FreeDefinedCurrency6,
      Values.FreeDefinedCurrency7,
      Values.FreeDefinedCurrency8,

      Values.BaseUnit,
      @DefaultAggregation: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'BaseUnit'} }
      Values.Quantity,

      @Semantics.amount.currencyCode: 'CompanyCodeCurrency'
      Values.AmountInCompanyCodeCurrency,
      @Semantics.amount.currencyCode: 'GlobalCurrency'
      Values.AmountInGlobalCurrency,
      @Semantics.amount.currencyCode: 'FunctionalCurrency'
      Values.AmountInFunctionalCurrency,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
      Values.AmountInFreeDefinedCurrency1,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
      Values.AmountInFreeDefinedCurrency2,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
      Values.AmountInFreeDefinedCurrency3,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
      Values.AmountInFreeDefinedCurrency4,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
      Values.AmountInFreeDefinedCurrency5,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
      Values.AmountInFreeDefinedCurrency6,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
      Values.AmountInFreeDefinedCurrency7,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
      Values.AmountInFreeDefinedCurrency8,

      LedgerCompanyCodeCrcyRole.CompanyCodeCurrencyRole,
      LedgerCompanyCodeCrcyRole.GlobalCurrencyRole,
      LedgerCompanyCodeCrcyRole.FunctionalCurrencyRole,
      LedgerCompanyCodeCrcyRole.FreeDefinedCurrency1Role,
      LedgerCompanyCodeCrcyRole.FreeDefinedCurrency2Role,
      LedgerCompanyCodeCrcyRole.FreeDefinedCurrency3Role,
      LedgerCompanyCodeCrcyRole.FreeDefinedCurrency4Role,
      LedgerCompanyCodeCrcyRole.FreeDefinedCurrency5Role,
      LedgerCompanyCodeCrcyRole.FreeDefinedCurrency6Role,
      LedgerCompanyCodeCrcyRole.FreeDefinedCurrency7Role,
      LedgerCompanyCodeCrcyRole.FreeDefinedCurrency8Role
}
where
  Values.AssetAcctTransClassfctn <> '00' //No balance carry forward items

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ASSETKEYFIGURESETSPEC",
"I_ASSETKEYFIGURESPECIFICATION",
"I_FIXEDASSETLINEITEM",
"I_LEDGERCOMPANYCODECRCYROLES"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/