CMS_OMS_VAL_LNK

Transparent Table Application Table
17 Fields 1 CDS Views

Value Link

CMS_OMS_VAL_LNK is an SAP database table in S/4HANA. Value Link. It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ObjectValuationLinkData view from BASIC Object Value Link Data

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY val_guid CMS_DTE_OMS_VAL_GUID Value GUID
val_link_guid CMS_DTE_OMS_VAL_LNK_GUID GUID for Values
val_type CMS_DTE_VALUE_TYPE Value type
calc_amount CMS_DTE_OMS_VAL_CALC_AMOUNT Calculated Val
calc_amt_curr CMS_DTE_OMS_VAL_CALC_CURR Currency
entered_amount CMS_DTE_OMS_VAL_ENTERED_AMOUNT Entered Value
ent_amt_curr CMS_DTE_OMS_VAL_ENTERED_CURR Currency
val_valid_from CMS_DTE_OMS_VAL_VALID_FROM Valid From
val_valid_to CMS_DTE_OMS_VAL_VALID_TO Valid To
val_date CMS_DTE_OMS_VAL_DATE Valuation Date
val_origin CMS_DTE_OMS_ATT_ID_TY_VAL001 Origin of Value
created_by CMS_DTE_USER Created by
created_at CMS_DTE_CREATED_AT Created At
changed_by CMS_DTE_LAST_CHNG_USER Last Changed by
changed_at CMS_DTE_CHANGED_AT Changed At
sourceofentry CMS_DTE_SOURCE_OF_ENTRY Source Of Entry

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.

-- Value Link
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CMS_OMS_VAL_LNK (
    MANDT,           -- Client [MANDT]
    VAL_GUID,        -- Value GUID [CMS_DTE_OMS_VAL_GUID]
    VAL_LINK_GUID,   -- GUID for Values [CMS_DTE_OMS_VAL_LNK_GUID]
    VAL_TYPE,        -- Value type [CMS_DTE_VALUE_TYPE]
    CALC_AMOUNT,     -- Calculated Val [CMS_DTE_OMS_VAL_CALC_AMOUNT]
    CALC_AMT_CURR,   -- Currency [CMS_DTE_OMS_VAL_CALC_CURR]
    ENTERED_AMOUNT,  -- Entered Value [CMS_DTE_OMS_VAL_ENTERED_AMOUNT]
    ENT_AMT_CURR,    -- Currency [CMS_DTE_OMS_VAL_ENTERED_CURR]
    VAL_VALID_FROM,  -- Valid From [CMS_DTE_OMS_VAL_VALID_FROM]
    VAL_VALID_TO,    -- Valid To [CMS_DTE_OMS_VAL_VALID_TO]
    VAL_DATE,        -- Valuation Date [CMS_DTE_OMS_VAL_DATE]
    VAL_ORIGIN,      -- Origin of Value [CMS_DTE_OMS_ATT_ID_TY_VAL001]
    CREATED_BY,      -- Created by [CMS_DTE_USER]
    CREATED_AT,      -- Created At [CMS_DTE_CREATED_AT]
    CHANGED_BY,      -- Last Changed by [CMS_DTE_LAST_CHNG_USER]
    CHANGED_AT,      -- Changed At [CMS_DTE_CHANGED_AT]
    SOURCEOFENTRY,   -- Source Of Entry [CMS_DTE_SOURCE_OF_ENTRY]
    PRIMARY KEY (MANDT, VAL_GUID)
);

Learn More