CRMS4D_ICM_LOC

Transparent Table Application Table
22 Fields 2 CDS Views

ICM Location

CRMS4D_ICM_LOC is an SAP database table in S/4HANA. ICM Location. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_InvgCsMLocation view from EXTENSION Extention include view for location
I_InvgCsMLocation view from BASIC ICM Location

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY location_id crms4_icm_loc_id Location ID
location_name crms4_icm_loc_name Location Name
cat_guid crms4_icm_cat_guid Category GUID
security_level crm_icm_aut_sec_lvl Sec. Lvl.
hidden_flag crm_icm_cmg_hidden_flag Hidden
addrnumber ad_addrnum Address Number
restrcted crm_restr_access Restricted Access
valid_from crms4_icm_valid_from Valid From
valid_to crms4_icm_valid_to Valid To
longitude crms4_icm_loc_longitude Longitude
latitude crms4_icm_loc_latitude Latitude
altitude crms4_icm_loc_altitude Altitude
precisid crms4_icm_loc_geoprecis Precision
created_by crms4_created_by Created By
created_on crms4_created_on Created On
changed_by crms4_changed_by Changed By
changed_on crms4_changed_on Changed On
arch_status crms4_icm_arch_status Archiving Status
image_id sdok_docid Object ID
cat_id char40 Char
location_uuid crms4_icm_uuid ICM UUID

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.

-- ICM Location
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CRMS4D_ICM_LOC (
    MANDT,           -- Client [mandt]
    LOCATION_ID,     -- Location ID [crms4_icm_loc_id]
    LOCATION_NAME,   -- Location Name [crms4_icm_loc_name]
    CAT_GUID,        -- Category GUID [crms4_icm_cat_guid]
    SECURITY_LEVEL,  -- Sec. Lvl. [crm_icm_aut_sec_lvl]
    HIDDEN_FLAG,     -- Hidden [crm_icm_cmg_hidden_flag]
    ADDRNUMBER,      -- Address Number [ad_addrnum]
    RESTRCTED,       -- Restricted Access [crm_restr_access]
    VALID_FROM,      -- Valid From [crms4_icm_valid_from]
    VALID_TO,        -- Valid To [crms4_icm_valid_to]
    LONGITUDE,       -- Longitude [crms4_icm_loc_longitude]
    LATITUDE,        -- Latitude [crms4_icm_loc_latitude]
    ALTITUDE,        -- Altitude [crms4_icm_loc_altitude]
    PRECISID,        -- Precision [crms4_icm_loc_geoprecis]
    CREATED_BY,      -- Created By [crms4_created_by]
    CREATED_ON,      -- Created On [crms4_created_on]
    CHANGED_BY,      -- Changed By [crms4_changed_by]
    CHANGED_ON,      -- Changed On [crms4_changed_on]
    ARCH_STATUS,     -- Archiving Status [crms4_icm_arch_status]
    IMAGE_ID,        -- Object ID [sdok_docid]
    CAT_ID,          -- Char [char40]
    LOCATION_UUID,   -- ICM UUID [crms4_icm_uuid]
    PRIMARY KEY (MANDT, LOCATION_ID)
);

Learn More