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)
);