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

    inner join P_SlalitypeDerivation( P_AssetAccountingKeyFigureSet: $parameters.P_AssetAccountingKeyFigureSet ) as Derivation            on  Derivation.AssetAccountingKeyFigure      = AssetKeyFigureSetSpec.AssetAccountingKeyFigure
                                                                                                                                          and Derivation.AssetAcctTransClassfctn       = Values.AssetAcctTransClassfctn
                                                                                                                                          and Derivation.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 Derivation.SubLedgerAcctLineItemType,
  key Derivation.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.PartnerCompanyCode,
      Values.PartnerMasterFixedAsset,
      Values.PartnerFixedAsset,
      Values.AccountingDocumentCreationDate,
      Values.CreationTime,
      Values.PostingDate,
      Values.DocumentDate,
      Values.AssetValueDate,
      Values.AccountingDocCreatedByUser,
      Values.FinancialClosingStep,
      Values.BusinessTransactionType,
      Values.BusinessTransactionCategory,
      Values.AssetTransactionType,
      Values.AssignmentReference,
      Values.DocumentItemText,
      Values.ReferenceDocumentType,
      Values.ReferenceDocument,
      Values.ReferenceDocumentItem,
      Values.LogicalSystem,
      Values.ReferenceDocumentContext,
      Values.PredecessorJournalEntry,
      Values.PredecessorReferenceDocument,
      Values.PredecessorReferenceDocItem,
      Values.PredecessorReferenceDocCntxt,
      Values.PredecessorReferenceDocType,
      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

//    and Values.SubLedgerAcctLineItemType between '07000' and '07999'

//and Values.AssetAcctTransClassfctn is not initial