/SCMTMS/D_TCRTVP

Transparent Table Application Table
25 Fields 1 CDS Views

Validity Period For Rate

/SCMTMS/D_TCRTVP is an SAP database table in S/4HANA. Validity Period For Rate. It contains 25 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TranspRateValidity view from BASIC Rate Validity

Fields (25)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
valid_start_dt /SCMTMS/VAL_DATE_FROM Valid-From Date
valid_end_dt /SCMTMS/VAL_DATE_TO Valid-To Date
valid_start_dt_ts /SCMTMS/VALIDITY_DATE_FROM_TS Valid-From Date
valid_end_dt_ts /SCMTMS/VALIDITY_DATE_TO_TS Valid-To Date
currency /SCMTMS/CURRENCY Currency
rnd_rul /SCMTMS/TCM_ROUNDING_PROFILE Rounding Prof.
rate_maint_mode /SCMTMS/RATE_MAINT_MODE Rate Mode
rate_formula_id /SCMTMS/TRCHARG_RTFORMULA_RULE Formula Rule
rate_surcharge /SCMTMS/RATE_SURCHARGE Surcharge
rate_cumul_ind /SCMTMS/RATE_CUMULATION_INDICA Rate Cumulation
datetime_cr /SCMTMS/DATETIME_CR Created On/At
user_id_cr /SCMTMS/USER_ID_CR Created By
datetime_ch /SCMTMS/DATETIME_CH Changed On/At
user_id_ch /SCMTMS/USER_ID_CH Changed By
eew_tcrate_valid DUMMY Dummy function in length 1
datetime_chlcs /SCMTMS/DATETIME Date/Time
user_id_chlcs /SCMTMS/USER_ID_CH Changed By
rate_records /SCMTMS/RATE_CROSS_PRODUCT Rte Tab. Cross Prod.
update_rates_val /SCMTMS/UPDATE_RATES_VAL Upd. Rate Validities
lifecyclestatus /SCMTMS/TCMM_LIFE_CYCLE_STATUS Life Cycle Status
archiving_status /SCMTMS/ARCHIVING_STATUS_CODE Archiving Status
_dataaging DATA_TEMPERATURE Data Aging

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.

-- Validity Period For Rate
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCMTMS/D_TCRTVP (
    MANDT,              -- Client [MANDT]
    DB_KEY,             -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,         -- NodeID [/BOBF/CONF_KEY]
    VALID_START_DT,     -- Valid-From Date [/SCMTMS/VAL_DATE_FROM]
    VALID_END_DT,       -- Valid-To Date [/SCMTMS/VAL_DATE_TO]
    VALID_START_DT_TS,  -- Valid-From Date [/SCMTMS/VALIDITY_DATE_FROM_TS]
    VALID_END_DT_TS,    -- Valid-To Date [/SCMTMS/VALIDITY_DATE_TO_TS]
    CURRENCY,           -- Currency [/SCMTMS/CURRENCY]
    RND_RUL,            -- Rounding Prof. [/SCMTMS/TCM_ROUNDING_PROFILE]
    RATE_MAINT_MODE,    -- Rate Mode [/SCMTMS/RATE_MAINT_MODE]
    RATE_FORMULA_ID,    -- Formula Rule [/SCMTMS/TRCHARG_RTFORMULA_RULE]
    RATE_SURCHARGE,     -- Surcharge [/SCMTMS/RATE_SURCHARGE]
    RATE_CUMUL_IND,     -- Rate Cumulation [/SCMTMS/RATE_CUMULATION_INDICA]
    DATETIME_CR,        -- Created On/At [/SCMTMS/DATETIME_CR]
    USER_ID_CR,         -- Created By [/SCMTMS/USER_ID_CR]
    DATETIME_CH,        -- Changed On/At [/SCMTMS/DATETIME_CH]
    USER_ID_CH,         -- Changed By [/SCMTMS/USER_ID_CH]
    EEW_TCRATE_VALID,   -- Dummy function in length 1 [DUMMY]
    DATETIME_CHLCS,     -- Date/Time [/SCMTMS/DATETIME]
    USER_ID_CHLCS,      -- Changed By [/SCMTMS/USER_ID_CH]
    RATE_RECORDS,       -- Rte Tab. Cross Prod. [/SCMTMS/RATE_CROSS_PRODUCT]
    UPDATE_RATES_VAL,   -- Upd. Rate Validities [/SCMTMS/UPDATE_RATES_VAL]
    LIFECYCLESTATUS,    -- Life Cycle Status [/SCMTMS/TCMM_LIFE_CYCLE_STATUS]
    ARCHIVING_STATUS,   -- Archiving Status [/SCMTMS/ARCHIVING_STATUS_CODE]
    _DATAAGING,         -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More