MATSTKSUBS_LOG

Transparent Table Application Table
12 Fields 2 CDS Views

Material Stock Reporting Subscriptions Log

MATSTKSUBS_LOG is an SAP database table in S/4HANA. Material Stock Reporting Subscriptions Log. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MatlStkReportSubscriptionLog view_entity from BASIC Material Stock Subscription Log
P_MatlStkReportSubscriptionLog view_entity from BASIC

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY subscriptionid STOCKREPORTINGSUBSID Collection Subs. Id
KEY subscriptionitem STOCKREPORTINGSUBSITEM Stock Reporting Subscription Id Item
KEY stockreprunid STOCKREPRUNID Collection Run Id
KEY collection_counter STOCKREPORTINGSUBSCOUNTER Subscrpn Iteration
firstgoodsmovementpostingdate STOCKREPORTPERIODSTART Period Start
lastgoodsmovementpostingdate STOCKREPORTPERIODEND Period End
stockreport_id STOCKREPORTID Stock Report ID
stockreport_step STKREPPROCESSINGTSTEP Processing Step
stockreport_status STKREPPROCESSINGSTATUS Processing Status
stockreport_msg STOCKREPSTPMSG Step Error Message
offboardingdate REPORTOFFBOARDING Offboarding Date

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.

-- Material Stock Reporting Subscriptions Log
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATSTKSUBS_LOG (
    MANDT,                          -- Client [MANDT]
    SUBSCRIPTIONID,                 -- Collection Subs. Id [STOCKREPORTINGSUBSID]
    SUBSCRIPTIONITEM,               -- Stock Reporting Subscription Id Item [STOCKREPORTINGSUBSITEM]
    STOCKREPRUNID,                  -- Collection Run Id [STOCKREPRUNID]
    COLLECTION_COUNTER,             -- Subscrpn Iteration [STOCKREPORTINGSUBSCOUNTER]
    FIRSTGOODSMOVEMENTPOSTINGDATE,  -- Period Start [STOCKREPORTPERIODSTART]
    LASTGOODSMOVEMENTPOSTINGDATE,   -- Period End [STOCKREPORTPERIODEND]
    STOCKREPORT_ID,                 -- Stock Report ID [STOCKREPORTID]
    STOCKREPORT_STEP,               -- Processing Step [STKREPPROCESSINGTSTEP]
    STOCKREPORT_STATUS,             -- Processing Status [STKREPPROCESSINGSTATUS]
    STOCKREPORT_MSG,                -- Step Error Message [STOCKREPSTPMSG]
    OFFBOARDINGDATE,                -- Offboarding Date [REPORTOFFBOARDING]
    PRIMARY KEY (MANDT, SUBSCRIPTIONID, SUBSCRIPTIONITEM, STOCKREPRUNID, COLLECTION_COUNTER)
);

Learn More