CRMS4D_ICM_LOC

Transparent Table Application Table
23 Fields 2 CDS Views

ICM Location

CRMS4D_ICM_LOC is an SAP database table in S/4HANA. ICM Location. It contains 23 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 (23)

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
icm_loc_dummy CFD_DUMMY Dummy

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]
    ICM_LOC_DUMMY,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, LOCATION_ID)
);

Learn More