I_STCKWORKLIST

CDS View
11 Fields 2 CDS Views

CDS view for stock worklist

I_STCKWORKLIST is a CDS View in S/4HANA. CDS view for stock worklist. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_Stockworklistcumulative view from COMPOSITE
P_Stockworklistquantity view from COMPOSITE

Fields (11)

KeyField CDS FieldsUsed in Views
KEY Batch Batch 1
KEY Customer Customer 1
KEY IssueDate BubbleDate,IssueDate 2
KEY IssueType IssueType 2
KEY Material Material 2
KEY Plant Plant 2
KEY SalesOrder SalesOrder 1
KEY SalesOrderItem SalesOrderItem 1
KEY SolutionType SolutionType 1
QuantityUnit QuantityUnit 1
ReferenceDocumentScheduleLine ReferenceDocumentScheduleLine 1

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.

-- CDS view for stock worklist
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_STCKWORKLIST (
    BATCH,
    CUSTOMER,
    ISSUEDATE,
    ISSUETYPE,
    MATERIAL,
    PLANT,
    SALESORDER,
    SALESORDERITEM,
    SOLUTIONTYPE,
    QUANTITYUNIT,
    REFERENCEDOCUMENTSCHEDULELINE,
    PRIMARY KEY (BATCH, CUSTOMER, ISSUEDATE, ISSUETYPE, MATERIAL, PLANT, SALESORDER, SALESORDERITEM, SOLUTIONTYPE)
);

Learn More