P_FIVALUATIONRESULTLISTORI

@AccessControl.authorizationCheck: #NOT_ALLOWED
@VDM.private:true
@VDM.viewType: #COMPOSITE

@ObjectModel: {
                usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }

define view entity P_FIVALUATIONRESULTLISTORI
  as select from I_GLAccountLineItem           as acdoca
    inner join   I_JrnlPerdEndClsgRunLogResult as result_list on  acdoca.CompanyCode                    = result_list.CompanyCode
                                                              and acdoca.FiscalYear                     = result_list.FiscalYear
                                                              and acdoca.AccountingDocument             = result_list.AccountingDocument
                                                              and acdoca.LedgerGLLineItem               = result_list.LedgerGLLineItem
                                                              and acdoca.Ledger                         = result_list.Ledger
                                                              and acdoca.JrnlPeriodEndClosingRunLogUUID = result_list.JrnlPeriodEndClosingRunLogUUID


{
  key result_list.JrnlPerdEndClsgRunResultUUID,
      acdoca.Ledger,
      acdoca.CompanyCode,
      acdoca.FiscalYear,
      acdoca.AccountingDocument,
      acdoca.LedgerGLLineItem,
      result_list.JrnlPeriodEndClosingRunLogUUID,
      acdoca.BalanceTransactionCurrency,
      acdoca.AmountInBalanceTransacCrcy,
      acdoca.CompanyCodeCurrency,
      acdoca.AmountInCompanyCodeCurrency,
      acdoca.GlobalCurrency,
      acdoca.AmountInGlobalCurrency,

      acdoca.FreeDefinedCurrency1,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency1'
      acdoca.AmountInFreeDefinedCurrency1,
      acdoca.FreeDefinedCurrency2,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency2'
      acdoca.AmountInFreeDefinedCurrency2,
      acdoca.FreeDefinedCurrency3,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency3'
      acdoca.AmountInFreeDefinedCurrency3,
      acdoca.FreeDefinedCurrency4,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency4'
      acdoca.AmountInFreeDefinedCurrency4,
      acdoca.FreeDefinedCurrency5,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency5'
      acdoca.AmountInFreeDefinedCurrency5,
      acdoca.FreeDefinedCurrency6,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency6'
      acdoca.AmountInFreeDefinedCurrency6,
      acdoca.FreeDefinedCurrency7,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency7'
      acdoca.AmountInFreeDefinedCurrency7,
      acdoca.FreeDefinedCurrency8,
      @Semantics.amount.currencyCode: 'FreeDefinedCurrency8'
      acdoca.AmountInFreeDefinedCurrency8,
      acdoca.FinancialTransactionType,
      acdoca.ProfitCenter,
      acdoca.SalesDocument               as SalesOrder,
      acdoca.SalesDocumentItem           as SalesOrderItem,
      acdoca.Supplier,
      acdoca.Customer,
      acdoca.HouseBank,
      acdoca.HouseBankAccount,
      acdoca.CostCtrActivityType,
      acdoca.OrderID,
      acdoca.WBSElementInternalID,
      acdoca.ProjectNetwork,
      acdoca.RelatedNetworkActivity,
      acdoca.BusinessProcess,
      acdoca.CostCenter,
      acdoca.FunctionalArea,
      acdoca.BusinessArea,
      acdoca.ControllingArea,
      acdoca.Segment,
      acdoca.PartnerCostCenter,
      acdoca.PartnerProfitCenter,
      acdoca.PartnerFunctionalArea,
      acdoca.PartnerBusinessArea,
      acdoca.PartnerCompany,
      acdoca.CostObject,
      acdoca.PartnerSegment,
      acdoca.JointVenture,
      acdoca.JointVentureEquityGroup,
      acdoca.JointVentureCostRecoveryCode,
      acdoca.JointVenturePartner,
      acdoca.PartnerVenture,
      acdoca.FinancialValuationObjectType,
      acdoca.FinancialValuationObject,
      acdoca.FinancialValuationSubobject,
      acdoca.REBusinessEntity,
      acdoca.RealEstateBuilding,
      acdoca.RealEstateProperty,

      acdoca.GLAccount,
      acdoca.OffsettingAccount,

      acdoca.SubLedgerAcctLineItemType,
      acdoca.ChartOfAccounts,
      acdoca.PostingDate,
      acdoca.AccountingDocumentCategory,
      acdoca.IsOpenItemManaged,
      acdoca.ClearingDate,
      acdoca.ClearingAccountingDocument,
      acdoca.ClearingDocFiscalYear,
      acdoca.FiscalPeriod,

      acdoca.PrdcssrJournalEntryCompanyCode,
      acdoca.PrdcssrJournalEntryFiscalYear,
      acdoca.PredecessorJournalEntry,
      acdoca.PredecessorJournalEntryItem,

      acdoca.InvoiceItemReference,
      acdoca.InvoiceReference,
      acdoca.InvoiceReferenceFiscalYear,
      acdoca.FollowOnDocumentType,
      acdoca.AccountingDocumentItem,
      acdoca.BusinessTransactionType,
      acdoca.FinancialAccountType,
      acdoca.GeneralLedgerAgingScope,
      acdoca.GeneralLedgerAgingIncrement as PostedAgingIncrement,

      //      result_list.FreeDefinedCurrency1,

      result_list.FreeDefinedCurrency1   as FinClsgRunRsltFDCrcy1,
      @Semantics.amount.currencyCode: 'FinClsgRunRsltFDCrcy1'
      result_list.FinClsgRunRsltAmtInFDCrcy1,

      //      result_list.FreeDefinedCurrency2,

      result_list.FreeDefinedCurrency2   as FinClsgRunRsltFDCrcy2,
      @Semantics.amount.currencyCode: 'FinClsgRunRsltFDCrcy2'
      result_list.FinClsgRunRsltAmtInFDCrcy2,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list.FreeDefinedCurrency3   as FinClsgRunRsltFDCrcy3,
      @Semantics.amount.currencyCode: 'FinClsgRunRsltFDCrcy3'
      result_list.FinClsgRunRsltAmtInFDCrcy3,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list.FreeDefinedCurrency4   as FinClsgRunRsltFDCrcy4,
      @Semantics.amount.currencyCode: 'FinClsgRunRsltFDCrcy4'
      result_list.FinClsgRunRsltAmtInFDCrcy4,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list.FreeDefinedCurrency5   as FinClsgRunRsltFDCrcy5,
      @Semantics.amount.currencyCode: 'FinClsgRunRsltFDCrcy5'
      result_list.FinClsgRunRsltAmtInFDCrcy5,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list.FreeDefinedCurrency6   as FinClsgRunRsltFDCrcy6,
      @Semantics.amount.currencyCode: 'FinClsgRunRsltFDCrcy6'
      result_list.FinClsgRunRsltAmtInFDCrcy6,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list.FreeDefinedCurrency7   as FinClsgRunRsltFDCrcy7,
      @Semantics.amount.currencyCode: 'FinClsgRunRsltFDCrcy7'
      result_list.FinClsgRunRsltAmtInFDCrcy7,

      //      @Semantics.amount.currencyCode: 'TargetCurrency'

      result_list.FreeDefinedCurrency8   as FinClsgRunRsltFDCrcy8,
      @Semantics.amount.currencyCode: 'FinClsgRunRsltFDCrcy8'
      result_list.FinClsgRunRsltAmtInFDCrcy8,
      
      result_list.ExchangeRate,
      result_list.FinClosingRunIsTestExecution,
      result_list.FinancialClosingLineItemType,
      result_list.FinancialClosingLineItemStatus,
      result_list.FinClosingEntryCalculationType,
      result_list.CreditRiskClass,
      result_list.GeneralLedgerAgingIncrement,
      result_list.NetDueDate,
      result_list.OldestOpenItemNetDueDate,
      result_list.ExpectedCreditLossPercent,
      result_list.FinancialClosingGroupingRule,
      result_list.FinClosingGroupingRuleStep,
      result_list.FinancialClosingGrouping,
      result_list.FinClosingLineItemDetailStatus,
      result_list.InterestCalculationCode,
      result_list.DiscountingAnnualInterestRate,
      result_list.DiscgFiscalPeriodInterestRate,
      result_list.DiscgDurationInFiscalPeriods,
      result_list.NrOfDiscountedFiscalPeriods,
      result_list.LongTrmAstLbltyDiscountFactor,
      result_list.FinancialClosingValuationRule,
      result_list.FinClosingValuationRuleStep,
      result_list.PrdcssrPerdEndClsgRunRsltUUID


}
where
  result_list.FinancialClosingLineItemStatus = 'U'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEM",
"I_JRNLPERDENDCLSGRUNLOGRESULT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/