CRMS4D_TECH_RES

Transparent Table Application Table
9 Fields 5 CDS Views

TC: Technical Resources

CRMS4D_TECH_RES is an SAP database table in S/4HANA. TC: Technical Resources. It contains 9 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
CRMS4_TECH_RES view from Technical Ressources
I_BusSolnQtanItmTechRsce view from BASIC Solution Quotation Item Technical Resource
I_SubscrpnContrItmTechRsce view_entity from BASIC Subscription Contract Item Technical Resource
I_SubscrpnItmTechResource view from BASIC Subscription Item Technical Resource
I_SubscrpnOrdItemTechRsce view_entity from COMPOSITE Item Technical Resource

Fields (9)

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 tr_type VTTRT_KK Type of ID
KEY tr_slot CRMT_TC_SLOT Slot of Tech. Res.
tr_obj_id CRMT_TC_TECH_RES_ID ID
tr_valid_from CRMT_TC_VALID_FROM Valid From
tr_valid_to CRMT_TC_VALID_TO Valid To

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.

-- TC: Technical Resources
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_TECH_RES (
    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]
    TR_TYPE,        -- Type of ID [VTTRT_KK]
    TR_SLOT,        -- Slot of Tech. Res. [CRMT_TC_SLOT]
    TR_OBJ_ID,      -- ID [CRMT_TC_TECH_RES_ID]
    TR_VALID_FROM,  -- Valid From [CRMT_TC_VALID_FROM]
    TR_VALID_TO,    -- Valid To [CRMT_TC_VALID_TO]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, TR_TYPE, TR_SLOT)
);

Learn More