STCK_WORKLIST

Transparent Table Application Table
26 Fields 1 CDS Views

Accepted solutions for Issue Stock Champion

STCK_WORKLIST is an SAP database table in S/4HANA. Accepted solutions for Issue Stock Champion. It contains 26 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StockWorklist view from BASIC Stock Worklist

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY rowindex INT4 INT4
KEY material MATNR Material
KEY plant WERKS_D Plant
KEY customer KUNNR Customer
KEY issuetype STCK_ISSUE_TYPE Issue Type for stock
KEY solutiontype LO_SOL_TYPE Solution Type
KEY salesorder VBELN SD Document
KEY salesorderitem POSNR Item
KEY referencedocumentscheduleline ETENR Schedule Line
KEY batch CHARG_D Batch
issuedate DATS Date
originaldeliveryquantity BASMN Base quantity
deliveryquantityinbaseunit BASMN Base quantity
quantityunit MEINS Base Unit
actualdeliveryquantity BASMN Base quantity
deliveryquantity BASMN Base quantity
actualdeliverydate DATS Date
deliverydate DATS Date
actualsolutionmargin STCK_AVERAGE_VALUES Average value
solutionmargin STCK_AVERAGE_VALUES Average value
profit NETPR Net Price
solutioncoverage STCK_AVERAGE_VALUES Average value
revenue NETPR Net Price
createdbyusername ANNAM Created by
companycodecurrency WAERS Currency

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.

-- Accepted solutions for Issue Stock Champion
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE STCK_WORKLIST (
    MANDT,                          -- Client [MANDT]
    ROWINDEX,                       -- INT4 [INT4]
    MATERIAL,                       -- Material [MATNR]
    PLANT,                          -- Plant [WERKS_D]
    CUSTOMER,                       -- Customer [KUNNR]
    ISSUETYPE,                      -- Issue Type for stock [STCK_ISSUE_TYPE]
    SOLUTIONTYPE,                   -- Solution Type [LO_SOL_TYPE]
    SALESORDER,                     -- SD Document [VBELN]
    SALESORDERITEM,                 -- Item [POSNR]
    REFERENCEDOCUMENTSCHEDULELINE,  -- Schedule Line [ETENR]
    BATCH,                          -- Batch [CHARG_D]
    ISSUEDATE,                      -- Date [DATS]
    ORIGINALDELIVERYQUANTITY,       -- Base quantity [BASMN]
    DELIVERYQUANTITYINBASEUNIT,     -- Base quantity [BASMN]
    QUANTITYUNIT,                   -- Base Unit [MEINS]
    ACTUALDELIVERYQUANTITY,         -- Base quantity [BASMN]
    DELIVERYQUANTITY,               -- Base quantity [BASMN]
    ACTUALDELIVERYDATE,             -- Date [DATS]
    DELIVERYDATE,                   -- Date [DATS]
    ACTUALSOLUTIONMARGIN,           -- Average value [STCK_AVERAGE_VALUES]
    SOLUTIONMARGIN,                 -- Average value [STCK_AVERAGE_VALUES]
    PROFIT,                         -- Net Price [NETPR]
    SOLUTIONCOVERAGE,               -- Average value [STCK_AVERAGE_VALUES]
    REVENUE,                        -- Net Price [NETPR]
    CREATEDBYUSERNAME,              -- Created by [ANNAM]
    COMPANYCODECURRENCY,            -- Currency [WAERS]
    PRIMARY KEY (MANDT, ROWINDEX, MATERIAL, PLANT, CUSTOMER, ISSUETYPE, SOLUTIONTYPE, SALESORDER, SALESORDERITEM, REFERENCEDOCUMENTSCHEDULELINE, BATCH)
);

Learn More