VALUPDATECLEARINGINFO

DDL: VALUPDATECLEARINGINFO SQL: VALUPDATECLEAR Type: view

VALUPDATECLEARINGINFO is a CDS View in SAP S/4HANA. It reads from 1 data source (I_GLAccountLineItem) and exposes 43 fields with key fields AccountingDocument, LedgerGLLineItem, FiscalYear, Ledger, CompanyCode.

1 data source(s) 43 fields

Data Sources (1)

SourceAliasJoin Type
I_GLAccountLineItem acdoca inner

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName VALUPDATECLEAR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY AccountingDocument I_GLAccountLineItem AccountingDocument
KEY LedgerGLLineItem I_GLAccountLineItem LedgerGLLineItem
KEY FiscalYear I_GLAccountLineItem FiscalYear
KEY Ledger I_GLAccountLineItem Ledger
KEY CompanyCode I_GLAccountLineItem CompanyCode
ClearingAccountingDocument I_GLAccountLineItem ClearingAccountingDocument
ClearingDate I_GLAccountLineItem ClearingDate
ClearingDocFiscalYear I_GLAccountLineItem ClearingDocFiscalYear
IsReversed I_GLAccountLineItem IsReversed
IsReversal I_GLAccountLineItem IsReversal
NewClearingAccountingDocument wl clearingaccountingdocument
NewClearingDate wl clearingdate
NewClearingDocFiscalYear wl clearingdocfiscalyear
group_id wl group_id
GLAccount I_GLAccountLineItem GLAccount
CreationDateTime I_GLAccountLineItem CreationDateTime
SubLedgerAcctLineItemType I_GLAccountLineItem SubLedgerAcctLineItemType
PostingDate I_GLAccountLineItem PostingDate
AccountingDocumentCategory I_GLAccountLineItem AccountingDocumentCategory
LedgerFiscalYear I_GLAccountLineItem LedgerFiscalYear
ReferenceDocumentType I_GLAccountLineItem ReferenceDocumentType
BalanceTransactionCurrency I_GLAccountLineItem BalanceTransactionCurrency
AmountInBalanceTransacCrcy I_GLAccountLineItem AmountInBalanceTransacCrcy
CompanyCodeCurrency I_GLAccountLineItem CompanyCodeCurrency
AmountInCompanyCodeCurrency I_GLAccountLineItem AmountInCompanyCodeCurrency
GlobalCurrency I_GLAccountLineItem GlobalCurrency
AmountInGlobalCurrency I_GLAccountLineItem AmountInGlobalCurrency
FreeDefinedCurrency1 I_GLAccountLineItem FreeDefinedCurrency1
AmountInFreeDefinedCurrency1 I_GLAccountLineItem AmountInFreeDefinedCurrency1
FreeDefinedCurrency2 I_GLAccountLineItem FreeDefinedCurrency2
AmountInFreeDefinedCurrency2 I_GLAccountLineItem AmountInFreeDefinedCurrency2
FreeDefinedCurrency3 I_GLAccountLineItem FreeDefinedCurrency3
AmountInFreeDefinedCurrency3 I_GLAccountLineItem AmountInFreeDefinedCurrency3
FreeDefinedCurrency4 I_GLAccountLineItem FreeDefinedCurrency4
AmountInFreeDefinedCurrency4 I_GLAccountLineItem AmountInFreeDefinedCurrency4
FreeDefinedCurrency5 I_GLAccountLineItem FreeDefinedCurrency5
AmountInFreeDefinedCurrency5 I_GLAccountLineItem AmountInFreeDefinedCurrency5
FreeDefinedCurrency6 I_GLAccountLineItem FreeDefinedCurrency6
AmountInFreeDefinedCurrency6 I_GLAccountLineItem AmountInFreeDefinedCurrency6
FreeDefinedCurrency7 I_GLAccountLineItem FreeDefinedCurrency7
AmountInFreeDefinedCurrency7 I_GLAccountLineItem AmountInFreeDefinedCurrency7
FreeDefinedCurrency8 I_GLAccountLineItem FreeDefinedCurrency8
AmountInFreeDefinedCurrency8 I_GLAccountLineItem AmountInFreeDefinedCurrency8 
@AbapCatalog.sqlViewName: 'VALUPDATECLEAR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: {
                usageType.serviceQuality: #D,
                usageType.sizeCategory: #XXL,
                usageType.dataClass: #MIXED }
@ClientHandling.algorithm: #SESSION_VARIABLE
define view VALUPDATECLEARINGINFO
  as select distinct from fins_cls_wl         as wl
    inner join            I_GLAccountLineItem as acdoca 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
                                                        and acdoca.BalanceTransactionCurrency     = wl.balancetransactioncurrency
{
  key acdoca.AccountingDocument,
  key acdoca.LedgerGLLineItem,
  key acdoca.FiscalYear,
  key acdoca.Ledger,
  key acdoca.CompanyCode,
      acdoca.ClearingAccountingDocument,
      acdoca.ClearingDate,
      acdoca.ClearingDocFiscalYear,
      acdoca.IsReversed,
      acdoca.IsReversal,
      wl.clearingaccountingdocument as NewClearingAccountingDocument,
      wl.clearingdate               as NewClearingDate,
      wl.clearingdocfiscalyear      as NewClearingDocFiscalYear,

      //Filtering fields

      wl.group_id,
      wl.finclosingvaluationcriterion,
      wl.finclosinglineitemprocessstep,
      wl.jrnlperiodendclosingrunloguuid,
      acdoca.GLAccount,
      acdoca.CreationDateTime,
      acdoca.SubLedgerAcctLineItemType,
      acdoca.PostingDate,
      acdoca.AccountingDocumentCategory,
      acdoca.LedgerFiscalYear,
      acdoca.ReferenceDocumentType,
      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

}
where
     acdoca.ClearingAccountingDocument <> wl.clearingaccountingdocument
  or acdoca.ClearingDate               <> wl.clearingdate
  or acdoca.ClearingDocFiscalYear      <> wl.clearingdocfiscalyear

Learn More