ISLTNAPPRH_D

Transparent Table Application Table
30 Fields 1 CDS Views

Draft table for entity R_ISLTNCERTAPPROVALHISTORYTP

ISLTNAPPRH_D is an SAP database table in S/4HANA. Draft table for entity R_ISLTNCERTAPPROVALHISTORYTP. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
R_IsltnCertApprvlHistoryDraft view_entity from BASIC Isltn Cert Approval History - Draft

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY isolationcertificateinternalid J_OBJNR Object number
KEY nmbrofapprvlinisltncertvalue I_COUNT Counter
KEY nrofapprvlinisltncertificate I_COUNT Counter
KEY draftuuid SDRAFT_UUID Draft Document ID
parentdraftuuid SDRAFT_UUID Draft Document ID
isolationcertificate WCEWCNR WC Document
isltncertapprovalenteredbyuser GENNAME Entered by
approvaldatetime TIMESTAMP Time Stamp
isltncertapprovalcomment PTWEWORKPERMITAPPROVALCOMMENT Approval Comment
isltncertapprovalrevokedbyuser GENINAME Deactivated by
isltncertrevokedatetime TIMESTAMP Time Stamp
textobjectkey TDOBNAME Text Name
isltncertrevokelongtextkey TDOBNAME Text Name
plainlongtext ESH_E_SR_LONGTEXT Long Text
isltncertrevokelongtext ESH_E_SR_LONGTEXT Long Text
isltncertapprovalentrytime GENVTIME Entered At
isltncertapprovedfromdate GENVDATE App.fr date
isltncertapprovedtodate GENBDATE App.to date
isltncertapprovedfromtime GENVTIME Entered At
isltncertapprovedtotime GENBTIME AppToTime
isltncertapprvldactvtndate GENIDATE Deactivated on
isltncertapprvldactvtntime GENITIME Deactivated at
isltncertapprvlsgmtisinactive GENIAKT Permit inactive
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_ISLTNCERTAPPROVALHISTORYTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ISLTNAPPRH_D (
    MANDT,                           -- Client [MANDT]
    ISOLATIONCERTIFICATEINTERNALID,  -- Object number [J_OBJNR]
    NMBROFAPPRVLINISLTNCERTVALUE,    -- Counter [I_COUNT]
    NROFAPPRVLINISLTNCERTIFICATE,    -- Counter [I_COUNT]
    DRAFTUUID,                       -- Draft Document ID [SDRAFT_UUID]
    PARENTDRAFTUUID,                 -- Draft Document ID [SDRAFT_UUID]
    ISOLATIONCERTIFICATE,            -- WC Document [WCEWCNR]
    ISLTNCERTAPPROVALENTEREDBYUSER,  -- Entered by [GENNAME]
    APPROVALDATETIME,                -- Time Stamp [TIMESTAMP]
    ISLTNCERTAPPROVALCOMMENT,        -- Approval Comment [PTWEWORKPERMITAPPROVALCOMMENT]
    ISLTNCERTAPPROVALREVOKEDBYUSER,  -- Deactivated by [GENINAME]
    ISLTNCERTREVOKEDATETIME,         -- Time Stamp [TIMESTAMP]
    TEXTOBJECTKEY,                   -- Text Name [TDOBNAME]
    ISLTNCERTREVOKELONGTEXTKEY,      -- Text Name [TDOBNAME]
    PLAINLONGTEXT,                   -- Long Text [ESH_E_SR_LONGTEXT]
    ISLTNCERTREVOKELONGTEXT,         -- Long Text [ESH_E_SR_LONGTEXT]
    ISLTNCERTAPPROVALENTRYTIME,      -- Entered At [GENVTIME]
    ISLTNCERTAPPROVEDFROMDATE,       -- App.fr date [GENVDATE]
    ISLTNCERTAPPROVEDTODATE,         -- App.to date [GENBDATE]
    ISLTNCERTAPPROVEDFROMTIME,       -- Entered At [GENVTIME]
    ISLTNCERTAPPROVEDTOTIME,         -- AppToTime [GENBTIME]
    ISLTNCERTAPPRVLDACTVTNDATE,      -- Deactivated on [GENIDATE]
    ISLTNCERTAPPRVLDACTVTNTIME,      -- Deactivated at [GENITIME]
    ISLTNCERTAPPRVLSGMTISINACTIVE,   -- Permit inactive [GENIAKT]
    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, NMBROFAPPRVLINISLTNCERTVALUE, NROFAPPRVLINISLTNCERTIFICATE, DRAFTUUID)
);

Learn More