SAFETYCERTTMPL_D

Transparent Table Application Table
76 Fields 2 CDS Views

Draft table for entity R_SAFETYCERTIFICATETEMPLATETP

SAFETYCERTTMPL_D is an SAP database table in S/4HANA. Draft table for entity R_SAFETYCERTIFICATETEMPLATETP. It contains 76 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_SftyCertificateTemplateDraft view_entity from EXTENSION Safety Certificate Template - Extension
R_SftyCertificateTemplateDraft view_entity from BASIC Sfty Certificate Template Draft

Fields (76)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY safetycertificate WCEWCNR WC Document
KEY draftuuid SDRAFT_UUID Draft Document ID
safetycertificateinternalid J_OBJNR Object number
sftycertificatesubobjecttype WCETYP Object Type
safetycertificatetype WCEUSAGE Usage
sftycertdesc WCESTXT Short Text
sftycerthaslongtext WCELTXTFLG Long Text
longtextkey TDOBNAME Text Name
sftycertisdeleted WCEDELFLG Delete
maintenanceplannergroup INGRP Planner Group
maintenanceplanningplant IWERK Planning Plant
objecttypecode CR_OBJTY Object Type
operationworkcenterinternalid CR_OBJID Object ID
techobjauthorizationgroup IAUTG AuthorizGroup
sftycertvalidfrmdate WCEDATEFR Valid from
sftycertvalidfrmtime WCETIMEFR ValidFrm Time
sftycertvalidtodate WCEDATETO Valid to
sftycertvalidtotime 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
plantsectiondesc abap.char
maintenanceplantname WERKS_NAME Plant Name
sftycerthasobjectlist WCELNKFLG Obj.List Exists
createdbyusername VDM_USERDESCRIPTION Description
createdbyuser WCECRNAME Created by
creationdate WCECRDATE Created on
creationtime WCECRTIME Created at
creationdatetime TIMESTAMP Time Stamp
validfromdatetime TIMESTAMP Time Stamp
validtodatetime TIMESTAMP Time Stamp
sftycertrefsftycerttemplate WCEWCNR WC Document
lastchangedbyusername VDM_USERDESCRIPTION Description
lastchangedbyuser WCECHNAME Changed By
maintenanceplanningplantname WERKS_NAME Plant Name
maintenanceplannergroupname EAM_PLANNER_GROUP_NAME Planner Group Name
sftycertificatetypedescription PTWESFTYCERTTEXT Sfty Cert Type Desc
lastchangedate WCECHDATE Changed on
lastchangetime WCECHTIME Last Changed at
lastchangedatetime TIMESTAMP Time Stamp
workcenter PPH_ARBPL Work Center
workcentertext WORKCENTERTEXT Work Center Text
workcenterplant WERKS_D Plant
mainworkcenterplantname WERKS_NAME Plant Name
sftycertislinkdtodoc WCEDOCFLG Document Link
statusprofile J_STSMA Status Profile
isattachmentsenabled CV_ORIG Originals
safetycertificatetmplid WCEREFOBJ Template
sftycerthasmaintremark WCEREMARKFLG1 Remarks Mt
sftycerthasopremark WCEREMARKFLG2 Remarks Op
sftycertprocessingstatus PTWDSFTYCERTPROCESSINGSTATUS Proc Stat Sfty Cert
sftycertprocessingstatustext VAL_TEXT Short Description
safetycertificatelongtext ESH_E_SR_LONGTEXT Long Text
sftycertcancellationtext ESH_E_SR_LONGTEXT Long Text
sftycertcnctntdactvsystststxt VDM_J_SYSTEM_STATUS_CONCAT_T Concatenated System Status
isapproved XFELD Checkbox
printisreal abap.char
sftycertchgstsactnenbldval abap.char
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
dummy_wcahe_tmpl_incl_eew_ps CFD_DUMMY Dummy

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_SAFETYCERTIFICATETEMPLATETP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SAFETYCERTTMPL_D (
    MANDT,                           -- Client [MANDT]
    SAFETYCERTIFICATE,               -- WC Document [WCEWCNR]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    SAFETYCERTIFICATEINTERNALID,     -- Object number [J_OBJNR]
    SFTYCERTIFICATESUBOBJECTTYPE,    -- Object Type [WCETYP]
    SAFETYCERTIFICATETYPE,           -- Usage [WCEUSAGE]
    SFTYCERTDESC,                    -- Short Text [WCESTXT]
    SFTYCERTHASLONGTEXT,             -- Long Text [WCELTXTFLG]
    LONGTEXTKEY,                     -- Text Name [TDOBNAME]
    SFTYCERTISDELETED,               -- Delete [WCEDELFLG]
    MAINTENANCEPLANNERGROUP,         -- Planner Group [INGRP]
    MAINTENANCEPLANNINGPLANT,        -- Planning Plant [IWERK]
    OBJECTTYPECODE,                  -- Object Type [CR_OBJTY]
    OPERATIONWORKCENTERINTERNALID,   -- Object ID [CR_OBJID]
    TECHOBJAUTHORIZATIONGROUP,       -- AuthorizGroup [IAUTG]
    SFTYCERTVALIDFRMDATE,            -- Valid from [WCEDATEFR]
    SFTYCERTVALIDFRMTIME,            -- ValidFrm Time [WCETIMEFR]
    SFTYCERTVALIDTODATE,             -- Valid to [WCEDATETO]
    SFTYCERTVALIDTOTIME,             -- 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]
    PLANTSECTIONDESC,                -- abap.char
    MAINTENANCEPLANTNAME,            -- Plant Name [WERKS_NAME]
    SFTYCERTHASOBJECTLIST,           -- Obj.List Exists [WCELNKFLG]
    CREATEDBYUSERNAME,               -- Description [VDM_USERDESCRIPTION]
    CREATEDBYUSER,                   -- Created by [WCECRNAME]
    CREATIONDATE,                    -- Created on [WCECRDATE]
    CREATIONTIME,                    -- Created at [WCECRTIME]
    CREATIONDATETIME,                -- Time Stamp [TIMESTAMP]
    VALIDFROMDATETIME,               -- Time Stamp [TIMESTAMP]
    VALIDTODATETIME,                 -- Time Stamp [TIMESTAMP]
    SFTYCERTREFSFTYCERTTEMPLATE,     -- WC Document [WCEWCNR]
    LASTCHANGEDBYUSERNAME,           -- Description [VDM_USERDESCRIPTION]
    LASTCHANGEDBYUSER,               -- Changed By [WCECHNAME]
    MAINTENANCEPLANNINGPLANTNAME,    -- Plant Name [WERKS_NAME]
    MAINTENANCEPLANNERGROUPNAME,     -- Planner Group Name [EAM_PLANNER_GROUP_NAME]
    SFTYCERTIFICATETYPEDESCRIPTION,  -- Sfty Cert Type Desc [PTWESFTYCERTTEXT]
    LASTCHANGEDATE,                  -- Changed on [WCECHDATE]
    LASTCHANGETIME,                  -- Last Changed at [WCECHTIME]
    LASTCHANGEDATETIME,              -- Time Stamp [TIMESTAMP]
    WORKCENTER,                      -- Work Center [PPH_ARBPL]
    WORKCENTERTEXT,                  -- Work Center Text [WORKCENTERTEXT]
    WORKCENTERPLANT,                 -- Plant [WERKS_D]
    MAINWORKCENTERPLANTNAME,         -- Plant Name [WERKS_NAME]
    SFTYCERTISLINKDTODOC,            -- Document Link [WCEDOCFLG]
    STATUSPROFILE,                   -- Status Profile [J_STSMA]
    ISATTACHMENTSENABLED,            -- Originals [CV_ORIG]
    SAFETYCERTIFICATETMPLID,         -- Template [WCEREFOBJ]
    SFTYCERTHASMAINTREMARK,          -- Remarks Mt [WCEREMARKFLG1]
    SFTYCERTHASOPREMARK,             -- Remarks Op [WCEREMARKFLG2]
    SFTYCERTPROCESSINGSTATUS,        -- Proc Stat Sfty Cert [PTWDSFTYCERTPROCESSINGSTATUS]
    SFTYCERTPROCESSINGSTATUSTEXT,    -- Short Description [VAL_TEXT]
    SAFETYCERTIFICATELONGTEXT,       -- Long Text [ESH_E_SR_LONGTEXT]
    SFTYCERTCANCELLATIONTEXT,        -- Long Text [ESH_E_SR_LONGTEXT]
    SFTYCERTCNCTNTDACTVSYSTSTSTXT,   -- Concatenated System Status [VDM_J_SYSTEM_STATUS_CONCAT_T]
    ISAPPROVED,                      -- Checkbox [XFELD]
    PRINTISREAL,                     -- abap.char
    SFTYCERTCHGSTSACTNENBLDVAL,      -- abap.char
    DRAFTENTITYCREATIONDATETIME,     -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,   -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,     -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,        -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                 -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,               -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_WCAHE_TMPL_INCL_EEW_PS,    -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, SAFETYCERTIFICATE, DRAFTUUID)
);

Learn More