WRKPMTISSHIST_D

Transparent Table Application Table
23 Fields 2 CDS Views

Draft table for entity R_WORKPERMITISSUEHISTORYTP

WRKPMTISSHIST_D is an SAP database table in S/4HANA. Draft table for entity R_WORKPERMITISSUEHISTORYTP. It contains 23 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WorkPermitIssueHistoryDraft view_entity from EXTENSION Work Permit Issue History - Extension
R_WorkPermitIssueHistoryDraft view_entity from BASIC Work Permit Issue History Draft

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY workpermitinternalid J_OBJNR Object number
KEY numberofworkpermitissued I_COUNT Counter
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
workpermit WCEWAPINR Application
maintenanceplanningplant IWERK Planning Plant
workpermittype WCEUSAGE Usage
workpermitissuedby PTWEISSUEDBY Permit Issued By
workpermitissuedto PTWEISSUEDTO Permit Issued To
usercommentstext CHAR100SM Character 100
workpermitissuedatetime TIMESTAMP Time Stamp
workpermitreturnedto PTWERETURNEDTO Permit Returned To
workpermitreturneddatetime TIMESTAMP Time Stamp
workpermitissuedbyname VDM_USERDESCRIPTION Description
workpermitreturnedbyname VDM_USERDESCRIPTION Description
personfullname BU_NAME1TX Full Name
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes

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.

-- Draft table for entity R_WORKPERMITISSUEHISTORYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTISSHIST_D (
    MANDT,                          -- Client [MANDT]
    WORKPERMITINTERNALID,           -- Object number [J_OBJNR]
    NUMBEROFWORKPERMITISSUED,       -- Counter [I_COUNT]
    DRAFTUUID,                      -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                -- Draft Document ID [SDRAFT_UUID]
    WORKPERMIT,                     -- Application [WCEWAPINR]
    MAINTENANCEPLANNINGPLANT,       -- Planning Plant [IWERK]
    WORKPERMITTYPE,                 -- Usage [WCEUSAGE]
    WORKPERMITISSUEDBY,             -- Permit Issued By [PTWEISSUEDBY]
    WORKPERMITISSUEDTO,             -- Permit Issued To [PTWEISSUEDTO]
    USERCOMMENTSTEXT,               -- Character 100 [CHAR100SM]
    WORKPERMITISSUEDATETIME,        -- Time Stamp [TIMESTAMP]
    WORKPERMITRETURNEDTO,           -- Permit Returned To [PTWERETURNEDTO]
    WORKPERMITRETURNEDDATETIME,     -- Time Stamp [TIMESTAMP]
    WORKPERMITISSUEDBYNAME,         -- Description [VDM_USERDESCRIPTION]
    WORKPERMITRETURNEDBYNAME,       -- Description [VDM_USERDESCRIPTION]
    PERSONFULLNAME,                 -- Full Name [BU_NAME1TX]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, WORKPERMITINTERNALID, NUMBEROFWORKPERMITISSUED, DRAFTUUID)
);

Learn More