VALUATIONREORGLINEITEM

@AbapCatalog.sqlViewName: 'PVALREORG'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_ALLOWED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ObjectModel: {
                usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
define view VALUATIONREORGLINEITEM
  as select from fins_cls_wl         as wl
    inner join   I_GLAccountLineItem as acdoca on  acdoca.PredecessorJournalEntry       = wl.accountingdocument
                                               and acdoca.PrdcssrJournalEntryFiscalYear = wl.fiscalyear
                                               and acdoca.PredecessorJournalEntryItem   = wl.ledgergllineitem
                                               and acdoca.CompanyCode                   = wl.companycode
                                               and acdoca.Ledger                        = wl.ledger
                                               and acdoca.GLAccount                     = wl.glaccount
{
      //Debit items are invoices, credit items are payments

  key acdoca.CompanyCode,
  key acdoca.FiscalYear,
  key acdoca.AccountingDocument,
  key acdoca.LedgerGLLineItem,
  key acdoca.Ledger,
  key acdoca.SourceLedger,
      acdoca.GLAccount,
      acdoca.CreationDateTime,
      acdoca.SubLedgerAcctLineItemType,
      acdoca.BusinessTransactionCategory,
      acdoca.PostingDate       as OriginalPostingDate,
      acdoca.LedgerFiscalYear,
      acdoca.FiscalYearPeriod,
      acdoca.FiscalPeriod,
      acdoca.IsReversal,
      acdoca.ReferenceDocumentType,
      acdoca.ProfitCenter      as ReorgProfitCenter,
      acdoca.Segment           as ReorgSegment,
      acdoca.OrganizationalChange,
      acdoca.PredecessorJournalEntry,
      acdoca.PrdcssrJournalEntryFiscalYear,
      acdoca.PredecessorJournalEntryItem,
      acdoca.AccrualObjectType,
      acdoca.AccrualObject,
      acdoca.AccrualSubobject,
      acdoca.AccrualItemType,
      acdoca.AccrualReferenceObject,
      acdoca.AccrualObjectLogicalSystem,
      acdoca.BalanceTransactionCurrency,
      acdoca.CompanyCodeCurrency,
      acdoca.GlobalCurrency,
      acdoca.FreeDefinedCurrency1,
      acdoca.FreeDefinedCurrency2,
      acdoca.FreeDefinedCurrency3,
      acdoca.FreeDefinedCurrency4,
      acdoca.FreeDefinedCurrency5,
      acdoca.FreeDefinedCurrency6,
      acdoca.FreeDefinedCurrency7,
      acdoca.FreeDefinedCurrency8,
      acdoca.AmountInBalanceTransacCrcy,
      acdoca.AmountInCompanyCodeCurrency,
      acdoca.AmountInGlobalCurrency,
      acdoca.AmountInFreeDefinedCurrency1,
      acdoca.AmountInFreeDefinedCurrency2,
      acdoca.AmountInFreeDefinedCurrency3,
      acdoca.AmountInFreeDefinedCurrency4,
      acdoca.AmountInFreeDefinedCurrency5,
      acdoca.AmountInFreeDefinedCurrency6,
      acdoca.AmountInFreeDefinedCurrency7,
      acdoca.AmountInFreeDefinedCurrency8,

      wl.postingdate           as PostingDate,
      wl.documentdate          as DocumentDate,
      wl.postingkey,
      wl.jrnlperiodendclosingrunloguuid,
      wl.currentfiscalyear,
      wl.newaccountingdocument,
      wl.newledgergllineitem,
      wl.accountingprinciple,
      wl.financialvaluationobjecttype,
      wl.financialvaluationobject,
      wl.financialvaluationsubobject,
      wl.netduedate,
      wl.oldestopenitemnetduedate,
      wl.chartofaccounts,
      wl.accountingdocumentcategory,
      wl.isopenitemmanaged,
      wl.is_cleared_at_keydate as ISCLEAREDATKEYDATE,
      wl.offsettingaccount,
      wl.debitcreditcode,
      wl.exchangerate,
      wl.assignmentreference,
      wl.businesspartner,
      wl.predecessorreferencedoctype,
      wl.predecessorreferencedoccntxt,
      wl.predecessorreferencedocument,
      wl.predecessorreferencedocitem,
      wl.prdcssrjournalentrycompanycode,
      wl.invoiceitemreference,
      wl.invoicereference,
      wl.invoicereferencefiscalyear,
      wl.followondocumenttype,
      wl.accountingdocumentitem,
      wl.clearingdate,
      wl.clearingaccountingdocument,
      wl.clearingdocfiscalyear,
      wl.housebank,
      wl.housebankaccount,
      wl.costctractivitytype,
      wl.wbselementinternalid,
      wl.financialtransactiontype,
      wl.jointventure,
      wl.jointventureequitygroup,
      wl.partnerventure,
      wl.jointventurepartner,
      wl.jointventurecostrecoverycode,
      wl.jointventureequitytype,
      wl.projectnetwork,
      wl.relatednetworkactivity,
      wl.orderid,
      wl.businessprocess,
      wl.salesorder,
      wl.salesorderitem,
      wl.costobject,
      wl.costcenter,
      wl.profitcenter,
      wl.functionalarea,
      wl.businessarea,
      wl.controllingarea,
      wl.segment,
      wl.partnercostcenter,
      wl.partnerprofitcenter,
      wl.partnerfunctionalarea,
      wl.partnerbusinessarea,
      wl.partnercompany,
      wl.partnersegment,
      wl.supplier,
      wl.customer,
      wl.wbselement,
      wl.rebusinessentity,
      wl.realestatebuilding,
      wl.realestateproperty,
      wl.fund,
      wl.budgetperiod,
      wl.grantid,
      wl.pubsecbudgetaccount,
      wl.cashledgeraccount,
      wl.sponsoredprogram,
      wl.sponsoredclass,
      wl.plant,
      wl.product,
      wl.shiptoparty,
      wl.fundedprogram,
      wl.partnerbudgetperiod,
      wl.relatednetworkactivityinternal,
      wl.financialclosinglineitemstatus,
      wl.finclosinglineitemprocessstep,
      wl.financialclosinglineitemtype,
      wl.finclosingentrycalculationtype,
      wl.line_type,
      wl.line_item_status_detail,
      wl.creditriskclass,
      wl.taxcode,
      wl.taxcountry,
      wl.partnerfund,
      wl.partnergrant,
      wl.cashledgercompanycode,
      wl.fundscenter,
      wl.partnerequitygroup,
      wl.account_type          as FinancialAccountType,
      wl.glaccount_type        as GLAccountType,
      wl.customer_supplier_group_key,
      wl.pubsecbudgetaccountcocode,
      wl.servicedocument,
      wl.servicedocumentitem,
      wl.servicedocumenttype,
      wl.material,
      wl.group_id,
      wl.grouping_rule,
      wl.grouping_rule_step,
      wl.marked_for_deletion,
      wl.valuation_rule_step

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