ValuationValuationItems

@AccessControl.authorizationCheck: #NOT_ALLOWED

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

define view entity ValuationValuationItems
  with parameters
    p_fiscal_year_period : fiscalyearperiod

  as select from VALUATIONACDOCA   as acdoca

    inner join   VALUATIONWORKLIST as wl on  acdoca.PrdcssrJournalEntryFiscalYear  = wl.Fiscalyear
                                         and acdoca.PrdcssrJournalEntryCompanyCode = wl.companycode
                                         and acdoca.PredecessorJournalEntry        = wl.accountingdocument
                                         and acdoca.PredecessorJournalEntryItem    = wl.ledgergllineitem
                                         and acdoca.Ledger                         = wl.ledger
                                         and acdoca.OriginalGlAccount              = wl.originalGlAccount
                                         and acdoca.CompanyCode                    = wl.companycode

{
      // only to be valuated line item

  key acdoca.SourceLedger,
  key acdoca.CompanyCode,
  key acdoca.FiscalYear,
  key acdoca.AccountingDocument,
  key acdoca.LedgerGLLineItem,
  key acdoca.Ledger,

      // dimensions

      @Environment.sql.passValue: true
      acdoca.p_is_mdc_on,
      wl.glaccount,
      wl.isopenitemmanaged,
      acdoca.NetDueDate,
      acdoca.OriginalGlAccount,
      wl.group_id,
      wl.grouping_rule,
      wl.grouping_rule_step,
      wl.chartofaccounts,
      wl.marked_for_deletion,
      acdoca.PredecessorReferenceDocCntxt,
      acdoca.PredecessorReferenceDocument,
      acdoca.PredecessorReferenceDocItem,
      acdoca.PrdcssrJournalEntryCompanyCode,
      acdoca.PrdcssrJournalEntryFiscalYear,
      acdoca.PredecessorJournalEntry,
      acdoca.PredecessorJournalEntryItem,
      acdoca.GLRecordType,
      acdoca.OriginalCreditRiskClass as CreditRiskClass,
      wl.businesspartner,

      case  when acdoca.FiscalYearPeriod = $parameters.p_fiscal_year_period
      then 'VALUATION_CURRENT'
      when acdoca.FiscalYearPeriod < $parameters.p_fiscal_year_period and wl.clearingfiscalyearperiod <= acdoca.FiscalYearPeriod
      then 'VALUATION_BETWEEN_CLEARING_AND_CURRENT'
      when acdoca.FiscalYearPeriod < $parameters.p_fiscal_year_period
      then 'VALUATION_PREVIOUS'
      end                            as line_type,

      // filtering fields

      acdoca.CreationDateTime,
      wl.postingdate,
      wl.documentdate                as DocumentDate,
      acdoca.PostingDate             as OriginalPostingDate,
      acdoca.FiscalYearPeriod,
      acdoca.SubLedgerAcctLineItemType,
      acdoca.ReferenceDocumentType,
      acdoca.AccountingDocumentCategory,
      acdoca.ClearingAccountingDocument,
      acdoca.ClearingDocFiscalYear,
      acdoca.ClearingDate,
      acdoca.IsReversal,
      wl.financialclosinglineitemtype,
      wl.finclosinglineitemprocessstep,
      wl.Jrnlperiodendclosingrunloguuid,
      wl.valuation_rule_step,
      wl.customer_supplier_group_key,
      wl.is_cleared_at_keydate       as IsClearedAtKeyDate,
      acdoca.BusinessTransactionCategory,

      // Amount fields

      acdoca.BalanceTransactionCurrency,
      acdoca.AmountInBalanceTransacCrcy,
      acdoca.CompanyCodeCurrency,
      acdoca.AmountInCompanyCodeCurrency,
      acdoca.GlobalCurrency,
      acdoca.AmountInGlobalCurrency,
      acdoca.FreeDefinedCurrency1,
      acdoca.AmountInFreeDefinedCurrency1,
      acdoca.FreeDefinedCurrency2,
      acdoca.AmountInFreeDefinedCurrency2,
      acdoca.FreeDefinedCurrency3,
      acdoca.AmountInFreeDefinedCurrency3,
      acdoca.FreeDefinedCurrency4,
      acdoca.AmountInFreeDefinedCurrency4,
      acdoca.FreeDefinedCurrency5,
      acdoca.AmountInFreeDefinedCurrency5,
      acdoca.FreeDefinedCurrency6,
      acdoca.AmountInFreeDefinedCurrency6,
      acdoca.FreeDefinedCurrency7,
      acdoca.AmountInFreeDefinedCurrency7,
      acdoca.FreeDefinedCurrency8,
      acdoca.AmountInFreeDefinedCurrency8,


      ////valuation fields

      acdoca.HouseBank,
      acdoca.HouseBankAccount,
      acdoca.AssignmentReference,
      acdoca.CostCtrActivityType,
      acdoca.WBSElementInternalID,
      acdoca.FinancialTransactionType,
      acdoca.JointVenture,
      acdoca.JointVentureEquityGroup,
      acdoca.PartnerVenture,
      acdoca.JointVenturePartner,
      acdoca.JointVentureCostRecoveryCode,
      acdoca.JointVentureEquityType,
      acdoca.ProjectNetwork,
      acdoca.RelatedNetworkActivity,
      acdoca.OrderID,
      acdoca.BusinessProcess,
      acdoca.SalesOrder,
      acdoca.SalesOrderItem,
      acdoca.CostObject,
      acdoca.CostCenter,
      acdoca.ProfitCenter,
      acdoca.FunctionalArea,
      acdoca.BusinessArea,
      acdoca.ControllingArea,
      acdoca.Segment,
      acdoca.PartnerCostCenter,
      acdoca.PartnerProfitCenter,
      acdoca.PartnerFunctionalArea,
      acdoca.PartnerBusinessArea,
      case when acdoca.p_is_mdc_on = 'X' then wl.partnercompany
      else acdoca.PartnerCompany end as PartnerCompany,
      acdoca.PartnerSegment,
      acdoca.Supplier,
      acdoca.Customer,
      acdoca.FinancialValuationObjectType,
      acdoca.FinancialValuationObject,
      acdoca.FinancialValuationSubobject,
      acdoca.REBusinessEntity,
      acdoca.RealEstateBuilding,
      acdoca.RealEstateProperty,
      acdoca.Fund,
      acdoca.BudgetPeriod,
      acdoca.GrantID,
      acdoca.PubSecBudgetAccount,
      acdoca.CashLedgerAccount,
      acdoca.SponsoredProgram,
      acdoca.SponsoredClass,
      acdoca.Plant,
      acdoca.Product,
      acdoca.ShipToParty,
      acdoca.WBSElement,
      acdoca.PartnerFund,
      acdoca.PartnerGrant,
      acdoca.CashLedgerCompanyCode,
      acdoca.FundsCenter,
      acdoca.PartnerEquityGroup,
      acdoca.FundedProgram,
      acdoca.PartnerBudgetPeriod,
      acdoca.TaxCode,
      acdoca.TaxCountry,
      acdoca.AccrualObjectType,
      acdoca.AccrualObject,
      acdoca.AccrualSubobject,
      acdoca.AccrualItemType,
      acdoca.AccrualReferenceObject,
      acdoca.AccrualObjectLogicalSystem,
      acdoca.PubSecBudgetAccountCoCode,
      acdoca.ServiceDocument,
      acdoca.ServiceDocumentItem,
      acdoca.ServiceDocumentType,
      acdoca.Material,

      acdoca.relatednetworkactivityinternal,

      acdoca.MASTERDATARECNCLNACCT,
      acdoca.MASTERDATAPARTNERCOMPANY,
      acdoca.SpecialGLCode
}