SFTYCERTSFTYRQMT

Transparent Table Customizing Table
12 Fields 3 CDS Views

Safety Certificate Safety Requirements

SFTYCERTSFTYRQMT is an SAP database table in S/4HANA. Safety Certificate Safety Requirements. It contains 12 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_SftyCertSafetyPrecaution view_entity from EXTENSION Safety Certificate Safety Precaution - Extn
E_SftyCertTmplSafetyPrecaution view_entity from EXTENSION Sfty Cert Template Safety Precaution - Extn
I_SftyCertSafetyPrecaution view from BASIC Safety Certificate Safety Precaution

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY wcnr wcewcnr WC Document
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.

-- Safety Certificate Safety Requirements
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SFTYCERTSFTYRQMT (
    MANDT,          -- Client [mandt]
    WCNR,           -- WC Document [wcewcnr]
    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, WCNR, GRP_CATEGORY, GRP_ID, ITEM_ID)
);

Learn More