WRKPMTISLNCERT_D

Transparent Table Application Table
24 Fields 1 CDS Views

Draft table for entity R_WRKPMTISOLATIONCERTIFICATETP

WRKPMTISLNCERT_D is an SAP database table in S/4HANA. Draft table for entity R_WRKPMTISOLATIONCERTIFICATETP. It contains 24 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_WrkPmtIsltnCertDraft view_entity from BASIC Isltn Certificate in WorkPermit - Draft

Fields (24)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY workpermitinternalid J_OBJNR Object number
KEY isolationcertificateinternalid J_OBJNR Object number
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
workpermitobjecttype WCEFATHERART 1st ObjTyp
sftycertwrkpmtobjecttype WCECHILDART 2nd ObjTyp
sftycertprocessingcontext PTWEWRKPMTPROCESSINGCONTEXT Processing Context
isolationcertificatetype WCEUSAGE Usage
isltncerttypedescription ASM_PTW_ISTLNCERTTEXT Iso Cert Type Desc
validfromdatetime TIMESTAMP Time Stamp
validtodatetime TIMESTAMP Time Stamp
workpermit WCEWAPINR Application
isolationcertificate WCEWCNR WC Document
isltncertificatedescription WCESTXT Short Text
maintenanceplanningplant IWERK Planning Plant
isltncertprocessingstatus PTWISLTNCERTPROCESSINGSTATUS Proc Stat Isltn Cert
isltncertprocessingstatustext VAL_TEXT Short Description
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Draft Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Draft Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID Admin. UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Draft 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_WRKPMTISOLATIONCERTIFICATETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WRKPMTISLNCERT_D (
    MANDT,                           -- Client [MANDT]
    WORKPERMITINTERNALID,            -- Object number [J_OBJNR]
    ISOLATIONCERTIFICATEINTERNALID,  -- Object number [J_OBJNR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    WORKPERMITOBJECTTYPE,            -- 1st ObjTyp [WCEFATHERART]
    SFTYCERTWRKPMTOBJECTTYPE,        -- 2nd ObjTyp [WCECHILDART]
    SFTYCERTPROCESSINGCONTEXT,       -- Processing Context [PTWEWRKPMTPROCESSINGCONTEXT]
    ISOLATIONCERTIFICATETYPE,        -- Usage [WCEUSAGE]
    ISLTNCERTTYPEDESCRIPTION,        -- Iso Cert Type Desc [ASM_PTW_ISTLNCERTTEXT]
    VALIDFROMDATETIME,               -- Time Stamp [TIMESTAMP]
    VALIDTODATETIME,                 -- Time Stamp [TIMESTAMP]
    WORKPERMIT,                      -- Application [WCEWAPINR]
    ISOLATIONCERTIFICATE,            -- WC Document [WCEWCNR]
    ISLTNCERTIFICATEDESCRIPTION,     -- Short Text [WCESTXT]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    ISLTNCERTPROCESSINGSTATUS,       -- Proc Stat Isltn Cert [PTWISLTNCERTPROCESSINGSTATUS]
    ISLTNCERTPROCESSINGSTATUSTEXT,   -- Short Description [VAL_TEXT]
    DRAFTENTITYCREATIONDATETIME,     -- Draft Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Draft Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- Admin. UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Draft Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    PRIMARY KEY (MANDT, WORKPERMITINTERNALID, ISOLATIONCERTIFICATEINTERNALID, DRAFTUUID)
);

Learn More