WRKPMTTECHOBJ_D

Transparent Table Application Table
18 Fields 2 CDS Views

Draft table for entity R_WRKPMTTECHNICALOBJECTDRAFTTP

WRKPMTTECHOBJ_D is an SAP database table in S/4HANA. Draft table for entity R_WRKPMTTECHNICALOBJECTDRAFTTP. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WrkPmtTechnicalObjectDraft view_entity from EXTENSION Work Permit Tech Obj Drft - Extension
R_WrkPmtTechnicalObjectDraft view_entity from BASIC Work Permit Tech Obj Draft

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY workpermitinternalid j_objnr Object number
KEY technicalobject wceccobj Tech. Object
KEY sftycertitemcattype wcecctyp Item Category
KEY draftuuid sdraft_uuid Draft Document ID
techobjisequiporfuncnlloc eams_tec_obj_type_value Tech. Obj. Type
parentdraftuuid sdraft_uuid Draft Document ID
workpermit wcewapinr Application
maintenanceplanningplant iwerk Planning Plant
maintenanceplant swerk MaintPlant
plantname werks_name Plant Name
techobjisequiporfuncnllocdesc eams_tec_obj_type_desc TObj.Type Desc.
technicalobjectlabel ilom_strno Functional Loc.
technicalobjectdescription eams_tec_obj_des Tech. Obj. Desc
assetlocation pmloc Location
plantsection beber Plant Section
techobjcnctntdactvsyststs vdm_j_system_status_concat_t Concatenated System Status
maintobjectinternalid j_objnr Object number

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_WRKPMTTECHNICALOBJECTDRAFTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTTECHOBJ_D (
    MANDT,                          -- Client [mandt]
    WORKPERMITINTERNALID,           -- Object number [j_objnr]
    TECHNICALOBJECT,                -- Tech. Object [wceccobj]
    SFTYCERTITEMCATTYPE,            -- Item Category [wcecctyp]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    TECHOBJISEQUIPORFUNCNLLOC,      -- Tech. Obj. Type [eams_tec_obj_type_value]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    WORKPERMIT,                     -- Application [wcewapinr]
    MAINTENANCEPLANNINGPLANT,       -- Planning Plant [iwerk]
    MAINTENANCEPLANT,               -- MaintPlant [swerk]
    PLANTNAME,                      -- Plant Name [werks_name]
    TECHOBJISEQUIPORFUNCNLLOCDESC,  -- TObj.Type Desc. [eams_tec_obj_type_desc]
    TECHNICALOBJECTLABEL,           -- Functional Loc. [ilom_strno]
    TECHNICALOBJECTDESCRIPTION,     -- Tech. Obj. Desc [eams_tec_obj_des]
    ASSETLOCATION,                  -- Location [pmloc]
    PLANTSECTION,                   -- Plant Section [beber]
    TECHOBJCNCTNTDACTVSYSTSTS,      -- Concatenated System Status [vdm_j_system_status_concat_t]
    MAINTOBJECTINTERNALID,          -- Object number [j_objnr]
    PRIMARY KEY (MANDT, WORKPERMITINTERNALID, TECHNICALOBJECT, SFTYCERTITEMCATTYPE, DRAFTUUID)
);

Learn More