VALUATIONWORKLIST

DDL: VALUATIONWORKLIST Type: view_entity
10 Fields 2 Data Sources

Worklist View

VALUATIONWORKLIST is a CDS View that provides data about "Worklist View" in SAP S/4HANA. It reads from 2 data sources (I_FiscalCalendarDateForLedger, fins_cls_wl) and exposes 10 fields with key field Jrnlperiodendclosingrunloguuid.

Data Sources (2)

SourceAliasJoin Type
I_FiscalCalendarDateForLedger calendar left_outer
fins_cls_wl wl from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Worklist View view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY Jrnlperiodendclosingrunloguuid fins_cls_wl jrnlperiodendclosingrunloguuid Closing Run UUID
companycode fins_cls_wl companycode Receiver Company Code
ledger fins_cls_wl ledger Ledger
Sourceledger fins_cls_wl sourceledger Source Ledger
Fiscalyear fins_cls_wl fiscalyear G/L Fiscal Year
glaccount fins_cls_wl glaccount General Ledger
group_id fins_cls_wl group_id UUID
postingdate fins_cls_wl postingdate Posting Date for GR
documentdate fins_cls_wl documentdate Journal Entry Date
clearingdate fins_cls_wl clearingdate Clearing Date

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view VALUATIONWORKLIST.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW VALUATIONWORKLIST AS
SELECT
  wl.jrnlperiodendclosingrunloguuid AS Jrnlperiodendclosingrunloguuid,
  wl.companycode AS companycode,
  wl.ledger AS ledger,
  wl.sourceledger AS Sourceledger,
  wl.fiscalyear AS Fiscalyear,
  wl.glaccount AS glaccount,
  wl.group_id AS group_id,
  wl.postingdate AS postingdate,
  wl.documentdate AS documentdate,
  wl.clearingdate AS clearingdate
FROM fins_cls_wl AS wl
LEFT OUTER JOIN I_FiscalCalendarDateForLedger AS calendar ON /* join condition not captured in parsed metadata */
;

Learn More