/PLMI/SW_CSTRT

Transparent Table Application Table
21 Fields 2 CDS Views

ESD: Software Constraint Management

/PLMI/SW_CSTRT is an SAP database table in S/4HANA. ESD: Software Constraint Management. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Swcstrt view from BASIC Get Number of Constraints
I_Swcstrtdata view from BASIC Get Details of Constraints

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY db_key /PLMB/PPE_GUID Obj. GUID
sw_module /PLMB/MATNR Material
sw_module_type /PLMB/ESD_SW_MODULE_TYPE SwModule Type
sw_version_type /PLMB/DOKAR Document Type
sw_version_id /PLMB/DOKNR Document
sw_version_pos NUMC5 numc5
sw_version_min /PLMB/DOKVR Document Version
sw_version_max /PLMB/DOKVR Document Version
cstrt_rule /PLMB/ESD_CSTRT_RULE Rule
cstrt_obj_type /PLMB/ESD_CSTRT_OBJ_TYPE Constraint Obj. Type
cstrt_obj_id /PLMB/MATNR Material
cstrt_obj_val_min /PLMB/DOKVR Document Version
cstrt_obj_val_max /PLMB/DOKVR Document Version
cstrt_obj_descr /PLMB/CHAR40 Char
created_on /PLMB/CREATED_ON Created On
created_by /PLMB/CREATED_BY Created By
changed_on /PLMB/CHANGED_ON Changed On
changed_by /PLMB/CHANGED_BY Changed By
etag /PLMB/PPE_GUID Obj. GUID
timestamp TIMESTAMP Time Stamp

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.

-- ESD: Software Constraint Management
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /PLMI/SW_CSTRT (
    CLIENT,             -- Client [MANDT]
    DB_KEY,             -- Obj. GUID [/PLMB/PPE_GUID]
    SW_MODULE,          -- Material [/PLMB/MATNR]
    SW_MODULE_TYPE,     -- SwModule Type [/PLMB/ESD_SW_MODULE_TYPE]
    SW_VERSION_TYPE,    -- Document Type [/PLMB/DOKAR]
    SW_VERSION_ID,      -- Document [/PLMB/DOKNR]
    SW_VERSION_POS,     -- numc5 [NUMC5]
    SW_VERSION_MIN,     -- Document Version [/PLMB/DOKVR]
    SW_VERSION_MAX,     -- Document Version [/PLMB/DOKVR]
    CSTRT_RULE,         -- Rule [/PLMB/ESD_CSTRT_RULE]
    CSTRT_OBJ_TYPE,     -- Constraint Obj. Type [/PLMB/ESD_CSTRT_OBJ_TYPE]
    CSTRT_OBJ_ID,       -- Material [/PLMB/MATNR]
    CSTRT_OBJ_VAL_MIN,  -- Document Version [/PLMB/DOKVR]
    CSTRT_OBJ_VAL_MAX,  -- Document Version [/PLMB/DOKVR]
    CSTRT_OBJ_DESCR,    -- Char [/PLMB/CHAR40]
    CREATED_ON,         -- Created On [/PLMB/CREATED_ON]
    CREATED_BY,         -- Created By [/PLMB/CREATED_BY]
    CHANGED_ON,         -- Changed On [/PLMB/CHANGED_ON]
    CHANGED_BY,         -- Changed By [/PLMB/CHANGED_BY]
    ETAG,               -- Obj. GUID [/PLMB/PPE_GUID]
    TIMESTAMP,          -- Time Stamp [TIMESTAMP]
    PRIMARY KEY (CLIENT, DB_KEY)
);

Learn More