PERMITPPE_D

Transparent Table Application Table
19 Fields 2 CDS Views

Draft table for entity R_WRKPMTPROTEQUIPDRAFTTP

PERMITPPE_D is an SAP database table in S/4HANA. Draft table for entity R_WRKPMTPROTEQUIPDRAFTTP. It contains 19 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WrkPmtPrsnlPrtcvEquipDraft view_entity from EXTENSION PPE Work Permit - Extension
R_WrkPmtPrsnlPrtcvEquipDraft view_entity from BASIC Work Permit PPE Draft

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY workpermit WCEWAPINR Application
KEY workpermitgroupcategory PTWESFTYRQMTCATEGORY Category
KEY wrkpmtsafetyrequirementgroup PTWESFTYRQMTGRP Safety Rqmt Group
KEY workpermitsafetyrequirement PTWESFTYRQMT Safety Rqmt
KEY draftuuid SDRAFT_UUID Draft Document ID
workpermitinternalid J_OBJNR Object number
parentdraftuuid SDRAFT_UUID Draft Document ID
maintenanceplanningplant IWERK Planning Plant
workpermittype WCEUSAGE Usage
wrkpmtsftyrequirementgrouptext PTWESFTYRQMTGRPTXT Safety Rqmt Grp Txt
wrkpmtsafetyrequirementtext PTWESFTYRQMTTXT Safety Rqmt Txt
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
dummy_ppe_incl_eew_ps CFD_DUMMY Dummy

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_WRKPMTPROTEQUIPDRAFTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PERMITPPE_D (
    MANDT,                           -- Client [MANDT]
    WORKPERMIT,                      -- Application [WCEWAPINR]
    WORKPERMITGROUPCATEGORY,         -- Category [PTWESFTYRQMTCATEGORY]
    WRKPMTSAFETYREQUIREMENTGROUP,    -- Safety Rqmt Group [PTWESFTYRQMTGRP]
    WORKPERMITSAFETYREQUIREMENT,     -- Safety Rqmt [PTWESFTYRQMT]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    WORKPERMITINTERNALID,            -- Object number [J_OBJNR]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    WORKPERMITTYPE,                  -- Usage [WCEUSAGE]
    WRKPMTSFTYREQUIREMENTGROUPTEXT,  -- Safety Rqmt Grp Txt [PTWESFTYRQMTGRPTXT]
    WRKPMTSAFETYREQUIREMENTTEXT,     -- Safety Rqmt Txt [PTWESFTYRQMTTXT]
    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]
    DUMMY_PPE_INCL_EEW_PS,           -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, WORKPERMIT, WORKPERMITGROUPCATEGORY, WRKPMTSAFETYREQUIREMENTGROUP, WORKPERMITSAFETYREQUIREMENT, DRAFTUUID)
);

Learn More