PTWPERMITTYPE

Transparent Table Customizing Table
11 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 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

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

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY iwerk IWERK Planning Plant
KEY workpermittype PTWEWRKPMTTYPE Work Permit Type
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

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]
    PRIMARY KEY (MANDT, IWERK, WORKPERMITTYPE)
);

Learn More