PTWSFTYCERTTYPE

Transparent Table Customizing Table
12 Fields 2 CDS Views

Safety Certificate Type

PTWSFTYCERTTYPE is an SAP database table in S/4HANA. Safety Certificate Type. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SafetyCertificateType view_entity from BASIC Safety Certificate Type
I_SftyCertTemplateType view_entity from BASIC Safety Certificate Template Type

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY iwerk iwerk Planning Plant
KEY safetycertificatetype ptwesftycerttype Safety Certif Type
safetycertificatecategory ptwesftycertwcetyp Object Type
int_range nrnr No. Range No.
ext_range nrnr No. Range No.
safetycertificateitemtype ptwesftycertitmtype Sfty Cert Itm Typ
defaultstarttime ptwesftycertcogsuzp Start Time Sfty Cert
sftycertificatevalidityinhours ptwesftycertvalidperiod Def Sfty Cert Valid
sftycertmaximumvalidityinhours ptwesftycertmaxvalidity Max Valid Sfty Cert
sftycertificateoffsetindays ptwevaliddays Offset Value
refsafetycertificatetype ptwerefsftycerttype Ref Safety Cert Typ

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 Type
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTWSFTYCERTTYPE (
    MANDT,                           -- Client [mandt]
    IWERK,                           -- Planning Plant [iwerk]
    SAFETYCERTIFICATETYPE,           -- Safety Certif Type [ptwesftycerttype]
    SAFETYCERTIFICATECATEGORY,       -- Object Type [ptwesftycertwcetyp]
    INT_RANGE,                       -- No. Range No. [nrnr]
    EXT_RANGE,                       -- No. Range No. [nrnr]
    SAFETYCERTIFICATEITEMTYPE,       -- Sfty Cert Itm Typ [ptwesftycertitmtype]
    DEFAULTSTARTTIME,                -- Start Time Sfty Cert [ptwesftycertcogsuzp]
    SFTYCERTIFICATEVALIDITYINHOURS,  -- Def Sfty Cert Valid [ptwesftycertvalidperiod]
    SFTYCERTMAXIMUMVALIDITYINHOURS,  -- Max Valid Sfty Cert [ptwesftycertmaxvalidity]
    SFTYCERTIFICATEOFFSETINDAYS,     -- Offset Value [ptwevaliddays]
    REFSAFETYCERTIFICATETYPE,        -- Ref Safety Cert Typ [ptwerefsftycerttype]
    PRIMARY KEY (MANDT, IWERK, SAFETYCERTIFICATETYPE)
);

Learn More