SCMG_T_CASE_ATTR

Transparent Table Application Table
26 Fields 15 CDS Views

Case Attributes

SCMG_T_CASE_ATTR is an SAP database table in S/4HANA. Case Attributes. It contains 26 fields. 15 CDS views read from this table.

CDS Views using this table (15)

ViewTypeJoinVDMDescription
/plmi/c_Er_Std_Hdr_Anlys view from CDS View for Engineering Record Standard Header Analysis
Coll_P2p_Attr view from Zahlungsversprechen
FACVD_CLRDC_01 view inner Dispute Case Attributes in Manual Clearing
FCLM_PROMISE2PAY view left_outer Promise To Pay Information
I_BhvrlInsgtsDisputeCase view_entity inner BASIC Dispute Case Data
I_CaseAttribute view from BASIC Case Attribute
I_InvgCsMCase view from BASIC Basic View For ICM Case
P_Case view from BASIC
P2p_Attr_Key_View view inner p2p_attr with invoice key
Udm_Attr_Key_View view inner Collections management attributes with FIN keys
udmo_dc_attr_view view from
v_ukm_clcr_attr_view view from Credit Limit Request
v_ukm_clcr_cnt_view view from Open Credit Limit Requests
v_ukm_dcd_attr_view view from Documented Credit Decision
v_ukm_dcd_sum_view view from Sum of Blocked Orders per Credit Account

Fields (26)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY case_guid SCMG_CASE_GUID Case Key
case_type SCMGCASE_TYPE Case Type
ext_key SCMG_EXT_KEY Case ID
ext_ref SCMG_EXT_REF External Reference
created_by SCMG_CREATE_USER Created By
create_time SCMG_CREATE_TIME Created On
changed_by SCMG_CHANGE_USER Changed By
change_time SCMG_CHANGE_TIME Changed On
closed_by SCMG_CLOSED_BY Closed By
closing_time SCMG_CLOSING_TIME Closed At
plan_end_date SCMG_PLAN_END_DATE Planned Close Date
processor SCMG_PROCESSOR Processor
responsible SCMG_RESPONSIBLE Person Respons.
case_title SCMG_CASE_TITLE Title
escal_reason SCMG_ESCAL_REASON Escalation Reason
category SCMG_CATEGORY Category
priority SCMG_PRIORITY Priority
secure_level SCMG_SECURE_LEVEL Auth. Level
profile_id SCMGSTATUSPROFID Status Profile
stat_orderno SCMGSTATUSONR Status
stat_para SCMGSTATPARA System Status
stat_objnr SCMGSTATOBJNR Object GUID
stat_line SCMGSTATLINE System Status
stat_user_line SCMGSTATUSERLINE User Status
reason_code SCMG_REASON_CODE Reason

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.

-- Case Attributes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SCMG_T_CASE_ATTR (
    MANDT,           -- Client [MANDT]
    CASE_GUID,       -- Case Key [SCMG_CASE_GUID]
    CASE_TYPE,       -- Case Type [SCMGCASE_TYPE]
    EXT_KEY,         -- Case ID [SCMG_EXT_KEY]
    EXT_REF,         -- External Reference [SCMG_EXT_REF]
    CREATED_BY,      -- Created By [SCMG_CREATE_USER]
    CREATE_TIME,     -- Created On [SCMG_CREATE_TIME]
    CHANGED_BY,      -- Changed By [SCMG_CHANGE_USER]
    CHANGE_TIME,     -- Changed On [SCMG_CHANGE_TIME]
    CLOSED_BY,       -- Closed By [SCMG_CLOSED_BY]
    CLOSING_TIME,    -- Closed At [SCMG_CLOSING_TIME]
    PLAN_END_DATE,   -- Planned Close Date [SCMG_PLAN_END_DATE]
    PROCESSOR,       -- Processor [SCMG_PROCESSOR]
    RESPONSIBLE,     -- Person Respons. [SCMG_RESPONSIBLE]
    CASE_TITLE,      -- Title [SCMG_CASE_TITLE]
    ESCAL_REASON,    -- Escalation Reason [SCMG_ESCAL_REASON]
    CATEGORY,        -- Category [SCMG_CATEGORY]
    PRIORITY,        -- Priority [SCMG_PRIORITY]
    SECURE_LEVEL,    -- Auth. Level [SCMG_SECURE_LEVEL]
    PROFILE_ID,      -- Status Profile [SCMGSTATUSPROFID]
    STAT_ORDERNO,    -- Status [SCMGSTATUSONR]
    STAT_PARA,       -- System Status [SCMGSTATPARA]
    STAT_OBJNR,      -- Object GUID [SCMGSTATOBJNR]
    STAT_LINE,       -- System Status [SCMGSTATLINE]
    STAT_USER_LINE,  -- User Status [SCMGSTATUSERLINE]
    REASON_CODE,     -- Reason [SCMG_REASON_CODE]
    PRIMARY KEY (MANDT, CASE_GUID)
);

Learn More