WRKPMTSFTYRQMT

Transparent Table Application Table
18 Fields 7 CDS Views

Work Permit Safety Requirements

WRKPMTSFTYRQMT is an SAP database table in S/4HANA. Work Permit Safety Requirements. It contains 18 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 Nature of Work - Extn
E_WrkPmtTmplPrsnlPrtcvEquip view_entity from EXTENSION Work Permit Template PPE - Extn
E_WrkPmtTmplSafetyPrecaution view_entity from EXTENSION Work Permit Template Safety Pre - Extn
I_WorkPermitSafetyRequirement view from BASIC Work Permit Safety Requirements

Fields (18)

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
dummy_spr_incl_eew_ps CFD_DUMMY Dummy
dummy_ppe_incl_eew_ps CFD_DUMMY Dummy
dummy_now_incl_eew_ps CFD_DUMMY Dummy
dummy_spr_tmpl_incl_eew_ps CFD_DUMMY Dummy
dummy_ppe_tmpl_incl_eew_ps CFD_DUMMY Dummy
dummy_now_tmpl_incl_eew_ps CFD_DUMMY Dummy

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]
    DUMMY_SPR_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    DUMMY_PPE_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    DUMMY_NOW_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    DUMMY_SPR_TMPL_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    DUMMY_PPE_TMPL_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    DUMMY_NOW_TMPL_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, WAPINR, GRP_CATEGORY, GRP_ID, ITEM_ID)
);

Learn More