PTWSFTYCERTAPPRV

Transparent Table Customizing Table

Assign Approvals to Safety Certificate

PTWSFTYCERTAPPRV is an SAP database table in S/4HANA. Assign Approvals to Safety Certificate. It contains 11 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_SftyCertificateApprovalBasic view from BASIC Maintain Approvals for Safety Cert

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY iwerk iwerk Planning Plant
KEY safetycertificatetype ptwesftycerttype Safety Certif Type
KEY sogen ptweapprovaltype Approval Type
KEY scenario ptweapprvlscen Scenario
hierarchylevel wcehilvl Hierarchy Level
sftycertapprvlcopyisautomatic wceflgcopy Copy Apprv Auto
sftycertapprovalismandatory wceflgmand App. Mandatory
deacflg wceflgdeac Revoke Approval
sftycertapprvlisprocessrelvind ptwesftycertapprvprocessind Proc Relvncy Ind
sftycertapprvlisprocesrelvpreq ptwesftycertapprvprocesprereq Restrictn for Apprv

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.

-- Assign Approvals to Safety Certificate
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTWSFTYCERTAPPRV (
    MANDT,                           -- Client [mandt]
    IWERK,                           -- Planning Plant [iwerk]
    SAFETYCERTIFICATETYPE,           -- Safety Certif Type [ptwesftycerttype]
    SOGEN,                           -- Approval Type [ptweapprovaltype]
    SCENARIO,                        -- Scenario [ptweapprvlscen]
    HIERARCHYLEVEL,                  -- Hierarchy Level [wcehilvl]
    SFTYCERTAPPRVLCOPYISAUTOMATIC,   -- Copy Apprv Auto [wceflgcopy]
    SFTYCERTAPPROVALISMANDATORY,     -- App. Mandatory [wceflgmand]
    DEACFLG,                         -- Revoke Approval [wceflgdeac]
    SFTYCERTAPPRVLISPROCESSRELVIND,  -- Proc Relvncy Ind [ptwesftycertapprvprocessind]
    SFTYCERTAPPRVLISPROCESRELVPREQ,  -- Restrictn for Apprv [ptwesftycertapprvprocesprereq]
    PRIMARY KEY (MANDT, IWERK, SAFETYCERTIFICATETYPE, SOGEN, SCENARIO)
);