ISLTNCERT_D

Transparent Table Application Table
75 Fields 1 CDS Views

Draft table for entity R_ISOLATIONCERTIFICATETP

ISLTNCERT_D is an SAP database table in S/4HANA. Draft table for entity R_ISOLATIONCERTIFICATETP. It contains 75 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_IsolationCertificateDraft view_entity from BASIC Isolation Certificate - Draft

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY isolationcertificate WCEWCNR WC Document
KEY draftuuid SDRAFT_UUID Draft Document ID
sapobjectnodetype abap.char
isolationcertificateinternalid J_OBJNR Object number
isltncertificatesubobjecttype WCETYP Object Type
isltncertexternalnumber WCEWCNR WC Document
isolationcertificatetype WCEUSAGE Usage
isltncerttypedescription ASM_PTW_ISTLNCERTTEXT Iso Cert Type Desc
isltncertificatedescription WCESTXT Short Text
longtextkey TDOBNAME Text Name
isltncertificateisdeleted WCEDELFLG Delete
maintenanceplannergroup INGRP Planner Group
maintenanceplanningplant IWERK Planning Plant
objecttypecode CR_OBJTY Object Type
operationworkcenterinternalid CR_OBJID Object ID
techobjauthorizationgroup IAUTG Authorization Group
isltncertvalidfromdate WCEDATEFR Valid from
isltncertvalidfromtime WCETIMEFR ValidFrm Time
isltncertvalidtodate WCEDATETO Valid to
isltncertvalidtotime WCETIMETO Valid-To Time
functionallocation EAMS_UI_OID_NAME Object ID
equipment EQUNR Equipment
functionallocationlabelname ILOM_STRNO Functional Loc.
techobjisequiporfuncnlloc EAMS_TEC_OBJ_TYPE_VALUE Tech. Obj. Type
technicalobject EAMS_TEC_OBJ Tech. Object
technicalobjectlabel EAMS_TEC_OBJ Tech. Object
technicalobjectdescription EAMS_TEC_OBJ_DES Tech. Obj. Desc
maintenanceplant SWERK MaintPlant
plantname WERKS_NAME Plant Name
plantsection BEBER Plant Section
assetlocation PMLOC Location
assetroom RAUMNR Room
locationname LOCATIONNAME Location Name
isolationcertificatelongtext ESH_E_SR_LONGTEXT Long Text
isltncerthaslongtext WCELTXTFLG Long Text
plantsectiondesc abap.char
maintenanceplantname WERKS_NAME Plant Name
createdbyuser WCECRNAME Created by
createdbyusername VDM_USERDESCRIPTION Description
creationdate WCECRDATE Created on
creationtime WCECRTIME Created at
creationdatetime TIMESTAMP Time Stamp
lastchangedbyusername VDM_USERDESCRIPTION Description
lastchangedbyuser WCECHNAME Changed By
lastchangedate ABP_LASTCHANGE_DATE Changed On
lastchangetime ABP_LASTCHANGE_TIME Changed At
lastchangedatetime TIMESTAMP Time Stamp
workpermitreferenceworkpermit WCEWAPINR Application
isolationcertificatetemplate WCEREFOBJ Template
refisltncertsubobjecttype WCETYP Object Type
isolationcertificatereference WCEWCNR WC Document
refisltncertificatetemplate WCEWCNR WC Document
referenceisolationcertificate WCEWCNR WC Document
refisltncertificateishidden ABAP_BOOLEAN Truth Value
refisltncerttmplishidden ABAP_BOOLEAN Truth Value
validfromdatetime TIMESTAMP Time Stamp
validtodatetime TIMESTAMP Time Stamp
isltncertprocessingstatus PTWISLTNCERTPROCESSINGSTATUS Proc Stat Isltn Cert
isltncertprocessingstatustext VAL_TEXT Short Description
workcenter PPH_ARBPL Work Center
workcenterinternalid CR_OBJID Object ID
workcenterplant WERKS_D Plant
isapproved XFELD Checkbox
isltncertthumbnailurl abap.char
isltncertitmconflictstsmessage ASM_PTW_ISLTNITEMCONFLSTSMSG Conflict Message
isltncertitmconflictstscritlty ASM_PTW_ISLTNITEMCONSTSCRITI Criticality
isltncertcancellationtext ESH_E_SR_LONGTEXT Long Text
referenceobjectcheckcode ASM_PTW_REFERENCEOBJECTCHECK Object Ref Check
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_ISOLATIONCERTIFICATETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISLTNCERT_D (
    MANDT,                           -- Client [MANDT]
    ISOLATIONCERTIFICATE,            -- WC Document [WCEWCNR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    SAPOBJECTNODETYPE,               -- abap.char
    ISOLATIONCERTIFICATEINTERNALID,  -- Object number [J_OBJNR]
    ISLTNCERTIFICATESUBOBJECTTYPE,   -- Object Type [WCETYP]
    ISLTNCERTEXTERNALNUMBER,         -- WC Document [WCEWCNR]
    ISOLATIONCERTIFICATETYPE,        -- Usage [WCEUSAGE]
    ISLTNCERTTYPEDESCRIPTION,        -- Iso Cert Type Desc [ASM_PTW_ISTLNCERTTEXT]
    ISLTNCERTIFICATEDESCRIPTION,     -- Short Text [WCESTXT]
    LONGTEXTKEY,                     -- Text Name [TDOBNAME]
    ISLTNCERTIFICATEISDELETED,       -- Delete [WCEDELFLG]
    MAINTENANCEPLANNERGROUP,         -- Planner Group [INGRP]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    OBJECTTYPECODE,                  -- Object Type [CR_OBJTY]
    OPERATIONWORKCENTERINTERNALID,   -- Object ID [CR_OBJID]
    TECHOBJAUTHORIZATIONGROUP,       -- Authorization Group [IAUTG]
    ISLTNCERTVALIDFROMDATE,          -- Valid from [WCEDATEFR]
    ISLTNCERTVALIDFROMTIME,          -- ValidFrm Time [WCETIMEFR]
    ISLTNCERTVALIDTODATE,            -- Valid to [WCEDATETO]
    ISLTNCERTVALIDTOTIME,            -- Valid-To Time [WCETIMETO]
    FUNCTIONALLOCATION,              -- Object ID [EAMS_UI_OID_NAME]
    EQUIPMENT,                       -- Equipment [EQUNR]
    FUNCTIONALLOCATIONLABELNAME,     -- Functional Loc. [ILOM_STRNO]
    TECHOBJISEQUIPORFUNCNLLOC,       -- Tech. Obj. Type [EAMS_TEC_OBJ_TYPE_VALUE]
    TECHNICALOBJECT,                 -- Tech. Object [EAMS_TEC_OBJ]
    TECHNICALOBJECTLABEL,            -- Tech. Object [EAMS_TEC_OBJ]
    TECHNICALOBJECTDESCRIPTION,      -- Tech. Obj. Desc [EAMS_TEC_OBJ_DES]
    MAINTENANCEPLANT,                -- MaintPlant [SWERK]
    PLANTNAME,                       -- Plant Name [WERKS_NAME]
    PLANTSECTION,                    -- Plant Section [BEBER]
    ASSETLOCATION,                   -- Location [PMLOC]
    ASSETROOM,                       -- Room [RAUMNR]
    LOCATIONNAME,                    -- Location Name [LOCATIONNAME]
    ISOLATIONCERTIFICATELONGTEXT,    -- Long Text [ESH_E_SR_LONGTEXT]
    ISLTNCERTHASLONGTEXT,            -- Long Text [WCELTXTFLG]
    PLANTSECTIONDESC,                -- abap.char
    MAINTENANCEPLANTNAME,            -- Plant Name [WERKS_NAME]
    CREATEDBYUSER,                   -- Created by [WCECRNAME]
    CREATEDBYUSERNAME,               -- Description [VDM_USERDESCRIPTION]
    CREATIONDATE,                    -- Created on [WCECRDATE]
    CREATIONTIME,                    -- Created at [WCECRTIME]
    CREATIONDATETIME,                -- Time Stamp [TIMESTAMP]
    LASTCHANGEDBYUSERNAME,           -- Description [VDM_USERDESCRIPTION]
    LASTCHANGEDBYUSER,               -- Changed By [WCECHNAME]
    LASTCHANGEDATE,                  -- Changed On [ABP_LASTCHANGE_DATE]
    LASTCHANGETIME,                  -- Changed At [ABP_LASTCHANGE_TIME]
    LASTCHANGEDATETIME,              -- Time Stamp [TIMESTAMP]
    WORKPERMITREFERENCEWORKPERMIT,   -- Application [WCEWAPINR]
    ISOLATIONCERTIFICATETEMPLATE,    -- Template [WCEREFOBJ]
    REFISLTNCERTSUBOBJECTTYPE,       -- Object Type [WCETYP]
    ISOLATIONCERTIFICATEREFERENCE,   -- WC Document [WCEWCNR]
    REFISLTNCERTIFICATETEMPLATE,     -- WC Document [WCEWCNR]
    REFERENCEISOLATIONCERTIFICATE,   -- WC Document [WCEWCNR]
    REFISLTNCERTIFICATEISHIDDEN,     -- Truth Value [ABAP_BOOLEAN]
    REFISLTNCERTTMPLISHIDDEN,        -- Truth Value [ABAP_BOOLEAN]
    VALIDFROMDATETIME,               -- Time Stamp [TIMESTAMP]
    VALIDTODATETIME,                 -- Time Stamp [TIMESTAMP]
    ISLTNCERTPROCESSINGSTATUS,       -- Proc Stat Isltn Cert [PTWISLTNCERTPROCESSINGSTATUS]
    ISLTNCERTPROCESSINGSTATUSTEXT,   -- Short Description [VAL_TEXT]
    WORKCENTER,                      -- Work Center [PPH_ARBPL]
    WORKCENTERINTERNALID,            -- Object ID [CR_OBJID]
    WORKCENTERPLANT,                 -- Plant [WERKS_D]
    ISAPPROVED,                      -- Checkbox [XFELD]
    ISLTNCERTTHUMBNAILURL,           -- abap.char
    ISLTNCERTITMCONFLICTSTSMESSAGE,  -- Conflict Message [ASM_PTW_ISLTNITEMCONFLSTSMSG]
    ISLTNCERTITMCONFLICTSTSCRITLTY,  -- Criticality [ASM_PTW_ISLTNITEMCONSTSCRITI]
    ISLTNCERTCANCELLATIONTEXT,       -- Long Text [ESH_E_SR_LONGTEXT]
    REFERENCEOBJECTCHECKCODE,        -- Object Ref Check [ASM_PTW_REFERENCEOBJECTCHECK]
    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, ISOLATIONCERTIFICATE, DRAFTUUID)
);

Learn More