VALUATIONREORGLINEITEM

@AccessControl.authorizationCheck: #NOT_ALLOWED
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

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

define view entity VALUATIONREORGLINEITEM


  as select from fins_cls_wl                              as wl

    inner join   VALUATIONACDOCA 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.OriginalGlAccount             = wl.recnclnacct_old


{
      // 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,
        @Environment.sql.passValue: true 
      acdoca.p_is_mdc_on,
      acdoca.CreationDateTime,
      acdoca.SubLedgerAcctLineItemType,
      acdoca.BusinessTransactionCategory,
      acdoca.PostingDate       as OriginalPostingDate,
      acdoca.LedgerFiscalYear,
      acdoca.FiscalYearPeriod,
      acdoca.FiscalPeriod,
      acdoca.IsReversal,
      acdoca.ReferenceDocumentType,
      acdoca.ProfitCenter,
      acdoca.Segment,
      acdoca.OrganizationalChange,
      acdoca.GLRecordType,
      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,
      acdoca.OriginalGlAccount,

      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.functionalarea,
      wl.businessarea,
      wl.controllingarea,
      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,

      acdoca.MASTERDATARECNCLNACCT,

      acdoca.MASTERDATAPARTNERCOMPANY,
      acdoca.SpecialGLCode
}