PERMITTMPLNOW_D

Transparent Table Application Table
10 Fields 2 CDS Views

Draft table for entity R_WRKPMTTMPLNATROFWRKDRFTTP

PERMITTMPLNOW_D is an SAP database table in S/4HANA. Draft table for entity R_WRKPMTTMPLNATROFWRKDRFTTP. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WrkPmtTmplNatrOfWrkDraft view_entity from EXTENSION Work Permit Tmpl Sfty Ntre of Wrk - Extn
R_WrkPmtTmplNatrOfWrkDraft view_entity from BASIC Work Permit Tmpl NOW Draft

Fields (10)

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
parentdraftuuid sdraft_uuid Draft Document ID
wrkpmtsftyrqmtisselected checkbox1 Checkbox
maintenanceplanningplant iwerk Planning Plant
workpermittype wceusage Usage

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_WRKPMTTMPLNATROFWRKDRFTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PERMITTMPLNOW_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]
    PARENTDRAFTUUID,               -- Draft Document ID [sdraft_uuid]
    WRKPMTSFTYRQMTISSELECTED,      -- Checkbox [checkbox1]
    MAINTENANCEPLANNINGPLANT,      -- Planning Plant [iwerk]
    WORKPERMITTYPE,                -- Usage [wceusage]
    PRIMARY KEY (MANDT, WORKPERMIT, WORKPERMITGROUPCATEGORY, WRKPMTSAFETYREQUIREMENTGROUP, WORKPERMITSAFETYREQUIREMENT, DRAFTUUID)
);

Learn More