CRMS4D_DURATION

Transparent Table Application Table

Transparent persistency for durations

CRMS4D_DURATION is an SAP database table in S/4HANA. Transparent persistency for durations. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_ServiceDocumentDuration view from BASIC Service Transaction Duration

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY objtype_h CRMT_SUBOBJECT_CATEGORY_DB Trans. Cat.
KEY object_id CRMT_OBJECT_ID_DB Transaction ID
KEY number_int CRMS4_NUMBER_INT Item Number in Doc.
KEY name_dura TIMENADURA Duration Name
duration TIMEDURA Duration Value
time_unit TIMEUNITDU Time Unit

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.

-- Transparent persistency for durations
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_DURATION (
    CLIENT,      -- Client [MANDT]
    OBJTYPE_H,   -- Trans. Cat. [CRMT_SUBOBJECT_CATEGORY_DB]
    OBJECT_ID,   -- Transaction ID [CRMT_OBJECT_ID_DB]
    NUMBER_INT,  -- Item Number in Doc. [CRMS4_NUMBER_INT]
    NAME_DURA,   -- Duration Name [TIMENADURA]
    DURATION,    -- Duration Value [TIMEDURA]
    TIME_UNIT,   -- Time Unit [TIMEUNITDU]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, NAME_DURA)
);