SFTYCERTSFTYRQMT

Transparent Table Customizing Table
14 Fields 3 CDS Views

Safety Certificate Safety Requirements

SFTYCERTSFTYRQMT is an SAP database table in S/4HANA. Safety Certificate Safety Requirements. It contains 14 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 (14)

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
dummy_sftycert_spr_incl_eew_ps CFD_DUMMY Dummy
dummy_sc_tmpl_spr_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.

-- 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]
    DUMMY_SFTYCERT_SPR_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    DUMMY_SC_TMPL_SPR_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, WCNR, GRP_CATEGORY, GRP_ID, ITEM_ID)
);

Learn More