ISLTNCERTAPPR_D

Transparent Table Application Table
39 Fields 1 CDS Views

Draft table for entity R_ISLTNCERTAPPROVALTP

ISLTNCERTAPPR_D is an SAP database table in S/4HANA. Draft table for entity R_ISLTNCERTAPPROVALTP. It contains 39 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_IsltnCertApprovalDraft view_entity from BASIC Isolation Cert Approval - Draft

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY isolationcertificateinternalid J_OBJNR Object number
KEY nrofapprvlinisltncertificate I_COUNT Counter
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
isolationcertificate WCEWCNR WC Document
isolationcertificatetype WCEUSAGE Usage
isltncerttypedescription PTWESFTYCERTTEXT Sfty Cert Type Desc
isltncertapprovalcode PMSOG Permit
isltncertapprovaldescription GNTXT Permit Text
isltncertapprovalcomment PTWEWORKPERMITAPPROVALCOMMENT Approval Comment
isltncertificateapprovalstatus PTWEWORKPERMITAPPROVALSTATUS Approval Status
isltncertcritltycode EAM_CRITICALITY Criticality
criticalitycode EVE_TV_CRITICALITY Criticality
isltncertapprvlmandtext abap.char
createdbyuser ERNAM Created By
creationdate ERDAT Created On
lastchangeddate AEDAT Changed On
lastchangedbyuser AENAM Changed By
isltncerthaslongtext KZLTG Long text
textobjectkey TDOBNAME Text Name
plainlongtext ESH_E_SR_LONGTEXT Long Text
maintenanceplanningplant IWERK Planning Plant
isltncertificateapprovalblock ASM_PTW_ISLTNCERTAPPRVLBLK Item Proc Restrict
isltncertapprvlprocrlvtpreqt PTWESFTYCERTAPPRVPROCESPREREQ Restrictn for Apprv
isltncertapprvlisprocrelevant ASM_PTW_ISLTNCERTAPPRPROCIND Proc Relvncy Ind
isltncertapprvlhierlvlval WCEHILVL Hierarchy Level
isltncertapprvlismandatory WCEFLGMAND App. Mandatory
isltncertaprvprocrlvtpreqttxt VAL_TEXT Short Description
isltncertapprvlblktext VAL_TEXT Short Description
maintenanceplantname WERKS_NAME Plant Name
approveishidden ABAP_BOOLEAN Truth Value
revokeishidden ABAP_BOOLEAN Truth Value
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_ISLTNCERTAPPROVALTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISLTNCERTAPPR_D (
    MANDT,                           -- Client [MANDT]
    ISOLATIONCERTIFICATEINTERNALID,  -- Object number [J_OBJNR]
    NROFAPPRVLINISLTNCERTIFICATE,    -- Counter [I_COUNT]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    ISOLATIONCERTIFICATE,            -- WC Document [WCEWCNR]
    ISOLATIONCERTIFICATETYPE,        -- Usage [WCEUSAGE]
    ISLTNCERTTYPEDESCRIPTION,        -- Sfty Cert Type Desc [PTWESFTYCERTTEXT]
    ISLTNCERTAPPROVALCODE,           -- Permit [PMSOG]
    ISLTNCERTAPPROVALDESCRIPTION,    -- Permit Text [GNTXT]
    ISLTNCERTAPPROVALCOMMENT,        -- Approval Comment [PTWEWORKPERMITAPPROVALCOMMENT]
    ISLTNCERTIFICATEAPPROVALSTATUS,  -- Approval Status [PTWEWORKPERMITAPPROVALSTATUS]
    ISLTNCERTCRITLTYCODE,            -- Criticality [EAM_CRITICALITY]
    CRITICALITYCODE,                 -- Criticality [EVE_TV_CRITICALITY]
    ISLTNCERTAPPRVLMANDTEXT,         -- abap.char
    CREATEDBYUSER,                   -- Created By [ERNAM]
    CREATIONDATE,                    -- Created On [ERDAT]
    LASTCHANGEDDATE,                 -- Changed On [AEDAT]
    LASTCHANGEDBYUSER,               -- Changed By [AENAM]
    ISLTNCERTHASLONGTEXT,            -- Long text [KZLTG]
    TEXTOBJECTKEY,                   -- Text Name [TDOBNAME]
    PLAINLONGTEXT,                   -- Long Text [ESH_E_SR_LONGTEXT]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    ISLTNCERTIFICATEAPPROVALBLOCK,   -- Item Proc Restrict [ASM_PTW_ISLTNCERTAPPRVLBLK]
    ISLTNCERTAPPRVLPROCRLVTPREQT,    -- Restrictn for Apprv [PTWESFTYCERTAPPRVPROCESPREREQ]
    ISLTNCERTAPPRVLISPROCRELEVANT,   -- Proc Relvncy Ind [ASM_PTW_ISLTNCERTAPPRPROCIND]
    ISLTNCERTAPPRVLHIERLVLVAL,       -- Hierarchy Level [WCEHILVL]
    ISLTNCERTAPPRVLISMANDATORY,      -- App. Mandatory [WCEFLGMAND]
    ISLTNCERTAPRVPROCRLVTPREQTTXT,   -- Short Description [VAL_TEXT]
    ISLTNCERTAPPRVLBLKTEXT,          -- Short Description [VAL_TEXT]
    MAINTENANCEPLANTNAME,            -- Plant Name [WERKS_NAME]
    APPROVEISHIDDEN,                 -- Truth Value [ABAP_BOOLEAN]
    REVOKEISHIDDEN,                  -- Truth Value [ABAP_BOOLEAN]
    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, ISOLATIONCERTIFICATEINTERNALID, NROFAPPRVLINISLTNCERTIFICATE, DRAFTUUID)
);

Learn More