RFM_ST_STKADJ

Transparent Table Application Table

Store Stock Adjustment: Header Data

RFM_ST_STKADJ is an SAP database table in S/4HANA. Store Stock Adjustment: Header Data. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_StoreStockAdjustment view from BASIC Store Stock Adjustment

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY store w_werks Plant
KEY storestockadjustmentuuid rfm_st_stock_adjust_uuid Stock Adjust UUID
goodsmovementtype bwart Movement Type
stockadjustmentreason rfm_st_stock_adjust_reason Adjustment Reason
storagelocation lgort_d Location
stockadjustmentstatus rfm_st_stock_adjust_status Stock Adjustment Status
createdbyuser ernam Created By
creationdatetime rfm_st_stock_adjust_datetime Created Date & Time
lastchangedbyuser last_changed_by_user Last Changed By
lastchangedatetime timestampl Time Stamp
materialdocument mblnr Material Doc.

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.

-- Store Stock Adjustment: Header Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE RFM_ST_STKADJ (
    MANDT,                     -- Client [mandt]
    STORE,                     -- Plant [w_werks]
    STORESTOCKADJUSTMENTUUID,  -- Stock Adjust UUID [rfm_st_stock_adjust_uuid]
    GOODSMOVEMENTTYPE,         -- Movement Type [bwart]
    STOCKADJUSTMENTREASON,     -- Adjustment Reason [rfm_st_stock_adjust_reason]
    STORAGELOCATION,           -- Location [lgort_d]
    STOCKADJUSTMENTSTATUS,     -- Stock Adjustment Status [rfm_st_stock_adjust_status]
    CREATEDBYUSER,             -- Created By [ernam]
    CREATIONDATETIME,          -- Created Date & Time [rfm_st_stock_adjust_datetime]
    LASTCHANGEDBYUSER,         -- Last Changed By [last_changed_by_user]
    LASTCHANGEDATETIME,        -- Time Stamp [timestampl]
    MATERIALDOCUMENT,          -- Material Doc. [mblnr]
    PRIMARY KEY (MANDT, STORE, STORESTOCKADJUSTMENTUUID)
);