VALUATIONWORKLIST

CDS View
24 Fields 3 CDS Views

Worklist View

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

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

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Worklist View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE VALUATIONWORKLIST (
    ACCOUNTINGDOCUMENT,
    COMPANYCODE,
    FISCALYEAR,
    LEDGER,
    BUSINESSPARTNER,
    CHARTOFACCOUNTS,
    CLEARINGACCOUNTINGDOCUMENT,
    CLEARINGDATE,
    CLEARINGDOCFISCALYEAR,
    CUSTOMER_SUPPLIER_GROUP_KEY,
    DOCUMENTDATE,
    FINANCIALCLOSINGLINEITEMTYPE,
    FINCLOSINGLINEITEMPROCESSSTEP,
    GLACCOUNT,
    GROUP_ID,
    GROUPING_RULE,
    GROUPING_RULE_STEP,
    IS_CLEARED_AT_KEYDATE,
    ISOPENITEMMANAGED,
    JRNLPERIODENDCLOSINGRUNLOGUUID,
    LEDGERGLLINEITEM,
    MARKED_FOR_DELETION,
    POSTINGDATE,
    VALUATION_RULE_STEP,
    PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER)
);

Learn More