WRKPMTSFTYRQMT

Transparent Table Application Table

Work Permit Safety Requirements

WRKPMTSFTYRQMT is an SAP database table in S/4HANA. Work Permit Safety Requirements. It contains 12 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
E_WorkPermitNatureOfWork view_entity from EXTENSION NOW in Work Permit - Extension
E_WorkPermitSafetyPrecaution view_entity from EXTENSION Sfty Precaution Work Permit - Extension
E_WrkPmtPrsnlPrtcvEquipment view_entity from EXTENSION PPE Work Permit - Extension
E_WrkPmtTemplateNatureOfWork view_entity from EXTENSION Work Permit Template Natur of Wrk - Extn
E_WrkPmtTmplPrsnlPrtcvEquip view_entity from EXTENSION WP Tmpl Personal Protective Equip - Extn
E_WrkPmtTmplSafetyPrecaution view_entity from EXTENSION Work Permit Template Safety Precaution - Extension
I_WorkPermitSafetyRequirement view_entity from BASIC Work Permit Safety Requirements

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wapinr wcewapinr Application
KEY grp_category ptwesftyrqmtcategory Category
KEY grp_id ptwesftyrqmtgrp Safety Rqmt Group
KEY item_id ptwesftyrqmt Safety Rqmt
checkbox checkbox1 Checkbox
comments char100sm Character 100
implementedby ername Created by
implementedon timestamp Time Stamp
implemented checkbox1 Checkbox
wapiuse wceusage Usage
iwerk iwerk Planning Plant

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.

-- Work Permit Safety Requirements
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTSFTYRQMT (
    MANDT,          -- Client [mandt]
    WAPINR,         -- Application [wcewapinr]
    GRP_CATEGORY,   -- Category [ptwesftyrqmtcategory]
    GRP_ID,         -- Safety Rqmt Group [ptwesftyrqmtgrp]
    ITEM_ID,        -- Safety Rqmt [ptwesftyrqmt]
    CHECKBOX,       -- Checkbox [checkbox1]
    COMMENTS,       -- Character 100 [char100sm]
    IMPLEMENTEDBY,  -- Created by [ername]
    IMPLEMENTEDON,  -- Time Stamp [timestamp]
    IMPLEMENTED,    -- Checkbox [checkbox1]
    WAPIUSE,        -- Usage [wceusage]
    IWERK,          -- Planning Plant [iwerk]
    PRIMARY KEY (MANDT, WAPINR, GRP_CATEGORY, GRP_ID, ITEM_ID)
);