WRKPMTORDER_D

Transparent Table Application Table
17 Fields 2 CDS Views

Draft table for entity R_WORKPERMITORDERDRAFTTP

WRKPMTORDER_D is an SAP database table in S/4HANA. Draft table for entity R_WORKPERMITORDERDRAFTTP. It contains 17 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WorkPermitOrderDraft view_entity from EXTENSION Work Permit Order - Extension
R_WorkPermitOrderDraft view_entity from BASIC Work Permit Order Draft

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY maintenanceorderinternalid j_objnr Object number
KEY workpermitinternalid j_objnr Object number
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
workpermit wcewapinr Application
maintenanceorder aufnr Order
maintenanceorderdesc auftext Description
rowindex abap.int4
maintenanceplanningplant iwerk Planning Plant
workpermitobjecttype wcechildart 2nd ObjTyp
workpermitorderobjecttype wcefatherart 1st ObjTyp
maintorderroutingnumber co_aufpl Plan No.f.Oper.
maintenanceordertype aufart Order Type
wrkpmtprocessingcontext ptwewrkpmtprocessingcontext Processing Context
maintordcnctntdactvsyststs vdm_j_system_status_concat_t Concatenated System Status
maintenanceorderoperation abap.char

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_WORKPERMITORDERDRAFTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTORDER_D (
    MANDT,                       -- Client [mandt]
    MAINTENANCEORDERINTERNALID,  -- Object number [j_objnr]
    WORKPERMITINTERNALID,        -- Object number [j_objnr]
    DRAFTUUID,                   -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,             -- Draft Document ID [sdraft_uuid]
    WORKPERMIT,                  -- Application [wcewapinr]
    MAINTENANCEORDER,            -- Order [aufnr]
    MAINTENANCEORDERDESC,        -- Description [auftext]
    ROWINDEX,                    -- abap.int4
    MAINTENANCEPLANNINGPLANT,    -- Planning Plant [iwerk]
    WORKPERMITOBJECTTYPE,        -- 2nd ObjTyp [wcechildart]
    WORKPERMITORDEROBJECTTYPE,   -- 1st ObjTyp [wcefatherart]
    MAINTORDERROUTINGNUMBER,     -- Plan No.f.Oper. [co_aufpl]
    MAINTENANCEORDERTYPE,        -- Order Type [aufart]
    WRKPMTPROCESSINGCONTEXT,     -- Processing Context [ptwewrkpmtprocessingcontext]
    MAINTORDCNCTNTDACTVSYSTSTS,  -- Concatenated System Status [vdm_j_system_status_concat_t]
    MAINTENANCEORDEROPERATION,   -- abap.char
    PRIMARY KEY (MANDT, MAINTENANCEORDERINTERNALID, WORKPERMITINTERNALID, DRAFTUUID)
);

Learn More