I_WORKPERMITAPPRVLSGMT

CDS View
21 Fields 2 CDS Views

Work Permit Approval Segment

I_WORKPERMITAPPRVLSGMT is a CDS View in S/4HANA. Work Permit Approval Segment. It contains 21 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
R_WorkPermitApprovalSegmentTP view_entity from TRANSACTIONAL Work Permit Approval Segment View
R_WrkPmtTmplApprovalSegmentTP view_entity from TRANSACTIONAL Work Permit Approval Segment View

Fields (21)

KeyField CDS FieldsUsed in Views
KEY NumberOfWrkPermitApprovals NumberOfWrkPermitApprovals 2
KEY WorkPermitInternalID WorkPermitInternalID 2
KEY WrkPermitApprvlSgmt WrkPermitApprvlSgmt 2
ApprovalDateTime ApprovalDateTime 2
TextObjectKey TextObjectKey 2
WorkPermit WorkPermit 2
WorkPermitApprovalComment WorkPermitApprovalComment 2
WorkPermitApprovalDescription WorkPermitApprovalDescription 2
WorkPermitRevokeDateTime WorkPermitRevokeDateTime 2
WorkPermitRevokeLongTextKey WorkPermitRevokeLongTextKey,WrkPmtTmplRevokeLongTextKey 2
WrkPermitApprvlDactvtdByUsr WrkPermitApprvlDactvtdByUsr 2
WrkPermitApprvlEnteredByUsr WrkPermitApprvlEnteredByUsr 2
WrkPermitApprvlEntryDate WrkPermitApprvlEntryDate 2
WrkPermitApprvlEntryTime WrkPermitApprvlEntryTime 2
WrkPermitApprvlSgmtIsInactive WrkPermitApprvlSgmtIsInactive 2
WrkPermitAprvdFromDate WrkPermitAprvdFromDate 2
WrkPermitAprvdFromTime WrkPermitAprvdFromTime 2
WrkPermitAprvdToDate WrkPermitAprvdToDate 2
WrkPermitAprvdToTime WrkPermitAprvdToTime 2
WrkPmtApprvlDeactivationDate WrkPmtApprvlDeactivationDate 2
WrkPmtApprvlDeactivationTime WrkPmtApprvlDeactivationTime 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.

-- Work Permit Approval Segment
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_WORKPERMITAPPRVLSGMT (
    NUMBEROFWRKPERMITAPPROVALS,
    WORKPERMITINTERNALID,
    WRKPERMITAPPRVLSGMT,
    APPROVALDATETIME,
    TEXTOBJECTKEY,
    WORKPERMIT,
    WORKPERMITAPPROVALCOMMENT,
    WORKPERMITAPPROVALDESCRIPTION,
    WORKPERMITREVOKEDATETIME,
    WORKPERMITREVOKELONGTEXTKEY,
    WRKPERMITAPPRVLDACTVTDBYUSR,
    WRKPERMITAPPRVLENTEREDBYUSR,
    WRKPERMITAPPRVLENTRYDATE,
    WRKPERMITAPPRVLENTRYTIME,
    WRKPERMITAPPRVLSGMTISINACTIVE,
    WRKPERMITAPRVDFROMDATE,
    WRKPERMITAPRVDFROMTIME,
    WRKPERMITAPRVDTODATE,
    WRKPERMITAPRVDTOTIME,
    WRKPMTAPPRVLDEACTIVATIONDATE,
    WRKPMTAPPRVLDEACTIVATIONTIME,
    PRIMARY KEY (NUMBEROFWRKPERMITAPPROVALS, WORKPERMITINTERNALID, WRKPERMITAPPRVLSGMT)
);

Learn More