ValuationValuationItems

@AbapCatalog.sqlViewName: 'VALVALUATION'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@ObjectModel: {
                usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
define view ValuationValuationItems
  with parameters
    p_fiscal_year_period : fiscalyearperiod
  as select from I_GLAccountLineItem as acdoca
    inner join   fins_cls_wl         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.GLAccount                      = wl.glaccount
                                           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

      acdoca.GLAccount,
      wl.isopenitemmanaged,
      wl.netduedate,
      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.CreditRiskClass,
      wl.businesspartner,
      wl.invoiceitemreference,
      wl.invoicereference,
      wl.invoicereferencefiscalyear,
      case  when acdoca.FiscalYearPeriod = :p_fiscal_year_period
      then 'VALUATION_CURRENT'
      when acdoca.FiscalYearPeriod < :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

      case GLAccountType when 'C' then acdoca.HouseBank else ' ' end        as HouseBank,
      case GLAccountType when 'C' then acdoca.HouseBankAccount else ' ' end as 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.SalesDocument                                                  as SalesOrder,
      acdoca.SalesDocumentItem                                              as SalesOrderItem,
      acdoca.CostObject,
      acdoca.CostCenter,
      acdoca.ProfitCenter,
      acdoca.FunctionalArea,
      acdoca.BusinessArea,
      acdoca.ControllingArea,
      acdoca.Segment,
      acdoca.PartnerCostCenter,
      acdoca.PartnerProfitCenter,
      acdoca.PartnerFunctionalArea,
      acdoca.PartnerBusinessArea,
      acdoca.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,
      cast(
      case when acdoca.RelatedNetworkActivity is not initial
      then concat(concat(acdoca.OrderCategory, '/' ), acdoca.AccountAssignment )
      else '' end        as cls_run_nplnr_vorgn_helper )                    as relatednetworkactivityinternal

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_GLACCOUNTLINEITEM",
"FINS_CLS_WL"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/