WRKPMTTLAPPRVL_D

Transparent Table Application Table
23 Fields 2 CDS Views

Draft table for entity R_WRKPMTTMPLAPPROVALDRAFTTP

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

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_WrkPmtTemplateApprovalDraft view_entity from EXTENSION Work Permit Template Approval - Extension
R_WrkPmtTemplateApprovalDraft view_entity from BASIC Work Permit Template Approval Draft

Fields (23)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY workpermitinternalid j_objnr Object number
KEY numberofwrkpermitapprovals i_count Counter
KEY draftuuid sdraft_uuid Draft Document ID
parentdraftuuid sdraft_uuid Draft Document ID
workpermitapproval pmsog Permit
workpermit wcewapinr Application
workpermithaslongtext kzltg Long text
creationdate erdat Created On
createdbyuser ernam Created By
lastchangeddate aedat Changed On
lastchangedbyuser aenam Changed By
workpermitapprovaldescription gntxt Permit Text
workpermitapprovalstatus ptweworkpermitapprovalstatus Approval Status
wrkpmtapprovalismandatory wceflgmand App. Mandatory
wrkpmtapprovalhierarchylevel wcehilvl Hierarchy Level
wrkpmtapprvlmandtext abap.char
workpermitapprovalcomment ptweworkpermitapprovalcomment Approval Comment
textobjectkey tdobname Text Name
plainlongtext esh_e_sr_longtext Long Text
wrkpmtsftyrqmtcriticalitycode eam_criticality Criticality
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_WRKPMTTMPLAPPROVALDRAFTTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTTLAPPRVL_D (
    MANDT,                          -- Client [mandt]
    WORKPERMITINTERNALID,           -- Object number [j_objnr]
    NUMBEROFWRKPERMITAPPROVALS,     -- Counter [i_count]
    DRAFTUUID,                      -- Draft Document ID [sdraft_uuid]
    PARENTDRAFTUUID,                -- Draft Document ID [sdraft_uuid]
    WORKPERMITAPPROVAL,             -- Permit [pmsog]
    WORKPERMIT,                     -- Application [wcewapinr]
    WORKPERMITHASLONGTEXT,          -- Long text [kzltg]
    CREATIONDATE,                   -- Created On [erdat]
    CREATEDBYUSER,                  -- Created By [ernam]
    LASTCHANGEDDATE,                -- Changed On [aedat]
    LASTCHANGEDBYUSER,              -- Changed By [aenam]
    WORKPERMITAPPROVALDESCRIPTION,  -- Permit Text [gntxt]
    WORKPERMITAPPROVALSTATUS,       -- Approval Status [ptweworkpermitapprovalstatus]
    WRKPMTAPPROVALISMANDATORY,      -- App. Mandatory [wceflgmand]
    WRKPMTAPPROVALHIERARCHYLEVEL,   -- Hierarchy Level [wcehilvl]
    WRKPMTAPPRVLMANDTEXT,           -- abap.char
    WORKPERMITAPPROVALCOMMENT,      -- Approval Comment [ptweworkpermitapprovalcomment]
    TEXTOBJECTKEY,                  -- Text Name [tdobname]
    PLAINLONGTEXT,                  -- Long Text [esh_e_sr_longtext]
    WRKPMTSFTYRQMTCRITICALITYCODE,  -- Criticality [eam_criticality]
    MAINTENANCEPLANNINGPLANT,       -- Planning Plant [iwerk]
    WORKPERMITTYPE,                 -- Usage [wceusage]
    PRIMARY KEY (MANDT, WORKPERMITINTERNALID, NUMBEROFWRKPERMITAPPROVALS, DRAFTUUID)
);

Learn More