WRKPMTSFTYRQMT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA