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 |
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 VALUATIONREMAINVALWL (
ACCOUNTINGDOCUMENT,
COMPANYCODE,
FISCALYEAR,
LEDGER,
BUSINESSPARTNER,
CHARTOFACCOUNTS,
CLEARINGACCOUNTINGDOCUMENT,
CLEARINGDATE,
CLEARINGDOCFISCALYEAR,
CUSTOMER_SUPPLIER_GROUP_KEY,
DOCUMENTDATE,
FINANCIALCLOSINGLINEITEMTYPE,
FINCLOSINGLINEITEMPROCESSSTEP,
GROUP_ID,
GROUPING_RULE,
GROUPING_RULE_STEP,
INVOICEITEMREFERENCE,
INVOICEREFERENCE,
INVOICEREFERENCEFISCALYEAR,
IS_CLEARED_AT_KEYDATE,
ISOPENITEMMANAGED,
JRNLPERIODENDCLOSINGRUNLOGUUID,
LEDGERGLLINEITEM,
MARKED_FOR_DELETION,
NETDUEDATE,
POSTINGDATE,
VALUATION_RULE_STEP,
PRIMARY KEY (ACCOUNTINGDOCUMENT, COMPANYCODE, FISCALYEAR, LEDGER)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA