/SCMTMS/D_TCRT5D

Transparent Table Application Table
28 Fields 1 CDS Views

Five Dimensional Rates

/SCMTMS/D_TCRT5D is an SAP database table in S/4HANA. Five Dimensional Rates. It contains 28 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TranspRateDimension05 view from BASIC Rate Table 5 Dimensional Rates

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY db_key /BOBF/CONF_KEY NodeID
parent_key /BOBF/CONF_KEY NodeID
root_key /BOBF/CONF_KEY NodeID
scale_item_key01 /BOBF/CONF_KEY NodeID
scale_item_key02 /BOBF/CONF_KEY NodeID
scale_item_key03 /BOBF/CONF_KEY NodeID
scale_item_key04 /BOBF/CONF_KEY NodeID
scale_item_key05 /BOBF/CONF_KEY NodeID
rate /SCMTMS/AMOUNT Amount
rate_curr /SCMTMS/CURRENCY Currency
target_rate /SCMTMS/AMOUNT Amount
tolerance /SCMTMS/TOLERANCE_PERCENTAGE Tolerance Percent
zero_rate /SCMTMS/TCM_ZERO_RATE Zero Rate
sol_spend_amount /SCMTMS/AMOUNT Amount
sol_spend_curr /SCMTMS/CURRENCY Currency
rate_requested /SCMTMS/TCM_RATE_REQUESTED Rate Requested
best_rate /SCMTMS/AMOUNT Amount
valid_start_dt /SCMTMS/VAL_DATE_FROM Valid-From Date
valid_end_dt /SCMTMS/VAL_DATE_TO Valid-To Date
rate_date_from_ts /SCMTMS/RATE_VAL_DATE_FROM_TS Val. Start Date
rate_date_to_ts /SCMTMS/RATE_VAL_DATE_TO_TS Val. End Date
created_by /BOFU/USER_ID_CREATED_BY Created By
created_on /BOFU/TSTMP_CREATION_TIME Created On
changed_by /BOFU/USER_ID_CHANGED_BY Changed By
changed_on /BOFU/TSTMP_CHANGED_TIME Changed On
eew_tcrate_5dmrt DUMMY Dummy function in length 1
_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.

-- Five Dimensional Rates
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /SCMTMS/D_TCRT5D (
    MANDT,              -- Client [MANDT]
    DB_KEY,             -- NodeID [/BOBF/CONF_KEY]
    PARENT_KEY,         -- NodeID [/BOBF/CONF_KEY]
    ROOT_KEY,           -- NodeID [/BOBF/CONF_KEY]
    SCALE_ITEM_KEY01,   -- NodeID [/BOBF/CONF_KEY]
    SCALE_ITEM_KEY02,   -- NodeID [/BOBF/CONF_KEY]
    SCALE_ITEM_KEY03,   -- NodeID [/BOBF/CONF_KEY]
    SCALE_ITEM_KEY04,   -- NodeID [/BOBF/CONF_KEY]
    SCALE_ITEM_KEY05,   -- NodeID [/BOBF/CONF_KEY]
    RATE,               -- Amount [/SCMTMS/AMOUNT]
    RATE_CURR,          -- Currency [/SCMTMS/CURRENCY]
    TARGET_RATE,        -- Amount [/SCMTMS/AMOUNT]
    TOLERANCE,          -- Tolerance Percent [/SCMTMS/TOLERANCE_PERCENTAGE]
    ZERO_RATE,          -- Zero Rate [/SCMTMS/TCM_ZERO_RATE]
    SOL_SPEND_AMOUNT,   -- Amount [/SCMTMS/AMOUNT]
    SOL_SPEND_CURR,     -- Currency [/SCMTMS/CURRENCY]
    RATE_REQUESTED,     -- Rate Requested [/SCMTMS/TCM_RATE_REQUESTED]
    BEST_RATE,          -- Amount [/SCMTMS/AMOUNT]
    VALID_START_DT,     -- Valid-From Date [/SCMTMS/VAL_DATE_FROM]
    VALID_END_DT,       -- Valid-To Date [/SCMTMS/VAL_DATE_TO]
    RATE_DATE_FROM_TS,  -- Val. Start Date [/SCMTMS/RATE_VAL_DATE_FROM_TS]
    RATE_DATE_TO_TS,    -- Val. End Date [/SCMTMS/RATE_VAL_DATE_TO_TS]
    CREATED_BY,         -- Created By [/BOFU/USER_ID_CREATED_BY]
    CREATED_ON,         -- Created On [/BOFU/TSTMP_CREATION_TIME]
    CHANGED_BY,         -- Changed By [/BOFU/USER_ID_CHANGED_BY]
    CHANGED_ON,         -- Changed On [/BOFU/TSTMP_CHANGED_TIME]
    EEW_TCRATE_5DMRT,   -- Dummy function in length 1 [DUMMY]
    _DATAAGING,         -- Data Aging [DATA_TEMPERATURE]
    PRIMARY KEY (MANDT, DB_KEY)
);

Learn More