EAM_USRSTS_ASGN

Transparent Table Customizing Table
15 Fields 1 CDS Views

Define Phase Control Codes

EAM_USRSTS_ASGN is an SAP database table in S/4HANA. Define Phase Control Codes. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MaintPhaseControlCode view from BASIC Phase Control Code

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY maintenanceordertype aufart Order Type
KEY eamblockercodeentitytype eam_blkcd_entity_type Entity
KEY eamblockercode eam_blocker_code Phase Control
eamblockercodeuserstsprofile j_stsma Status Profile
eamblockercodestatus j_estat User status
eamblockercodedesc eam_blocker_code_desc Description
eamisblockercodeactive eam_blkcd_auto_set Set Automatically
eamoverallstatusprofile eam_overall_status_profile Ovrl Sts Profile
eamblockercodeenteringphase eam_blkcd_entering_phase Entering Phase
eamblockercodeenteringsubphase eam_blkcd_entering_subphase Entering Sub-Phase
eamblockercodeblockingphase eam_blkcd_blocking_phase Phase
eamblockercodeblockingsubphase eam_blkcd_blocking_subphase Blocking Sub-Phase
eamblockercodeauthorizationkey eam_ustat_authkey Authorization Key
configurationdeprecationcode config_deprecation_code Validity

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.

-- Define Phase Control Codes
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE EAM_USRSTS_ASGN (
    MANDT,                           -- Client [mandt]
    MAINTENANCEORDERTYPE,            -- Order Type [aufart]
    EAMBLOCKERCODEENTITYTYPE,        -- Entity [eam_blkcd_entity_type]
    EAMBLOCKERCODE,                  -- Phase Control [eam_blocker_code]
    EAMBLOCKERCODEUSERSTSPROFILE,    -- Status Profile [j_stsma]
    EAMBLOCKERCODESTATUS,            -- User status [j_estat]
    EAMBLOCKERCODEDESC,              -- Description [eam_blocker_code_desc]
    EAMISBLOCKERCODEACTIVE,          -- Set Automatically [eam_blkcd_auto_set]
    EAMOVERALLSTATUSPROFILE,         -- Ovrl Sts Profile [eam_overall_status_profile]
    EAMBLOCKERCODEENTERINGPHASE,     -- Entering Phase [eam_blkcd_entering_phase]
    EAMBLOCKERCODEENTERINGSUBPHASE,  -- Entering Sub-Phase [eam_blkcd_entering_subphase]
    EAMBLOCKERCODEBLOCKINGPHASE,     -- Phase [eam_blkcd_blocking_phase]
    EAMBLOCKERCODEBLOCKINGSUBPHASE,  -- Blocking Sub-Phase [eam_blkcd_blocking_subphase]
    EAMBLOCKERCODEAUTHORIZATIONKEY,  -- Authorization Key [eam_ustat_authkey]
    CONFIGURATIONDEPRECATIONCODE,    -- Validity [config_deprecation_code]
    PRIMARY KEY (MANDT, MAINTENANCEORDERTYPE, EAMBLOCKERCODEENTITYTYPE, EAMBLOCKERCODE)
);

Learn More