EAM_USRSTS_ASGN

Transparent Table Customizing Table
15 Fields 2 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. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaintOrdTypePhaseControl view_entity from BASIC Maintenance Order Type Phase Control
I_MaintPhaseControlCode view from BASIC Phase Control Code of Maintenance Order

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