CRMS4D_ICM_STAFF

Transparent Table Application Table
9 Fields 3 CDS Views

Satff and Units for Location and Object

CRMS4D_ICM_STAFF is an SAP database table in S/4HANA. Satff and Units for Location and Object. It contains 9 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_InvgCsMLocationStaffUnit view from BASIC Basic view for Staff and Units in Location
I_InvgCsMObjectStaffUnit view from BASIC Basic view for Staff and Units in Location
I_InvgCsMStaffAndUnit view from BASIC S4CRM: ICM Staff and Unit basic view

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY staffunitid CRMS4_ICM_STF_ID Staff and Units ID
KEY partner_no BU_PARTNER Busn. Partner
KEY partner_fct COMT_PARTNER_FCT Partner Function
KEY entity_type CRMS4_ICM_RELATED_ENTITY_TYPE Related Entity Type
mainpartner CRMT_PARTNER_MAIN Main Partner
no_type CRMT_PARTNER_NO_TYPE Internal No. Typ
valid_from CRMS4_ICM_VALID_FROM Valid From
valid_to CRMS4_ICM_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.

-- Satff and Units for Location and Object
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_ICM_STAFF (
    MANDT,        -- Client [MANDT]
    STAFFUNITID,  -- Staff and Units ID [CRMS4_ICM_STF_ID]
    PARTNER_NO,   -- Busn. Partner [BU_PARTNER]
    PARTNER_FCT,  -- Partner Function [COMT_PARTNER_FCT]
    ENTITY_TYPE,  -- Related Entity Type [CRMS4_ICM_RELATED_ENTITY_TYPE]
    MAINPARTNER,  -- Main Partner [CRMT_PARTNER_MAIN]
    NO_TYPE,      -- Internal No. Typ [CRMT_PARTNER_NO_TYPE]
    VALID_FROM,   -- Valid From [CRMS4_ICM_VALID_FROM]
    VALID_TO,     -- Valid To [CRMS4_ICM_VALID_TO]
    PRIMARY KEY (MANDT, STAFFUNITID, PARTNER_NO, PARTNER_FCT, ENTITY_TYPE)
);

Learn More