ISLTNTITEMS_D

Transparent Table Application Table
63 Fields 1 CDS Views

Draft table for entity R_ISLTNCERTTEMPLATEITEMTP

ISLTNTITEMS_D is an SAP database table in S/4HANA. Draft table for entity R_ISLTNCERTTEMPLATEITEMTP. It contains 63 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_IsltnCertTemplateItemDraft view_entity from BASIC Isolation Cert Template Item - Draft

Fields (63)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY isolationcertificatetemplate WCEWCNR WC Document
KEY isolationcertificateitem WCEITM Item
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
sapobjectnodetype abap.char
isolationcertiteminternalid J_OBJNR Object number
isltncertitmcategory WCEITMTYP Item Category
isolationcertificatetype WCEUSAGE Usage
isltncertitemsequencenumber WCEITMSEQ Item
functionallocation VDM_EAM_TPLNR Functional Location
technicalobject TECHNICALOBJECT Technical Object
technicalobjectdescription EAMS_TEC_OBJ_DES Tech. Obj. Desc
technicalobjectlabel WCECCOBJ Tech. Object
maintenanceplanningplant IWERK Planning Plant
isltncertitmcattype WCECCTYP Item Category
isltncertitemdescription WCESTXT Short Text
isltncertitemoperationalgroup WCETGGRP Opl Group
isltncertitmtaggingcondition WCETGPROC Tagging Cond.
isltncertitemtaggingstep WCETGSTEP Tagging Step
isltncertitmtaggingtype WCETGTYP Tagging Type
isltncertitmtaggingsequence WCETGSEQ Tag. Sequence
isltncertitmtaggingcomment WCETGCOMMENT Tagging Comment
isltncertitmtagconditiontext WCEACTPROCX Opl Cndn Desc
isltncertitmtagtypetext WCEACTTYPX Opl Type Desc
isltncertitmuntaggingcondition WCEUNPROC Untag.Cond.
isltncertitmuntaggingtype WCEUNTYP Untagging Type
isltncertitmuntaggingstep WCEUNSTEP Untagging Step
isltncertitmuntaggingsequence WCEUNSEQ Unt. Sequence
isltncertitmuntaggingcomment WCEUNCOMMENT Untag. Comment
isltncertitmuntagconditiontext WCEACTPROCX Opl Cndn Desc
isltncertitmuntagtypetext WCEACTTYPX Opl Type Desc
isltncertitmphysblkisrqd WCEPHBLFLG Phys. Blocking
isltncertitmphysicalblocktype WCEPHBLTYP Blocking Type
isltncertitmphysblocktypetext WCEPHBLTYPX Blkg Typ Desc
isltncertitemtagisrequired WCETAGFLG Tag Required
isltncertitemtagprintformat WCETGFORM Print Format
isolationcertificateitemtag WCETGNR Tag
isltncertitmtesttag WCEUNNR Test Tag
isltncertitmtesttagprintformat WCEUNFORM Print Format
isltncertitmswitchinglocation WCECTRL Switching Loc.
isltncertitmlocation WCELOC Location
isltncertitmpersonresponsible WFD_WORKFORCE_ASSGMT WorkForce Assgmt ID
emailaddress AD_SMTPADR E-Mail Address
mobilephonenumber AD_TLNMBR Telephone
personfullname BU_NAME1TX Full Name
isltncertitmadditionalcomment EAMS_ITEM_ADDITIONAL_INFO Additional Info
isltncertitmistestingrequired BOOLEAN Boolean Variable (X = True, - = False, Space = Unknown)
isltncertitemlocknumber WCEPHBLNR Lock
isltncertitmhaslongtext WCELTXTFLG Long Text
isltncertitmprocessingstatus EAMS_ITEM_PROCESSING_STATUS Proc Stat Isltn Cert
isltncertitmprocgstatustext VAL_TEXT Short Description
techobjisequiporfuncnlloc EAMS_TEC_OBJ_TYPE_VALUE Tech. Obj. Type
isltncertitemoplgrouptext WCETGGRPX Opl Group Desc
isltncertitemlongtext ESH_E_SR_LONGTEXT Long Text
isltncertitmcattypetext VAL_TEXT Short Description
isltncertthumbnailurl SXMS_CHAR273 Message Text
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_ISLTNCERTTEMPLATEITEMTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISLTNTITEMS_D (
    MANDT,                           -- Client [MANDT]
    ISOLATIONCERTIFICATETEMPLATE,    -- WC Document [WCEWCNR]
    ISOLATIONCERTIFICATEITEM,        -- Item [WCEITM]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    SAPOBJECTNODETYPE,               -- abap.char
    ISOLATIONCERTITEMINTERNALID,     -- Object number [J_OBJNR]
    ISLTNCERTITMCATEGORY,            -- Item Category [WCEITMTYP]
    ISOLATIONCERTIFICATETYPE,        -- Usage [WCEUSAGE]
    ISLTNCERTITEMSEQUENCENUMBER,     -- Item [WCEITMSEQ]
    FUNCTIONALLOCATION,              -- Functional Location [VDM_EAM_TPLNR]
    TECHNICALOBJECT,                 -- Technical Object [TECHNICALOBJECT]
    TECHNICALOBJECTDESCRIPTION,      -- Tech. Obj. Desc [EAMS_TEC_OBJ_DES]
    TECHNICALOBJECTLABEL,            -- Tech. Object [WCECCOBJ]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    ISLTNCERTITMCATTYPE,             -- Item Category [WCECCTYP]
    ISLTNCERTITEMDESCRIPTION,        -- Short Text [WCESTXT]
    ISLTNCERTITEMOPERATIONALGROUP,   -- Opl Group [WCETGGRP]
    ISLTNCERTITMTAGGINGCONDITION,    -- Tagging Cond. [WCETGPROC]
    ISLTNCERTITEMTAGGINGSTEP,        -- Tagging Step [WCETGSTEP]
    ISLTNCERTITMTAGGINGTYPE,         -- Tagging Type [WCETGTYP]
    ISLTNCERTITMTAGGINGSEQUENCE,     -- Tag. Sequence [WCETGSEQ]
    ISLTNCERTITMTAGGINGCOMMENT,      -- Tagging Comment [WCETGCOMMENT]
    ISLTNCERTITMTAGCONDITIONTEXT,    -- Opl Cndn Desc [WCEACTPROCX]
    ISLTNCERTITMTAGTYPETEXT,         -- Opl Type Desc [WCEACTTYPX]
    ISLTNCERTITMUNTAGGINGCONDITION,  -- Untag.Cond. [WCEUNPROC]
    ISLTNCERTITMUNTAGGINGTYPE,       -- Untagging Type [WCEUNTYP]
    ISLTNCERTITMUNTAGGINGSTEP,       -- Untagging Step [WCEUNSTEP]
    ISLTNCERTITMUNTAGGINGSEQUENCE,   -- Unt. Sequence [WCEUNSEQ]
    ISLTNCERTITMUNTAGGINGCOMMENT,    -- Untag. Comment [WCEUNCOMMENT]
    ISLTNCERTITMUNTAGCONDITIONTEXT,  -- Opl Cndn Desc [WCEACTPROCX]
    ISLTNCERTITMUNTAGTYPETEXT,       -- Opl Type Desc [WCEACTTYPX]
    ISLTNCERTITMPHYSBLKISRQD,        -- Phys. Blocking [WCEPHBLFLG]
    ISLTNCERTITMPHYSICALBLOCKTYPE,   -- Blocking Type [WCEPHBLTYP]
    ISLTNCERTITMPHYSBLOCKTYPETEXT,   -- Blkg Typ Desc [WCEPHBLTYPX]
    ISLTNCERTITEMTAGISREQUIRED,      -- Tag Required [WCETAGFLG]
    ISLTNCERTITEMTAGPRINTFORMAT,     -- Print Format [WCETGFORM]
    ISOLATIONCERTIFICATEITEMTAG,     -- Tag [WCETGNR]
    ISLTNCERTITMTESTTAG,             -- Test Tag [WCEUNNR]
    ISLTNCERTITMTESTTAGPRINTFORMAT,  -- Print Format [WCEUNFORM]
    ISLTNCERTITMSWITCHINGLOCATION,   -- Switching Loc. [WCECTRL]
    ISLTNCERTITMLOCATION,            -- Location [WCELOC]
    ISLTNCERTITMPERSONRESPONSIBLE,   -- WorkForce Assgmt ID [WFD_WORKFORCE_ASSGMT]
    EMAILADDRESS,                    -- E-Mail Address [AD_SMTPADR]
    MOBILEPHONENUMBER,               -- Telephone [AD_TLNMBR]
    PERSONFULLNAME,                  -- Full Name [BU_NAME1TX]
    ISLTNCERTITMADDITIONALCOMMENT,   -- Additional Info [EAMS_ITEM_ADDITIONAL_INFO]
    ISLTNCERTITMISTESTINGREQUIRED,   -- Boolean Variable (X = True, - = False, Space = Unknown) [BOOLEAN]
    ISLTNCERTITEMLOCKNUMBER,         -- Lock [WCEPHBLNR]
    ISLTNCERTITMHASLONGTEXT,         -- Long Text [WCELTXTFLG]
    ISLTNCERTITMPROCESSINGSTATUS,    -- Proc Stat Isltn Cert [EAMS_ITEM_PROCESSING_STATUS]
    ISLTNCERTITMPROCGSTATUSTEXT,     -- Short Description [VAL_TEXT]
    TECHOBJISEQUIPORFUNCNLLOC,       -- Tech. Obj. Type [EAMS_TEC_OBJ_TYPE_VALUE]
    ISLTNCERTITEMOPLGROUPTEXT,       -- Opl Group Desc [WCETGGRPX]
    ISLTNCERTITEMLONGTEXT,           -- Long Text [ESH_E_SR_LONGTEXT]
    ISLTNCERTITMCATTYPETEXT,         -- Short Description [VAL_TEXT]
    ISLTNCERTTHUMBNAILURL,           -- Message Text [SXMS_CHAR273]
    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, ISOLATIONCERTIFICATETEMPLATE, ISOLATIONCERTIFICATEITEM, DRAFTUUID)
);

Learn More