VALUATIONREMAINVALWL
Worklist View
VALUATIONREMAINVALWL is a CDS View in S/4HANA. Worklist View. It contains 27 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| VALLEADINGITEMWITHGROUPID | view | from | ||
| VALUATIONLEADINGITEM | view | from | ||
| ValuationValuationItems | view | inner |
Fields (27)
| Key | Field | CDS Fields | Used 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 | |
| group_id | group_id | 2 | |
| grouping_rule | grouping_rule | 2 | |
| grouping_rule_step | grouping_rule_step | 2 | |
| invoiceitemreference | invoiceitemreference | 1 | |
| invoicereference | invoicereference | 1 | |
| invoicereferencefiscalyear | invoicereferencefiscalyear | 1 | |
| is_cleared_at_keydate | IsClearedAtKeyDate | 2 | |
| isopenitemmanaged | isopenitemmanaged | 1 | |
| Jrnlperiodendclosingrunloguuid | Jrnlperiodendclosingrunloguuid | 2 | |
| ledgergllineitem | ledgergllineitem | 1 | |
| marked_for_deletion | marked_for_deletion | 2 | |
| netduedate | netduedate | 1 | |
| 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 VALUATIONREMAINVALWL
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
{
// Same view as ValuationWorklist in ER1
key wl.jrnlperiodendclosingrunloguuid as Jrnlperiodendclosingrunloguuid,
wl.companycode,
wl.ledger,
wl.sourceledger as Sourceledger,
wl.fiscalyear as Fiscalyear,
cast ( case when calendar.CalendarDate is null
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.invoiceitemreference,
wl.invoicereference,
wl.invoicereferencefiscalyear,
wl.netduedate
}