MAINTORDOBJL_D

Transparent Table Application Table
23 Fields 1 CDS Views

Draft table for entity R_MAINTORDOBJECTLISTITEMTP

MAINTORDOBJL_D is an SAP database table in S/4HANA. Draft table for entity R_MAINTORDOBJECTLISTITEMTP. It contains 23 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_MaintOrdObjectListItemDraft view_entity from BASIC Maint Order Object List Item Temp data

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY maintenanceorder AUFNR Order
KEY maintenanceorderobjectlist OBJKNR Object list
KEY maintenanceobjectlistitem OBJZA Object counters
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
maintorderobjectlistforedit OBJKNR Object list
maintobjectlistitemforedit OBJZA Object counters
equipment EQUNR Equipment
maintenancenotification QMNUM Notification
assembly BAUTL Assembly
material MATNR Material
serialnumber GERNR Serial Number
uniqueitemidentifier UII_CHAR72 UII
functionallocation VDM_EAM_TPLNR Functional Location
maintobjectlistitemsequence OBSORT Sort field
maintobjlistentryisprocessed XFELD Checkbox
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft 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_MAINTORDOBJECTLISTITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MAINTORDOBJL_D (
    MANDT,                          -- Client [MANDT]
    MAINTENANCEORDER,               -- Order [AUFNR]
    MAINTENANCEORDEROBJECTLIST,     -- Object list [OBJKNR]
    MAINTENANCEOBJECTLISTITEM,      -- Object counters [OBJZA]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    MAINTORDEROBJECTLISTFOREDIT,    -- Object list [OBJKNR]
    MAINTOBJECTLISTITEMFOREDIT,     -- Object counters [OBJZA]
    EQUIPMENT,                      -- Equipment [EQUNR]
    MAINTENANCENOTIFICATION,        -- Notification [QMNUM]
    ASSEMBLY,                       -- Assembly [BAUTL]
    MATERIAL,                       -- Material [MATNR]
    SERIALNUMBER,                   -- Serial Number [GERNR]
    UNIQUEITEMIDENTIFIER,           -- UII [UII_CHAR72]
    FUNCTIONALLOCATION,             -- Functional Location [VDM_EAM_TPLNR]
    MAINTOBJECTLISTITEMSEQUENCE,    -- Sort field [OBSORT]
    MAINTOBJLISTENTRYISPROCESSED,   -- Checkbox [XFELD]
    DRAFTENTITYCREATIONDATETIME,    -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, MAINTENANCEORDER, MAINTENANCEORDEROBJECTLIST, MAINTENANCEOBJECTLISTITEM, DRAFTUUID)
);

Learn More