TVMS

Transparent Table Customizing Table
18 Fields 2 CDS Views

Materials: Status in Sales and Distribution

TVMS is an SAP database table in S/4HANA. Materials: Status in Sales and Distribution. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SalesDistributionStatus view from BASIC I view for TVMS
P_Distchnspecmatstts view from BASIC Value help for Distribution chain status

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY vmsta vmsta Status
spvba spvba Inquiry
spvbb spvbb Quotation
spvbc spvbc Sales Order
spvbd spvbd Prod Proposal
spvbe spvbe Skd Agreement
spvbf spvbf_vms Value Contract
spvbg spvbg Contract
spvbh spvbh Returns
spvbi spvbi Free Delivery
spvbj spvbj Delivery
spvbk spvbk Credit Memo Req
spvbl spvbl Debit Memo Req
lifsp lifsp_ep Delivery Block
wauft wauft Alloc tbl block
wrepl wrepl Replenish. block
wstor wstor Store order block

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.

-- Materials: Status in Sales and Distribution
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TVMS (
    MANDT,  -- Client [mandt]
    VMSTA,  -- Status [vmsta]
    SPVBA,  -- Inquiry [spvba]
    SPVBB,  -- Quotation [spvbb]
    SPVBC,  -- Sales Order [spvbc]
    SPVBD,  -- Prod Proposal [spvbd]
    SPVBE,  -- Skd Agreement [spvbe]
    SPVBF,  -- Value Contract [spvbf_vms]
    SPVBG,  -- Contract [spvbg]
    SPVBH,  -- Returns [spvbh]
    SPVBI,  -- Free Delivery [spvbi]
    SPVBJ,  -- Delivery [spvbj]
    SPVBK,  -- Credit Memo Req [spvbk]
    SPVBL,  -- Debit Memo Req [spvbl]
    LIFSP,  -- Delivery Block [lifsp_ep]
    WAUFT,  -- Alloc tbl block [wauft]
    WREPL,  -- Replenish. block [wrepl]
    WSTOR,  -- Store order block [wstor]
    PRIMARY KEY (MANDT, VMSTA)
);

Learn More