WRKPMTISSHIST

Transparent Table Application Table
9 Fields 2 CDS Views

WorkPermit Issue History

WRKPMTISSHIST is an SAP database table in S/4HANA. WorkPermit Issue History. It contains 9 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WorkPermitIssueHistory view_entity from EXTENSION Work Permit Issue History - Extension
I_WorkPermitIssueHistory view from BASIC Hand Out Work Permit history

Fields (9)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY objnr j_objnr Object number
KEY counter i_count Counter
issued_by ptweissuedby Permit Issued By
issued_to ptweissuedto Permit Issued To
comments char100sm Character 100
issued_on timestamp Time Stamp
return_to ptwereturnedto Permit Returned To
returned_on timestamp Time Stamp

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.

-- WorkPermit Issue History
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTISSHIST (
    MANDT,        -- Client [mandt]
    OBJNR,        -- Object number [j_objnr]
    COUNTER,      -- Counter [i_count]
    ISSUED_BY,    -- Permit Issued By [ptweissuedby]
    ISSUED_TO,    -- Permit Issued To [ptweissuedto]
    COMMENTS,     -- Character 100 [char100sm]
    ISSUED_ON,    -- Time Stamp [timestamp]
    RETURN_TO,    -- Permit Returned To [ptwereturnedto]
    RETURNED_ON,  -- Time Stamp [timestamp]
    PRIMARY KEY (MANDT, OBJNR, COUNTER)
);

Learn More