MATSTKSUBSCSGN

Transparent Table Application Table
15 Fields 1 CDS Views

Stock Reporting Subscriptions for Consignment Reporting

MATSTKSUBSCSGN is an SAP database table in S/4HANA. Stock Reporting Subscriptions for Consignment Reporting. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MatlStkSubscrpnConsignment view_entity from BASIC Material Stock Subscription Consignment

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY subscriptionid stockreportingsubsid Collection Subs. Id
KEY subscriptionitem stockreportingsubsitem Stock Reporting Subscription Id Item
matlstocksubscriptionnumber matstksubscriptionnr Subscription Nr
ismarkedfordeletion ismarkedfordeletion Deletion Flag
companycode bukrs Company Code
plant werks_d Plant
supplier lifnr Supplier
emptymatlstkreportsaresent sendemptyreports Send Empty Reports
groupingcategory stockreportinggrouping Grouping Category for Stock Reporting
onboardingdate reportonboarding Onboarding Date
offboardingdate reportoffboarding Offboarding Date
created_by syuname User Name
created_at timestampl Time Stamp
locallastchangedat timestampl Time Stamp

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.

-- Stock Reporting Subscriptions for Consignment Reporting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MATSTKSUBSCSGN (
    MANDT,                        -- Client [mandt]
    SUBSCRIPTIONID,               -- Collection Subs. Id [stockreportingsubsid]
    SUBSCRIPTIONITEM,             -- Stock Reporting Subscription Id Item [stockreportingsubsitem]
    MATLSTOCKSUBSCRIPTIONNUMBER,  -- Subscription Nr [matstksubscriptionnr]
    ISMARKEDFORDELETION,          -- Deletion Flag [ismarkedfordeletion]
    COMPANYCODE,                  -- Company Code [bukrs]
    PLANT,                        -- Plant [werks_d]
    SUPPLIER,                     -- Supplier [lifnr]
    EMPTYMATLSTKREPORTSARESENT,   -- Send Empty Reports [sendemptyreports]
    GROUPINGCATEGORY,             -- Grouping Category for Stock Reporting [stockreportinggrouping]
    ONBOARDINGDATE,               -- Onboarding Date [reportonboarding]
    OFFBOARDINGDATE,              -- Offboarding Date [reportoffboarding]
    CREATED_BY,                   -- User Name [syuname]
    CREATED_AT,                   -- Time Stamp [timestampl]
    LOCALLASTCHANGEDAT,           -- Time Stamp [timestampl]
    PRIMARY KEY (MANDT, SUBSCRIPTIONID, SUBSCRIPTIONITEM)
);

Learn More