WORKPERMIT_D

Transparent Table Application Table
85 Fields 2 CDS Views

Draft table for entity R_WORKPERMITTP

WORKPERMIT_D is an SAP database table in S/4HANA. Draft table for entity R_WORKPERMITTP. It contains 85 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WorkPermitDraft view_entity from EXTENSION Work Permit - Extension
R_WorkPermitDraft view_entity from BASIC Work Permit Draft

Fields (85)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY workpermit wcewapinr Application
KEY draftuuid sdraft_uuid Draft Document ID
workpermitinternalid j_objnr Object number
maintenanceplanningplant iwerk Planning Plant
workpermitexternalnumber wcewapinr Application
validationscenarioid abap.char
wrkpmtsftycertassgmtctrlcode ptwewrkpmtsftycertassgmtctrlco Assignment Code
isapproved xfeld Checkbox
wrkpmtissuehistoryisallowed ptweissuehistoryallowed Maintain Issue Hist
wrkpmtordopassgmtisallowed wrkpmtordopassgmtisallowed Assign Ord to Permit
workpermittype wceusage Usage
wrkpmtmgmtobjsubtype wcetyp Object Type
wrkpermitdesc wcestxt Short Text
workpermithaslongtext wceltxtflg Long Text
wrkpermitisdeleted wcedelflg Delete
maintenanceplannergroup ingrp Planner Group
objecttypecode cr_objty Object Type
operationworkcenterinternalid cr_objid Object ID
techobjauthorizationgroup iautg AuthorizGroup
wrkpermitvalidfrmdate wcedatefr Valid from
wrkpermitvalidfrmtime wcetimefr ValidFrm Time
wrkpermitvalidtodate wcedateto Valid to
wrkpermitvalidtotime wcetimeto Valid-To Time
workpermittmplid wcerefobj Template
functionallocation eams_ui_oid_name Object ID
wrkpermithasmaintremark wceremarkflg1 Remarks Mt
wrkpermithasopremark wceremarkflg2 Remarks Op
equipment equnr Equipment
functionallocationlabelname ilom_strno Functional Loc.
techobjisequiporfuncnlloc eams_tec_obj_type_value Tech. Obj. Type
technicalobject eams_tec_obj Tech. Object
technicalobjectlabel eams_tec_obj Tech. Object
technicalobjectdescription eams_tec_obj_des Tech. Obj. Desc
maintenanceplant swerk MaintPlant
plantname werks_name Plant Name
plantsection beber Plant Section
assetlocation pmloc Location
assetroom raumnr Room
locationname locationname Location Name
plantsectiondesc abap.char
maintenanceplantname werks_name Plant Name
maintordpersonresponsible eams_person_responsible Person Resp. ID
wrkpermithasobjectlist wcelnkflg Obj.List Exists
createdbyusername vdm_userdescription Description
createdbyuser wcecrname Created by
lastchangedbyusername vdm_userdescription Description
creationdate wcecrdate Created on
creationtime wcecrtime Created at
creationdatetime timestamp Time Stamp
lastchangedbyuser wcechname Changed By
lastchangedate wcechdate Changed on
lastchangetime wcechtime Last Changed at
lastchangedatetime timestamp Time Stamp
wrkpermitislinkdtodoc wcedocflg Document Link
statusprofile j_stsma Status Profile
workpermitreferenceobjecttype ptwereferenceobject Create with Referenc
workpermitreference wcewapinr Application
workpermitreferenceworkpermit wcewapinr Application
isattachmentsenabled cv_orig Originals
planttimezone tznzone Time Zone
validfromdatetime timestamp Time Stamp
validtodatetime timestamp Time Stamp
isexpired flag Indicator
workcenterplant werks_d Plant
mainworkcenterplantname werks_name Plant Name
maintenanceorder aufnr Order
isdisabled xfeld Checkbox
usercommentstext char100sm Character 100
maintenanceplanningplantname werks_name Plant Name
maintenanceplannergroupname eam_planner_group_name Planner Group Name
workpermittypedescription ptwewrkpmttypetext Work Permit Usg Desc
workpermitlongtext esh_e_sr_longtext Long Text
printisreal abap.char
workpermitoperationremarktext esh_e_sr_longtext Long Text
wrkpmtmaintenanceremarktext esh_e_sr_longtext Long Text
workpermitcancellationtext esh_e_sr_longtext Long Text
workcenter pph_arbpl Work Center
workpermitprocessingstatustext val_text Short Description
workcentertext workcentertext Work Center Text
wrkpmtcnctntdactvsystststxt vdm_j_system_status_concat_t Concatenated System Status
productimageurl productimageurl Image
wrkpmtchgstsactnenbldval abap.char
wrkpmtextensionvalidtodatetime timestamp Time Stamp
workpermitprocessingstatus ptweworkpermitprocessingstatus Processing State

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_WORKPERMITTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WORKPERMIT_D (
    MANDT,                           -- Client [mandt]
    WORKPERMIT,                      -- Application [wcewapinr]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    WORKPERMITINTERNALID,            -- Object number [j_objnr]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [iwerk]
    WORKPERMITEXTERNALNUMBER,        -- Application [wcewapinr]
    VALIDATIONSCENARIOID,            -- abap.char
    WRKPMTSFTYCERTASSGMTCTRLCODE,    -- Assignment Code [ptwewrkpmtsftycertassgmtctrlco]
    ISAPPROVED,                      -- Checkbox [xfeld]
    WRKPMTISSUEHISTORYISALLOWED,     -- Maintain Issue Hist [ptweissuehistoryallowed]
    WRKPMTORDOPASSGMTISALLOWED,      -- Assign Ord to Permit [wrkpmtordopassgmtisallowed]
    WORKPERMITTYPE,                  -- Usage [wceusage]
    WRKPMTMGMTOBJSUBTYPE,            -- Object Type [wcetyp]
    WRKPERMITDESC,                   -- Short Text [wcestxt]
    WORKPERMITHASLONGTEXT,           -- Long Text [wceltxtflg]
    WRKPERMITISDELETED,              -- Delete [wcedelflg]
    MAINTENANCEPLANNERGROUP,         -- Planner Group [ingrp]
    OBJECTTYPECODE,                  -- Object Type [cr_objty]
    OPERATIONWORKCENTERINTERNALID,   -- Object ID [cr_objid]
    TECHOBJAUTHORIZATIONGROUP,       -- AuthorizGroup [iautg]
    WRKPERMITVALIDFRMDATE,           -- Valid from [wcedatefr]
    WRKPERMITVALIDFRMTIME,           -- ValidFrm Time [wcetimefr]
    WRKPERMITVALIDTODATE,            -- Valid to [wcedateto]
    WRKPERMITVALIDTOTIME,            -- Valid-To Time [wcetimeto]
    WORKPERMITTMPLID,                -- Template [wcerefobj]
    FUNCTIONALLOCATION,              -- Object ID [eams_ui_oid_name]
    WRKPERMITHASMAINTREMARK,         -- Remarks Mt [wceremarkflg1]
    WRKPERMITHASOPREMARK,            -- Remarks Op [wceremarkflg2]
    EQUIPMENT,                       -- Equipment [equnr]
    FUNCTIONALLOCATIONLABELNAME,     -- Functional Loc. [ilom_strno]
    TECHOBJISEQUIPORFUNCNLLOC,       -- Tech. Obj. Type [eams_tec_obj_type_value]
    TECHNICALOBJECT,                 -- Tech. Object [eams_tec_obj]
    TECHNICALOBJECTLABEL,            -- Tech. Object [eams_tec_obj]
    TECHNICALOBJECTDESCRIPTION,      -- Tech. Obj. Desc [eams_tec_obj_des]
    MAINTENANCEPLANT,                -- MaintPlant [swerk]
    PLANTNAME,                       -- Plant Name [werks_name]
    PLANTSECTION,                    -- Plant Section [beber]
    ASSETLOCATION,                   -- Location [pmloc]
    ASSETROOM,                       -- Room [raumnr]
    LOCATIONNAME,                    -- Location Name [locationname]
    PLANTSECTIONDESC,                -- abap.char
    MAINTENANCEPLANTNAME,            -- Plant Name [werks_name]
    MAINTORDPERSONRESPONSIBLE,       -- Person Resp. ID [eams_person_responsible]
    WRKPERMITHASOBJECTLIST,          -- Obj.List Exists [wcelnkflg]
    CREATEDBYUSERNAME,               -- Description [vdm_userdescription]
    CREATEDBYUSER,                   -- Created by [wcecrname]
    LASTCHANGEDBYUSERNAME,           -- Description [vdm_userdescription]
    CREATIONDATE,                    -- Created on [wcecrdate]
    CREATIONTIME,                    -- Created at [wcecrtime]
    CREATIONDATETIME,                -- Time Stamp [timestamp]
    LASTCHANGEDBYUSER,               -- Changed By [wcechname]
    LASTCHANGEDATE,                  -- Changed on [wcechdate]
    LASTCHANGETIME,                  -- Last Changed at [wcechtime]
    LASTCHANGEDATETIME,              -- Time Stamp [timestamp]
    WRKPERMITISLINKDTODOC,           -- Document Link [wcedocflg]
    STATUSPROFILE,                   -- Status Profile [j_stsma]
    WORKPERMITREFERENCEOBJECTTYPE,   -- Create with Referenc [ptwereferenceobject]
    WORKPERMITREFERENCE,             -- Application [wcewapinr]
    WORKPERMITREFERENCEWORKPERMIT,   -- Application [wcewapinr]
    ISATTACHMENTSENABLED,            -- Originals [cv_orig]
    PLANTTIMEZONE,                   -- Time Zone [tznzone]
    VALIDFROMDATETIME,               -- Time Stamp [timestamp]
    VALIDTODATETIME,                 -- Time Stamp [timestamp]
    ISEXPIRED,                       -- Indicator [flag]
    WORKCENTERPLANT,                 -- Plant [werks_d]
    MAINWORKCENTERPLANTNAME,         -- Plant Name [werks_name]
    MAINTENANCEORDER,                -- Order [aufnr]
    ISDISABLED,                      -- Checkbox [xfeld]
    USERCOMMENTSTEXT,                -- Character 100 [char100sm]
    MAINTENANCEPLANNINGPLANTNAME,    -- Plant Name [werks_name]
    MAINTENANCEPLANNERGROUPNAME,     -- Planner Group Name [eam_planner_group_name]
    WORKPERMITTYPEDESCRIPTION,       -- Work Permit Usg Desc [ptwewrkpmttypetext]
    WORKPERMITLONGTEXT,              -- Long Text [esh_e_sr_longtext]
    PRINTISREAL,                     -- abap.char
    WORKPERMITOPERATIONREMARKTEXT,   -- Long Text [esh_e_sr_longtext]
    WRKPMTMAINTENANCEREMARKTEXT,     -- Long Text [esh_e_sr_longtext]
    WORKPERMITCANCELLATIONTEXT,      -- Long Text [esh_e_sr_longtext]
    WORKCENTER,                      -- Work Center [pph_arbpl]
    WORKPERMITPROCESSINGSTATUSTEXT,  -- Short Description [val_text]
    WORKCENTERTEXT,                  -- Work Center Text [workcentertext]
    WRKPMTCNCTNTDACTVSYSTSTSTXT,     -- Concatenated System Status [vdm_j_system_status_concat_t]
    PRODUCTIMAGEURL,                 -- Image [productimageurl]
    WRKPMTCHGSTSACTNENBLDVAL,        -- abap.char
    WRKPMTEXTENSIONVALIDTODATETIME,  -- Time Stamp [timestamp]
    WORKPERMITPROCESSINGSTATUS,      -- Processing State [ptweworkpermitprocessingstatus]
    PRIMARY KEY (MANDT, WORKPERMIT, DRAFTUUID)
);

Learn More