PTWPERMITTYPE

Transparent Table Customizing Table
12 Fields 2 CDS Views

Work Permit Type in Permit to Work

PTWPERMITTYPE is an SAP database table in S/4HANA. Work Permit Type in Permit to Work. It contains 12 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_WorkPermitTemplateType view_entity from BASIC Work Permit Template Type
I_WorkPermitType view_entity from BASIC Work Permit Type

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY iwerk iwerk Planning Plant
KEY workpermittype ptwewrkpmttype Work Permit Type
KEY wrkpmtusagetype ptwewrkpmtusagetype Work Permit Usage
int_range nrnr No. Range No.
ext_range nrnr No. Range No.
wrkpmtoffsetindays ptwevaliddays Offset Value
defaultstarttime ptwecogsuzp Start Time Wrk Pmt
wrkpmtvalidityinhours ptwevalidperiod Def Wrk Pmt Validity
wrkpmtmaxextnvaldtyinhrs ptwemaxvalidity Max Valid Wrk Pmt
workpermittyperef ptwerefwrkpmttype Ref Work Permit Type
wrkpmtapprovalrequired ptw_appr_reqd

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 Type in Permit to Work
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTWPERMITTYPE (
    MANDT,                     -- Client [mandt]
    IWERK,                     -- Planning Plant [iwerk]
    WORKPERMITTYPE,            -- Work Permit Type [ptwewrkpmttype]
    WRKPMTUSAGETYPE,           -- Work Permit Usage [ptwewrkpmtusagetype]
    INT_RANGE,                 -- No. Range No. [nrnr]
    EXT_RANGE,                 -- No. Range No. [nrnr]
    WRKPMTOFFSETINDAYS,        -- Offset Value [ptwevaliddays]
    DEFAULTSTARTTIME,          -- Start Time Wrk Pmt [ptwecogsuzp]
    WRKPMTVALIDITYINHOURS,     -- Def Wrk Pmt Validity [ptwevalidperiod]
    WRKPMTMAXEXTNVALDTYINHRS,  -- Max Valid Wrk Pmt [ptwemaxvalidity]
    WORKPERMITTYPEREF,         -- Ref Work Permit Type [ptwerefwrkpmttype]
    WRKPMTAPPROVALREQUIRED,    -- ptw_appr_reqd
    PRIMARY KEY (MANDT, IWERK, WORKPERMITTYPE, WRKPMTUSAGETYPE)
);

Learn More