CRMS4D_REFOBJ

Transparent Table Application Table
14 Fields 2 CDS Views

Customer Mgmt Add-on S4: Reference Object

CRMS4D_REFOBJ is an SAP database table in S/4HANA. Customer Mgmt Add-on S4: Reference Object. It contains 14 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
CRMS4_REF_OBJECT view from Reference Object for Service Item
I_ServiceDocumentRefObject view from BASIC Reference Object of Service Transaction

Fields (14)

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 counter crms4_refobj_counter Ref. Obj. Counter
type_object crmt_type_object Object Type
guid_object crmt_object_guid Object GUID
product_id matnr Material
main_object crmt_srv_main_object Main Object
product_guid /scmb/mdl_matid Product
serial_number gernr Serial Number
equipment_id equnr Equipment
functional_location_id tplnr Functional loc.
ref_product_id crms4_ref_product_id Reference Product ID

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.

-- Customer Mgmt Add-on S4: Reference Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_REFOBJ (
    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]
    COUNTER,                 -- Ref. Obj. Counter [crms4_refobj_counter]
    TYPE_OBJECT,             -- Object Type [crmt_type_object]
    GUID_OBJECT,             -- Object GUID [crmt_object_guid]
    PRODUCT_ID,              -- Material [matnr]
    MAIN_OBJECT,             -- Main Object [crmt_srv_main_object]
    PRODUCT_GUID,            -- Product [/scmb/mdl_matid]
    SERIAL_NUMBER,           -- Serial Number [gernr]
    EQUIPMENT_ID,            -- Equipment [equnr]
    FUNCTIONAL_LOCATION_ID,  -- Functional loc. [tplnr]
    REF_PRODUCT_ID,          -- Reference Product ID [crms4_ref_product_id]
    PRIMARY KEY (CLIENT, OBJTYPE_H, OBJECT_ID, NUMBER_INT, COUNTER)
);

Learn More