MAINTORDOPPHSC_D

Transparent Table Application Table
29 Fields 1 CDS Views

Draft table for entity R_MAINTORDEROPPHASECONTROLTP

MAINTORDOPPHSC_D is an SAP database table in S/4HANA. Draft table for entity R_MAINTORDEROPPHASECONTROLTP. It contains 29 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_MaintOrdOpPhaseControlDraft view_entity from BASIC Maint Order Op Phase Control Draft data

Fields (29)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY maintenanceorder AUFNR Order
KEY maintenanceorderoperation abap.char
KEY maintenanceordersuboperation MAINTENANCEORDERSUBOPERATION Suboperation
KEY maintenancephasecontrol EAM_BLOCKER_CODE Phase Control
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
maintenancephasecontrolname EAM_BLOCKER_CODE Phase Control
maintenancephasecontroltext EAM_BLOCKER_CODE_DESC Description
maintphsectrlissetautomly EAM_BLKCD_AUTO_SET Set Automatically
maintphasecontrolauthoritycode EAM_USTAT_AUTHKEY Authorization Key
maintprocgphsectrlactvtncode EAM_PHASE_CTRL_KEY Phase Control Key
eamprocessphasecode EAM_OSTAT_PHASE Process Phase
eamprocesssubphasecode EAM_OSTAT_SPHASE Process Subphase
maintobjphsectrlstatusisactive abap.char
statusobject J_OBJNR Object number
maintenanceuserstatuscode J_ESTAT User status
eamoverallstatusprofile EAM_OVERALL_STATUS_PROFILE Ovrl Sts Profile
maintuserstatusprofilecode J_STSMA Status Profile
maintenanceordertype AUFART Order Type
maintenanceplanningplant IWERK Planning Plant
eamblockercodeentitytype EAM_BLKCD_ENTITY_TYPE Entity
maintenanceorderdraftuuid SDRAFT_UUID Draft Document ID
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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.

-- Draft table for entity R_MAINTORDEROPPHASECONTROLTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAINTORDOPPHSC_D (
    MANDT,                           -- Client [MANDT]
    MAINTENANCEORDER,                -- Order [AUFNR]
    MAINTENANCEORDEROPERATION,       -- abap.char
    MAINTENANCEORDERSUBOPERATION,    -- Suboperation [MAINTENANCEORDERSUBOPERATION]
    MAINTENANCEPHASECONTROL,         -- Phase Control [EAM_BLOCKER_CODE]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    MAINTENANCEPHASECONTROLNAME,     -- Phase Control [EAM_BLOCKER_CODE]
    MAINTENANCEPHASECONTROLTEXT,     -- Description [EAM_BLOCKER_CODE_DESC]
    MAINTPHSECTRLISSETAUTOMLY,       -- Set Automatically [EAM_BLKCD_AUTO_SET]
    MAINTPHASECONTROLAUTHORITYCODE,  -- Authorization Key [EAM_USTAT_AUTHKEY]
    MAINTPROCGPHSECTRLACTVTNCODE,    -- Phase Control Key [EAM_PHASE_CTRL_KEY]
    EAMPROCESSPHASECODE,             -- Process Phase [EAM_OSTAT_PHASE]
    EAMPROCESSSUBPHASECODE,          -- Process Subphase [EAM_OSTAT_SPHASE]
    MAINTOBJPHSECTRLSTATUSISACTIVE,  -- abap.char
    STATUSOBJECT,                    -- Object number [J_OBJNR]
    MAINTENANCEUSERSTATUSCODE,       -- User status [J_ESTAT]
    EAMOVERALLSTATUSPROFILE,         -- Ovrl Sts Profile [EAM_OVERALL_STATUS_PROFILE]
    MAINTUSERSTATUSPROFILECODE,      -- Status Profile [J_STSMA]
    MAINTENANCEORDERTYPE,            -- Order Type [AUFART]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    EAMBLOCKERCODEENTITYTYPE,        -- Entity [EAM_BLKCD_ENTITY_TYPE]
    MAINTENANCEORDERDRAFTUUID,       -- Draft Document ID [SDRAFT_UUID]
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, MAINTENANCEORDER, MAINTENANCEORDEROPERATION, MAINTENANCEORDERSUBOPERATION, MAINTENANCEPHASECONTROL, DRAFTUUID)
);

Learn More