I_SFTYCERTAPPROVALSEGMENT

CDS View
21 Fields 2 CDS Views

Approval History in Safety Certificate

I_SFTYCERTAPPROVALSEGMENT is a CDS View in S/4HANA. Approval History in Safety Certificate. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_SftyCertApprovalSegmentTP view_entity from TRANSACTIONAL Approval History in Safety Certificate
R_SftyCertTmplApprvlSegmentTP view_entity from TRANSACTIONAL Safety Certificate Template Approval Segment

Fields (21)

KeyField CDS FieldsUsed in Views
KEY NumberOfSftyCertApprovals NumberOfSftyCertApprovals 2
KEY SafetyCertificateInternalID SafetyCertificateInternalID 2
KEY SftyCertApprovalSegmentValue SftyCertApprovalSegmentValue 2
ApprovalDateTime ApprovalDateTime 2
SafetyCertificate SafetyCertificate 2
SftyCertApprovalDactvtdByUsr SftyCertApprovalDactvtdByUsr 2
SftyCertApprovalDescription SftyCertApprovalDescription 2
SftyCertApprovalEnteredByUser SftyCertApprovalEnteredByUser 2
SftyCertApprovalEntryDate SftyCertApprovalEntryDate 2
SftyCertApprovalEntryTime SftyCertApprovalEntryTime 2
SftyCertApprovedFromDate SftyCertApprovedFromDate 2
SftyCertApprovedFromTime SftyCertApprovedFromTime 2
SftyCertApprovedToDate SftyCertApprovedToDate 2
SftyCertApprovedToTime SftyCertApprovedToTime 2
SftyCertApprvlDeactivationDate SftyCertApprvlDeactivationDate 2
SftyCertApprvlDeactivationTime SftyCertApprvlDeactivationTime 2
SftyCertApprvlSgmtIsInactive SftyCertApprvlSgmtIsInactive 2
SftyCertificateApprovalComment SftyCertificateApprovalComment 2
SftyCertRevokeDateTime SftyCertRevokeDateTime 2
SftyCertRevokeLongTextKey SftyCertRevokeLongTextKey 2
TextObjectKey TextObjectKey 2

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.

-- Approval History in Safety Certificate
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SFTYCERTAPPROVALSEGMENT (
    NUMBEROFSFTYCERTAPPROVALS,
    SAFETYCERTIFICATEINTERNALID,
    SFTYCERTAPPROVALSEGMENTVALUE,
    APPROVALDATETIME,
    SAFETYCERTIFICATE,
    SFTYCERTAPPROVALDACTVTDBYUSR,
    SFTYCERTAPPROVALDESCRIPTION,
    SFTYCERTAPPROVALENTEREDBYUSER,
    SFTYCERTAPPROVALENTRYDATE,
    SFTYCERTAPPROVALENTRYTIME,
    SFTYCERTAPPROVEDFROMDATE,
    SFTYCERTAPPROVEDFROMTIME,
    SFTYCERTAPPROVEDTODATE,
    SFTYCERTAPPROVEDTOTIME,
    SFTYCERTAPPRVLDEACTIVATIONDATE,
    SFTYCERTAPPRVLDEACTIVATIONTIME,
    SFTYCERTAPPRVLSGMTISINACTIVE,
    SFTYCERTIFICATEAPPROVALCOMMENT,
    SFTYCERTREVOKEDATETIME,
    SFTYCERTREVOKELONGTEXTKEY,
    TEXTOBJECTKEY,
    PRIMARY KEY (NUMBEROFSFTYCERTAPPROVALS, SAFETYCERTIFICATEINTERNALID, SFTYCERTAPPROVALSEGMENTVALUE)
);

Learn More