PERMITSPR_D

Transparent Table Application Table
22 Fields 2 CDS Views

Draft table for entity R_WRKPMTSAFETYPRECAUTIONDRFTTP

PERMITSPR_D is an SAP database table in S/4HANA. Draft table for entity R_WRKPMTSAFETYPRECAUTIONDRFTTP. It contains 22 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WrkPmtSafetyPrecautionDraft view_entity from EXTENSION Work Permit Safety Precaution - Extension
R_WrkPmtSafetyPrecautionDraft view_entity from BASIC Wrk Pmt Safety Precaution Draft

Fields (22)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY workpermit wcewapinr Application
KEY workpermitgroupcategory ptwesftyrqmtcategory Category
KEY wrkpmtsafetyrequirementgroup ptwesftyrqmtgrp Safety Rqmt Group
KEY workpermitsafetyrequirement ptwesftyrqmt Safety Rqmt
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
workpermitinternalid j_objnr Object number
usercommentstext char100sm Character 100
createdbyuser ername Created by
createdbyusername vdm_userdescription Description
creationdatetime timestamp Time Stamp
wrkpmtsftyrqmtisselected checkbox1 Checkbox
wrkpmtsftyrqmtisimplemented checkbox1 Checkbox
wrkpmtsftyrqmtcriticalitycode eam_criticality Criticality
criticalitytext abap.char
maintenanceplanningplant iwerk Planning Plant
workpermittype wceusage Usage
wrkpmtsftyrequirementgrouptext ptwesftyrqmtgrptxt Safety Rqmt Grp Txt
wrkpmtsafetyrequirementtext ptwesftyrqmttxt Safety Rqmt Txt
safetycertificatetype ptwesftycerttype Safety Certif Type
sftycertificatetypedescription ptwesftycerttext Sfty Cert Type Desc

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_WRKPMTSAFETYPRECAUTIONDRFTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PERMITSPR_D (
    MANDT,                           -- Client [mandt]
    WORKPERMIT,                      -- Application [wcewapinr]
    WORKPERMITGROUPCATEGORY,         -- Category [ptwesftyrqmtcategory]
    WRKPMTSAFETYREQUIREMENTGROUP,    -- Safety Rqmt Group [ptwesftyrqmtgrp]
    WORKPERMITSAFETYREQUIREMENT,     -- Safety Rqmt [ptwesftyrqmt]
    DRAFTUUID,                       -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                 -- Draft Document ID [sdraft_uuid]
    WORKPERMITINTERNALID,            -- Object number [j_objnr]
    USERCOMMENTSTEXT,                -- Character 100 [char100sm]
    CREATEDBYUSER,                   -- Created by [ername]
    CREATEDBYUSERNAME,               -- Description [vdm_userdescription]
    CREATIONDATETIME,                -- Time Stamp [timestamp]
    WRKPMTSFTYRQMTISSELECTED,        -- Checkbox [checkbox1]
    WRKPMTSFTYRQMTISIMPLEMENTED,     -- Checkbox [checkbox1]
    WRKPMTSFTYRQMTCRITICALITYCODE,   -- Criticality [eam_criticality]
    CRITICALITYTEXT,                 -- abap.char
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [iwerk]
    WORKPERMITTYPE,                  -- Usage [wceusage]
    WRKPMTSFTYREQUIREMENTGROUPTEXT,  -- Safety Rqmt Grp Txt [ptwesftyrqmtgrptxt]
    WRKPMTSAFETYREQUIREMENTTEXT,     -- Safety Rqmt Txt [ptwesftyrqmttxt]
    SAFETYCERTIFICATETYPE,           -- Safety Certif Type [ptwesftycerttype]
    SFTYCERTIFICATETYPEDESCRIPTION,  -- Sfty Cert Type Desc [ptwesftycerttext]
    PRIMARY KEY (MANDT, WORKPERMIT, WORKPERMITGROUPCATEGORY, WRKPMTSAFETYREQUIREMENTGROUP, WORKPERMITSAFETYREQUIREMENT, DRAFTUUID)
);

Learn More