VALUATIONWORKLIST

CDS View

Worklist View

VALUATIONWORKLIST is a CDS View in S/4HANA. Worklist View. It contains 24 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 24 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
VALLEADINGITEMWITHGROUPID view from Valuation run leading item with group id
VALUATIONLEADINGITEM view from Valuation run leading item
ValuationValuationItems view_entity inner Impairment postings

Fields (24)

KeyField CDS FieldsUsed in Views
KEY accountingdocument accountingdocument 1
KEY companycode companycode 1
KEY Fiscalyear Fiscalyear 1
KEY ledger ledger 1
businesspartner businesspartner 1
chartofaccounts chartofaccounts 1
clearingaccountingdocument clearingaccountingdocument 1
clearingdate clearingdate 1
clearingdocfiscalyear clearingdocfiscalyear 1
customer_supplier_group_key customer_supplier_group_key 1
documentdate DocumentDate 1
financialclosinglineitemtype financialclosinglineitemtype 1
finclosinglineitemprocessstep finclosinglineitemprocessstep 1
glaccount glaccount 1
group_id group_id 2
grouping_rule grouping_rule 2
grouping_rule_step grouping_rule_step 2
is_cleared_at_keydate IsClearedAtKeyDate 2
isopenitemmanaged isopenitemmanaged 1
Jrnlperiodendclosingrunloguuid Jrnlperiodendclosingrunloguuid 2
ledgergllineitem ledgergllineitem 1
marked_for_deletion marked_for_deletion 2
postingdate postingdate 1
valuation_rule_step valuation_rule_step 2 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Worklist View'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
  serviceQuality: #X,
  sizeCategory: #S,
  dataClass: #MIXED
}
define view entity VALUATIONWORKLIST
  as select from    fins_cls_wl                   as wl
    left outer join I_FiscalCalendarDateForLedger as calendar on  calendar.CompanyCode  = wl.companycode
                                                              and calendar.Ledger       = wl.ledger
                                                              and calendar.CalendarDate = wl.clearingdate
{
  key wl.jrnlperiodendclosingrunloguuid                        as Jrnlperiodendclosingrunloguuid,
      wl.companycode,
      wl.ledger,
      wl.sourceledger                                          as Sourceledger,
      wl.fiscalyear                                            as Fiscalyear,
      cast ( case when calendar.CalendarDate is null or wl.clearingdate is initial
      then '9999012'
      else calendar.FiscalYearPeriod end as fins_fyearperiod ) as clearingfiscalyearperiod,
      wl.accountingdocument,
      wl.ledgergllineitem,
      wl.glaccount,
      wl.isopenitemmanaged,
      wl.group_id,
      wl.grouping_rule,
      wl.grouping_rule_step,
      wl.chartofaccounts,
      wl.marked_for_deletion,
      wl.businesspartner,
      wl.postingdate,
      wl.documentdate,
      wl.financialclosinglineitemtype,
      wl.finclosinglineitemprocessstep,
      wl.valuation_rule_step,
      wl.customer_supplier_group_key,
      wl.is_cleared_at_keydate,
      wl.clearingdate,
      wl.clearingaccountingdocument,
      wl.clearingdocfiscalyear,
      wl.accountingdocumentitem,
      wl.partnercompany,
      wl.recnclnacct_old as originalGlAccount,
      wl.specialglcode
}

Learn More